Method for processing online spreadsheet
AssigneeBeijing Zitiao Network Technology Co., Ltd.
InventorLei Zhang
Life of this patent
Estimating the term…
Abstract
A method for processing an online spreadsheet and a device are provided. The method includes: acquiring, in response to an editing operation triggered by a user for the online spreadsheet display on a client terminal and received by the client terminal, an editing area corresponding to the editing operation by the client terminal, wherein the editing area includes a plurality of cells; acquiring editing data corresponding to the plurality of cells by the client terminal, wherein the editing data includes attribute values respectively edited for each cell of the plurality of cells; obtaining a message body according to the editing data; and sending the message body to a server by the client terminal.
Claims13
A method for processing an online spreadsheet, comprising:
- acquiring, in response to an editing operation triggered by a user for the online spreadsheet display on a client terminal and received by the client terminal, an editing area corresponding to the editing operation by the client terminal, wherein the editing area comprises a plurality of cells;
- acquiring editing data corresponding to the plurality of cells by the client terminal, wherein the editing data comprises attribute values respectively edited for each cell of the plurality of cells;
- obtaining a message body according to the editing data;
- and
- sending the message body to a server by the client terminal,
- wherein the obtaining the message body according to the editing data comprises:
- obtaining a target array corresponding to each cell according to the attribute values respectively edited for each cell of the plurality of cells, wherein the plurality of cells comprises a first cell, a target array corresponding to the first cell comprises at least one element, each element of the at least one element corresponds to one cell attribute, and a value of each element is used to indicate an attribute value of a cell attribute corresponding to the each element;
- and
- obtaining a message body comprising the target array corresponding to each cell, according to the target array corresponding to each cell,
- wherein the target array corresponding to the first cell comprises a second element, a cell attribute corresponding to the second element is a first attribute, the first attribute is not a value of the cell, and a value of the second element is an identifier of an attribute value of the first attribute,
- wherein the obtaining a target array corresponding to each cell according to the attribute values respectively edited for each cell of the plurality of cells, comprises:
- acquiring the attribute value of the first attribute corresponding to the first cell;
- obtaining the identifier according to the attribute value of the first attribute;
- and
- obtaining the target array corresponding to the first cell according to the identifier,
- wherein the obtaining the identifier according to the attribute value of the first attribute comprises:
- querying an attribute manager corresponding to the first attribute using the attribute value of the first attribute;
- in response to the attribute manager comprising a corresponding relationship between the attribute value and the identifier corresponding to the attribute value, acquiring the identifier from the attribute manager;
- and
- in response to the attribute manager not comprising the attribute value, generating the identifier, and storing the corresponding relationship between the attribute value and the identifier in the attribute manager.
A method for processing an online spreadsheet, comprising:
- receiving a message body send by a client terminal, wherein the message body is obtained based on editing data corresponding to a plurality of cells by the client terminal in the online spreadsheet displayed on the client terminal, and the editing data comprises attribute values respectively edited for each cell of the plurality of cells;
- acquiring the attribute values respectively edited for each cell of the plurality of cells according to the message body;
- and
- updating the online spreadsheet according to the attribute values respectively edited for each cell of the plurality of cells,
- wherein the message body comprises a target array corresponding to each cell, the target array corresponding to each cell is obtained according to the attribute values respectively edited for each cell of the plurality of cells, the plurality of cells comprises a first cell, a target array corresponding to the first cell comprises at least one element, each element of the at least one element corresponds to one cell attribute, and a value of each element is used to indicate an attribute value of a cell attribute corresponding to the each element,
- wherein the target array corresponding to the first cell comprises a second element, a cell attribute corresponding to the second element is a first attribute, the first attribute is not a value of the cell, and a value of the second element is an identifier of an attribute value of the first attribute,
- wherein the method further comprises:
- receiving an attribute manager corresponding to the first attribute, wherein the attribute manager corresponding to the first attribute comprises a corresponding relationship between the attribute value of the first attribute and the identifier.
A method for processing an online spreadsheet, comprising:
- acquiring, in response to an editing operation triggered by a user for the online spreadsheet display on a client terminal and received by the client terminal, an editing area corresponding to the editing operation by the client terminal, wherein the editing area comprises a plurality of cells;
- acquiring editing data corresponding to the plurality of cells by the client terminal, wherein the editing data comprises attribute values respectively edited for each cell of the plurality of cells;
- obtaining a message body according to the editing data;
- and
- sending the message body to a server by the client terminal,
- wherein the obtaining the message body according to the editing data comprises:
- obtaining a target array corresponding to each cell according to the attribute values respectively edited for each cell of the plurality of cells, wherein the plurality of cells comprises a first cell, a target array corresponding to the first cell comprises at least one element, each element of the at least one element corresponds to one cell attribute, and a value of each element is used to indicate an attribute value of a cell attribute corresponding to the each element;
- and
- obtaining a message body comprising the target array corresponding to each cell, according to the target array corresponding to each cell,
- wherein the obtaining a target array corresponding to each cell according to the attribute values respectively edited for each cell of the plurality of cells, comprises:
- obtaining an initial array corresponding to each cell according to the attribute values respectively edited for each cell of the plurality of cells;
- and
- in response to values from an nth element to a last element in the initial array being all null, deleting the nth element to the last element in the initial array to obtain the target array.
Dependencies are inferred from the claim text.