Table updating method and device, equipment and storage medium

By generating change events and limiting the scope of processing, the problem of invalid calculations in spreadsheets is solved, resulting in more efficient data updates and faster response times.

CN121809431APending Publication Date: 2026-04-07ZHUHAI KINGSOFT OFFICE SOFTWARE +2
0 Cites 0 Cited by

Patent Information

Application Number
CN202512030620.0
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-12-30
Publication Date
2026-04-07

AI Technical Summary

Technical Problem

In existing technologies, spreadsheets have low data update efficiency because the expansion of the calculation scope leads to a large number of invalid calculations, especially when cell dependencies spread.

Method used

By generating change events, recording the row identifier of the cell whose content has changed, and sending it to the dependent columns, updates are only made when the latest processing result of the cell to be processed is different from its own content. The processing scope is limited to the dependent cells of the cell whose content has changed, and column-based storage management is used instead of row-based management.

Benefits of technology

It effectively reduces the amount of cell processing and updating, improves the response speed and efficiency of the spreadsheet system, reduces operating resources, and reduces monitoring and processing costs.

✦ Generated by Eureka AI based on patent content.
Patent Text Reader

Abstract

The invention discloses a table updating method and device, equipment and a storage medium, and relates to the technical field of table calculation. The method comprises the steps that when any column of a table is changed, a corresponding change event is generated according to a content change cell of the change column, and the change event records a row identifier of the content change cell; and sending the change event to a depended column of the change column, determining a to-be-processed cell by the depended column according to the change event, and changing the content of the to-be-processed cell into the latest processing result under the condition that the latest processing result of the to-be-processed cell is different from the content of the to-be-processed cell. Through the technical means, the processing range of the table can be restrained in the dependent table cells of the content change table cells, a large amount of invalid processing caused by diffusion of the processing range to the whole column of table cells is avoided, the processing amount and the updating amount of the table cells are effectively reduced, and the problem that in the prior art, the data updating efficiency of the spreadsheet is low is solved.
Need to check novelty before this filing date? Find Prior Art