IP Library Granted Patent US 12,340,168
Granted Patent B1
US 12,340,168 · App. 16/565,230 · Granted Jun 24, 2025

GUI with axes having directional indicators of the absence of data

Inventor: Jefferson Wilson (Williston, VT)
Assignee: ALTERA DIGITAL HEALTH, INC.
G06F40/18
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,340,168
App. No.
16/565,230
Granted
Jun 24, 2025
Kind
B1
Abstract

A method of displaying a GUI including a multidimensional array of axes includes constructing a multidimensional array of axes, each axis comprising a plurality of entities located therealong, each entity configured to contain data for display on the axis; for a particular axis of the axes of the array, determining an entity first encountered in a first direction along the particular axis which contains data for display on the particular axis; displaying a view of the array of axes, which view comprises at least a portion of the particular axis that precedes the first encountered data-containing entity in the first direction; and, in conjunction with the displaying of the view of the array of axes, providing an indicator of an absence of data for display being contained in each entity of the particular axis preceding the first data-containing entity encountered in the first direction.

Claims (73)

1. A client computing device comprising:

a processor;

a display; and

memory that has an application loaded therein, wherein the application, when executed by the processor, causes the processor to perform acts comprising:

causing display of a spreadsheet at the display of the client computing device by way of a graphical user interface (GUI) of the application;

evaluating the spreadsheet being displayed at the client computing device, wherein the spreadsheet comprises a first spreadsheet portion presently being displayed at the display of the client computing device and a second spreadsheet portion not being displayed at the display of the client computing device;

identifying that a cell in a row of the spreadsheet comprises data within the first spreadsheet portion;

identifying that all cells to the right of the cell in the row fail to comprise data within the second spreadsheet portion, where the row comprises first cells to the right of the cell that are within the first spreadsheet portion, and second cells to the right of the cell that are within the second spreadsheet portion; and

subsequent to identifying that all cells to the right of the cell in the row fail to comprise data within the second spreadsheet portion, displaying, in each cell in the first cells that is to the right of the cell in the row, an indicator that indicates that each cell in the first cells and the second cells to the right of the displayed cell in the row fails to comprise data.

2. The client computing device of claim 1 , the acts further comprising:

identifying that a second cell of the spreadsheet comprises data, wherein the second cell is in a column of the spreadsheet;

identifying that all cells below the second cell in the column fail to comprise data; and

displaying, within the GUI, the second cell, wherein the second cell has a second indicator therein that indicates that all cells below the second cell in the column fail to comprise data.

3. The client computing device of claim 1 , the acts further comprising:

identifying that a second cell of the spreadsheet comprises data, wherein the second cell is in a column of the spreadsheet;

identifying that multiple cells below the second cell in the column comprise data; and

displaying, within the GUI, the second cell, wherein the second cell has a second indicator therein that indicates that a third cell below the second cell in the column comprises data.

4. The client computing device of claim 1 , the acts further comprising:

identifying that a second cell of the spreadsheet comprises data, wherein the second cell is in a column of the spreadsheet;

identifying that all cells above the second cell in the column fail to comprise data; and

displaying, within the GUI, the second cell, wherein the second cell has a second indicator therein that indicates that all cells above the second cell in the column fail to comprise data.

5. The client computing device of claim 1 , the acts further comprising:

identifying that all cells to the left of a second cell in the row fail to comprise data within the second spreadsheet portion, wherein the row comprises third cells to the left of the second cell that are within the first spreadsheet portion and fourth cells to the left of the second cell that are within the second spreadsheet portion; and

subsequent to identifying that all cells to the left of the second cell in the row fail to comprise data within the second spreadsheet portion, displaying, in each cell in the third cells that is to the left of the second cell in the row, an indicator that indicates that each cell in the first cells and the second cells to the left of the displayed second cell in the row fails to comprise data.

6. The client computing device of claim 1 , the acts further comprising:

identifying that multiple cells to the left of a second cell in the row comprise data; and

displaying, within the GUI, the second cell, wherein the second cell has a second indicator therein that indicates that a third cell to the left of the second cell in the row comprises data.

7. The client computing device of claim 1 , the acts further comprising:

identifying that multiple cells to the right of a second cell in the row comprise data; and

displaying, within the GUI, the second cell, wherein the second cell has a second indicator therein that indicates that a third cell to the right of the second cell in the row comprises data.

8. The client computing device of claim 1 , wherein the cell in the row has a second indicator therein that indicates that each cell in a second row of the spreadsheet fails to comprise data.

