US 9,811,516 B2
Location aware spreadsheet actions
John Campbell, Renton, WA (US); Amy Lin, Redmond, WA (US); Lawrence Waldman, Seattle, WA (US); and Sherman Der, NewCastle, WA (US)
Assigned to Microsoft Technology Licensing, LLC, Redmond, WA (US)
Filed by John Campbell, Renton, WA (US); Amy Lin, Redmond, WA (US); Lawrence Waldman, Seattle, WA (US); and Sherman Der, NewCastle, WA (US)
Filed on Dec. 14, 2010, as Appl. No. 12/967,972.
Prior Publication US 2012/0151314 A1, Jun. 14, 2012
Int. Cl. G06F 17/00 (2006.01); G06F 17/24 (2006.01); H04M 1/725 (2006.01); G06F 1/16 (2006.01); H04M 1/2745 (2006.01)
CPC G06F 17/246 (2013.01) [G06F 1/1698 (2013.01); G06F 17/24 (2013.01); H04M 1/274516 (2013.01); H04M 1/7253 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method for using location information with a first spreadsheet, comprising:
receiving, by a first computing device associated with a first user, location information for a physical location of a second user associated with a second computing device;
in response to receiving the location information, automatically performing an operation on preexisting data within the first spreadsheet to create updated data, wherein the preexisting data comprises non-location values and location values, and wherein performing the operation on the preexisting data within the first spreadsheet comprises:
determining that the second user is within a predetermined proximity;
determining that data within a second spreadsheet on the second computing device is available for collaborating;
determining identifiers in the first spreadsheet associated with the location values;
automatically executing at least one native formula to create the updated data based on a predetermined condition satisfied by the location information, wherein the updated data is based at least in part on data within the second spreadsheet on the second computing device; and
displaying the first spreadsheet with the updated data; and
in response to receiving different location information, changing a display of the first spreadsheet in response to executing the at least one native formula based on the predetermined condition satisfied by the different location information.