Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Method to composite collaborative spreadsheet summary pages on mobile

IP.com Disclosure Number: IPCOM000248216D
Publication Date: 2016-Nov-10
Document File: 9 page(s) / 107K

Publishing Venue

The IP.com Prior Art Database

Abstract

This invention provides a method to pick columns and rows dynamically based on users edit and view history and composite summary pages on mobile for collaborative spreadsheet. A primary column will always be displayed as the first column in every display page. Top N columns will be selected based on the editing history and the device display width. Rows for the selected columns will be ranked by priority. The pages are generated based on device size and will be displayed on mobile device one by one. So a user can view the cells or contents that are changed most recently in a spreadsheet with large rows and columns on mobile device easily.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 27% of the total text.

Page 01 of 9

Method to composite collaborative spreadsheet summary pages on mobile

Todays spreadsheet usually has large rows and columns and it's hard to be displayed in the screen, it's even worse on mobile device. A common solution is to provide a horizontal and vertical scroll bar or split a large sheet to regular small pages to display one by one. For the scroll bar or the regular pages approach, it's very hard for a user to find the cells or contents that are changed most recently because the cells are among the large spreadsheet. Another method is to jump to the cells that was revised last time whenever a user open the spreadsheet. However, it can only focus on a certain cell. This invention provide a method to pick spreadsheet columns and rows dynamically based on it's editing history. A algorithm is used to prioritize the columns and rows and order the columns and rows into small pages according to the rank result. The pages generated dynamically will be displayed on mobile device one by one. In the invention, a primary column is introduced, a primary column is a column that will always be displayed as the first column in every display page.

Therefore we need a model or a method to do the following:


1. A primary column and the method to select the primary column. A primary column is the column that will always be displayed as first column when show on device. It's the most less changed column, the most occupied column, the most earlier input column and does not contain any reference.

2. A method to select Top N columns. Top N columns will be selected based on the editing history and the device display width. The column with newest changes or most often changes has highest priority. The more newer for a column, or more revised cells in the column has more higer priority. Selected columns will be ordered according to the Top N columns priority.

3. A method to rank all the rows for selcted columns. The newer for a row or the more cells revised in the row has the more higher priority. All the rows will be ordered accoring to the priority.

4. Split and generate dynamic pages based on the selected columns and rows and the device width and height.

5. Freeze the header of the top row when show every generated page.

Collaborative spreadsheet is commonly used now, and mobile is more popular and common used. It's a huge challenge to display large spreadhseet in the small screen of mobil. We propose the following solution to display large spreadsheet on mobile.


1. A primary column and the method to select the primary column. A primary column is the column that will always be displayed as first column when show on device. It's the most less changed column, the most occupied column, the most earlier input column and does not contain any reference.

2. A method to select Top N columns. Top N columns will be selected based on the editing history and the device display width. The column with newest changes or most often changes has highest priority. Th...