Using text messages to interact with spreadsheets

• US 9,898,454 B2
• Filed: 12/14/2010
• Issued: 02/20/2018
• Est. Priority Date: 12/14/2010
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Campbell, John, Lin, Amy, Waldman, Lawrence, Mullowney, Daniel, Villanueva, Jair Cazarin, Parish, Daniel
• Primary Examiner(s): Bashore, William
• Assistant Examiner(s): Faber, David
• Application Number:
  US12/967,991
• Publication Number:
  US 20120151315A1
• Time in Patent Office: 2,625 Days
• Field of Search: 715212, 715219, 715220, 715255
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 40/205 Parsing
• CPC Class Codes: G06Q 10/107 Computer-aided management of electronic mailing [e-mailing]

Abstract

Text messages are used to interact with objects in a spreadsheet. For example, text messages may be used to enter/receive data in the spreadsheet. One or more text messages may be associated with a spreadsheet. Text messages may be associated with cells, tables, charts and other objects of the spreadsheet. When the spreadsheet receives a text message, the text message is parsed and information that is contained within the text message is used to interact with one or more objects within the spreadsheet. The spreadsheet may also generate and send text messages that provide information about the spreadsheet and/or request information to be entered within the spreadsheet. For example, the spreadsheet may send out an update of one or more values/objects within a spreadsheet and/or send a request within a text message requesting information to update a table.

Claims

1. A method for associating text messages to a spreadsheet stored on a first computing device, comprising:

receiving a text message from a second computing device directed to a text address associated with at least one spreadsheet object within the spreadsheet, wherein the spreadsheet comprises one or more spreadsheet objects, wherein the text message comprises one of;

an instant message (IM), a short message service (SMS) message, an enhanced messaging service (EMS) message, and a multimedia messaging service (MMS) message, wherein the text address is a number, and wherein the text message is not associated with a spreadsheet stored on the second computing device;

parsing the text message received from the second computing device to determine the at least one spreadsheet object of the one or more spreadsheet objects associated with the text message, wherein determining the at least one spreadsheet object is based at least in part on the text address;

determining an operation to perform in the spreadsheet from the text message; and

performing the operation in the spreadsheet, wherein the operation comprises accessing the associated at least one spreadsheet object.

2. The method of claim 1, further comprising, the spreadsheet automatically generating a spreadsheet text message and sending the spreadsheet text message from the spreadsheet to one or more text message addressees.

3. The method of claim 2, wherein the spreadsheet text message requests one or more users associated with the one or more text message addressees to send a reply text message to the spreadsheet that includes requested information that is specified within the spreadsheet text message.

4. The method of claim 2, wherein determining the at least one spreadsheet object within the spreadsheet that is associated with the text message comprises determining contextual information that is associated with the text message.

5. The method of claim 2, wherein the spreadsheet text message is automatically generated in response to updating one or more values or one or more objects within the spreadsheet, wherein the spreadsheet text message comprises information relating to the update of the one or more values or the one or more objects.

6. The method of claim 2, wherein the text message comprises a formula to place in the spreadsheet, wherein the formula in the text message comprises input parameters for the formula.

7. The method of claim 1, wherein parsing the text message comprises parsing the text message to further determine when the text message comprises at least one of:

a hyperlink, text, a number and an image.

8. The method of claim 1, wherein the text message comprises an operation specifying at least one of:

adding, deleting, updating, retrieving, providing a parameter for a function, creating a function, starting a function, and accessing data specified by a parameter in the text message.

9. The method of claim 1, wherein the text message includes a spreadsheet object identifier, an operation, and data relating to the operation, and wherein the spreadsheet object identifier is used to associate the text message to the spreadsheet object within the spreadsheet.

10. The method of claim 1, wherein receiving the text message comprises receiving the text message in response to a spreadsheet text message sent by the spreadsheet.

