Representing spreadsheet document content

• US 7,299,406 B2
• Filed: 06/02/2004
• Issued: 11/20/2007
• Est. Priority Date: 06/02/2004
• Status: Active Grant

• Current Assignee: Malikie Innovations Limited (Key Patent Innovations Limited)
• Original Assignee: Research In Motion Limited (Blackberry Limited)
• Inventors: Schnurr, Jeffrey R.
• Primary Examiner(s): Hutton; Doug
• Assistant Examiner(s): Blackwell; James H.
• Application Number:
  US10/857,900
• Publication Number:
  US 20050273695A1
• Time in Patent Office: 1,266 Days
• Field of Search: 715/503, 715854-856, 715/513, 715/500.1, 715/504, 715/509, 715/863, 709/206, 345/440, 382/298
• US Class Current: 715/212
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: H04W 24/00 Supervisory, monitoring or testing arrangements

Abstract

A representation of a spreadsheet is displayed on a mobile communication device after receiving a description of a spreadsheet. The description relates to a plurality of map cells, where each map cell corresponds to a cell block, and the description includes location information and primary data type information for each map cell. Based on the location and content-type information in the description, a pictorial representation of the spreadsheet may be generated and displayed to a user of the mobile communication device. A mobile device server may not only generate the description, but also may interpret the user'"'"'s selection of a region of interest and transmit enough information about the region of interest for the mobile communication device to present the region of interest to the user in a conventional viewer.

Claims

1. A method of displaying a representation of a spreadsheet on a mobile communication device, said method comprising:

receiving a description of said spreadsheet, where said description relates to a plurality of map cells, where each map cell in said plurality of map cells corresponds to a cell block, each cell block comprising at least two adjacent cells of said spreadsheet arid said description includes location information and primary data type information for said each map cell;

generating a summary representation of said spreadsheet, based on said location information and said primary data type information wherein each map cell is represented in said summary representation of said spreadsheet by an indicator of its primary data type; and

displaying said summary representation of said spreadsheet.

2. The method of claim 1 further comprising;

receiving notice of a selection of a region of interest by a user of said mobile communication device;

transmitting an indication of said region of interest to a server;

receiving information describing said region of interest from said sewer; and

invoking a viewer application to;

interpret said information describing said region of interest; and

display said region of interest.

3. The method of claim 2 wherein said receiving notice of said selection of said region of interest by said user comprises receiving an identity of a given map cell.

4. The method of claim 3 wherein said region of interest is defined to include a given cell block as the top-leftmost cell block, where said given cell block corresponds to said given map cell.

5. The method of claim 3 wherein said region of interest is defined to include a given cell block as the center cell block, where said given cell block corresponds to said given map cell.

6. The method of claim 1 wherein said description includes a data label for said each map cell in said plurality of map cells.

7. The method of claim 6 wherein said data label is derived from data contained by a given cell of said at least two adjacent cells in said cell block corresponding to said each map cell, which given cell is the topmost and leftmost cell having data content.

8. The method of claim 3 wherein said displaying said summary representation of said spreadsheet further comprises providing a navigation interface that may be used to select said region of interest.

9. The method of claim 1 further comprising, before said receiving said description of said spreadsheet;

receiving an indication of an association or said spreadsheet with an e-mail message; and

displaying a menu including an option to display said summary representation.

10. The method of claim 9 further comprising:

detecting selection of said option to display said summary representation; and

transmitting a request for said description of said spreadsheet.

11. The method of claim 1 wherein said indicator is one of a fill pattern, fill colour, or a letter.

12. A mobile communication device comprising a processor adapted to:

receive a description of a spreadsheet, where said description relates to a plurality of map cells, where each map cell in said plurality of map cells corresponds to a cell block, each cell block comprising at least two adjacent cells of said spreadsheet and said description includes location information and primary data type information for said each map cell;

generate a summary representation of said spreadsheet, based on said location information and said primary data type information wherein each map cell is represented in said summary representation of said spreadsheet by an indicator of its primary data type; and

display said summary representation of said spreadsheet.

13. A computer readable medium containing computer-executable instructions that, when performed by a processor in a mobile communication device, cause said processor to:

receive a description of a spreadsheet, where said description relates to a plurality of map cells, where each map cell in said plurality of map cells corresponds to a cell block, each cell block comprising at least two adjacent cells of said spreadsheet and said description includes location information and primary data type information for said each map cell;

generate a summary representation of said spreadsheet, based on said location information and said primary data type information wherein each map cell is represented in said summary representation of said spreadsheet by an indicator of its primary data type; and

display said summary representation of said spreadsheet.

14. A method of preparing a description of a spreadsheet, said method comprising:

analyzing each spreadsheet cell of a plurality of spreadsheet cells of a sheet of a spreadsheet;

to determine whether said each spreadsheet cell contains data; and

if said each spreadsheet cell contains data, to determine a type for said data;

