Client side, web-based spreadsheet

• US 6,988,241 B1
• Filed: 11/15/2000
• Issued: 01/17/2006
• Est. Priority Date: 10/16/2000
• Status: Active Grant

• Current Assignee: Globalfoundries US Incorporated (GlobalFoundries, Inc.)
• Original Assignee: International Business Machines Corporation
• Inventors: Ternasky, Joseph, Guttman, Steven
• Primary Examiner(s): Feild, Joseph
• Assistant Examiner(s): Blackwell, James H.
• Application Number:
  US09/714,024
• Time in Patent Office: 1,889 Days
• Field of Search: 715/503, 715/504, 715/514, 715/513, 705/26, 705/19
• US Class Current: 715/220
• CPC Class Codes: G06F 16/9566 URL specific, e.g. using aliases, detecting broken or misspelled links
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06Q 10/10 Office automation; Time management

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.

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.

2. The method of claim 1, wherein said sending the request includes sending a request from a client to the server.

3. The method of claim 1, wherein the information in the received web page and the programming language are Javascript.

4. The method of claim 1, wherein said second cell of the web-based spreadsheet comprises a second formula expressly referencing a second user-defined macro of the one or more user-defined macros, to retrieve live data that is updated periodically as the spreadsheet is being displayed, the second user-defined macro comprising one or more instructions of the programming language, and

wherein said executing information in the received web page to allow information to be entered into at least one second cell comprises invoking the second user-defined macro.

5. The method of claim 4, wherein the live data is stock quotation information.

6. The method of claim 5, wherein the stock quotation information is obtained from the server.

7. The method of claim 5, wherein the stock quotation information is obtained from a third party.

8. The method of claim 5, wherein the stock quotation information also includes historical information of a stock.

9. The method of claim 4, wherein the live data is currency conversion information.

10. The method of claim 9, wherein the currency conversion information is obtained from the server.

11. The method of claim 9, wherein the currency conversion information is obtained from a third party.

12. The method of claim 1, wherein at least one other cell of the web-based spreadsheet contains a link to another web page.

13. The method of claim 1, wherein at least one other cell of the web-based spreadsheet contains an image obtained from an address on the World Wide Web.

14. The method of claim 13, further comprising:

allowing the user to expand the size of the other cell to view more of the image.

15. The method of claim 1, wherein at least one other cell of the web-based spreadsheet contains an image obtained from a data processing device connected to the user via a network.

16. The method of claim 2, where the client is connected to the server via World Wide Web.

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.

18. The method of claim 17, further comprising e-mailing a link to the spreadsheet, including:

allowing the user to click on an “

e-mail this page”

button; and

allowing the user to enter a recipient'"'"'s address.

19. The method of claim 17, further comprising embedding the spreadsheet in a web page to create an embedded HTML web page, comprising:

displaying an HTML code including a spreadsheet ID of the spreadsheet; and

allowing the user to copy the HTML code and paste it into the web page'"'"'s HTML.

20. The method of claim 19, wherein the embedded HTML web page comprises “

JavaScript include”

tags.

21. The method of claim 17, wherein the spreadsheet is displayed on a client system.

22. The method of claim 21, wherein JavaScript Dynamic HTML is downloaded to the client system, the JavaScript including functionality, format and content of the spreadsheet web page.

23. The method of claim 17, wherein the information in the received web page and the user-defined macro are Javascript.

24. The method of claim 17, wherein at least one cell of the web-based spreadsheet contains live data that is updated periodically as the spreadsheet is being displayed.

25. The method of claim 24, wherein the live data is stock quotation information.

26. The method of claim 25, wherein the stock quotation information is obtained from the server.

27. The method of claim 25, wherein the stock quotation information is obtained from a third party.

28. The method of claim 27, wherein the stock quotation information also includes historical information for a stock.

29. The method of claim 28, wherein the live data is currency conversion information.

30. The method of claim 29, wherein the currency conversion information is obtained from the server.

31. The method of claim 29, wherein the currency conversion information is obtained from a third party.

32. The method of claim 17, wherein at least one other cell of the web-based spreadsheet contains a link to a web page.

33. The method of claim 17, wherein at least one other cell of the web-based spreadsheet contains an image obtained from an address on the World Wide Web.

34. The method of claim 33, further comprising:

allowing the user to expand the size of the other cell to view more of the image.

35. The method of claim 17, wherein at lest one other cell of the web-based spreadsheet contains an image obtained from a data processing device connected to the user via a network.

36. The method of claim 21, where the client is connected to the server vial the World Wide Web.

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.

38. The method of claim 37, wherein before sending the spreadsheet web page, JavaScript data is embedded into the spreadsheet web page.

39. The method of claim 37, wherein the data ID identifies a file name.

40. The method of claim 37, wherein the server includes data for more than one spreadsheet web page.

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.

42. The method of claim 41, wherein said sending the request includes sending a request from a client to the server.

43. The method of claim 41, wherein the one or more user-defined macros in the received web page are Javascript.

44. The method of claim 41, wherein the second cell of the web-based spreadsheet contains live data that is updated periodically as the spreadsheet is being displayed.

45. The method of claim 44, wherein the live data is stock quotation information.

46. The method of claim 45, wherein the stock quotation information is obtained from the server.

47. The method of claim 45, wherein the stock quotation information is obtained from a third party.

48. The method of claim 45, wherein the stock quotation information also includes historical information of a stock.

49. The method of claim 44, wherein the live data is currency conversion information.

50. The method of claim 49, wherein the currency conversion information is obtained from the server.

51. The method of claim 49, wherein the currency conversion information is obtained from a third party.

52. The method of claim 41, wherein at least one other cell of the web-based spreadsheet contains a link to another web page.

53. The method of claim 41, wherein at least one other cell of the web-based spreadsheet contains an image obtained from an address on the World Wide Web.

54. The method of claim 53, further comprising:

allowing the user to expand the size of the other cell to view more of the image.

55. The method of claim 41, wherein at least one other cell of the web-based spreadsheet contains an image obtained from a data processing device connected via a network.

56. The method of claim 42, where the client is connected to the server via World Wide Web.

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.

58. The article of manufacture of claim 57 wherein the one or more user-defined macros comprise an initialization macro which is invoked when the web-based spreadsheet is loaded, the initialization macro comprising user specified Javascript instructions,

wherein said executing said one or more user-defined macros also executes the initialization macro in the received web page.

59. The article of manufacture of claim 58 wherein the web-based spreadsheet comprises a user-defined global variable, accessible to the initialization macro and the one or more user-defined macros.

60. The article of manufacture of claim 57 wherein the programming language is Javascript.

61. The article of manufacture of claim 57 wherein the second cell of the web-based spreadsheet comprises a second formula expressly referencing a second user-defined macro of said one or more user-defined macros, to retrieve live data that is update periodically as the spreadsheet is being displayed, the second user-defined macro being Javascript, and

wherein said executing information in the received webpage to allow information to be entered into the second cell comprises invoking the second user-defined macro.

62. The article of manufacture of claim 61, wherein the live data is stock quotation information.

63. The article of manufacture of claim 61, wherein the live data is currency conversion information.

64. The article of manufacture of claim 61 wherein the third cell of the web-based spreadsheet comprises a third formula expressly referencing a third user-defined macro and said one or more user-defined macros, the third user-defined macro being Javascript, and

wherein said executing information in the received web page to update the third cell invokes the third user-defined macro.