Method for logical organization of worksheets

• US 9,483,458 B2
• Filed: 03/10/2015
• Issued: 11/01/2016
• Est. Priority Date: 04/28/2014
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Presler-Marshall, Martin J. C., Presnall, Hunter K.
• Primary Examiner(s): Baderman, Scott
• Assistant Examiner(s): Mrabi, Hassan
• Application Number:
  US14/643,745
• Publication Number:
  US 20150309979A1
• Time in Patent Office: 602 Days
• Field of Search: 715/205, 715/255, 715/211, 715/202
• US Class Current: 1/1
• CPC Class Codes: G06F 40/117 Tagging; Marking up details of markup languages G06F40/143; Designating a block; Setting of attributes style sheets, e.g. eXtensible Stylesheet Language Transformation [XSLT], G06F40/154
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

According to one embodiment of the present invention, methods, systems and computer-readable media of accessing data within a spreadsheet are provided. A set of attributes is assigned to each worksheet of a plurality of worksheets within the spreadsheet. One or more worksheets may be identified by comparing the set of attributes for each worksheet to one or more attributes specified within a request for data, and the identified worksheets may be displayed.

Claims

1. A computer-implemented method of accessing data within a spreadsheet including a plurality of worksheets comprising:

assigning a set of a plurality of attributes to each worksheet within the spreadsheet, wherein the set of attributes for a corresponding worksheet describes a type of data in that worksheet;

processing a request for data within the spreadsheet to identify one or more worksheets containing the data from among the plurality of worksheets by comparing the set of attributes for each worksheet to one or more attributes specified within the request, wherein the set of attributes for each identified worksheet satisfies the comparison; and

displaying a portion of the spreadsheet including only the identified worksheets.

2. The computer-implemented method of claim 1, wherein displaying the identified worksheets further comprises:

displaying the identified worksheets in accordance with a user-specified arrangement.

3. The computer-implemented method of claim 2, wherein the user-specified arrangement includes one of a single window, plural tiled windows, and plural stacked windows.

4. The computer-implemented method of claim 1, further comprising:

ordering the identified worksheets in accordance with a specified set of conditions.

5. The computer-implemented method of claim 1, further comprising;

accessing data within multiple spreadsheets by assigning a set of attributes to each worksheet of a plurality of spreadsheets;

identifying one or more worksheets of the plurality of spreadsheets by comparing the set of attributes for each worksheet to one or more attributes specified within a request for data; and

displaying the identified worksheets.

6. The computer-implemented method of claim 1, wherein the set of attributes includes a tag.

7. The computer-implemented method of claim 1, wherein the set of attributes includes a key-value pair.