Data processing method and device for spreadsheet

Abstract

The invention provides a data processing method and device for a spreadsheet. The method comprises the following steps that: receiving a version comparison indication input by a user on the first version, which is edited at present, of the spreadsheet; according to the version comparison indication, canceling the editing of the user for the first version, and updating the first version into a second version, which is stored by a version management server at present, of the spreadsheet; determining the difference cell of the first version and the second version; and combining data in the difference cell, and submitting a combined version. Since the first version is updated into the second version before data is combined, the version number of the combined version is a second version number,the version number of the combined version is almost consistent with the version number of the version on the version management server so as to avoid the conflict of the spreadsheet, in addition, aplurality of users can carry out parallel execution, and the editing efficiency of the spreadsheet is improved.

Description

Technical field [0001] The present invention relates to the technical field of data processing, in particular to a data processing method and device of an electronic form. Background technique [0002] Spreadsheet, also known as electronic data sheet, is a grid composed of a series of rows and columns. Numerical values, calculation formulas and texts can be stored in the grid. Commonly used electronic forms such as Excel tables are submitted to the version management server for version management. [0003] In daily work, multiple users often edit an electronic form at the same time. When multiple users edit an electronic form at the same time, a form conflict will occur when the electronic form is submitted after editing. In the prior art, the electronic form can be locked to avoid conflicts, that is, the form must be locked when editing the electronic form. Only one person can edit the same form at a time. After the form is unlocked, other people can then lock the form and edit i...

AI Technical Summary

Problems solved by technology

[0004] Although the above scheme can effectively solve the problem of table conflicts in version management, this method is equivalent to a queuing scheme. Every time you edit a table, you need to wait for the previous editor to release it, and the editing efficiency is low.

Images