Micro browser spreadsheet viewer

• US 10,031,905 B2
• Filed: 12/30/2014
• Issued: 07/24/2018
• Est. Priority Date: 06/17/2008
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Fu, Tsui-Ying, King, Hung Ju, Hung, Shao Yi, Tseng, Yung-Yu
• Primary Examiner(s): Zuberi, Mohammed-Ibrahim
• Application Number:
  US14/586,790
• Publication Number:
  US 20150113377A1
• Time in Patent Office: 1,302 Days
• Field of Search: 715212, 345440
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/9577 Optimising the visualization of content, e.g. distillation of HTML documents
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Various technologies and techniques are disclosed for displaying and managing spreadsheets on mobile devices. An optimized search can be performed. A selection is received from a user to open a spreadsheet. A find selection is received from the use along with keywords for which to the user wishes to search. Any matching keywords are found in the spreadsheet and the cell location of the keywords is retrieved. A results page is constructed that shows search result listings with the keywords along with data surrounding the one or more keywords. The results page is displayed. Navigation options are provided for allowing a user to navigate around the spreadsheet. Right, left, downward, and upward navigation options can be used to change the current view of the spreadsheet by a pre-defined number of cells. Techniques are described for optimizing the display of charts in the spreadsheet.

Claims

1. Non-transitory computer storage media having computer-executable instructions for causing a computer to perform steps comprising:

displaying a plurality of user-selectable options that correspond to at least one of a pre-defined number of rows or a pre-defined number of columns;

receiving a selection from a user as to at least one of the pre-defined number of rows or the pre-defined number of columns from the plurality of user-selectable options, the number being greater than one;

receiving a selection from the user to open a spreadsheet;

displaying a portion of the spreadsheet in a current view;

when the spreadsheet contains additional columns of data on a right side of any columns being displayed in the current view, providing a right navigation option that when selected will shift the spreadsheet rightward by the pre-defined number of columns;

when the spreadsheet contains additional columns of data on a left side of any columns being displayed in the current view, providing a left navigation option that when selected will shift the spreadsheet leftward by the pre-defined number of columns;

when the spreadsheet contains additional rows of data on a lower side of any rows being displayed in the current view, providing a down navigation option that when selected will shift the spreadsheet downward by the pre-defined number of rows; and

when the spreadsheet contains additional rows of data on an upper side of any rows being displayed in the current view, providing an up navigation option that when selected will shift the spreadsheet upward by the pre-defined number of rows.

2. The non-transitory computer storage media of claim 1, further having computer-executable instructions for causing a computer to perform steps comprising:

receiving a selection from a user to freeze a row or column of the spreadsheet.

3. The non-transitory computer storage media of claim 2, further having computer-executable instructions for causing a computer to perform steps comprising:

prompting the user to specify the row or column to freeze.

4. The non-transitory computer storage media of claim 3, further having computer-executable instructions operable to cause a computer to perform steps comprising:

freezing the row or column that was specified by the user as the user navigates through the spreadsheet.

5. The non-transitory computer storage media of claim 4, further having computer-executable instructions for causing a computer to perform steps comprising:

receiving a selection from a user to unfreeze the row or column; and

unfreezing the row or column in the spreadsheet.

6. A computer-implemented method, the method comprising:

displaying a plurality of user-selectable options that correspond to at least one of a pre-defined number of rows or a pre-defined number of columns;

receiving a selection from a user as to at least one of the pre-defined number of rows or the pre-defined number of columns from the plurality of user-selectable options, the number being greater than one;

receiving a selection from the user to open a spreadsheet;

displaying a portion of the spreadsheet in a current view;

when the spreadsheet contains additional columns of data on a right side of any columns being displayed in the current view, providing a right navigation option that when selected will shift the spreadsheet rightward by the pre-defined number of columns;

when the spreadsheet contains additional columns of data on a left side of any columns being displayed in the current view, providing a left navigation option that when selected will shift the spreadsheet leftward by the pre-defined number of columns;

when the spreadsheet contains additional rows of data on a lower side of any rows being displayed in the current view, providing a down navigation option that when selected will shift the spreadsheet downward by the pre-defined number of rows; and

when the spreadsheet contains additional rows of data on an upper side of any rows being displayed in the current view, providing an up navigation option that when selected will shift the spreadsheet upward by the pre-defined number of rows.

7. The computer-implemented method of claim 6, further comprising:

receiving a selection from a user to freeze a row or column of the spreadsheet.

8. The computer-implemented method of claim 7, further comprising:

prompting the user to specify the row or column to freeze.

9. The computer-implemented method of claim 8, further comprising:

freezing the row or column that was specified by the user as the user navigates through the spreadsheet.

10. The computer-implemented method of claim 9, further comprising:

receiving a selection from a user to unfreeze the row or column; and

unfreezing the row or column in the spreadsheet.

11. Non-transitory computer storage media having computer-executable instructions for causing a computer to perform steps comprising:

displaying a plurality of user-selectable options that correspond to at least one of a pre-defined number of rows or a pre-defined number of columns;

receiving a selection from a user from the user-selectable options as to at least one of the predetermined number of rows to display or the predetermined number of columns to display, the number being greater than one;

receiving a selection from a user to open a spreadsheet;

displaying a portion of the spreadsheet in a current view, the portion being determined by at least one of the predetermined number of rows or the predetermined number of columns;

when the spreadsheet contains additional columns of data on a right side of any columns being displayed in the current view, providing a right navigation option that when selected will shift the spreadsheet rightward;

when the spreadsheet contains additional columns of data on a left side of any columns being displayed in the current view, providing a left navigation option that when selected will shift the spreadsheet leftward;

when the spreadsheet contains additional rows of data on a lower side of any rows being displayed in the current view, providing a down navigation option that when selected will shift the spreadsheet downward; and

when the spreadsheet contains additional rows of data on an upper side of any rows being displayed in the current view, providing an up navigation option that when selected will shift the spreadsheet upward.

12. The non-transitory computer storage media of claim 11, further having computer-executable instructions for causing a computer to perform steps comprising:

receiving a selection from a user as to a pre-defined number of columns by which to shift;

receiving a request from the user to shift left or right; and

shifting the spreadsheet left or right, respectively, by the pre-defined number of columns.

13. The non-transitory computer storage media of claim 11, further having computer-executable instructions for causing a computer to perform steps comprising:

receiving a selection from a user as to a pre-defined number of rows by which to shift;

receiving a request from the user to shift up or down; and

shifting the spreadsheet up or down, respectively, by the pre-defined number of rows.