9. The client computing device of claim 1 , wherein the indicator comprises:

a symbol;

a color; or

a pattern.

10. A method executed by a client computing device, wherein the client computing device executes an application that is configured to display one or more spreadsheets, the method comprising:

causing display of a spreadsheet at a display of the client computing device by way of a graphical user interface (GUI) of the application;

evaluating the spreadsheet being displayed at the client computing device, wherein the spreadsheet comprises a first spreadsheet portion presently being displayed at the display of the client computing device and a second spreadsheet portion not being displayed at the display of the client computing device;

identifying that a cell in a row of the spreadsheet comprises data within the first spreadsheet portion;

identifying that all cells to the right of the cell in the row fail to comprise data within the second spreadsheet portion, where the row comprises first cells to the right of the cell that are within the first spreadsheet portion, and second cells to the right of the cell that are within the second spreadsheet portion; and

subsequent to identifying that all cells to the right of the cell in the row fail to comprise data within the second spreadsheet portion, displaying, in each cell in the first cells that is to the right of the cell in the row, an indicator that indicates that each cell in the first cells and the second cells to the right of the displayed cell in the row fails to comprise data.

11. The method of claim 10 , further comprising:

identifying that a second cell of the spreadsheet comprises data, wherein the second cell is in a column of the spreadsheet;

identifying that multiple cells above the second cell in the column comprise data; and

displaying, within the GUI, the second cell, wherein the second cell has a second indicator therein that indicates that a third cell above the second cell in the column comprises data.

12. The method of claim 10 , wherein the cell is in a column, the method further comprising:

identifying that all cells below the cell in the column fail to comprise data; and

displaying, within the GUI, the cell in the column, wherein the cell has a second indicator therein that indicates that all cells below the cell fail to comprise data.

13. The method of claim 10 , wherein the cell is in a column, the method further comprising:

identifying that all cells above the cell in the column fail to comprise data; and

displaying, within the GUI, the cell in the column, wherein the cell has a second indicator therein that indicates that all cells above the cell in the column and all cells to the right of the cell in the row fail to comprise data.

14. The method of claim 10 , further comprising:

identifying that all cells to the left of a second cell in the row fail to comprise data within the second spreadsheet portion, wherein the row comprises third cells to the left of the second cell that are within the first spreadsheet portion and fourth cells to the left of the second cell that are within the second spreadsheet portion; and

subsequent to identifying that all cells to the left of the second cell in the row fail to comprise data within the second spreadsheet portion, displaying, in each cell in the third cells that is to the left of the second cell in the row, an indicator that indicates that each cell in the first cells and the second cells to the left of the displayed second cell in the row fails to comprise data.

15. The method of claim 10 , further comprising:

identifying that multiple cells to the left of a second cell in the row comprise data;

displaying, within the GUI, the second cell, wherein the second cell has a second indicator therein that indicates that a third cell to the left of the second cell in the row comprises data.

16. The method of claim 10 , wherein a second cell in a second row of the spreadsheet has a second indicator therein that indicates that each cell in the second row of the spreadsheet to the right or to the left of the second cell fails to comprise data.

17. A non-transitory computer-readable storage medium comprising a client electronic health records application (client EHR), wherein the client EHR, when executed by a processor, causes the processor to perform acts comprising:

causing display of a spreadsheet at a display of a client computing device executing the client EHR, by way of a graphical user interface (GUI) of the client EHR;

evaluating the spreadsheet being displayed at the client computing device, wherein the spreadsheet comprises a first spreadsheet portion presently being displayed at the display of the client computing device and a second spreadsheet portion not being displayed at the display of the client computing device;

identifying that a cell in a row of the spreadsheet comprises clinical data pertaining to a patient within the first spreadsheet portion;

identifying that all cells to the right of the cell in the row fail to comprise data within the second spreadsheet portion, where the row comprises first cells to the right of the cell that are within the first spreadsheet portion, and second cells to the right of the cell that are within the second spreadsheet portion; and

subsequent to identifying that all cells to the right of the cell in the row fail to comprise data within the second spreadsheet portion, displaying, in each cell in the first cells that is to the right of the cell in the row, an indicator that indicates that each cell in the first cells and the second cells to the right of the displayed cell in the row fails to comprise data.

18. The non-transitory computer-readable storage medium of claim 17 , the acts further comprising:

identifying that multiple cells to the left of a second cell in the row comprise data;

displaying, within the GUI, the second cell, wherein the second cell has a second indicator therein that indicates that a third cell to the left of the second cell in the row comprises data;

