US20090313537A1 - Micro browser spreadsheet viewer - Google Patents

Micro browser spreadsheet viewer Download PDF

Info

Publication number
US20090313537A1
US20090313537A1 US12/140,289 US14028908A US2009313537A1 US 20090313537 A1 US20090313537 A1 US 20090313537A1 US 14028908 A US14028908 A US 14028908A US 2009313537 A1 US2009313537 A1 US 2009313537A1
Authority
US
United States
Prior art keywords
spreadsheet
user
chart
computer
selection
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Abandoned
Application number
US12/140,289
Inventor
Tsui-Ying Fu
Hung Ju King
Shao Yi Hung
Yung-Yu Tseng
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Microsoft Technology Licensing LLC
Original Assignee
Microsoft Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Microsoft Corp filed Critical Microsoft Corp
Priority to US12/140,289 priority Critical patent/US20090313537A1/en
Assigned to MICROSOFT CORPORATION reassignment MICROSOFT CORPORATION ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: FU, TSUI-YING, HUNG, SHAO YI, KING, HUNG JU, TSENG, YUNG-YU
Publication of US20090313537A1 publication Critical patent/US20090313537A1/en
Assigned to MICROSOFT TECHNOLOGY LICENSING, LLC reassignment MICROSOFT TECHNOLOGY LICENSING, LLC ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: MICROSOFT CORPORATION
Application status is Abandoned legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F17/00Digital computing or data processing equipment or methods, specially adapted for specific functions
    • G06F17/20Handling natural language data
    • G06F17/21Text processing
    • G06F17/24Editing, e.g. insert/delete
    • G06F17/246Spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/95Retrieval from the web
    • G06F16/957Browsing optimisation, e.g. caching or content distillation
    • G06F16/9577Optimising the visualization of content, e.g. distillation of HTML documents

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.

Description

    BACKGROUND
  • 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.
  • SUMMARY
  • 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.
  • 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.
  • BRIEF DESCRIPTION OF THE DRAWINGS
  • FIG. 1 is a process flow diagram for one implementation illustrating the stages involved in performing a search for data on a micro browser spreadsheet viewer on a mobile device.
  • FIG. 2 is a simulated screen for one implementation that illustrates selection of a location at which to begin the search.
  • FIG. 3 is a simulated screen for one implementation that illustrates an exemplary search results listing with the matching data displayed along with surrounding data.
  • FIG. 4 is a simulated screen for one implementation that illustrates additional search options that can also be used.
  • FIG. 5 is a process flow diagram for one implementation illustrating the stages involved in performing a search based upon a row or column selection.
  • FIG. 6 is a simulated screen for one implementation that illustrates allowing a user to select row or column search options.
  • FIG. 7 is a simulated screen for one implementation that illustrates an exemplary search results listing with the matching data displayed by row along with surrounding data.
  • FIG. 8 is a process flow diagram for one implementation illustrating the stages involved in rendering a chart within a micro browser spreadsheet viewer on a mobile device.
  • FIG. 9 is a simulated screen for one implementation that illustrates initially rendering a chart with just a simple icon and a title.
  • FIG. 10 is a simulated screen for one implementation that illustrates an exemplary view of the chart that can be displayed when the user selects the simple icon that represents the chart.
  • FIG. 11 is a simulated screen for one implementation that illustrates a zoomed in view of the chart shown in FIG. 10.
  • FIG. 12 is a simulated screen for one implementation that illustrates a zoomed in view of the chart shown in FIG. 11.
  • FIG. 13 is a diagrammatic view of one implementation that illustrates an exemplary navigation structure for navigating portions of the spreadsheet one section at a time.
  • FIG. 14 is a simulated screen for one implementation that illustrates an initial view of spreadsheet data that begins in an upper left corner of the spreadsheet.
  • FIG. 15 is a simulated screen for one implementation that illustrates some exemplary navigation and other options that appear at the bottom of the current view of spreadsheet data.
  • FIG. 16 is a simulated screen for one implementation that illustrates an exemplary navigation screen that can be displayed when a user selects a navigation button.
  • FIG. 17 is a simulated screen for one implementation that illustrates an exemplary settings screen that enables the user to customize various display settings.
  • FIG. 18 is a process flow diagram for one implementation illustrating the stages involved in enabling a user to freeze a selected column or row in the spreadsheet.
  • FIG. 19 is a simulated screen for one implementation that illustrates allowing a user to choose an option for whether to freeze a row or a column.
  • FIG. 20 is a simulated screen for one implementation that illustrates allowing a user to select the specific column to freeze.
  • FIG. 21 is a simulated screen for one implementation that illustrates allowing a user to select the specific row to freeze.
  • FIG. 22 is a simulated screen for one implementation that illustrates that the selected column has been frozen.
  • FIG. 23 is a simulated screen for one implementation that illustrates the data having been shifted one cell to the right, but the frozen column still remaining in place.
  • FIG. 24 is a diagrammatic view of a computer system of one implementation.
  • DETAILED DESCRIPTION
  • 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 FIGS. 1-23, the stages for implementing one or more implementations of micro browser spreadsheet viewer are described in further detail. In some implementations, the processes of FIG. 2-23 are at least partially implemented in the operating logic of computing device 600 (of FIG. 24).
  • FIG. 1 is a process flow diagram 100 for one implementation illustrating the stages involved in performing a search for data contained in a spreadsheet from within a micro browser spreadsheet viewer on a mobile device. A selection is received from a user to open a spreadsheet on a mobile device (stage 102). A find selection is received from the user (stage 104). Keyword input is received from the user (stage 106). Any matching keywords that are contained in the document are found, and their respective cell locations are retrieved (stage 108). A results page is constructed with data surrounding the keyword (stage 110). In other words, data for some of the rows and/or columns that surround the cell where the matching keyword is located can also be retrieved. The search results are then displayed to the user in one or more search results listings (stage 112), which can include the cell name and data from the cell containing the keyword, and some of the surrounding data to give the user further context. The user can then select an entry in the search results listing and go to that particular location in the spreadsheet. FIGS. 2-4 describe some exemplary screens which illustrate this search process in further detail.
  • FIG. 2 is a simulated screen 220 for one implementation that illustrates selection of a location at which to begin the search. In the example shown, the user enters the key word criteria 222 to search for in the document. The user can also select the location in the spreadsheet to search, such as from the top left cell 224 or from the first cell 226. Upon selecting the find option 228, a search is performed to see if the keyword is present in one or more locations in the spreadsheet. The results of the search are then displayed to the user in a screen such as the one illustrated in FIG. 3.
  • FIG. 3 is a simulated screen 240 for one implementation that illustrates an exemplary search results listing with the matching data displayed along with surrounding data. In this example, the keyword that was being searched for in the spreadsheet was PDA. The keyword PDA was located in at least three different positions within the spreadsheet. If the data that surrounds the keyword is also displayed for each search result listing. For example, the keyword PDA was located in cell B19 (244). This data is shown in the center 242 of the search results for that listing, along with the other surrounding rows and columns. This allows the user to see the data in its original context, and to then select a particular search result to navigate to that portion of the spreadsheet. It will be appreciated that while the search results listing in FIG. 3 are shown in a 3×3 format, numerous other variations for displaying the search results could also be used in other implementations.
  • FIG. 4 is a simulated screen 260 for one implementation that illustrates additional search options that can be used. In the example shown, additional search options are displayed after the end of the search results data being displayed on that page 262. One of the search options includes a find field 264, which allows the user to enter a keyword to search for in the spreadsheet. The location at which to begin the search can also be specified. A find option 266 can be selected to perform another search. If the user is finished performing a search, then option 268 can be selected to go back to the spreadsheet.
  • FIG. 5 is a process flow diagram 280 for one implementation illustrating the stages involved in performing a search based upon a row or column selection. A spreadsheet is opened on a mobile device (stage 281). A user selects a find option (stage 282). The user inputs one or more keywords and selects a row or column on which to base the search (stage 284). If a column search was selected, then all matching keywords are found in the document in their cell locations retrieved (stage 286). If a row search was selected, then all matching keywords are found in the document and their cell locations retrieved (stage 290). In either scenario, a results page is constructed by retrieving the cells that are in the same column or row as the keyword (stage 288). The search result is displayed to the user (stage 294) and the process ends (stage 296). The simulated screens of FIGS. 6 and 7 illustrate this process in further detail.
  • FIG. 6 is a simulated screen 300 for one implementation that illustrates allowing a user to select row or column search options. After entering the keyword(s) 302 for which to search, the user can select a row or column option 304 to indicate whether the search should be limited to values contained in a certain row or column.
  • Turning now to FIG. 7, a simulated screen 320 is shown for one implementation that illustrates an exemplary search results listing with the matching data displayed by row along with surrounding data. Since a row option was chosen on FIG. 6, the search was limited to the row that was selected when the search was initiated. In another implementation, the user can be prompted to specify which row to use for the search. The cells that contained the matching keywords are then displayed, along with the surrounding data for that cell. For example, cell A9 (322) contains the word Chinese 324, which was the keyword being searched for in this example
  • FIG. 8 is a process flow diagram 350 for one implementation illustrating the stages involved in rendering a chart or other image within a micro browser spreadsheet viewer on a mobile device. A spreadsheet is displayed for the user to view (stage 352). If the spreadsheet contains a chart (or other image) (decision point 354), then the chart is rendered as an image icon or other representation (graphic or textual) (stage 356). The term “chart” as used herein is meant to include any type of graphic chart, image, photo, etc. that may be present in a spreadsheet. In one implementation, different types of icons are used to visually indicate the type of chart it is. For example, if the chart is a bar chart, then the icon representing the chart can have a bar chart graphic. If the chart is a photo such as a jpg, then the icon can display a graphic or other representation to show that it is a jpg format.
  • 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 FIG. 8 are just provided for the sake of illustration. In other implementations, various other zoom in or zoom out combinations could also be supported. The process of FIG. 8 will now be described in further detail with the simulated screens of FIGS. 9-12.
  • FIG. 9 is a simulated screen 380 for one implementation that illustrates initially rendering a chart with just a simple icon and a title. In the position where the chart appears in the original spreadsheet, an icon 382 along with the title of the chart is displayed. In one implementation, the user can view the actual chart by selecting the icon 382. In one implementation, by showing the chart in a simple icon format initially, resources can be saved by not rendering a chart unless and until the end user wishes to view it.
  • FIG. 10 is a simulated screen 390 for one implementation that illustrates an exemplary view of the chart that can be displayed when the user selects the simple icon that represents the chart. In the example shown in FIG. 10, the chart is displayed in a format that is fit according to the current window 392 so the user can see a small version of the entire chart. Upon selecting the chart, or upon otherwise selecting a zoom in option, a larger view of the chart can be displayed. An example of this is shown in FIG. 11.
  • FIG. 11 is a simulated screen 394 for one implementation that illustrates a zoomed in view 395 of the chart shown in FIG. 10. Again, upon selecting the chart, or upon otherwise selecting a zoom in option, a larger view of the chart can be displayed. An example of this is shown in FIG. 12.
  • FIG. 12 is a simulated screen 396 for one implementation that illustrates a zoomed in view of the chart shown in FIG. 11. In the example view of FIG. 12, the chart is being displayed in its original size 398, which causes a portion of it to chop off of the screen.
  • Turning now to FIGS. 13-16, some exemplary navigation features for navigating around the spreadsheet in a micro browser spreadsheet viewer are illustrated. FIG. 13 is a diagrammatic view 400 of one implementation that illustrates an exemplary navigation structure for navigating portions of the spreadsheet one section at a time. Using right, left, down, and up navigation options, the user is able to control which cells of the spreadsheet are shown at a given time. For example, when the spreadsheet is first opened, a small portion of the entire spreadsheet is displayed initially on the screen as the current view. Upon selecting a right navigation option 402, the next region to the right of the initial page is then displayed that shows additional columns for the current rows of data. From the second page being displayed on the screen, if the user selects a down navigation option 404, then the spreadsheet view shifts down several rows to reach the next region of the spreadsheet. If the user then wishes to navigate to the right, then the user can select a right navigation option 406 to further scroll to the right to see additional columns in the current region. An up navigation option can also be used as appropriate to shift the spreadsheet upward. These navigation concepts will now be illustrated graphically in FIGS. 14-16.
  • FIG. 14 is a simulated screen 420 for one implementation that illustrates an initial view of spreadsheet data 428 that begins in an upper left corner of the spreadsheet. Upon selecting next row set option 422, the rows that are displayed get shifted by a pre-defined number of rows (such as fifty rows). Upon selecting right navigation option 424, the columns that are displayed get shifted so that columns E, F, G, and H are shown for rows 1 through 14, for example. Upon selecting next column set option 426, the columns that are displayed get shifted by a pre-defined number of columns (such as four columns).
  • FIG. 15 is a simulated screen 430 for one implementation that illustrates some exemplary navigation and other options that appear at the bottom of the current view of spreadsheet data. If the user scrolls to the bottom of the data region being displayed in FIG. 14, then some additional navigation and other options are presented. For example, the user can select a next row set option 432, next column option 434, next column set option 436, an option to go to one or more other sheets 438, an option to freeze a particular column or row 440, or to view certain display settings 442. The user can select an option to go to the first cell (A1) 444, to go back to the entry point 446, or to see the document properties 448. These navigation and other options are just provided for the sake of illustration, and numerous other variations could also be used instead of or in addition to these.
  • FIG. 16 is a simulated screen 450 for one implementation that illustrates an exemplary navigation screen that can be displayed when a user selects a navigation button. In this example, the user is first prompted to specify how many columns to the right the data should be shifted. As screen such as FIG. 16 can be shown in an alternate implementation, such as instead of the next row set option (432 on FIG. 15) and/or the next column set option (436 on FIG. 15) that were displayed directly on the navigation bar and in the bottom region of the spreadsheet. Upon receiving the user's selection 452 of the number of columns to scroll to the right, then the spreadsheet view is updated accordingly. In other implementations, the view simply shifts by a pre-determined or user-defined setting that had specified the number of rows or columns to shift so that the user is not prompted to specify the information every time he/she navigates through the document.
  • FIG. 17 is a simulated screen 460 for one implementation that illustrates an exemplary settings screen that enables the user to customize various display settings. In this example, the user is able to choose a column option 462 to set the number of columns to be displayed per page, along with a row option 464 to set the number of rows to be displayed per page.
  • Turning now to FIGS. 18-23, options for freezing one or more portions of the spreadsheet from within the micro browser spreadsheet viewer are described. FIG. 18 is a process flow diagram 500 for one implementation illustrating the stages involved in enabling a user to freeze a selected column or row in the spreadsheet. While the user is viewing a spreadsheet (stage 502), he or she can select an option to freeze a column or row (stage 504). If an option is chosen to freeze a particular column, then the page is reconstructed to make sure that the frozen column always displayed on the screen (stage 506). If an option is chosen to freeze a particular row, then the page is reconstructed to make sure that the frozen row always displayed on the screen (stage 508). When the user cancels freezing, the process ends at end point 510. FIGS. 19-23 are simulated screens that illustrate the row and column freezing features in further detail.
  • FIG. 19 is a simulated screen 520 for one implementation that illustrates allowing a user to choose an option for whether to freeze a row 522 or to freeze a column 524. In one implementation, the same options screen also contains an unfreeze option 526 to allow the user to turn off the freezing option. Upon selecting the option to freeze a column 524, a screen similar to the simulated screen 530 of FIG. 20 is displayed. Screen 530 allows the user to input the specific column 532 that he or she would like to freeze. Returning to FIG. 19, upon selecting the option to freeze a row 522, a screen similar to the simulated screen 540 of FIG. 21 is displayed. Screen 540 allows the user to input the specific row 542 that he or she would like to freeze. Upon selecting one of the options to freeze a particular row or column, the spreadsheet view is then updated so that the selected row or column stays in place even while the user navigates the rest of the document.
  • FIG. 22 is a simulated screen 550 for one implementation that illustrates that the selected column has been frozen. In the example shown, Column A 552 has been frozen, and the data that can shift left and right begins with Column B 554.
  • FIG. 23 is a simulated screen 560 for one implementation that illustrates the data having been shifted one cell to the right 564, but the frozen column (Column A 562 in this example) still remaining in place.
  • As shown in FIG. 24, an exemplary computer system to use for implementing one or more parts of the system includes a computing device, such as computing device 600. In its most basic configuration, computing device 600 typically includes at least one processing unit 602 and memory 604. Depending on the exact configuration and type of computing device, memory 604 may be volatile (such as RAM), non-volatile (such as ROM, flash memory, etc.) or some combination of the two. This most basic configuration is illustrated in FIG. 24 by dashed line 606.
  • 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 FIG. 24 by removable storage 608 and non-removable storage 610. Computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data. Memory 604, removable storage 608 and non-removable storage 610 are all examples of computer storage media. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, digital versatile disks (DVD) or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed by device 600. Any such computer storage media may be part of device 600.
  • 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 (20)

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.
US12/140,289 2008-06-17 2008-06-17 Micro browser spreadsheet viewer Abandoned US20090313537A1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
US12/140,289 US20090313537A1 (en) 2008-06-17 2008-06-17 Micro browser spreadsheet viewer

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US12/140,289 US20090313537A1 (en) 2008-06-17 2008-06-17 Micro browser spreadsheet viewer
US14/586,790 US10031905B2 (en) 2008-06-17 2014-12-30 Micro browser spreadsheet viewer

