Mobile Spreadsheet Viewer Search and Navigation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Mobile devices have limited screen space, making it difficult to effectively display and navigate large spreadsheets and charts, and existing technologies do not efficiently manage data retrieval and visualization on these devices.
Innovation Solution
A micro browser spreadsheet viewer is developed, allowing users to navigate spreadsheets on mobile devices with search functionality, row and column freezing, and optimized chart rendering as icons, enabling efficient data management and visualization within limited screen space.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If large spreadsheets are displayed on mobile devices, then complete data visibility is improved, but screen space is insufficient
Solution Approach 1:
The spreadsheet is divided into multiple pages, with each page displaying a portion of the data. Users can navigate between pages to view different sections, allowing complete data visibility while maintaining comfortable display density on limited screen space.
Solution Approach 2:
Navigation controls are positioned in the toolbar area (horizontal dimension) rather than requiring vertical scrolling space. This utilizes the horizontal dimension of the screen for navigation functionality, preserving vertical screen real estate for data display.
2Ease of operation
If navigation controls are added to mobile spreadsheet viewer, then data accessibility is improved, but device complexity is increased
Solution Approach 1:
The toolbar serves multiple functions: displaying application branding, providing navigation controls (previous page, next page, first page, last page), and maintaining a consistent interface across different spreadsheet views. This consolidates multiple functionalities into a single interface element, reducing overall device complexity.
Solution Approach 2:
The toolbar acts as an intermediary layer between the user and the spreadsheet data, providing standardized navigation controls that simplify interaction without requiring users to understand the underlying data structure or implement custom navigation logic.
3Loss of information
If charts are displayed in full on mobile devices, then data visualization quality is improved, but load time is increased
Solution Approach 1:
Charts are extracted from the main spreadsheet view and displayed in a separate full-screen overlay mode. This allows the chart rendering engine to focus resources on creating high-quality visualizations without the overhead of integrating them into the spreadsheet grid layout, improving both visualization quality and load efficiency.
Solution Approach 2:
Chart data is pre-processed and prepared for rendering before being displayed in full-screen mode. This preliminary preparation includes data validation, format conversion, and rendering optimization, which reduces the actual display load time while maintaining high visualization quality.
Data Source
AI 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. 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.