Electronic data table calculation chain generation method and device

An electronic data sheet and generation system technology, applied in the direction of electrical digital data processing, calculation, special data processing applications, etc., can solve the problems of computer system resource waste, a large amount of processing time, etc., to reduce redundant operations, improve computing efficiency, Avoid the effect of repeated movement

Active Publication Date: 2009-04-29
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For extremely complex spreadsheets, especially in large-scale financial planning schemes, completing long chain calculations in the above-mentioned way requires a lot of processing time and will also cause a lot of waste of computer system resources

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Electronic data table calculation chain generation method and device
  • Electronic data table calculation chain generation method and device
  • Electronic data table calculation chain generation method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] In order to make the above objects, features and advantages of the present invention more comprehensible, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0056] The core idea of ​​the present invention is to first construct the dependency relationship between the units in the electronic data sheet, and the implementation of the dependency relationship between the construction of the various units is different in different electronic data sheets, but the principle is similar: when the content of a unit changes To notify other units that depend on this unit, and update their content. Then add support units to the computing chain in a certain traversal order, query the dependent units of the unit, add them to the end of the computing chain in turn, start from the first dependent unit of the supporting unit in the computing chain, and query the dependencies of the unit Units are added ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a method and system for producing the calculating chain of spreadsheet.The method comprises the steps of: analyzing the dependent relationship between units in the spreadsheet; adding first unit for the calculating chain; looking up the dependent unit of unit according to the dependent relationship; adding the dependent unit the tail of the calculating chain; adding next unit to the tail of the calculating chain based on predetermined ergodic order to look up the dependent unit of unit, and adding the dependent unit to the tail of the calculating chain, repeating the step until all units is added to the calculating chain. Accordingly, the repeated moving of unit nodes in the calculating process is avoided, and the redundant calculation can be reduced and the calculated efficiency for the spreadsheet is improved obviously, as well as the system resource of computer is also saved greatly.

Description

technical field [0001] The invention relates to electronic data table processing, in particular to a method and system for generating electronic data table calculation chains. Background technique [0002] Spreadsheet: It is a calculation tool software that organizes data and information in unit form, such as Microsoft Excel, Lotus1-2-3, Borland Quattro Pro, LinuxGnumeric, WPS spreadsheet, Yongzhong Office, etc. [0003] A cell is the most basic unit of a spreadsheet, which can contain calculation formulas to calculate the value of this cell. The electronic data sheet can also be pre-set or provided by the secondary developer with some functional functions, which can be used in unit formulas for the convenience of users. [0004] Traditional spreadsheets such as Microsoft Excel handle the calculation and recalculation of formulas in a spreadsheet with a single calculation chain, which is essentially an ordered list of all formulas that are entered into all worksheets curren...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/24G06F17/30
Inventor 乔昕明
Owner KINGDEE SOFTWARE(CHINA) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap