Using text messages to interact with spreadsheets

Patent metadata

Field	Value
Publication number	US-9898454-B2
Application number	US-96799110-A
Country	US
Kind code	B2
Filing date	Dec 14, 2010
Priority date	Dec 14, 2010
Publication date	Feb 20, 2018
Grant date	Feb 20, 2018

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.

First claim

What is claimed is:

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 th

Assignees

• Campbell John
• Lin Amy
• Waldman Lawrence
• Mullowney Daniel
• Villanueva Jair Cazarin
• Parish Daniel
• Microsoft Technology Licensing Llc

Inventors

• Campbell John
• Lin Amy
• Waldman Lawrence
• Mullowney Daniel
• Villanueva Jair Cazarin
• Parish Daniel

Classifications

• G06F40/18 Primary

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06Q10/107

  Computer-aided management of electronic mailing [e-mailing] · CPC title

• G06F40/205

  Parsing · CPC title

• G06F17/246 Primary

  Physics · mapped topic

• G06F15/16

  Combinations of two or more digital computers each having at least an arithmetic unit, a program unit and a register, e.g. for a simultaneous processing of several programs {(coordinating program control therefor G06F9/52; in regulating and control system G05B)} · CPC title