identifying that multiple cells to the right of a fourth cell in the row comprise data; and

displaying, within the GUI, the fourth cell, wherein the fourth cell has a third indicator therein that indicates that a fifth cell to the right of the fourth cell in the row comprises data.

19. The non-transitory computer-readable storage medium of claim 17 , the acts further comprising:

identifying that all cells to the left of a second cell in the row fail to comprise clinical data within the second spreadsheet portion, wherein the row comprises third cells to the left of the second cell that are within the first spreadsheet portion and fourth cells to the left of the second cell that are within the second spreadsheet portion; and

subsequent to identifying that all cells to the left of the second cell in the row fail to comprise clinical data within the second spreadsheet portion, displaying, in each cell in the third cells that is to the left of the second cell in the row, an indicator that indicates that each cell in the first cells and the second cells to the left of the displayed second cell in the row fails to comprise clinical data.

20. The non-transitory computer-readable storage medium of claim 17 , the acts further comprising identifying that each cell in a second row of the spreadsheet fails to comprise clinical data, and wherein a second cell in a second row of the spreadsheet has a second indicator therein that indicates that each cell to the right or to the left of the second cell in the second row of the spreadsheet fails to comprise clinical data.

Assignments (3)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 4, 2022
From: ALLSCRIPTS SOFTWARE, LLC
To: HARRIS DAWN HOLDINGS, INC
Reel/Frame 061933/0655 →
SECURITY INTEREST Recorded May 10, 2022
From: ALTERA DIGITAL HEALTH INC.
To: JPMORGAN CHASE BANK, N.A., AS ADMINISTRATIVE AGENT
Reel/Frame 059913/0710 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 12, 2020
From: WILSON, JEFFERSON
To: ALLSCRIPTS SOFTWARE, LLC
Reel/Frame 054350/0991 →
Continuity (1)
Continuation 15365951 · Dec 1, 2016
References Cited (17)
US 5247611A · Norden-Paul et al. · 1993 [cited by applicant]
US 5255356A · Michelman et al. · 1993 [cited by applicant]
US 5337405A · Lindauer · 1994 [cited by examiner]
US 6057837A · Hatakeda et al. · 2000 [cited by applicant]
US 20020161799A1 · Maguire, III et al. · 2002 [cited by applicant]
US 20060136839A1 · Makela · 2006 [cited by applicant]
US 20060282818A1 · DeSpain · 2006 [cited by applicant]
“Find and Highlight All Blank Cells in Your Data [Excel Tips]” available at https://chandoo.org/wp/find-and-highlight-all-blank-cells-in-your-data-excel-tips/, Apr. 20, 2015, (hereinafter Chandoo). [cited by examiner]
“MS Excel: LEN function” available at https://web.archive.org/web/20150321004351/https://www.techonthenet.com/excel/formulas/len.php , Mar. 21, 2015 (hereinafter Tech). [cited by examiner]
“COUNTA function” available at http://web.archive.org/web/20161010172240/https://support.office.com/en-us/article/counta-function-7dc98875-d5c1-46f1-9a82-53f3219e2509 , Oct. 10, 2016 (hereinafter COUNTA). [cited by examiner]
“Preliminary Amendment for U.S. Appl. No. 15/365,951”, Filed Date: Dec. 1, 2016, 3 pages. [cited by applicant]
“Preliminary Amendment for U.S. Appl. No. 15/365,951”, Filed Date: Dec. 29, 2016, 29 pages. [cited by applicant]
“Non-Final Office Action for U.S. Appl. No. 15/365,951”, Mailed Date: Nov. 2, 2018, 19 pages. [cited by applicant]
“Find and Highlight All Blank Cells In Your Data [Excel Tips]”, Apr. 20, 2015, Retrieved Date: Oct. 23, 2018, Retrieved At: <<https://chandoo.org/wp/find-and-highlight-all-blank-cells-in-your-data-excel-tips/>>, 19 page… [cited by applicant]
“Response to the Non-Final Office Action for U.S. Appl. No. 15/365,951”, Filed Date: Mar. 4, 2019, 14 pages. [cited by applicant]
“Finding The Last Used Cell in a Range”, Aug. 20, 2008, Retrieved Date: Apr. 25, 2019, Retrieved At: <<http://www.cpearson.com/Excel/LastCell.aspx>>, 4 pages. [cited by applicant]
“Notice of Allowance and Fees Due for U.S. Appl. No. 15/365,951”, Mailed Date: Apr. 30, 2019, 8 pages. [cited by applicant]