Client side, web-based spreadsheet

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.

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.

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.

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.