CN117009717A - Dynamic data calculation method and device for Web form - Google Patents
Dynamic data calculation method and device for Web form Download PDFInfo
- Publication number
- CN117009717A CN117009717A CN202311266621.XA CN202311266621A CN117009717A CN 117009717 A CN117009717 A CN 117009717A CN 202311266621 A CN202311266621 A CN 202311266621A CN 117009717 A CN117009717 A CN 117009717A
- Authority
- CN
- China
- Prior art keywords
- dynamic data
- position value
- web form
- cell variable
- relative position
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000004364 calculation method Methods 0.000 title claims abstract description 79
- 238000000034 method Methods 0.000 claims abstract description 53
- 238000004590 computer program Methods 0.000 claims description 11
- 230000007547 defect Effects 0.000 abstract description 6
- 230000000007 visual effect Effects 0.000 abstract description 5
- 238000009877 rendering Methods 0.000 description 10
- 238000004891 communication Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/10—Complex mathematical operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The invention relates to the technical field of table data processing, in particular to a method and a device for calculating dynamic data of a Web table, wherein the method comprises the following steps: acquiring Web form configuration; determining the expansion range of dynamic data in the configuration of the Web form; the coordinates of each cell variable in the expansion range are configured according to a calculation formula in Web form configuration and used as the relative position value of the cell variable; calculating the relative position value of each cell variable according to the dynamic data cycle to obtain the absolute position value of the cell variable; and outputting the absolute position value to be rendered to a Web form. The method and the device are used for solving the defects of high learning cost, high operation difficulty and non-visual checking data of the Web form in the prior art so as to realize the usability and flexibility of the Web form.
Description
Technical Field
The present invention relates to the field of table data processing technologies, and in particular, to a method and an apparatus for calculating dynamic data of a Web table.
Background
With the digital transformation of offices, offline data processing is gradually transformed into online. In the face of multi-layer grouping and complex report calculated by formulas, each unit disputes to exit each distinctive Web form tool.
However, currently, the mainstream Web form tools have certain defects. If the native formula of Excel cannot be supported, the Web table encapsulates the commonly used formula, the functions in the formula need to be combined with encapsulated variables, the function names are the same as those of the native formula of Excel, but the function value-taking mode is different from that of the native formula, and the learning cost and the operation difficulty are high. In addition, the formulas for rendering the dynamic data are all calculated along with the data and then return values, and the rendered data cannot see the formulas in the Web table, so that the data are not intuitive when being checked. The above problems make current Web forms less easy to use and less flexible.
Disclosure of Invention
The invention provides a method and a device for calculating dynamic data of a Web form, which are used for solving the defects of high learning cost, high operation difficulty and non-visual checking data of the Web form in the prior art so as to realize the usability and flexibility of the Web form.
The invention provides a dynamic data calculation method of a Web form, which comprises the following steps:
acquiring Web form configuration;
determining the expansion range of dynamic data in the configuration of the Web form;
the coordinates of each cell variable in the expansion range are configured according to a calculation formula in Web form configuration and used as the relative position value of the cell variable;
calculating the relative position value of each cell variable according to the dynamic data cycle to obtain the absolute position value of the cell variable;
and outputting the absolute position value to be rendered to a Web form.
According to the method for calculating the dynamic data of the Web table, the coordinates of each cell variable in the expansion range are configured according to the calculation formula in the configuration of the Web table, and the coordinates are used as the relative position values of the cell variables, and the method comprises the following steps:
the coordinates of the first group of cells in the expansion range are configured according to a calculation formula in Web table configuration and serve as relative position values of cell variables, wherein the relative position values of the first group of cells are the first instance;
and starting a loop calculation example according to the first example, so as to configure the coordinates of each cell variable in the expansion range and take the coordinates as the relative position value of the cell variable.
According to the method for calculating the dynamic data of the Web form provided by the invention, the method for calculating the instance according to the first instance starts to circularly calculate the instance so as to configure the coordinates of each cell variable in the expansion range as the relative position value of the cell variable, and the method comprises the following steps:
calculating a start-stop position of the expansion range according to the first example, wherein the start-stop position comprises: a start row position, a stop row position, a start column position, and a stop column position;
starting from the first example in the starting and ending position range, according to the line number vertical calculation example and the column number horizontal calculation example, the coordinates of each cell variable in the expansion range are configured to serve as relative position values of the cell variables.
According to the method for calculating the dynamic data of the Web table provided by the invention, the coordinates of each cell variable in the expansion range are configured according to the calculation formula in the configuration of the Web table, and the method further comprises the following steps after the coordinates are used as the relative position values of the cell variables:
and configuring coordinates of cell variables outside the expansion range according to a calculation formula in Web table configuration, and taking the coordinates as relative position values of the cell variables.
According to the method for calculating the dynamic data of the Web form, the relative position value of each cell variable is calculated according to the dynamic data cycle, so as to obtain the absolute position value of the cell variable, and the method comprises the following steps:
acquiring the relative position value of each cell variable, judging whether the current cell variable circulates along with an expansion range, if so, circulating along with dynamic data, calculating the absolute position value of the current cell variable, replacing the relative position value of the current cell variable with the absolute position value, and if not, expanding along with dynamic data, calculating the absolute position value of the current cell variable, and replacing the relative position value of the current cell variable with the absolute position value.
According to the method for calculating the dynamic data of the Web form, the configuration of the Web form comprises the following steps: a reference field and the calculation formula, the reference field including: the dynamic data and the expansion direction, and the expansion range of the dynamic data is determined through the expansion direction.
According to the method for calculating the dynamic data of the Web form, provided by the invention, the expansion range of the dynamic data comprises the following steps: a continuous expansion range and a discontinuous expansion range.
The invention also provides a dynamic data computing device of the Web form, which comprises:
the configuration acquisition module is used for acquiring Web form configuration;
the range determining module is used for determining the expansion range of the dynamic data in the Web form configuration;
the relative position calculation module is used for configuring the coordinates of each cell variable in the expansion range according to a calculation formula in Web form configuration and taking the coordinates as the relative position value of the cell variable;
the absolute position calculation module is used for circularly calculating the relative position value of each cell variable according to the dynamic data to obtain the absolute position value of the cell variable;
and the result output module is used for outputting the absolute position value to be rendered to the Web form.
The invention also provides an electronic device, which comprises a memory, a processor and a computer program stored in the memory and capable of running on the processor, wherein the processor realizes the dynamic data calculation method of the Web form when executing the program.
The present invention also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the method for dynamic data calculation of a Web form according to any of the above.
According to the method and the device for calculating the dynamic data of the Web form, the Web form configuration is acquired and analyzed, the expansion range of the dynamic data in the Web form configuration is determined, and the dynamic data, namely the data acquired in real time in the Web form, can return data with different numbers along with the query condition and the data quantity of the original data. The coordinates of each cell variable in the expansion range are configured at the back end through a calculation formula in the Web table configuration and serve as relative position values of the cell variables, namely coordinate positions represented by the variables arranged in the cells, and the coordinate positions of the variables can be changed along with expansion of the area. And then calculating the relative position value of each cell variable through dynamic data circulation to obtain the absolute position value of the cell variable, namely the coordinate position of the cell variable after dynamic data rendering. And finally, replacing the data in the expansion range by the absolute position value, and outputting the absolute position value to render to the Web form at the front end, thereby realizing the dynamic data calculation of the Web form. The method comprises the steps of obtaining dynamic data of the front end of the Web, adopting a primary formula at the rear end according to configuration, calculating absolute position values after configuring the relative positions of cell variables in an expansion range, and finally outputting the absolute position values to the front end of the Web form. The method has the advantages that the Excel native formula can be directly used for the Web form after data rendering, the defects of high learning cost, high operation difficulty and non-visual checking of data in the Web form in the prior art are overcome, and the usability and flexibility of the Web form are realized.
Drawings
In order to more clearly illustrate the invention or the technical solutions of the prior art, the following description will briefly explain the drawings used in the embodiments or the description of the prior art, and it is obvious that the drawings in the following description are some embodiments of the invention, and other drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a method for dynamic data computation of a Web form provided by the invention;
FIG. 2 is a schematic diagram of dynamic data of a method for calculating dynamic data of a Web form according to the present invention;
FIG. 3 is a schematic diagram of relative position values of a method for dynamic data calculation of a Web form provided by the present invention;
FIG. 4 is a schematic diagram of absolute position values of a dynamic data calculation method of a Web form provided by the present invention;
FIG. 5 is a schematic diagram of a dynamic data computing device for a Web form according to the present invention;
fig. 6 is a schematic structural diagram of an electronic device provided by the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the present invention more apparent, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is apparent that the described embodiments are some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
A dynamic data calculation method of a Web form according to a first embodiment of the present invention is described below with reference to fig. 1 to 4.
As shown in fig. 1, the method for calculating dynamic data of a Web table according to the present embodiment specifically includes the following steps (the present invention only performs step distinction on numbers of steps, and does not limit the specific execution sequence of the steps):
step S1: a Web form configuration is obtained.
Each configuration parameter in the front-end Web table is acquired, and the Web table configuration of the embodiment includes: a reference field and a calculation formula, the reference field including: dynamic data and expansion directions, wherein the dynamic data, namely data acquired in real time in a Web form, can return data with different numbers along with query conditions and data quantity of original data.
Step S2: and determining the expansion range of the dynamic data in the Web form configuration.
Analyzing the acquired Web form configuration, determining the appointed expansion range in the dynamic data, and determining the expansion range of the dynamic data through the expansion direction in the configuration.
Step S3: and configuring the coordinates of each cell variable in the expansion range according to a calculation formula in Web table configuration, and taking the coordinates as the relative position value of the cell variable.
The coordinates of each cell variable in the expansion range are configured at the back end through a calculation formula in the Web table configuration and serve as relative position values of the cell variables, namely coordinate positions represented by the variables arranged in the cells, and the coordinate positions of the variables can be changed along with expansion of the area.
Step S4: and calculating the relative position value of each cell variable according to the dynamic data cycle to obtain the absolute position value of the cell variable.
And calculating the relative position value of each cell variable through dynamic data circulation to obtain the absolute position value of the cell variable, namely the coordinate position of the cell variable after dynamic data rendering.
Step S5: and outputting the absolute position value to be rendered to a Web form.
And replacing the data in the expansion range by the absolute position value, and outputting the absolute position value to render to the Web form at the front end, so that the dynamic data calculation of the Web form is realized.
According to the method for calculating the dynamic data of the Web form, provided by the first embodiment of the invention, the Web form configuration is obtained to analyze the Web form configuration, the expansion range of the dynamic data in the Web form configuration is determined, and the dynamic data, namely the data obtained in real time in the Web form, can return different data according to the query condition and the data quantity of the original data. The coordinates of each cell variable in the expansion range are configured at the back end through a calculation formula in the Web table configuration and serve as relative position values of the cell variables, namely coordinate positions represented by the variables arranged in the cells, and the coordinate positions of the variables can be changed along with expansion of the area. And then calculating the relative position value of each cell variable through dynamic data circulation to obtain the absolute position value of the cell variable, namely the coordinate position of the cell variable after dynamic data rendering. And finally, replacing the data in the expansion range by the absolute position value, and outputting the absolute position value to render to the Web form at the front end, thereby realizing the dynamic data calculation of the Web form. The method comprises the steps of obtaining dynamic data of the front end of the Web, adopting a primary formula at the rear end according to configuration, calculating absolute position values after configuring the relative positions of cell variables in an expansion range, and finally outputting the absolute position values to the front end of the Web form. The method has the advantages that the Excel native formula can be directly used for the Web form after data rendering, the defects of high learning cost, high operation difficulty and non-visual checking of data in the Web form in the prior art are overcome, and the usability and flexibility of the Web form are realized.
In this embodiment, the configuring coordinates of each cell variable in the expansion range according to the calculation formula in the Web table configuration as the relative position value of the cell variable includes:
the coordinates of the first group of cells in the expansion range are configured according to a calculation formula in Web table configuration and serve as relative position values of cell variables, wherein the relative position values of the first group of cells are the first instance;
and starting a loop calculation example according to the first example, so as to configure the coordinates of each cell variable in the expansion range and take the coordinates as the relative position value of the cell variable.
As shown in fig. 2, fig. 2 is original dynamic data acquired from a Web configuration, including data of a series of fields a and a series of fields B. As shown in fig. 3, the fields a and B are in columns a and B, respectively, and column C is SUM (a# { current row }, b# { current row }) that is, the SUM of the fields a and B in the current row of column C. Therefore, in this embodiment, the range of column a, column B, and column C is an expansion range, where a1+b1+c1 in the table is a first group of cells in the expansion range, and coordinates of the first group of cells in the expansion range are configured according to a calculation formula in the Web table configuration and used as relative position values of cell variables, where the relative position value of the first group of cells is the first instance (a1+b1+c1). SUM (C1, C# { current row-1 }) of column C is a formula outside the expansion range, namely, the SUM of all data of column C in the expansion range is calculated. And circularly calculating the examples from the first example according to the dynamic data to configure the coordinates of each cell variable in the expansion range as the relative position value of the cell variable. In the process, the back end directly uses the original formula to calculate the relative position value, so that the Web form after data rendering has usability and flexibility.
In this embodiment, the starting the loop calculation example according to the first example to configure coordinates of each cell variable in the expansion range as the relative position value of the cell variable includes:
calculating a start-stop position of the expansion range according to the first example, wherein the start-stop position comprises: a start row position, a stop row position, a start column position, and a stop column position;
starting from the first example in the starting and ending position range, according to the line number vertical calculation example and the column number horizontal calculation example, the coordinates of each cell variable in the expansion range are configured to serve as relative position values of the cell variables.
In a specific process of configuring the relative position values of the cell variables in the expansion range, calculating the start-stop positions of the expansion range according to the first example, wherein the start-stop positions comprise: a start row position, a stop row position, a start column position, and a stop column position. For example, the starting and stopping positions of the expansion range are A1 to C8, and the starting row position, the stopping row position, the starting column position and the stopping column position of the starting and stopping positions in the expansion range can be determined according to the starting and stopping positions. Starting from the first example (A1+B1+C1) in the starting and ending position range, according to the line number vertical calculation example and the column number horizontal calculation example, the coordinates of each cell variable in the expansion range are configured to serve as the relative position values of the cell variables. Specifically, the configured extension data range is an instance, data is filled in a circulating instance mode according to the configuration, each piece of data generates an instance, the number of the filled instances in the table is recorded, the extension direction is judged, the number of the row number of the instances is calculated in the vertical direction, and the number of the column number of the instances is calculated in the horizontal direction. Through the above calculation process, accuracy between the relative position values is ensured.
In this embodiment, the configuring coordinates of each cell variable in the expansion range according to the calculation formula in the Web table configuration, as the relative position value of the cell variable, further includes:
and configuring coordinates of cell variables outside the expansion range according to a calculation formula in Web table configuration, and taking the coordinates as relative position values of the cell variables.
If the Web table configuration further includes a formula outside the expansion range, for example, SUM (C1, c# { current row-1 }) of column C is a formula outside the expansion range, that is, the SUM of all data of column C in the expansion range is calculated. After the current expansion range is determined, the relative position values outside the expansion range are expanded along with the dynamic data according to the configuration of the Web form, so that the actual requirements of the Web form are met, and the compatibility of dynamic data processing is ensured.
In this embodiment, the calculating the relative position value of each cell variable according to the dynamic data cycle to obtain the absolute position value of the cell variable includes:
acquiring the relative position value of each cell variable, judging whether the current cell variable circulates along with an expansion range, if so, circulating along with dynamic data, calculating the absolute position value of the current cell variable, replacing the relative position value of the current cell variable with the absolute position value, and if not, expanding along with dynamic data, calculating the absolute position value of the current cell variable, and replacing the relative position value of the current cell variable with the absolute position value.
In calculating the absolute position value from the relative position value, a start row position, a stop row position, a start column position, and a stop column position within the extended data range are determined from the top left corner position of the first instance. And acquiring the relative position value of each cell variable, judging whether the current cell variable circulates along with the expansion range, if so, circulating along with dynamic data, calculating the absolute position value of the current cell variable, namely, calculating according to the initial position of the variable and the number of rows/columns of an example circularly to obtain the absolute position value, and replacing the relative position value of the current cell variable by the absolute position value. If the absolute position value is out of the expansion range, the absolute position value of the current cell variable is calculated along with dynamic data expansion, namely, the absolute position value is obtained according to the variable initial position and the number of lines/columns x (the number of examples is-1), and the relative position value of the current cell variable is replaced by the absolute position value. As shown in fig. 4, the formulas for configuring the cells in column C are C1 and C2 along with the dynamic data circulation, that is, both C1 and C2 have formulas=sum (a# { current row }, b# { current row }), the value of # { current row } of the cell in column C1 is calculated to be 1, the value of # { current row } of the cell in column C2 is calculated to be 2, the final result is shown in fig. 4, the calculated absolute position value is the result of the Web table, and the calculated absolute position value is output to the front end of the Web table, so that the display is intuitive and the calculation is flexible.
In this embodiment, the Web form configuration includes: a reference field and the calculation formula, the reference field including: the dynamic data and the expansion direction, and the expansion range of the dynamic data is determined through the expansion direction.
Determining the source of the dynamic data and the expansion direction of the dynamic data according to the reference field, determining the expansion range of the dynamic data according to the expansion direction, and calculating a corresponding absolute position value according to the expansion range, namely a result of the Web form needing to be calculated, wherein the process of back-end calculation is correct and the data is accurate by acquiring the configuration information.
In this embodiment, the expansion range of the dynamic data includes: a continuous expansion range and a discontinuous expansion range.
According to the configuration requirement of the Web table, the expansion range of the embodiment includes a continuous expansion range and a discontinuous expansion range, and the main difference is that the calculation result of the discontinuous expansion range and the input dynamic data are not in the same row/column, for example, the column C of the discontinuous expansion range is SUM (a# { current row-1 }, b# { current row-1 }), that is, the result of a1+b1 is displayed at the position C2 of the table. The calculation result of the relative position value is correspondingly adjusted, so that the calculation method of the embodiment has high compatibility.
The dynamic data calculating device of the Web form provided by the invention is described below, and the dynamic data calculating device of the Web form described below and the dynamic data calculating method of the Web form described above can be referred to correspondingly to each other.
As shown in fig. 5, a second embodiment of the present invention further provides a dynamic data computing device for a Web form, including:
the configuration acquisition module 210 is configured to acquire a Web form configuration.
The range determining module 220 is configured to determine an expansion range of the dynamic data in the Web form configuration.
The relative position calculating module 230 is configured to configure coordinates of each cell variable in the expansion range according to a calculation formula in the Web table configuration, and the coordinates are used as relative position values of the cell variables.
The absolute position calculating module 240 is configured to calculate the relative position value of each cell variable according to the dynamic data cycle, so as to obtain the absolute position value of the cell variable.
The result output module 250 is configured to output the absolute position value for rendering to a Web form.
According to the dynamic data computing device of the Web form, provided by the second embodiment of the invention, the Web form configuration is obtained to analyze the Web form configuration, the expansion range of dynamic data in the Web form configuration is determined, and the dynamic data, namely the data obtained in real time in the Web form, can return different data according to the query condition and the data quantity of the original data. The coordinates of each cell variable in the expansion range are configured at the back end through a calculation formula in the Web table configuration and serve as relative position values of the cell variables, namely coordinate positions represented by the variables arranged in the cells, and the coordinate positions of the variables can be changed along with expansion of the area. And then calculating the relative position value of each cell variable through dynamic data circulation to obtain the absolute position value of the cell variable, namely the coordinate position of the cell variable after dynamic data rendering. And finally, replacing the data in the expansion range by the absolute position value, and outputting the absolute position value to render to the Web form at the front end, thereby realizing the dynamic data calculation of the Web form. The method comprises the steps of obtaining dynamic data of the front end of the Web, adopting a primary formula at the rear end according to configuration, calculating absolute position values after configuring the relative positions of cell variables in an expansion range, and finally outputting the absolute position values to the front end of the Web form. The method has the advantages that the Excel native formula can be directly used for the Web form after data rendering, the defects of high learning cost, high operation difficulty and non-visual checking of data in the Web form in the prior art are overcome, and the usability and flexibility of the Web form are realized.
Optionally, the relative position calculation module 230 is specifically configured to:
the coordinates of the first group of cells in the expansion range are configured according to a calculation formula in Web table configuration and serve as relative position values of cell variables, wherein the relative position values of the first group of cells are the first instance;
and starting a loop calculation example according to the first example, so as to configure the coordinates of each cell variable in the expansion range and take the coordinates as the relative position value of the cell variable.
Optionally, the relative position calculating module 230 is further specifically configured to:
the coordinates of the first group of cells in the expansion range are configured according to a calculation formula in Web table configuration and serve as relative position values of cell variables, wherein the relative position values of the first group of cells are the first instance;
calculating a start-stop position of the expansion range according to the first example, wherein the start-stop position comprises: a start row position, a stop row position, a start column position, and a stop column position;
starting from the first example in the starting and ending position range, according to the line number vertical calculation example and the column number horizontal calculation example, the coordinates of each cell variable in the expansion range are configured to serve as relative position values of the cell variables. Optionally, the relative position calculation module 230 is specifically configured to:
the coordinates of each cell variable in the expansion range are configured according to a calculation formula in Web form configuration and used as the relative position value of the cell variable;
and configuring coordinates of cell variables outside the expansion range according to a calculation formula in Web table configuration, and taking the coordinates as relative position values of the cell variables.
Optionally, the absolute position calculation module 240 is specifically configured to:
acquiring the relative position value of each cell variable, judging whether the current cell variable circulates along with an expansion range, if so, circulating along with dynamic data, calculating the absolute position value of the current cell variable, replacing the relative position value of the current cell variable with the absolute position value, and if not, expanding along with dynamic data, calculating the absolute position value of the current cell variable, and replacing the relative position value of the current cell variable with the absolute position value.
Optionally, the Web form configuration includes: a reference field and the calculation formula, the reference field including: the dynamic data and the expansion direction, and the expansion range of the dynamic data is determined through the expansion direction.
Optionally, the expanding range of the dynamic data includes: a continuous expansion range and a discontinuous expansion range.
Fig. 6 illustrates a physical schematic diagram of an electronic device, as shown in fig. 6, which may include: processor 310, communication interface (Communications Interface) 320, memory 330 and communication bus 340, wherein processor 310, communication interface 320, memory 330 accomplish communication with each other through communication bus 340. Processor 310 may invoke logic instructions in memory 330 to perform a method of dynamic data computation for a Web form, the method comprising:
a Web form configuration is obtained.
And determining the expansion range of the dynamic data in the Web form configuration.
And configuring the coordinates of each cell variable in the expansion range according to a calculation formula in Web table configuration, and taking the coordinates as the relative position value of the cell variable.
And calculating the relative position value of each cell variable according to the dynamic data cycle to obtain the absolute position value of the cell variable.
And outputting the absolute position value to be rendered to a Web form.
Further, the logic instructions in the memory 330 described above may be implemented in the form of software functional units and may be stored in a computer-readable storage medium when sold or used as a stand-alone product. Based on this understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
In another aspect, the present invention also provides a computer program product, where the computer program product includes a computer program, where the computer program can be stored on a non-transitory computer readable storage medium, where the computer program when executed by a processor can perform a method for calculating dynamic data of a Web table provided by the methods above, where the method includes:
a Web form configuration is obtained.
And determining the expansion range of the dynamic data in the Web form configuration.
And configuring the coordinates of each cell variable in the expansion range according to a calculation formula in Web table configuration, and taking the coordinates as the relative position value of the cell variable.
And calculating the relative position value of each cell variable according to the dynamic data cycle to obtain the absolute position value of the cell variable.
And outputting the absolute position value to be rendered to a Web form.
In yet another aspect, the present invention also provides a non-transitory computer readable storage medium having stored thereon a computer program which, when executed by a processor, is implemented to perform a method for dynamic data computation of a Web form provided by the methods described above, the method comprising:
a Web form configuration is obtained.
And determining the expansion range of the dynamic data in the Web form configuration.
And configuring the coordinates of each cell variable in the expansion range according to a calculation formula in Web table configuration, and taking the coordinates as the relative position value of the cell variable.
And calculating the relative position value of each cell variable according to the dynamic data cycle to obtain the absolute position value of the cell variable.
And outputting the absolute position value to be rendered to a Web form.
The apparatus embodiments described above are merely illustrative, wherein the elements illustrated as separate elements may or may not be physically separate, and the elements shown as elements may or may not be physical elements, may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art will understand and implement the present invention without undue burden.
From the above description of the embodiments, it will be apparent to those skilled in the art that the embodiments may be implemented by means of software plus necessary general hardware platforms, or of course may be implemented by means of hardware. Based on this understanding, the foregoing technical solution may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a computer readable storage medium, such as ROM/RAM, a magnetic disk, an optical disk, etc., including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method described in the respective embodiments or some parts of the embodiments.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solution of the present invention, and are not limiting; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. A method for dynamic data computation of a Web form, comprising:
acquiring Web form configuration;
determining the expansion range of dynamic data in the configuration of the Web form;
the coordinates of each cell variable in the expansion range are configured according to a calculation formula in Web form configuration and used as the relative position value of the cell variable;
calculating the relative position value of each cell variable according to the dynamic data cycle to obtain the absolute position value of the cell variable;
and outputting the absolute position value to be rendered to a Web form.
2. The method for calculating dynamic data of a Web table according to claim 1, wherein the configuring coordinates of each cell variable in the expansion range according to a calculation formula in the Web table configuration as a relative position value of the cell variable includes:
the coordinates of the first group of cells in the expansion range are configured according to a calculation formula in Web table configuration and serve as relative position values of cell variables, wherein the relative position values of the first group of cells are the first instance;
and starting a loop calculation example according to the first example, so as to configure the coordinates of each cell variable in the expansion range and take the coordinates as the relative position value of the cell variable.
3. The method for calculating dynamic data of a Web form according to claim 2, wherein the starting the loop calculation instance according to the first instance to configure coordinates of each cell variable in the expansion range as a relative position value of the cell variable includes:
calculating a start-stop position of the expansion range according to the first example, wherein the start-stop position comprises: a start row position, a stop row position, a start column position, and a stop column position;
starting from the first example in the starting and ending position range, according to the line number vertical calculation example and the column number horizontal calculation example, the coordinates of each cell variable in the expansion range are configured to serve as relative position values of the cell variables.
4. The method for calculating dynamic data of a Web table according to claim 1, wherein the configuring coordinates of each cell variable in the expansion range according to a calculation formula in the Web table configuration, as a relative position value of the cell variable, further comprises:
and configuring coordinates of cell variables outside the expansion range according to a calculation formula in Web table configuration, and taking the coordinates as relative position values of the cell variables.
5. The method for calculating dynamic data of Web form according to claim 4, wherein calculating the relative position value of each cell variable according to the dynamic data cycle, to obtain the absolute position value of the cell variable, comprises:
acquiring the relative position value of each cell variable, judging whether the current cell variable circulates along with an expansion range, if so, circulating along with dynamic data, calculating the absolute position value of the current cell variable, replacing the relative position value of the current cell variable with the absolute position value, and if not, expanding along with dynamic data, calculating the absolute position value of the current cell variable, and replacing the relative position value of the current cell variable with the absolute position value.
6. The method for calculating dynamic data of a Web form according to any one of claims 1 to 5, wherein the Web form configuration includes: a reference field and the calculation formula, the reference field including: the dynamic data and the expansion direction, and the expansion range of the dynamic data is determined through the expansion direction.
7. The method for computing dynamic data of a Web form according to claim 6, wherein the expansion range of the dynamic data comprises: a continuous expansion range and a discontinuous expansion range.
8. A dynamic data computing device of a Web form, comprising:
the configuration acquisition module is used for acquiring Web form configuration;
the range determining module is used for determining the expansion range of the dynamic data in the Web form configuration;
the relative position calculation module is used for configuring the coordinates of each cell variable in the expansion range according to a calculation formula in Web form configuration and taking the coordinates as the relative position value of the cell variable;
the absolute position calculation module is used for circularly calculating the relative position value of each cell variable according to the dynamic data to obtain the absolute position value of the cell variable;
and the result output module is used for outputting the absolute position value to be rendered to the Web form.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of dynamic data calculation of a Web form according to any one of claims 1 to 7 when the program is executed by the processor.
10. A non-transitory computer readable storage medium having stored thereon a computer program, wherein the computer program when executed by a processor implements the method of dynamic data calculation of a Web form according to any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311266621.XA CN117009717B (en) | 2023-09-28 | 2023-09-28 | Dynamic data calculation method and device for Web form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311266621.XA CN117009717B (en) | 2023-09-28 | 2023-09-28 | Dynamic data calculation method and device for Web form |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117009717A true CN117009717A (en) | 2023-11-07 |
| CN117009717B CN117009717B (en) | 2023-12-22 |
Family
ID=88562143
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311266621.XA Active CN117009717B (en) | 2023-09-28 | 2023-09-28 | Dynamic data calculation method and device for Web form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117009717B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6851088B1 (en) * | 1999-12-07 | 2005-02-01 | International Business Machines Corporation | Conditional highlighting of given cells in a dynamic HTML table |
| US20050050088A1 (en) * | 2000-06-21 | 2005-03-03 | Microsoft Corporation | System and method for integrating spreadsheets and word processing tables |
| CN114741144A (en) * | 2022-03-18 | 2022-07-12 | 中银金融科技有限公司 | Web-side complex table display method, device and system |
| CN115222840A (en) * | 2022-06-08 | 2022-10-21 | 阿里巴巴（中国）有限公司 | Table rendering method, computer-readable storage medium, and electronic device |
| CN116050362A (en) * | 2023-03-23 | 2023-05-02 | 青岛诺亚信息技术有限公司 | Web form dynamic data binding method, medium and system |
| CN116107576A (en) * | 2023-04-14 | 2023-05-12 | 小米汽车科技有限公司 | Page component rendering method and device, electronic equipment and vehicle |
-
2023
- 2023-09-28 CN CN202311266621.XA patent/CN117009717B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6851088B1 (en) * | 1999-12-07 | 2005-02-01 | International Business Machines Corporation | Conditional highlighting of given cells in a dynamic HTML table |
| US20050050088A1 (en) * | 2000-06-21 | 2005-03-03 | Microsoft Corporation | System and method for integrating spreadsheets and word processing tables |
| CN114741144A (en) * | 2022-03-18 | 2022-07-12 | 中银金融科技有限公司 | Web-side complex table display method, device and system |
| CN115222840A (en) * | 2022-06-08 | 2022-10-21 | 阿里巴巴（中国）有限公司 | Table rendering method, computer-readable storage medium, and electronic device |
| CN116050362A (en) * | 2023-03-23 | 2023-05-02 | 青岛诺亚信息技术有限公司 | Web form dynamic data binding method, medium and system |
| CN116107576A (en) * | 2023-04-14 | 2023-05-12 | 小米汽车科技有限公司 | Page component rendering method and device, electronic equipment and vehicle |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117009717B (en) | 2023-12-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107609217B (en) | Processing method and device for collision check data | |
| CN109746405B (en) | Automatic control method and device for casting blank roller way, terminal equipment and storage medium | |
| CN109740244A (en) | A kind of multicore interconnection verification method of the irredundant uniform fold of excitation space | |
| CN112270146A (en) | Process design toolkit development method and device, electronic equipment and storage medium | |
| CN117009717B (en) | Dynamic data calculation method and device for Web form | |
| CN107704568A (en) | A kind of method and device of test data addition | |
| CN114648105A (en) | Slicing method, device, chip and storage medium of multi-output neural network | |
| CN116070552B (en) | Calculation method and device for non-sticky flux, terminal equipment and storage medium | |
| CN116225640A (en) | Concurrent construction method for welding digital twin three-dimensional scene model | |
| CN109871939B (en) | Image processing method and image processing device | |
| EP4357924A1 (en) | Application performance testing method, method and apparatus for establishing performance testing model | |
| CN116360787A (en) | Automatic generation method and device for form codes, electronic equipment and storage medium | |
| CN116009889A (en) | Deep learning model deployment method and device, electronic equipment and storage medium | |
| CN109857832A (en) | A kind of preprocess method and device of payment data | |
| CN113763521B (en) | Hair model rendering method and device, electronic equipment and storage medium | |
| CN101770527A (en) | Method for modifying data of circuit components | |
| CN110699863B (en) | Timing method, system, computer readable storage medium and server | |
| CN110175414A (en) | Placing part method and tool in a kind of PCB design | |
| CN107025106B (en) | Graph drawing method and device | |
| TW201316194A (en) | System and method for outputting measurement codes | |
| CN113991678B (en) | Stability control analysis method, device, medium and equipment for power system | |
| CN113077538B (en) | Method and device for establishing three-dimensional temperature and humidity cloud picture of machine room and terminal equipment | |
| CN110096555B (en) | Table matching processing method and device for distributed system | |
| CN111007836B (en) | New energy BMS hardware-in-the-loop test case library establishing method | |
| CN117762338A (en) | Memory grouping method, device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |