Granted Patent B2

US 12,412,028 · App. 18/666,587 · Granted Sep 9, 2025

Inventor: Zihuan Lin (Beijing, CN)

Assignee: Beijing Zitiao Network Technology Co., Ltd.

G06F40/18

Abstract

Claims (63)

1. A spreadsheet processing method, comprising:

determining a target cell;

displaying a data editing interface in response to a first operation, wherein the data editing interface comprises a first control;

determining an option data set based on a second operation on the data editing interface, wherein the option data set comprises N items of option data, and N is a positive integer, and wherein the N items of option data comprise N cell values selectable to fill the target cell;

automatically determining and configuring M cell color schemes without user input based on the N items of option data in response to the first control displayed in the data editing interface being triggered, wherein M is a positive integer not greater than N;

associating the M cell color schemes with the N items of option data, so that each item of option data is capable of being displayed in the target cell according to an associated cell color scheme;

displaying an option interface in response to a third operation on the target cell, wherein in the option interface, the N cell values selectable to fill the target cell are displayed according to the M cell color schemes; and

filling the target cell with a cell value in response to selecting the cell value from the N cell values displayed via the option interface, wherein the cell value is displayed in the target cell according to a cell color scheme associated with the cell value.

2. The spreadsheet processing method according to claim 1 , further comprising:

in response to a user entering one or more of the N items of option data in the target cell, displaying the entered option data in the target cell according to a cell color scheme associated with the entered option data.

3. The spreadsheet processing method according to claim 1 , wherein

the cell color scheme comprises a setting on a background color of a cell and/or a setting on a font color of the cell.

4. The spreadsheet processing method according to claim 1 , wherein

the determining M cell color schemes based on the N items of option data in response to a first control displayed in the data editing interface being triggered comprises: determining M initial cell color schemes in response to the first control displayed in the data editing interface being triggered; and

the method further comprises:

displaying a color selection interface used to edit cell color schemes for the N items of option data; and

determining the M cell color schemes based on an operation of a user on the color selection interface.

5. The spreadsheet processing method according to claim 4 , wherein the displaying a color selection interface comprises:

displaying the color selection interface in response to a second control displayed in the data editing interface being triggered.

6. The spreadsheet processing method according to claim 4 , wherein

the N items of option data are displayed in the color selection interface, and each item of option data corresponds to one color selection identifier; and

the determining the M cell color schemes based on an operation of a user on the color selection interface comprises:

in response to a first color selection identifier corresponding to first option data being triggered, displaying a cell color scheme set interface where a plurality of cell color schemes are displayed;

determining a first cell color scheme in response to an operation of the user on the cell color scheme set interface; and

determining the first cell color scheme as a cell color scheme corresponding to the first option data,

wherein the first option data is any one of the N items of option data.

7. The spreadsheet processing method according to claim 6 , wherein

an initial display color of the first color selection identifier corresponds to one of the M initial cell color schemes; and

after the first cell color scheme is determined, a display color of the first color selection identifier corresponds to the first cell color scheme.

8. The spreadsheet processing method according to claim 1 , wherein

N is equal to M, and each item of option data corresponds to one cell color scheme.

9. The spreadsheet processing method according to claim 1 , wherein the determining M cell color schemes comprises:

determining the M cell color schemes from a preset cell color scheme set according to a preset sequence.

10. The spreadsheet processing method according to claim 1 , wherein the determining an option data set based on a second operation on the data editing interface comprises:

in response to a select operation on at least one cell in a spreadsheet, referencing a cell data set corresponding to the at least one cell as the option data set.

11. The spreadsheet processing method according to claim 6 , wherein that the N items of option data are displayed in the color selection interface comprises:

if the option data set is referenced from cell data in a spreadsheet, the N items of option data are displayed in the color selection interface according to an arrangement order of the referenced cell data.

12. The spreadsheet processing method according to claim 10 , further comprising:

if a preset operation is performed on second data in the cell data set, reassociating second option data corresponding to the second data with a cell color scheme,

wherein the preset operation is used to adjust a position order of the second data in the cell data set; and the second data is any item of data in the cell data set.

13. The spreadsheet processing method according to claim 12 , wherein

the preset operation is a drag-and-drop operation.

14. The spreadsheet processing method according to claim 10 , further comprising:

if third data is added to the cell data set, adding third option data corresponding to the third data to the option data set, and associating the third option data with a cell color scheme.

15. The spreadsheet processing method according to claim 10 , further comprising:

if fourth data is deleted from the cell data set, deleting fourth option data corresponding to the fourth data from the option data set, and deleting a cell color scheme associated with the fourth option data, wherein the fourth data is any item of data in the cell data set.

16. An electronic device, comprising:

at least one memory and at least one processor, wherein the memory is configured to store program code, the processor is configured to call the program code stored in the memory, to cause the electronic device to perform operations, and the operations comprise:

determining a target cell;

displaying a data editing interface in response to a first operation, wherein the data editing interface comprises a first control;

determining an option data set based on a second operation on the data editing interface, wherein the option data set comprises N items of option data, and N is a positive integer, and wherein the N items of option data comprise N cell values selectable to fill the target cell;

automatically determining and configuring M cell color schemes without user input based on the N items of option data in response to the first control displayed in the data editing interface being triggered, wherein M is a positive integer not greater than N;

associating the M cell color schemes with the N items of option data, so that each item of option data is capable of being displayed in the target cell according to an associated cell color scheme;

displaying an option interface in response to a third operation on the target cell, wherein in the option interface, the N cell values selectable to fill the target cell are displayed according to the M cell color schemes; and

filling the target cell with a cell value in response to selecting the cell value from the N cell values displayed via the option interface, wherein the cell value is displayed in the target cell according to a cell color scheme associated with the cell value.

17. A non-transitory computer storage medium, wherein the non-transitory computer storage medium stores program code that, when executed by a computer device, causes the computer device to perform operations comprising:

determining a target cell;

displaying a data editing interface in response to a first operation, wherein the data editing interface comprises a first control;

determining an option data set based on a second operation on the data editing interface, wherein the option data set comprises N items of option data, and N is a positive integer, and wherein the N items of option data comprise N cell values selectable to fill the target cell;

automatically determining and configuring M cell color schemes without user input based on the N items of option data in response to the first control displayed in the data editing interface being triggered, wherein M is a positive integer not greater than N;

associating the M cell color schemes with the N items of option data, so that each item of option data is capable of being displayed in the target cell according to an associated cell color scheme;

displaying an option interface in response to a third operation on the target cell, wherein in the option interface, the N cell values selectable to fill the target cell are displayed according to the M cell color schemes; and

filling the target cell with a cell value in response to selecting the cell value from the N cell values displayed via the option interface, wherein the cell value is displayed in the target cell according to a cell color scheme associated with the cell value.

Assignments (2)

Priority Claims (1)

Continuity (2)

References Cited (38)