Adaptive navigation functionality in a web-based data-entry grid

• US 10,339,213 B2
• Filed: 06/26/2015
• Issued: 07/02/2019
• Est. Priority Date: 10/19/2011
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: van den Broek, Hendrik, Chow, Chadwick
• Primary Examiner(s): Padmanabhan, Kavita
• Assistant Examiner(s): Burke, Tionna M
• Application Number:
  US14/752,593
• Publication Number:
  US 20150293895A1
• Time in Patent Office: 1,467 Days
• Field of Search: 715220
• CPC Class Codes: G06F 16/957 Browsing optimisation, e.g. caching or content distillation
• CPC Class Codes: G06F 40/12 Use of codes for handling textual entities
• CPC Class Codes: G06F 40/166 Editing, e.g. inserting or deleting
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

Techniques for facilitating navigation in a web-based data entry grid. In one set of embodiments, when a user navigates into a cell of the data entry grid, the user'"'"'s web browser can wait for a predetermined time period before accessing an application server to retrieve input control information for the cell. If the user enters a command to navigate away from the cell before the predetermined time period has passed, the server access can be avoided, and thus the navigation event can be processed immediately. If no navigation command is received from the user before the predetermined time period has passed, the input control information can be retrieved from the application server and rendered.

Claims

1. A method of facilitating navigation in a web-based data entry grid, the method comprising:

displaying, in a web browser being executed by a computer system, a data entry grid interface for a web application hosted by an application server;

receiving, by the web browser, a first user input that engages a navigation mode, wherein the navigation mode prevents the web browser from accessing the application server upon each navigation event;

receiving, by the web browser, a second user input requesting navigation to a first cell of a plurality of cells of the web-based data entry grid, wherein the navigation mode is engaged while the first user input is received;

in response to receiving the second user input, determining, by the web browser, that the navigation mode is engaged;

in response to receiving the second user input and determining that the navigation mode is engaged, navigating, by the web browser, to the first cell without requesting data from the application server and without rendering an input control for the first cell such that the first cell is read-only;

after navigating to the first cell, receiving, by the web browser being executed by the computer system, a third user input requesting disengagement of the navigation mode for the data entry grid interface;

in response to the third user input, disengaging, by the web browser, the navigation mode for the data entry grid interface;

after disengaging the navigation mode, receiving, by the web browser, a fourth user input requesting navigation to a second cell of the plurality of cells of the data entry grid interface;

in response to receiving the fourth user input, determining, by the web browser, that the navigation mode is disengaged; and

in response to receiving the fourth user input and determining that the navigation mode is disengaged;

navigating, by the web browser, to the second cell;

accessing, by the web browser, data from the application server; and

rendering, by the web browser, an input control for the second cell, the input control allowing content of the second cell to be edited.

2. The method of facilitating navigation in the web-based data entry grid of claim 1, wherein the web application is a spreadsheet application.

3. The method of facilitating navigation in the web-based data entry grid of claim 1, wherein a default mode is disengagement of the navigation mode.

4. The method of facilitating navigation in the web-based data entry grid of claim 1, further comprising:

in response to receiving the fourth user input and determining that the navigation mode is disengaged, transmitting, by the web browser, a request to the application server to retrieve input control information for only the second cell.

5. The method of facilitating navigation in the web-based data entry grid of claim 4, further comprising:

receiving, by the web browser, from the application server, the input control information for only the second cell in response to the request, wherein the input control information is used by the web browser to render the input control for only the second cell.

6. The method of facilitating navigation in the web-based data entry grid of claim 1, wherein the input control permits a user to edit contents of only the second cell.

7. The method of facilitating navigation in the web-based data entry grid of claim 6, wherein each cell, other than the second cell, of the plurality of cells of the data entry grid interface is read-only while the input control permits editing of the second cell.

8. The method of facilitating navigation in the web-based data entry grid of claim 1, further comprising:

in response to navigating to the first cell, modifying, by the web browser, an appearance of the first cell to indicate that focus is on the first cell.

9. A non-transitory processor-readable medium for facilitating navigation in a web-based data entry grid, comprising processor-readable instructions configured to cause one or more processors to:

display, in a web browser, a data entry grid interface for a web application hosted by an application server;

process a first user input that engages a navigation mode, wherein the navigation mode prevents the web browser from accessing the application server upon each navigation event;

process a second user input requesting navigation to a first cell of a plurality of cells of the web-based data entry grid, wherein the navigation mode is engaged while the first user input is received;

in response to processing the second user input, determine that the navigation mode is engaged;

in response to processing the second user input and determining that the navigation mode is engaged, navigate to the first cell without requesting data from the application server and without rendering an input control for the first cell such that the first cell is read-only;

after navigating to the first cell, process a third user input requesting disengagement of the navigation mode for the data entry grid interface;

in response to the third user input, disengage the navigation mode for the data entry grid interface;

after disengaging the navigation mode, process a fourth user input requesting navigation to a second cell of the plurality of cells of the data entry grid interface;

in response to processing the fourth user input, determine that the navigation mode is disengaged; and

in response to processing the fourth user input and determining that the navigation mode is disengaged;

navigate to the second cell;

access data from the application server; and

render an input control for the second cell, the input control allowing content of the second cell to be edited.

10. The non-transitory processor-readable medium for facilitating navigation in the web-based data entry grid of claim 9, wherein the web application is a spreadsheet application.

11. The non-transitory processor-readable medium for facilitating navigation in the web-based data entry grid of claim 10, wherein a default mode is disengagement of the navigation mode.

12. The non-transitory processor-readable medium for facilitating navigation in the web-based data entry grid of claim 9, wherein the processor-readable instructions are further configured to cause the one or more processors to:

in response to processing the fourth user input and determining that the navigation mode is disengaged, transmit a request to the application server to retrieve input control information for only the second cell.

13. The non-transitory processor-readable medium for facilitating navigation in the web-based data entry grid of claim 12, wherein the processor-readable instructions are further configured to cause the one or more processors to:

receive, from the application server, the input control information for only the second cell in response to the request, wherein the input control information is used to render the input control for only the second cell.

14. The non-transitory processor-readable medium for facilitating navigation in the web-based data entry grid of claim 9, wherein the input control permits a user to edit contents of only the second cell.

15. The non-transitory processor-readable medium for facilitating navigation in the web-based data entry grid of claim 14, wherein each cell, other than the second cell, of the plurality of cells of the data entry grid interface is read-only while the input control permits editing of the second cell.

16. The non-transitory processor-readable medium for facilitating navigation in the web-based data entry grid of claim 9, wherein the processor-readable instructions are further configured to cause the one or more processors to:

in response to navigating to the first cell, modify an appearance of the first cell to indicate that focus is on the first cell.

17. A system for facilitating navigation in a web-based data entry grid, comprising:

one or more processors; and

a memory communicatively coupled with and readable by the one or more processors and having stored therein processor-readable instructions which, when executed by the one or more processors, cause the one or more processors to;

display, in a web browser, a data entry grid interface for a web application hosted by an application server;

process a first user input that engages a navigation mode, wherein the navigation mode prevents the web browser from accessing the application server upon each navigation event

process a second user input requesting navigation to a first cell of a plurality of cells of the web-based data entry grid, wherein the navigation mode is engaged while the first user input is received;

in response to processing the second user input, determine that the navigation mode is engaged;

in response to processing the second user input and determining that the navigation mode is engaged, navigate to the first cell without requesting data from the application server and without rendering an input control for the first cell such that the first cell is read-only;

after navigating to the first cell, process a third user input requesting disengagement of the navigation mode for the data entry grid interface;

in response to the third user input, disengage the navigation mode for the data entry grid interface;

after disengaging the navigation mode, process a fourth user input requesting navigation to a second cell of the plurality of cells of the data entry grid interface;

in response to processing the fourth user input, determine that the navigation mode is disengaged; and

in response to processing the fourth user input and determining that the navigation mode is disengaged;

navigate to the second cell;

access data from the application server; and

render an input control for the second cell, the input control allowing content of the second cell to be edited.

18. The system for facilitating navigation in the web-based data entry grid of claim 17, wherein the web application is a spreadsheet application.

19. The system for facilitating navigation in the web-based data entry grid of claim 18, wherein a default mode is disengagement of the navigation mode.

20. The system for facilitating navigation in the web-based data entry grid of claim 17, wherein the processor-readable instructions, when executed, further cause the one or more processors to:

in response to processing the fourth user input and determining that the navigation mode is disengaged, transmit a request to the application server to retrieve input control information for only the second cell.