COMPUTER-IMPLEMENTED METHOD AND DEVICE FOR GENERATING SPREADSHEET FORMULA, AND STORAGE MEDIUM

摘要

The present application discloses a computer-implemented method and device for generating a spreadsheet formula, and a storage medium. The method comprises: acquiring a hierarchical formula for a spreadsheet, the hierarchical formula comprising an operator and a hierarchical reference, wherein the hierarchical reference corresponds to one or more nodes in one or more hierarchies in a hierarchical structure for the spreadsheet; determining dependency between one or more nodes on the basis of the correlation between the hierarchical reference and the one or more nodes; determining a computational relationship between one or more nodes on the basis of the operator and the dependency; and generating a spreadsheet formula at least on the basis of the hierarchical structure and the computational relationship for the spreadsheet.