MICRO BROWSER SPREADSHEET VIEWER
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.
Latest Microsoft Patents:
- APPLICATION SINGLE SIGN-ON DETERMINATIONS BASED ON INTELLIGENT TRACES
- SCANNING ORDERS FOR NON-TRANSFORM CODING
- SUPPLEMENTAL ENHANCEMENT INFORMATION INCLUDING CONFIDENCE LEVEL AND MIXED CONTENT INFORMATION
- INTELLIGENT USER INTERFACE ELEMENT SELECTION USING EYE-GAZE
- NEURAL NETWORK ACTIVATION COMPRESSION WITH NON-UNIFORM MANTISSAS
In today's world of technology, it is easier than ever before to access information while traveling. For example, laptop computers often have wireless internet access to corporate networks to allow users to access critical data when needed. Similarly, mobile devices are becoming more and more advanced, and most mobile phones and PDAs today provide the user with access to the Internet and sometimes company documents from within the small viewing window that the mobile phone or PDA has to offer.
As with most advances in technology, there are also some challenges. Mobile phones and PDAs have very small screens for displaying information to end users. So even though these devices may have a fast Internet connection for retrieving large documents, there is still an issue with finding the best ways to fit that information onto the small screen of the mobile device for the user to view it.
SUMMARYVarious 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.
In one implementation, navigation options are provided for allowing a user to navigate around the spreadsheet. A selection is received from a user to open a spreadsheet. A portion of the spreadsheet is displayed 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, a right navigation option is provided that when selected will shift the spreadsheet rightward by a pre-defined number of cells. When the spreadsheet contains additional columns of data on a left side of any columns being displayed in the current view, a left navigation option is provided that when selected will shift the spreadsheet leftward by the pre-defined number of cells. When the spreadsheet contains additional rows of data on a lower side of any rows being displayed in the current view, a down navigation option is provided that when selected will shift the spreadsheet downward by the pre-defined number of cells. When the spreadsheet contains additional rows of data on an upper side of any rows being displayed in the current view, an up navigation option is provided that when selected will shift the spreadsheet upward by the pre-defined number of cells.
In another implementation, techniques are described for optimizing the display of charts in the spreadsheet. A selection is received from a user to open a spreadsheet on a mobile device. When the spreadsheet being opened contains a chart, an icon is displayed instead of the chart. A selection is received from the user to view the chart. The chart is then displayed in the spreadsheet for the user to view and interact with.
This Summary was provided to introduce a selection of concepts in a simplified form that are further described below in the Detailed Description. This Summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used as an aid in determining the scope of the claimed subject matter.
The technologies and techniques herein may be described in the general context as an application that enables spreadsheets to be browsed in a micro browser on a mobile device, but the technologies and techniques also serve other purposes in addition to these. In one implementation, one or more of the techniques described herein can be implemented as features within a mobile device spreadsheet program such as MICROSOFT® Excel Mobile, from within a content management application such as MICROSOFT® SharePoint, and/or from any other type of program or service that stores and/or interfaces with spreadsheets that are displayed on a mobile device.
In one implementation, a micro browser spreadsheet viewer is described that allows a user to view and optionally manage spreadsheets from a mobile device such as a mobile phone or PDA in an efficient manner. The term “micro browser spreadsheet viewer” as used herein is meant to include a spreadsheet program that is designed to operate with a small viewing window, such as a screen of a mobile device. The micro browser spreadsheet viewer is designed to provide a rich user experience for interacting with spreadsheets, but within the confines of the limited screen space offered on such mobile devices. For example, the user is able to navigate both horizontally and vertically through the spreadsheet using a series of navigation options (e.g. buttons or otherwise). A find technique is offered that displays multiple search results on a page along with a context of the surrounding data from the cells that surround the matching keyword that was being searched for. Row and column freezing is made available for the spreadsheet. Alternatively or additionally, images and charts are initially rendered as icons so that their load time and/or download time can be reduced, and/or the screen real estate preserved until the user is ready to view them.
While the techniques herein are described in the context of a micro browser spreadsheet viewer on a mobile device, some or all of these techniques could also be used in other spreadsheet programs running on a larger device such as a desktop computer or laptop computer and still prove beneficial to end users.
Turning now to
Turning now to
In one implementation, the chart is initially rendered as an icon in order to save time for downloading the chart from an online web server that is storing the spreadsheet, when applicable. Alternatively or additionally, any costs associated with download transfer fees (i.e. internet data transfer costs) can be saved until the information is actually needed. In another implementation, the chart is initially rendered as an icon in order to save screen real estate until the user is ready to view the information.
When the user wishes to actually view the chart, then the user can click on a chart link or other chart view option (stage 358), and the chart image is retrieved (when applicable) and then displayed, such as in a mode which is fit to the screen (stage 360). The user is able to zoom in further on the chart, or to return back to the spreadsheet (stage 362). If the user selects an option to zoom in, then a larger (medium size) image is shown (stage 364). The user can choose to further zoom in to the original size of the image, to zoom out, or to return to the spreadsheet (stage 366).
From the original size of the image, if the user selects an option to zoom out, then a medium size image is shown (stage 364). If the user chooses to zoom in a second time, then the original and larger size of the image is shown (stage 368). The user can choose to zoom out or go back to the spreadsheet (stage 370). At any point upon selecting an option to return to the spreadsheet, the zooming process ends and the user is returned to the spreadsheet (stage 372). It will be appreciated that the zoom in and zoom out examples described in
Turning now to
Turning now to
As shown in
Additionally, device 600 may also have additional features/functionality. For example, device 600 may also include additional storage (removable and/or non-removable) including, but not limited to, magnetic or optical disks or tape. Such additional storage is illustrated in
Computing device 600 includes one or more communication connections 614 that allow computing device 600 to communicate with other computers/applications 615. Device 600 may also have input device(s) 612 such as keyboard, mouse, pen, voice input device, touch input device, etc. Output device(s) 611 such as a display, speakers, printer, etc. may also be included. These devices are well known in the art and need not be discussed at length here.
Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or acts described above. Rather, the specific features and acts described above are disclosed as example forms of implementing the claims. All equivalents, changes, and modifications that come within the spirit of the implementations as described herein and/or by the following claims are desired to be protected.
For example, a person of ordinary skill in the computer software art will recognize that the examples discussed herein could be organized differently on one or more computers to include fewer or additional options or features than as portrayed in the examples.
Claims
1. A method for performing a search for data in a spreadsheet viewer on a mobile device comprising the steps of:
- receiving a selection from a user to open a spreadsheet;
- receiving a find selection from the user;
- receiving one or more keywords from the user for which to the user wishes to search;
- finding any keywords in the spreadsheet which match the one or more keywords received from the user;
- retrieving a cell location of the one or more keywords found in the spreadsheet;
- constructing a results page that shows search one or more search result listings with the one or more keywords along with data surrounding the one or more keywords; and
- displaying the results page.
2. The method of claim 1, wherein the keyword is centered in each of the search result listings.
3. The method of claim 1, wherein each of the search result listings is three rows high and three columns wide.
4. The method of claim 1, further comprising the steps of:
- receiving user selection of one of the search result listings.
5. The method of claim 4, further comprising the steps of:
- returning to the spreadsheet to a location where the selected search result listing is found.
6. The method of claim 1, wherein the results page shows a cell name for each search result listing in which the keyword was found.
7. The method of claim 1, further comprising the steps of:
- at the bottom of the results page, providing additional options to the user.
8. The method of claim 7, wherein the additional options include options which allow the user to perform another search.
9. The method of claim 7, wherein the additional options include an option to leave the results page and return back to the spreadsheet.
10. A computer-readable medium having computer-executable instructions for causing a computer to perform steps comprising:
- receiving a selection from a 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 a pre-defined number of cells;
- 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 cells;
- 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 cells; 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 cells.
11. The computer-readable medium of claim 10, 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.
12. The computer-readable medium of claim 11, further having computer-executable instructions for causing a computer to perform steps comprising:
- prompting the user to specify the row or column to freeze.
13. The computer-readable medium of claim 12, 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.
14. The computer-readable medium of claim 13, 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.
15. A method for optimizing a display of charts in spreadsheets on a mobile device comprising the steps of:
- receiving a selection from a user to open a spreadsheet on a mobile device;
- when the spreadsheet being opened contains a chart, displaying an icon instead of the chart;
- receiving a selection from the user to view the chart; and
- retrieving and displaying the chart in the spreadsheet.
16. The method of claim 15, wherein the chart is displayed at a size that fits completely within a viewing window on the mobile device.
17. The method of claim 15, further comprising the steps of:
- receiving a selection from a user to zoom in on the chart; and
- in response to the selection to zoom in on the chart, displaying the chart in a larger size on the mobile device.
18. The method of claim 17, further comprising the steps of:
- receiving a selection from the user to return to the spreadsheet; and
- displaying the spreadsheet with the chart again represented as an icon.
19. The method of claim 15, wherein the retrieving is performed by accessing an external computer over an Internet connection.
20. The method of claim 15, wherein the retrieval of the chart is delayed until the chart is needed to preserve resources on the mobile device.
Type: Application
Filed: Jun 17, 2008
Publication Date: Dec 17, 2009
Applicant: MICROSOFT CORPORATION (Redmond, WA)
Inventors: Tsui-Ying Fu (Taipei), Hung Ju King (Taipei), Shao Yi Hung (Taipei), Yung-Yu Tseng (Taipei)
Application Number: 12/140,289
International Classification: G06F 17/00 (20060101);