Client side, web-based spreadsheet
First Claim
1. A method of displaying a web-based spreadsheet comprising:
- sending a request to a server to retrieve the web-based spreadsheet;
receiving at least part of a web page in response to the request;
executing one or more user-defined macros, comprising one or more instructions of a programming language, in the received web page to display the web-based spreadsheet, the web-based spreadsheet comprising cells, the one or more user-defined macros comprising a first user-defined macro that is expressly referenced in a first formulas of a first cell;
executing information in the received web page to allow information to be entered into a second cell of the web-based spreadsheet; and
executing information in the received web page to allow information to be entered into a second cell of the web-based spreadsheet; and
executing information in the received web page to update a third cell dependent on the second cell.
8 Assignments
0 Petitions
Accused Products
Abstract
A method and system that that allows a designer to create “spreadsheet” web pages, which can then be viewed and used by the designer and/or by other users. The described embodiments of the present invention allow people to collaborate and to share spreadsheets over the web. The described embodiment allows a user of the spreadsheet to email the spreadsheet to others and to embed the spreadsheet into web pages owned by the designer or by third parties. A described embodiments of the web-based spreadsheet allowed the designer to specify both web data and real-time data in the cells of the “spreadsheet.” The web data includes a URL of an image that is to be placed in a cell. The web data includes a link to a web page in a cell. The real-time data includes stock quotes and currency conversion information in the cells of the spreadsheet. Such data reflects a current (or specified) day'"'"'s stock quote or a current (or specified) currency conversion value.
-
Citations
64 Claims
-
1. A method of displaying a web-based spreadsheet comprising:
-
sending a request to a server to retrieve the web-based spreadsheet;
receiving at least part of a web page in response to the request;
executing one or more user-defined macros, comprising one or more instructions of a programming language, in the received web page to display the web-based spreadsheet, the web-based spreadsheet comprising cells, the one or more user-defined macros comprising a first user-defined macro that is expressly referenced in a first formulas of a first cell;
executing information in the received web page to allow information to be entered into a second cell of the web-based spreadsheet; and
executing information in the received web page to allow information to be entered into a second cell of the web-based spreadsheet; and
executing information in the received web page to update a third cell dependent on the second cell. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)
-
-
17. A method of allowing a user to design a web-based spreadsheet, comprising:
-
executing information in the received web page to allow the user to create a user-defined macro comprising Javascript instructions, the user-defined macro having a macro name;
executing information in the received web page to allow the user to enter information into the cells of the web-base spreadsheet, the user entering a formula expressly referencing the macro name in at least one cell;
sending a number or rows and columns of the web based spreadsheet, the user-defined macro, and the information entered by the user to a server for storage on the server; and
sending a request to the server to retrieve the web-based spreadsheet. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36)
-
-
37. A computer-implemented method performed by a server data processing system, comprising:
-
receiving a request, from a client system, for a spreadsheet web page;
reviewing parameters received with the request for the spreadsheet web page, said parameters include a spreadsheet mode and a data ID; and
sending the requested spreadsheet web page to the client system, based on the parameters received, wherein said spreadsheet web page contains embedded data specific to the requested spreadsheet web page and capable of causing display of a spreadsheet, said spreadsheet web page comprising one or more user-defined macros comprising Javascript, the spreadsheet web page comprising cells, at least one cell of said cells comprising a formula expressly referencing at least one user-defined macro. - View Dependent Claims (38, 39, 40)
-
-
41. A method of displaying a web-based spreadsheet comprising:
-
sending a request to a server to retrieve the web-based spreadsheet;
receiving at least part of a web page in response to the request;
executing one or more user-defined macros in the received web page to display the web-based spreadsheet, said one or more user-defined macros comprising at least one of an initialization macro which is invoked when the spreadsheet web page is loaded and a first macro which is expressly referenced in a formula of at least one cell of the web-based spreadsheet;
executing a second macro of said one or more user-defined macros in the received web page to allow information to be entered into a second cell of the web-based spreadsheet; and
executing a third macro of said one or more user-defined macros in the received web page to update a third cell dependent on the second cell. - View Dependent Claims (42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56)
-
-
57. An article of manufacture readable by a computer, tangibly embodying instruction executable by the computer to perform a method of displaying a web-based spreadsheet, said method comprising:
-
sending a request to a server to retrieve the web-based spreadsheet;
receiving at least part of a web page in response to the request;
executing one or more user-defined macros, comprising one or more instructions of a programming language, in the received web page to display the web-based spreadsheet, the web-based spreadsheet comprising cells, the one or more user-defined macros comprising a first user-defined macro that is expressly referenced in a first formula of a first cell;
executing information in the received web page to allow information to be entered into a second cell of the web-based spreadsheet; and
executing information in the received web page to update a third cell dependent on the second cell. - View Dependent Claims (58, 59, 60, 61, 62, 63, 64)
-
Specification