PATTERN-BASED FILLING OF A CANVAS WITH DATA AND FORMULA

摘要

A computer implemented method includes receiving one or more data sequences and formula sequences, each formula referencing one or more of the data values of the data sequences; providing a GUI enabling a user to define a pattern including at least one data element representing a data sequence and at least one formula element representing a formula sequence, the GUI enabling the user to define the spatial relationship of the data elements and formula elements in the pattern, applying the pattern on a canvas of an electronic document multiple times, thereby filling canvas elements mapped to a data element with data values and filling canvas elements mapped to a formula element with formulas or formula results, until all data values of one of the data sequences or all formulas of one of the formula sequences have been filled once into the canvas.