Related Child Applications (1)

Application Number Title Priority Date Filing Date
US14/586,790 Division US10031905B2 (en) 2008-06-17 2014-12-30 Micro browser spreadsheet viewer

Publications (1)

Publication Number Publication Date
US20090313537A1 true US20090313537A1 (en) 2009-12-17

Family

ID=41415880

Family Applications (2)

Application Number Title Priority Date Filing Date
US12/140,289 Abandoned US20090313537A1 (en) 2008-06-17 2008-06-17 Micro browser spreadsheet viewer
US14/586,790 Active 2028-10-02 US10031905B2 (en) 2008-06-17 2014-12-30 Micro browser spreadsheet viewer

Family Applications After (1)

Application Number Title Priority Date Filing Date
US14/586,790 Active 2028-10-02 US10031905B2 (en) 2008-06-17 2014-12-30 Micro browser spreadsheet viewer

Country Status (1)

Country Link
US (2) US20090313537A1 (en)

Cited By (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080082938A1 (en) * 2006-10-03 2008-04-03 Tomasz Buczek System and method for freezing columns and rows in a ui table
US20100083082A1 (en) * 2008-09-30 2010-04-01 Apple Inc. Locking spreadsheet cells
US20100188679A1 (en) * 2009-01-26 2010-07-29 Nakagawa Chisa Document image data printing system
US20100287467A1 (en) * 2005-03-30 2010-11-11 Research In Motion Limited Method for requesting and viewing a preview of a table attachment on a mobile communication device
US20110185305A1 (en) * 2010-01-28 2011-07-28 Ebay Inc. Application module for managing jobs asynchronously
WO2011137079A3 (en) * 2010-04-30 2012-04-19 Microsoft Corporation Spin control user interface for selecting options
US20120151317A1 (en) * 2010-12-13 2012-06-14 Ronald Ho System and Method for Providing Online Data Management Services
US20140026041A1 (en) * 2012-07-17 2014-01-23 Microsoft Corporation Interacting with a document as an application
US9013513B2 (en) 2012-04-12 2015-04-21 Blackberry Limited Methods and apparatus to navigate electronic documents
US9164972B2 (en) 2012-06-07 2015-10-20 Microsoft Technology Licensing, Llc Managing objects in panorama display to navigate spreadsheet
CN105022722A (en) * 2014-04-18 2015-11-04 珠海金山办公软件有限公司 Electronic form row and column freezing method and electronic form row and column freezing device
WO2016018681A3 (en) * 2014-07-28 2016-06-30 Microsoft Technology Licensing, Llc Presenting dataset of spreadsheet in form based view
US9477392B2 (en) 2011-06-20 2016-10-25 Blackberry Limited Presentation of tabular information
US20170010785A1 (en) * 2014-09-08 2017-01-12 Tableau Software Inc. Methods and devices for displaying data mark information
US20170124055A1 (en) * 2015-11-02 2017-05-04 Microsoft Technology Licensing, Llc Decks, cards, and mobile ui
US9645723B2 (en) 2012-05-29 2017-05-09 Microsoft Technology Licensing, Llc Row and column navigation
US9933931B2 (en) 2015-06-23 2018-04-03 Microsoft Technology Licensing Llc Freeze pane with snap scrolling
US10031905B2 (en) 2008-06-17 2018-07-24 Microsoft Technology Licensing, Llc Micro browser spreadsheet viewer
US10169401B1 (en) 2011-03-03 2019-01-01 Google Llc System and method for providing online data management services

Citations (22)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4191673A (en) * 1976-11-12 1980-03-04 American Can Company Non-blocking coating composition
US20030084104A1 (en) * 2001-10-31 2003-05-01 Krimo Salem System and method for remote storage and retrieval of data
US20040139397A1 (en) * 2002-10-31 2004-07-15 Jianwei Yuan Methods and apparatus for summarizing document content for mobile communication devices
US20050273695A1 (en) * 2004-06-02 2005-12-08 Schnurr Jeffrey R Representing spreadsheet document content
US20060225001A1 (en) * 2005-03-30 2006-10-05 Sylthe Olav A Method for requesting and viewing a preview of a table attachment on a mobile communication device
US20060271520A1 (en) * 2005-05-27 2006-11-30 Ragan Gene Z Content-based implicit search query
US7181417B1 (en) * 2000-01-21 2007-02-20 Microstrategy, Inc. System and method for revenue generation in an automatic, real-time delivery of personalized informational and transactional data
US20070050448A1 (en) * 2005-08-25 2007-03-01 Polycom, Inc. Method and system for information collaboration over an IP network via handheld wireless communication devices
US20070061751A1 (en) * 2005-09-15 2007-03-15 Microsoft Corporation Integrating charts in documents
US20070067305A1 (en) * 2005-09-21 2007-03-22 Stephen Ives Display of search results on mobile device browser with background process
US20070074108A1 (en) * 2005-09-26 2007-03-29 Microsoft Corporation Categorizing page block functionality to improve document layout for browsing
US7200615B2 (en) * 2003-10-16 2007-04-03 Xerox Corporation Viewing tabular data on small handheld displays and mobile phones
US7289981B2 (en) * 2002-12-10 2007-10-30 International Business Machines Corporation Using text search engine for parametric search
US20080018928A1 (en) * 2006-07-17 2008-01-24 Business Objects, S.A. Apparatus and method for report invocation and manipulation on a mobile communication device
US20080082938A1 (en) * 2006-10-03 2008-04-03 Tomasz Buczek System and method for freezing columns and rows in a ui table
US20090106200A1 (en) * 2007-09-10 2009-04-23 Robert Salinas Methods and Systems of Content Mobilization, Mobile Search, and Video Editing through a Web Interface
US20090249418A1 (en) * 2008-03-28 2009-10-01 Channer Medianet, S.L. Repository for information about streaming video/audio channels
US7630972B2 (en) * 2007-01-05 2009-12-08 Yahoo! Inc. Clustered search processing
US20090327240A1 (en) * 2007-08-20 2009-12-31 Meehan Stephen W System And Method For Organizing Data In A Dynamic User-Customizable Interface For Search And Display
US7712027B2 (en) * 2004-08-31 2010-05-04 Research In Motion Limited Method for document page delivery to a mobile communication device
US7937395B2 (en) * 2008-02-22 2011-05-03 Tigerlogic Corporation Systems and methods of displaying and re-using document chunks in a document development application
US20110298805A1 (en) * 2010-03-11 2011-12-08 Lumesis LLC Method and Data Processing System for Financial Planning

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5621876A (en) * 1995-04-07 1997-04-15 Apple Computer, Inc. Method and apparatus for modifying a display matrix in a computer window by adding one column or row at a time
JPH10340172A (en) * 1997-06-06 1998-12-22 Sharp Corp Data processor and medium storing data processor controlling program
US6005573A (en) * 1997-06-12 1999-12-21 Siemens Information And Communication Networks, Inc. Method and system for establishing area boundaries in computer applications
US20090313537A1 (en) 2008-06-17 2009-12-17 Microsoft Corporation Micro browser spreadsheet viewer

Patent Citations (23)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4191673A (en) * 1976-11-12 1980-03-04 American Can Company Non-blocking coating composition
US7181417B1 (en) * 2000-01-21 2007-02-20 Microstrategy, Inc. System and method for revenue generation in an automatic, real-time delivery of personalized informational and transactional data
US20030084104A1 (en) * 2001-10-31 2003-05-01 Krimo Salem System and method for remote storage and retrieval of data
US20040139397A1 (en) * 2002-10-31 2004-07-15 Jianwei Yuan Methods and apparatus for summarizing document content for mobile communication devices
US7289981B2 (en) * 2002-12-10 2007-10-30 International Business Machines Corporation Using text search engine for parametric search
US7200615B2 (en) * 2003-10-16 2007-04-03 Xerox Corporation Viewing tabular data on small handheld displays and mobile phones
US20050273695A1 (en) * 2004-06-02 2005-12-08 Schnurr Jeffrey R Representing spreadsheet document content
US7299406B2 (en) * 2004-06-02 2007-11-20 Research In Motion Limited Representing spreadsheet document content
US7712027B2 (en) * 2004-08-31 2010-05-04 Research In Motion Limited Method for document page delivery to a mobile communication device
US20060225001A1 (en) * 2005-03-30 2006-10-05 Sylthe Olav A Method for requesting and viewing a preview of a table attachment on a mobile communication device
US20060271520A1 (en) * 2005-05-27 2006-11-30 Ragan Gene Z Content-based implicit search query
US20070050448A1 (en) * 2005-08-25 2007-03-01 Polycom, Inc. Method and system for information collaboration over an IP network via handheld wireless communication devices
US20070061751A1 (en) * 2005-09-15 2007-03-15 Microsoft Corporation Integrating charts in documents
US20070067305A1 (en) * 2005-09-21 2007-03-22 Stephen Ives Display of search results on mobile device browser with background process
US20070074108A1 (en) * 2005-09-26 2007-03-29 Microsoft Corporation Categorizing page block functionality to improve document layout for browsing
US20080018928A1 (en) * 2006-07-17 2008-01-24 Business Objects, S.A. Apparatus and method for report invocation and manipulation on a mobile communication device
US20080082938A1 (en) * 2006-10-03 2008-04-03 Tomasz Buczek System and method for freezing columns and rows in a ui table
US7630972B2 (en) * 2007-01-05 2009-12-08 Yahoo! Inc. Clustered search processing
US20090327240A1 (en) * 2007-08-20 2009-12-31 Meehan Stephen W System And Method For Organizing Data In A Dynamic User-Customizable Interface For Search And Display
US20090106200A1 (en) * 2007-09-10 2009-04-23 Robert Salinas Methods and Systems of Content Mobilization, Mobile Search, and Video Editing through a Web Interface
US7937395B2 (en) * 2008-02-22 2011-05-03 Tigerlogic Corporation Systems and methods of displaying and re-using document chunks in a document development application
US20090249418A1 (en) * 2008-03-28 2009-10-01 Channer Medianet, S.L. Repository for information about streaming video/audio channels
US20110298805A1 (en) * 2010-03-11 2011-12-08 Lumesis LLC Method and Data Processing System for Financial Planning

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
Shelly, Gary et al, Microsoft Office Excel 2007: Complete Concepts and Techniques, July 13 2007, Cengage Learning, Pages 481-482. *

Cited By (35)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20100287467A1 (en) * 2005-03-30 2010-11-11 Research In Motion Limited Method for requesting and viewing a preview of a table attachment on a mobile communication device
US8533585B2 (en) 2006-10-03 2013-09-10 Blackberry Limited System and method for freezing columns and rows in a UI table
US7779346B2 (en) * 2006-10-03 2010-08-17 Research In Motion Limited System and method for freezing columns and rows in a UI table
US20100269031A1 (en) * 2006-10-03 2010-10-21 Tomasz Buczek System and method for freezing columns and rows in a ui table
US20080082938A1 (en) * 2006-10-03 2008-04-03 Tomasz Buczek System and method for freezing columns and rows in a ui table
US10031905B2 (en) 2008-06-17 2018-07-24 Microsoft Technology Licensing, Llc Micro browser spreadsheet viewer
US20100083082A1 (en) * 2008-09-30 2010-04-01 Apple Inc. Locking spreadsheet cells
US9223771B2 (en) * 2008-09-30 2015-12-29 Apple Inc. Locking spreadsheet cells
US20100188679A1 (en) * 2009-01-26 2010-07-29 Nakagawa Chisa Document image data printing system
US20110185305A1 (en) * 2010-01-28 2011-07-28 Ebay Inc. Application module for managing jobs asynchronously
US8578289B2 (en) * 2010-01-28 2013-11-05 Ebay Inc. Application module for managing jobs asynchronously
US9558174B2 (en) 2010-01-28 2017-01-31 Ebay Inc. Application module for managing jobs asynchronously
WO2011137079A3 (en) * 2010-04-30 2012-04-19 Microsoft Corporation Spin control user interface for selecting options
AU2011245430B2 (en) * 2010-04-30 2014-05-15 Microsoft Technology Licensing, Llc Spin control user interface for selecting options
CN102859482A (en) * 2010-04-30 2013-01-02 微软公司 Spin control user interface for selecting options
US9367198B2 (en) 2010-04-30 2016-06-14 Microsoft Technology Licensing, Llc Spin control user interface for selecting options
US9201858B2 (en) * 2010-12-13 2015-12-01 Google Inc. System and method for providing online data management services
US8250459B2 (en) * 2010-12-13 2012-08-21 Google Inc. System and method for providing online data management services
US20150193420A1 (en) * 2010-12-13 2015-07-09 Ronald Ho System and Method for Providing Online Data Management Services
US20120151317A1 (en) * 2010-12-13 2012-06-14 Ronald Ho System and Method for Providing Online Data Management Services
US8250460B1 (en) * 2010-12-13 2012-08-21 Google Inc. System and method for providing online data management services
US10169401B1 (en) 2011-03-03 2019-01-01 Google Llc System and method for providing online data management services
US9477392B2 (en) 2011-06-20 2016-10-25 Blackberry Limited Presentation of tabular information
US9013513B2 (en) 2012-04-12 2015-04-21 Blackberry Limited Methods and apparatus to navigate electronic documents
US9645723B2 (en) 2012-05-29 2017-05-09 Microsoft Technology Licensing, Llc Row and column navigation
US9164972B2 (en) 2012-06-07 2015-10-20 Microsoft Technology Licensing, Llc Managing objects in panorama display to navigate spreadsheet
CN104471566A (en) * 2012-07-17 2015-03-25 微软公司 Interacting with a document as an application
US20140026041A1 (en) * 2012-07-17 2014-01-23 Microsoft Corporation Interacting with a document as an application
US20160055128A1 (en) * 2012-07-17 2016-02-25 Microsoft Technology Licensing, Llc Interacting with data from a document via document an application pages
US10282392B2 (en) * 2012-07-17 2019-05-07 Microsoft Technology Licensing, Llc Interacting with data from a document via document an application pages
CN105022722A (en) * 2014-04-18 2015-11-04 珠海金山办公软件有限公司 Electronic form row and column freezing method and electronic form row and column freezing device
WO2016018681A3 (en) * 2014-07-28 2016-06-30 Microsoft Technology Licensing, Llc Presenting dataset of spreadsheet in form based view
US20170010785A1 (en) * 2014-09-08 2017-01-12 Tableau Software Inc. Methods and devices for displaying data mark information
US9933931B2 (en) 2015-06-23 2018-04-03 Microsoft Technology Licensing Llc Freeze pane with snap scrolling
US20170124055A1 (en) * 2015-11-02 2017-05-04 Microsoft Technology Licensing, Llc Decks, cards, and mobile ui

Also Published As

Publication number Publication date
US10031905B2 (en) 2018-07-24
US20150113377A1 (en) 2015-04-23

Similar Documents

Publication Publication Date Title
US8280901B2 (en) Method and system for displaying search results
AU2011101579B4 (en) Selective rendering of off-screen content
CN102349066B (en) New tab pages and bookmark toolbars in a browser
US7343567B2 (en) System and method for providing dynamic user information in an interactive display
US7739622B2 (en) Dynamic thumbnails for document navigation
US7454694B2 (en) Method and system for organizing document information in a non-directed arrangement of documents
US8756523B2 (en) Terminal, history management method, and computer usable storage medium for history management
RU2403614C2 (en) User interface application for managing media files
CA2619970C (en) Software architecture for displaying information content from plug-in modules in a user interface
US7693912B2 (en) Methods for navigating collections of information in varying levels of detail
US8005857B2 (en) Object search UI and dragging object results
RU2546593C2 (en) Integrating digital book and zoom interface displays
RU2530301C2 (en) Scrollable menus and toolbars
KR101814102B1 (en) Multipoint pinch gesture control of search results
US8055444B2 (en) Content display and navigation interface
US7810049B2 (en) System and method for web navigation using images
US20070198930A1 (en) Methods, Systems and Computer Program Products for Controlling Tree Diagram Graphical User Interfaces and/or For Partially Collapsing Tree Diagrams
US7721197B2 (en) System and method of displaying content on small screen computing devices
CA2818406C (en) Multi-mode web browsing
US8205172B2 (en) Graphical web browser history toolbar
EP2074497B1 (en) Method and device for selecting and displaying a region of interest in an electronic document
US20100095219A1 (en) Selective history data structures
KR101319792B1 (en) Efficient navigation of search results
US20090254867A1 (en) Zoom for annotatable margins
US20060041846A1 (en) Method of window management for a windowing system

Legal Events

Date Code Title Description
AS Assignment

Owner name: MICROSOFT CORPORATION, WASHINGTON

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:FU, TSUI-YING;KING, HUNG JU;HUNG, SHAO YI;AND OTHERS;REEL/FRAME:021412/0831

Effective date: 20080613

AS Assignment

Owner name: MICROSOFT TECHNOLOGY LICENSING, LLC, WASHINGTON

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:MICROSOFT CORPORATION;REEL/FRAME:034564/0001

Effective date: 20141014

STCB Information on status: application discontinuation

Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION