| CPC G06F 40/18 (2020.01) | 17 Claims |
|
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.
|