determining, from spreadsheet cells determined to contain data, sheet dimensions, where said sheet dimensions include a sheet length, expressed as a number of spreadsheet cells, and a sheet width, expressed as a number of spreadsheet cells wherein where said sheet width is greater than a first predetermined number of spreadsheet cells, dividing said sheet into a plurality of cell blocks, where each cell block of said plurality of cell blocks has identical cell block dimensions and where said cell block dimensions include a length, expressed as a number of spreadsheet cells, and a width, expressed as a number of spreadsheet cells, and choosing said cell block width as a width which is greater than one spreadsheet cell wide and where said sheet length is greater than a second predetermined number of spreadsheet cells, choosing said cell block length as a length which is greater than one spreadsheet cell long;

assigning a corresponding map cell to said each cell block, thereby creating a plurality of corresponding map cells;

determining primary data type information and location information for each map cell of said plurality of map cells, where said primary data type information for said each corresponding map cell is representative of a prevalent data type of spreadsheet cells in said each cell block; and

transmitting, to a mobile communication device, a description of said sheet including said primary data type information and said location information for said each map cell.

15. The method of claim 14 further comprising:

receiving, from said mobile communication device, an indication of a region of interest; and

transmitting information describing said region of interest to said mobile communication device.

16. The method of claim 15 wherein said indication is an identity of a map cell.

17. The method of claim 14 wherein said description of said sheet further includes a data label for said each map cell.

18. The method of claim 17 wherein said data label for a given map cell is derived from data contained by a given spreadsheet cell among said at least two adjacent spreadsheet cells in a given cell block corresponding to said given map cell, which given spreadsheet cell is the topmost and leftmost cell having data content.

19. The method of claim 14 where said determining said sheet dimensions comprises determining said sheet length from a numeric component of a given spreadsheet cell reference, where said given spreadsheet cell reference has a maximum numeric component among said spreadsheet cell references of said spreadsheet cells determined to contain data.

20. The method of claim 14 where said determining said sheet dimensions comprises determining said sheet width from an alphabetic component of a given spreadsheet cell reference, where said given spreadsheet cell reference has a maximum alphabetic component among said spreadsheet cell references of said spreadsheet cells determined to contain data.

21. A mobile device server comprising a processor adapted to:

analyze each cell of a plurality of spreadsheet cells of a sheet of a spreadsheet;

to determine whether said each spreadsheet cell contains data; and

if said each spreadsheet cell contains data, to determine a type for said data;

determine, from spreadsheet cells determined to contain data, sheet dimensions, where said sheet dimensions include a length, expressed as a number of spreadsheet cells, and a width, expressed as a number of spreadsheet cells;

determine cell block dimensions, where said cell block dimensions include a length, expressed as a number of spreadsheet cells, and a width, expressed as a number of spreadsheet cells such that, where said sheet width is greater than a first predetermined number of spreadsheet cells, said cell block width is chosen as a width which is greater than one spreadsheet cell wide, and where said sheet length is greater than a second predetermined number of spreadsheet cells, said cell block length is chosen as a length which is greater than one spreadsheet cell long,

divide said sheet into a plurality of cell blocks, where each cell block of said plurality of cell blocks has identical said cell block dimensions;

assign a corresponding map cell to said each cell block, thereby creating a plurality of corresponding map cells,

determine primary data type information and location information for each map cell of said plurality of map cells, where said primary data type information for said each corresponding map cell is representative of a prevalent data type of spreadsheet cells in said each cell block; and

transmit, to a mobile communication device, a description of said sheet including said primary data type in formation and said location information for said each map cell.

22. A computer readable medium containing computer-executable instructions that, when performed by a processor in a mobile device server, cause said processor to:

analyze each cell of a plurality of spreadsheet cells of a sheet of a spreadsheet;

to determine whether said each spreadsheet cell contains data; and

if said each spreadsheet cell contains data, to determine a type for said data;

determine, from spreadsheet cells determined to contain data, sheet dimensions, where said sheet dimensions include a length, expressed as a number of spreadsheet cells, and a width, expressed as a number of spreadsheet cells;

determine cell block dimensions, where said cell block dimensions include a length, expressed as a number of spreadsheet cells, and a width, expressed as a number of spreadsheet cells such that, where said sheet width is greater than a first predetermined number of spreadsheet cells, said cell block width is chosen as a width which is greater than one spreadsheet cell wide, and where said sheet length is greater than a second predetermined number of spreadsheet cells, said cell block length is chosen as a length which is greater than one spreadsheet cell long;

divide said sheet into a plurality of cell blocks, each cell block of said plurality of cell blocks having said cell block dimensions and assign a corresponding map cell to each cell block, determine primary data type information and location information for each corresponding map cell, where said primary data type information for said each corresponding map cell is representative of a prevalent data type of spreadsheet cell contents among spreadsheet cells in said each cell block; and

transmit, to a mobile communication device, a description of said sheet including said primary data type information and said location information for said each map cell.