11. A first computing device comprising a processing unit and a memory storing computer-executable instructions that when executed by the processing unit perform a method for associating a text message to a spreadsheet, comprising:

generating a spreadsheet text message requesting information that relates to one or more spreadsheet objects that are contained within the spreadsheet;

sending the spreadsheet text message to at least one address using a spreadsheet application;

receiving a text message from a second computing device as a reply to the spreadsheet text message, wherein the text message comprises one of;

an instant message (IM), a short message service (SMS) message, an enhanced messaging service (EMS) message, and a multimedia messaging service (MMS) message, wherein the text message is directed to a text address associated with at least one spreadsheet object within the spreadsheet and comprises a response to the requested information, wherein the text address is a number, wherein the text message is not associated with a spreadsheet stored on the second computing device, and wherein the second computing device is associated with the at least one address;

parsing the text message to determine the at least one spreadsheet object of the one or more spreadsheet objects associated with the text message, wherein determining the at least one spreadsheet object is based at least in part on the text address;

determining an operation to perform in the spreadsheet; and

performing the operation in the spreadsheet, wherein the operation comprises using the requested information that is contained within the received text message.

12. The first computing device of claim 11, further comprising, the spreadsheet system automatically generating the spreadsheet text message.

13. The first computing device of claim 12, further comprising:

automatically generating a second spreadsheet text message in response to updating one or more values or one or more objects within the spreadsheet; and

automatically sending the second spreadsheet text message, wherein the second spreadsheet text message comprises information relating to the update of the one or more values or the one or more objects.

14. The first computing device of claim 11, further comprising determining when the text message comprises at least one of:

a hyperlink, text, a number and an image.

15. The first computing device of claim 11, wherein the text message comprises an operation specifying at least one of:

adding, deleting, updating, retrieving, providing a parameter for a function, creating a function, starting a function, and accessing data specified by a parameter in the text message.

16. The first computing device of claim 11, wherein the text message includes a spreadsheet object identifier, an operation and data relating to the operation, wherein the spreadsheet object identifier is used to associate the text message to the spreadsheet object within the spreadsheet.

17. A first computer system for associating a message to a spreadsheet, comprising:

a central processing unit (CPU), and a computer-readable storage device;

an operating environment stored on the computer-readable storage device and executing on the CPU;

a spreadsheet application;

a spreadsheet, wherein the spreadsheet comprises one or more spreadsheet objects;

a message manager operating in conjunction with the spreadsheet application that is configured to perform actions comprising;

receive a text message from a second computer system addressed to a text address associated with a spreadsheet object of the spreadsheet, wherein the text message comprises one of;

an instant message (IM), a short message service (SMS) message, an enhanced messaging service (EMS) message, and a multimedia messaging service (MMS) message, wherein the text address is a number, wherein the text message is not associated with a spreadsheet stored on the second computer system;

parse the text message received from the second computer system to determine the spreadsheet object within the spreadsheet that is associated with the text message, wherein determining the spreadsheet object is based on the text address;

determine an operation to perform in the spreadsheet, wherein the operation comprises at least one of;

adding, deleting, updating, retrieving, providing a parameter for a function, creating a function, starting a function, and accessing data specified by a parameter in the text message;

perform the operation in the spreadsheet, wherein the operation comprises accessing the associated spreadsheet object; and

automatically generate a spreadsheet message and send the spreadsheet message to one or more text addressees.

18. The first computer system of claim 17, wherein the text message manager is further configured to store the text address associated with the spreadsheet object within an address book of a contact application.

19. The first computer system of claim 17, further comprising, the spreadsheet automatically generating a spreadsheet text message and sending the spreadsheet text message from the spreadsheet to one or more text message addressees.

20. The first computer system of claim 19, wherein the spreadsheet text message is automatically generated in response to updating one or more values or one or more objects within the spreadsheet, wherein the spreadsheet text message comprises information relating to the update of the one or more values or the one or more objects.