CN112347747A - Form style processing method and related device - Google Patents
Form style processing method and related device Download PDFInfo
- Publication number
- CN112347747A CN112347747A CN202011210549.5A CN202011210549A CN112347747A CN 112347747 A CN112347747 A CN 112347747A CN 202011210549 A CN202011210549 A CN 202011210549A CN 112347747 A CN112347747 A CN 112347747A
- Authority
- CN
- China
- Prior art keywords
- style
- target
- cell
- file
- differential
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 23
- 238000000034 method Methods 0.000 claims abstract description 24
- 238000004364 calculation method Methods 0.000 claims description 7
- 238000004891 communication Methods 0.000 description 5
- 239000003086 colorant Substances 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000007373 indentation Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000005192 partition Methods 0.000 description 2
- 238000004590 computer program Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 230000010076 replication Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- 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/174—Form filling; Merging
-
- 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/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application discloses a form style processing method and a related device, which are used for realizing that files of the whole form occupy smaller storage space under the condition that the same content information is stored in the form. The method in the embodiment of the application comprises the following steps: acquiring a target table; determining a table base style corresponding to the target table; receiving cell style setting of the target table to form a table target style; calculating the table differential quantity style of the table basic style and the table target style to form a table differential quantity style file; storing the table delta style file in association with the target table.
Description
Technical Field
The present application relates to the field of data processing, and in particular, to a form style processing method and a related apparatus.
Background
The form, also called table, is a visual communication mode and a means for organizing and organizing data. People widely use tables of different shapes and colors in communication, scientific research and data analysis activities. The table with the cell style can facilitate people to quickly locate data which the cells with the specific cell style in the table want to express, and the function of reminding a user is achieved.
In the prior art, a filling scheme for table styles is to manually select cells in a table to fill a desired cell style, and then store table data and the cell style together in a file. In the prior art, the form style needs report compiling personnel to manually fill all cells needing to be provided with the cell style, each cell provided with the cell style is correspondingly added with a cell style file, the form style file comprises the cell style file of the whole form, so that the form style file of the form is overlarge, and the file of the whole form comprises the form style file and the form data file, so that the file of the whole form occupies a larger storage space.
Disclosure of Invention
The embodiment of the application provides a form style processing method and a related device, which are used for realizing that files of the whole form occupy smaller storage space under the condition that the same content information is stored in the form.
A first aspect of the present application provides a form style processing method, including:
acquiring a target table;
determining a table base style corresponding to the target table;
receiving cell style setting of the target table to form a table target style;
calculating the table differential quantity style of the table basic style and the table target style to form a table differential quantity style file;
storing the table delta style file in association with the target table.
Optionally, after storing the table delta pattern file in association with the target table, the method further comprises:
receiving an opening instruction of the target table;
and jointly reading the target table, the table differential style file stored in association with the target table and the table base style corresponding to the target table according to the opening instruction, and covering and displaying the table differential style in the table differential style file on the table base style displayed by the target table.
Optionally, the table delta style overlay in the table delta style file is shown after the table base style shown in the target table, the method further comprises:
receiving new cell style setting of the target table to form a new table target style;
calculating a new table differential style of the table basic style and the new table target style to form a new table differential style file;
treating the new table delta pattern file as a table delta pattern file;
triggering execution of the step of storing the table delta pattern file in association with the target table.
Optionally, calculating a table delta style of the table base style and the table target style, and forming a table delta style file includes:
traversing the current cell style of each cell in the target table and comparing the cell basic style of the cell in the table basic style;
if the current cell style is not consistent with the cell basic style, the current cell style is stored to form a cell style differential file, the cell style of the current cell corresponding to the current cell style points to the cell style differential file formed by changing the cell basic style into the current cell style, and the plurality of cell style differential files form the table differential style file.
Optionally, after the current cell style is inconsistent with the cell base style and before the current cell style is saved, the method further includes:
judging whether a cell pattern delta file formed by other cells in the target table is consistent with the current cell pattern or not;
if the cell style differential file is consistent with the current cell style, changing the cell style of the current cell corresponding to the current cell style from the cell basic style to the cell style differential file;
and if the cell style differential file is not consistent with the current cell style, triggering to execute the step of storing the current cell style.
Optionally, before determining the table base style corresponding to the target table, the method further includes:
dividing the target table into one or more areas according to a preset rule, wherein one area at least comprises one cell;
and respectively recording the cell style of each block of the area to form the table basic style.
Optionally, the dividing the target table into one or more blocks according to a preset rule includes:
dividing the target table into one or more blocks of areas according to the cell style similarity of the cells in the target table;
or the like, or, alternatively,
and dividing the target table into one or more blocks according to the received selection instruction of the cells in the target table.
Optionally, after forming the table delta pattern file, the method further comprises:
receiving a style selection of the table delta style file in other tables;
and selecting and reading the table differential style in the table differential style file to cover the table styles of the other tables according to the style.
Optionally, before receiving a style selection of the form delta style file by another form, the method further comprises:
presenting the table delta style file in the other table in a selectable table style.
A second aspect of the present application provides a form style processing system, comprising:
an acquisition unit configured to acquire a target table;
the determining unit is used for determining a table base style corresponding to the target table;
the receiving unit is used for receiving the cell style setting of the target table to form a table target style;
the calculation unit is used for calculating the table differential quantity styles of the table basic style and the table target style to form a table differential quantity style file;
and the association storage unit is used for associating and storing the table differential quantity pattern file with the target table.
Optionally, the system further comprises:
the receiving unit is also used for receiving an opening instruction of the target table;
and the reading and displaying unit is used for jointly reading the target table, the table differential style file stored in association with the target table and the table base style corresponding to the target table according to the opening instruction, and covering and displaying the table differential style in the table differential style file on the table base style displayed by the target table.
Optionally, the system further comprises:
the receiving unit is also used for receiving the new cell style setting of the target table to form a new table target style;
the calculation unit is also used for calculating a new table differential quantity style of the table basic style and the new table target style to form a new table differential quantity style file;
a treating unit for treating the new table delta pattern file as a table delta pattern file;
and the trigger unit is used for triggering the step of storing the table delta pattern file and the target table in an associated manner.
Optionally, when the calculation unit calculates the table differential quantity pattern of the table base pattern and the table target pattern to form a table differential quantity pattern file, the calculation unit is specifically configured to:
traversing the current cell style of each cell in the target table and comparing the cell basic style of the cell in the table basic style;
if the current cell style is not consistent with the cell basic style, the current cell style is stored to form a cell style differential file, the cell style of the current cell corresponding to the current cell style points to the cell style differential file formed by changing the cell basic style into the current cell style, and the plurality of cell style differential files form the table differential style file.
Optionally, the system further comprises:
the judging unit is used for judging whether a cell pattern differential file formed by other cells in the target table is consistent with the current cell pattern;
an updating unit, configured to change a cell style of a current cell corresponding to a current cell style from a cell basic style to the cell style differential file if the cell style differential file is consistent with the current cell style;
and the triggering unit is also used for triggering and executing the step of saving the current cell style if the cell style differential file is not consistent with the current cell style.
Optionally, the system further comprises:
the dividing unit is used for dividing the target table into one or more areas according to a preset rule, wherein one area at least comprises one cell;
and the forming unit is used for recording the cell style of each region respectively to form the table basic style.
Optionally, when the dividing unit divides the target table into one or more areas according to a preset rule, the dividing unit is specifically configured to:
dividing the target table into one or more blocks of areas according to the cell style similarity of the cells in the target table;
or the like, or, alternatively,
and dividing the target table into one or more blocks according to the received selection instruction of the cells in the target table.
Optionally, the system further comprises:
a receiving unit, further configured to receive a style selection for the table delta style file in another table;
and the covering unit is used for selecting and reading the table differential style in the table differential style file to cover the table style of the other table according to the style.
Optionally, the system further comprises:
and the presentation unit is used for presenting the table differential style file in the other tables in a form of selectable table styles.
A third aspect of the present application provides a computer device comprising:
a processor, a memory;
the processor, when executing a program stored in the memory, performs a method as set forth in any one of the preceding first aspects.
A fourth aspect of the present application provides a computer storage medium having stored therein instructions that, when executed on a computer, cause the computer to perform the method of any of the preceding first aspects.
A fifth aspect of the present application provides a computer program product which, when executed on a computer, causes the computer to perform the method of any one of the preceding first aspects.
According to the technical scheme, the embodiment of the application has the following advantages:
the technical scheme of the application includes that a table basic style of a target table is determined, the table basic style is a table style template common to all tables, the table basic style is not stored, but a table differential quantity style of a table target style and a table basic style after a cell style is set in the target table is selected and calculated, a table differential quantity style file is formed, and the table differential quantity style file and the target table are stored in a related mode. Therefore, the technical scheme of the application realizes the isolated storage of the form style and the form of a target form, reduces the storage of the target form to the form basic style, and realizes that the file of the whole form occupies smaller storage space under the condition that the form stores the same content information.
Drawings
FIG. 1 is a flowchart illustrating a table style processing method according to an embodiment of the present application;
FIG. 2 is a flow chart illustrating another exemplary embodiment of a table style processing method of the present application;
FIG. 3 is a block diagram of a table style processing system according to an embodiment of the present application;
FIG. 4 is a schematic structural diagram of another embodiment of the form style processing system of the present application;
FIG. 5 is a schematic structural diagram of an embodiment of a computer device according to the present application.
Detailed Description
The embodiment of the application provides a form style processing method and a related device, which are used for realizing that files of the whole form occupy smaller storage space under the condition that the same content information is stored in the form. The embodiment of the application can be applied to information management systems such as Enterprise Resource Planning (ERP).
Referring to fig. 1, an embodiment of a table style processing method of the present application includes:
101. and acquiring a target table.
The embodiment needs to acquire a target table, which has a default preset common basic style, i.e. a table basic style. The form base style is a default form style that the form style processing system self-carries to be initially set for each form.
102. And determining a table base style corresponding to the target table.
Determining the table base style corresponding to the target table in step 101, it can be understood that the table base style processing system may carry a plurality of table base styles, and this step needs to determine which table base style of the target table belongs to the table base style processing system.
103. And receiving the cell style setting of the target table to form a table target style.
After determining the table base style of the target table in step 102, the embodiment of the present application may receive a cell style setting for any cell of the target table, and finally form a table target style corresponding to the target table. Such as font, bold, font style, font size, underlining, horizontal alignment, vertical alignment, indentation, top border, bottom border, left border, right border, font color, background color, border color, etc., of one or more cells in the target table.
104. And calculating the table differential quantity styles of the table base style and the table target style to form a table differential quantity style file.
Since the cell style setting is performed on the cells of the target form in step 103, the form style processing system forms a corresponding form target style, the form target style is composed of the cell style file of the cells with the set cell style, and the step calculates the form differential style between the form target style and the form base style to form the form differential style file.
105. And storing the table difference quantity style file in association with the target table.
When the target table with the set cell style needs to be stored, the delta style file in step 104 is associated and stored in combination with the target table with the table base style in step 101 in the embodiment of the present application. Compared with the traditional mode that the table target style needs to be stored together with the target table, the technical scheme of the embodiment reduces the storage of the target table to the table basic style, and realizes that the file of the whole table occupies a smaller storage space under the condition that the same content information is stored in the table.
It can be seen that, according to the technical scheme of the application, by determining the table base style of the target table, where the table base style is a table style template common to all tables, the table base style is not stored, but a table differential style of a table target style and a table base style after a cell style is set in the target table is selected for calculation, a table differential style file is formed, and the table differential style file and the target table are stored in an associated manner. Therefore, the technical scheme of the application realizes the isolated storage of the form style and the form of a target form, reduces the storage of the target form to the form basic style, and realizes that the file of the whole form occupies smaller storage space under the condition that the form stores the same content information.
Referring to fig. 2, another embodiment of the form style processing method of the present application includes:
201. and acquiring a target table.
The execution of this step is similar to the step 101 in the embodiment of fig. 1, and will not be described again here.
It should be noted that the target table needs to support a table in which the front-end table control quickly implements functions of importing and exporting a report, formatting data, calculating a formula, and filling online data. For example, integration of SpreadJS and a form style processing system is supported, functions of import and export, data formatting, formula calculation, online data filling and the like of a form can be rapidly realized, and SpreadJS is a pure front-end form control based on HTML 5.
202. And dividing the target table into one or more areas according to a preset rule, wherein one area at least comprises one cell.
After the target table is obtained in step 201, the target table may be divided into a plurality of blocks according to actual needs, for example, all cells in the target table are regarded as a block according to a preset rule, or the cells in the target table are divided into a plurality of block regions, where each block region at least includes one cell and one cell in the target table can only be located in one of the block regions. The purpose of dividing the target table into regions in the step is to realize the different setting and management of the table styles of the cells in different regions in the same target table so as to meet the requirements of people on setting different cell styles of different cells in one target table.
Specifically, the process of dividing the target table into one or more blocks according to the preset rule may be: dividing the target table into one or more areas according to the cell pattern similarity of the cells in the target table, for example, if the cell pattern similarity of the cells in the whole target table is one hundred percent, the whole target table can be divided into only one area; for another example, if the cell pattern similarity of all the cells in the first row of the target table is one hundred percent, the cell pattern similarity of all the cells in the second row to the last row of the target table is one hundred percent, and the cell pattern similarity between the cells in the first row and the cells in other rows of the target table is not one hundred percent, the target table may be divided into 2 regions, one of the regions is the first row of the target table, and the other region is the second row to the last row of the target table; the similarity division ratio for dividing the target table into one or more blocks according to the cell style similarity of the cells in the target table may also be other ratios, and is not limited herein.
Specifically, the process of dividing the target table into one or more blocks according to the preset rule may be: and dividing the target table into one or more blocks according to the received selection instruction of the cells in the target table. It can be understood that the embodiment of the application also supports the manual selection of the cells in the target table by the user to be divided into one or more areas so as to meet the personalized requirements. For example, in a table for a financial application, a target table may be divided into 6 areas, such as a header area, a column area, a row area, a header area, a data area, and a data sub-total area; when the form basic style corresponding to the target form is formed in the subsequent steps, the cell styles such as fonts, bold faces, font styles, font sizes, underlines, horizontal alignment modes, vertical alignment modes, indentation, upper borders, lower borders, left borders, right borders, font colors, background colors or border colors in all the areas can be uniformly set in the same or various ways, and then a universal form basic style is formed.
203. And respectively recording the cell style of each block area to form a table base style corresponding to the target table.
And respectively recording the cell style of each of the plurality of regions divided by the target table in the step 202 to form a table base style corresponding to the target table. If table basic patterns which are divided in the same area and are set by the same table pattern are prestored in the table pattern processing system, combining the two table basic patterns or taking one of the two table basic patterns; and if the same table base style does not exist in the table style processing system, forming a new table base style. It can be understood that the region partition of the target table is not easily changed once formed, at this time, the cell style of each block region of the target table forming the region partition may be recorded to form a table base style corresponding to the target table, that is, used as a table style template, and the table base style may be separately stored, for example, in the form of a JSON file, and associated with the corresponding table to serve as a table base style file of the corresponding table. For example, in the table of the finance application in step 202, the target table may be divided into 6 blocks of areas, such as a header area, a column area, a row area, a header area, a data area, and an example of a data sub-total area.
204. And determining a table base style of the target table.
The table base style corresponding to the target table formed in step 203 is determined to be the same as which table base style stored by the table style processing system, so as to determine the table base style of the target table, so that the table style processing system can know the comparison object of the calculated table delta style for the target table and know that the table base style file which only needs to be associated is not needed to be stored separately for the target table.
205. And receiving the cell style setting of the target table to form a table target style.
The execution of this step is similar to the step 103 in the embodiment of fig. 1, and will not be described again here.
206. Comparing the current cell style of each cell in the traversal target table with the cell basic style of the current cell in the basic style of the corresponding table, and if the current cell style is not consistent with the cell basic style, executing step 207; if the current cell style is consistent with the cell basic style, the step is continuously executed until the target table is traversed.
Specifically, in this step, each cell in the target table is traversed to obtain a current cell style of a certain current cell, the current cell style is compared with a cell basic style of the current cell in the table basic style corresponding to the target table, that is, whether the current cell style of the current cell is consistent with the cell basic style of the current cell is judged, if the current cell style is inconsistent with the cell basic style, step 207 is further executed; if the current cell style is consistent with the cell basic style, the cell basic style of the target table is proved to be not modified, and the step is continuously executed to traverse and compare other cells of the target table until the target table is traversed and completed.
207. Judging whether the cell style difference file formed by other cells in the target table is consistent with the current cell style, if so, executing step 209; if not, go to step 208.
For the cell style of the current cell in the target table in step 206, it is determined whether a cell style delta file formed by other cells in the target table is consistent with the cell style of the current cell.
208. And storing the current cell style to form a cell style differential file.
The current cell style in step 207 is saved to form a new cell style differential file, and the table differential style file is composed of a plurality of the cell style differential files.
209. The cell style of the current cell is directed to the cell style delta file changed from the cell base style to the cell style.
Since it is determined in step 207 that the cell pattern difference file of the current cell is consistent with the cell pattern difference files of other cells, in order to reduce the storage of the pattern files, achieve light application, and increase the table processing speed, the cell pattern difference file formed by the current cell may not be stored separately, and only the cell pattern of the current cell needs to be directed to the cell pattern difference file changed from the cell base pattern to the cell pattern difference file, that is, the cell pattern of the current cell is stored in association with the same cell pattern difference file formed by other cells.
However, for step 208, the cell style of the current cell is also required and points to the cell style delta file formed by changing the cell base style to the current cell style.
For example, when the cell style of the a1 cell in the target table is changed from the base style to the target style and the target cell style delta file is formed, the cell style pointing direction of the a1 cell is changed from the base style to the target cell style delta file, and when other cells also exist in the target table and also form the same target cell style delta file as the a1 cell, the other cells do not need to store the target cell style delta file separately, but only need to change the cell style pointing direction thereof to the cell style delta file. Therefore, only one cell pattern differential file is stored when the same cell patterns of a plurality of cells are realized, the occupation of the storage space of the table file is greatly reduced, and the information of the table is not lost.
210. And storing the table difference quantity style file in association with the target table.
The execution of this step is similar to the step 105 in the embodiment of fig. 1, and will not be described again here.
211. An open instruction for the target table is received.
After the table delta pattern file is stored in association with the target table in step 210, an open instruction for the target table may be received.
212. And reading the table differential quantity style file and the target table which are stored in association with the target table according to the opening instruction, and covering and displaying the table differential quantity style in the table differential quantity style file on the table basic style displayed by the target table.
Reading the table differential quantity style file and the target table stored in association with the target table according to the opening instruction of step 211, so that the table differential quantity style of the table differential quantity style file is displayed on the table basic style displayed by the target table in a covering manner, thereby realizing the effect of presenting the table target style of the target table.
213. And receiving new unit format setting of the target table to form a new table target style.
It is understood that, on the basis of step 212, the user may continue to receive new cell style settings for the cells of the target form, forming a new form target style.
214. And calculating the new table differential style of the table basic style and the new table target style to form a new table differential style file.
Since the new cell style setting is performed on the cells of the target form in step 213, a corresponding new form target style is formed, the new form target style is formed by covering the form base style with the cell style file having the set cell style, and the new cell difference style between the new form target style and the form base style is calculated in this step to form a new cell difference style file. In general, the new table delta pattern file is a cell pattern file of cells in which a cell pattern is set.
215. The new table delta pattern file is treated as a table delta pattern file.
The new table delta pattern file in step 214 is treated as the table delta pattern file in step 209 to trigger the execution of step 210 to store the table delta pattern file in association with the target table.
216. And displaying the table differential style file in other tables in a form of selectable table styles.
After the table delta style file is formed in step 209, the embodiment may further display the table delta style file in other tables in a form of selectable table style, so that other tables may preview or select the effect of the table delta style file, so as to implement a cross-table style call.
217. Style selections for the table delta style file are received at the other tables.
After the table delta style file is presented in the other table in the form of the selectable table style in step 216, a style selection for the table delta style file may be received in the other table to implement a cross-table style call.
218. And reading the table differential style in the table differential style file according to the style selection to cover the table styles of other tables.
After the other tables select the table difference pattern file in step 217, the other tables select and read the table difference pattern in the table difference pattern file in the difference pattern file according to the pattern, and cover their own table patterns with the table difference pattern to form independent table difference pattern files of the other tables, and of course, a new table pattern setting may also be received, which is referred to step 213 for details and is not described herein again.
It can be seen that, in addition to the lightweight storage scheme, the form style processing method of the embodiment can form a new form base style for previewing and selecting other forms, thereby realizing form style replication across forms, and further modifying the form style into a new form style on the basis of the replicated form style, which is convenient and fast.
The above embodiments describe embodiments of the form style processing method of the present application, and referring to fig. 3, an embodiment of the form style processing system of the present application includes:
an acquisition unit 301 configured to acquire a target table;
a determining unit 302, configured to determine a table base style corresponding to the target table;
a receiving unit 303, configured to receive a cell style setting for the target table to form a table target style;
a calculating unit 304, configured to calculate a table delta pattern of the table base pattern and the table target pattern to form a table delta pattern file;
an association storage unit 305, configured to store the table delta pattern file in association with the target table.
The operation performed in this embodiment is similar to the operation performed in the embodiment of fig. 1, and is not described again here.
The technical scheme of the application includes that a table basic style of a target table is determined, the table basic style is a table style template common to all tables, the table basic style is not stored, but a table differential quantity style of a table target style and a table basic style after a cell style is set in the target table is selected and calculated, a table differential quantity style file is formed, and the table differential quantity style file and the target table are stored in a related mode. Therefore, the technical scheme of the application realizes the isolated storage of the form style and the form of a target form, reduces the storage of the target form to the form basic style, and realizes that the file of the whole form occupies smaller storage space under the condition that the form stores the same content information.
Referring to fig. 4, another embodiment of the table style processing system of the present application includes:
an obtaining unit 401 configured to obtain a target table;
a determining unit 402, configured to determine a table base style corresponding to the target table;
a receiving unit 403, configured to receive a cell style setting for the target table, and form a table target style;
a calculating unit 404, configured to calculate a table delta pattern of the table base pattern and the table target pattern, and form a table delta pattern file;
an association storage unit 405, configured to store the table delta pattern file in association with the target table.
Optionally, the system further comprises:
a receiving unit 403, further configured to receive an opening instruction for the target table;
a reading and displaying unit 406, configured to jointly read the target table, the table delta pattern file stored in association with the target table, and the table base pattern corresponding to the target table according to the opening instruction, and cover and display the table delta pattern in the table delta pattern file on the table base pattern displayed in the target table.
Optionally, the system further comprises:
a receiving unit 403, further configured to receive a new cell style setting for the target table, forming a new table target style;
a calculating unit 404, further configured to calculate a new table delta pattern of the table base pattern and the new table target pattern, forming a new table delta pattern file;
a treating unit 407 for treating the new table delta pattern file as a table delta pattern file;
a triggering unit 408, configured to trigger execution of the step of storing the table delta pattern file in association with the target table.
Optionally, when the calculating unit 404 calculates the table differential quantity pattern of the table base pattern and the table target pattern to form a table differential quantity pattern file, it is specifically configured to:
traversing the current cell style of each cell in the target table and comparing the cell basic style of the cell in the table basic style;
if the current cell style is not consistent with the cell basic style, the current cell style is stored to form a cell style differential file, the cell style of the current cell corresponding to the current cell style points to the cell style differential file formed by changing the cell basic style into the current cell style, and the plurality of cell style differential files form the table differential style file.
Optionally, the system further comprises:
a determining unit 409, configured to determine whether a cell pattern delta file formed by other cells in the target table is consistent with the current cell pattern;
an updating unit 410, configured to, if there is a cell pattern delta file that is consistent with the current cell pattern, change a cell pattern of a current cell corresponding to the current cell pattern from a cell basic pattern to the cell pattern delta file;
the triggering unit 408 is further configured to trigger execution of the step of saving the current cell style if the cell style delta file is not consistent with the current cell style.
Optionally, the system further comprises:
a dividing unit 411, configured to divide the target table into one or more areas according to a preset rule, where one area at least includes one cell;
a forming unit 412, configured to record the cell style of each of the regions, respectively, to form the table base style.
Optionally, when the dividing unit 411 divides the target table into one or more areas according to a preset rule, the dividing unit is specifically configured to:
dividing the target table into one or more blocks of areas according to the cell style similarity of the cells in the target table;
or the like, or, alternatively,
and dividing the target table into one or more blocks according to the received selection instruction of the cells in the target table.
Optionally, the system further comprises:
a receiving unit 403, configured to receive style selections of the table delta style file by other tables;
and the covering unit 413 is configured to select and read a table delta pattern in the table delta pattern file to cover the table pattern of the other table according to the pattern.
Optionally, the system further comprises:
a presentation unit 414, configured to present the table delta pattern file in the other table in a form of a selectable table pattern.
The operation performed in this embodiment is similar to the operation performed in the embodiment of fig. 2, and is not described again here.
The form style processing method of the embodiment can form a new form basic style for previewing and selecting other forms besides realizing a lightweight storage scheme, further realizes form style copying between cross forms, further modifies the form style into a new form style on the basis of copying the form style, and is convenient and fast.
One embodiment of a computer device of the present application is described below with reference to fig. 5, which includes:
the computer device 500 may include one or more Central Processing Units (CPUs) 501 and a memory 502, where the memory 502 stores one or more applications or data. Memory 502 may be volatile storage or persistent storage, among others. The program stored in the memory 502 may include one or more modules, each of which may include a series of instruction operations for a computer device. Still further, the central processor 501 may be arranged in communication with the memory 502 to execute a series of instruction operations in the memory 502 on the computer device 500. The central processing unit 501 may perform the operations in the embodiments shown in fig. 1 or fig. 2, which are not described herein again.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and the like.
Claims (11)
1. A form style processing method, comprising:
acquiring a target table;
determining a table base style corresponding to the target table;
receiving cell style setting of the target table to form a table target style;
calculating the table differential quantity style of the table basic style and the table target style to form a table differential quantity style file;
storing the table delta style file in association with the target table.
2. The form style processing method of claim 1, wherein after storing the form delta style file in association with the target form, the method further comprises:
receiving an opening instruction of the target table;
and jointly reading the target table, the table differential style file stored in association with the target table and the table base style corresponding to the target table according to the opening instruction, and covering and displaying the table differential style in the table differential style file on the table base style displayed by the target table.
3. The form style processing method of claim 2, wherein a form delta style overlay in the form delta style file is presented after the form base style of the target form presentation, the method further comprising:
receiving new cell style setting of the target table to form a new table target style;
calculating a new table differential style of the table basic style and the new table target style to form a new table differential style file;
treating the new table delta pattern file as a table delta pattern file;
triggering execution of the step of storing the table delta pattern file in association with the target table.
4. The form style processing method of claim 1, wherein calculating the form delta style of the form base style and the form target style, and forming a form delta style file comprises:
traversing a current cell style of each cell in the target table and comparing the cell base style of the current cell in the table base style;
if the current cell style is not consistent with the cell basic style, the current cell style is stored to form a cell style differential file, the cell style of the current cell corresponding to the current cell style points to the cell style differential file formed by changing the cell basic style into the current cell style, and the plurality of cell style differential files form the table differential style file.
5. The form style processing method of claim 4, wherein after the current cell style is inconsistent with the cell base style, before saving the current cell style, the method further comprises:
judging whether a cell pattern delta file formed by other cells in the target table is consistent with the current cell pattern or not;
if the cell style differential file is consistent with the current cell style, changing the cell style of the current cell from the cell basic style to the cell style differential file;
and if the cell style differential file is not consistent with the current cell style, triggering to execute the step of storing the current cell style.
6. The form style processing method of claim 1, wherein before determining the form base style corresponding to the target form, the method further comprises:
dividing the target table into one or more areas according to a preset rule, wherein one area at least comprises one cell;
and respectively recording the cell style of each block of the area to form the table basic style.
7. The form style processing method of claim 6, wherein the dividing the target form into one or more regions according to the preset rule comprises:
dividing the target table into one or more blocks of areas according to the cell style similarity of the cells in the target table;
or the like, or, alternatively,
and dividing the target table into one or more blocks according to the received selection instruction of the cells in the target table.
8. The form style processing method of claim 1, wherein after forming the form delta style file, the method further comprises:
receiving a style selection of the table delta style file in other tables;
and selecting and reading the table differential style in the table differential style file to cover the table styles of the other tables according to the style.
9. The form style file processing method of claim 8, wherein prior to receiving a style selection of the form delta style file by another form, the method further comprises:
presenting the table delta style file in the other table in a selectable table style.
10. A form style processing system, comprising:
an acquisition unit configured to acquire a target table;
the determining unit is used for determining a table base style corresponding to the target table;
the receiving unit is used for receiving the cell style setting of the target table to form a table target style;
the calculation unit is used for calculating the table differential quantity styles of the table basic style and the table target style to form a table differential quantity style file;
and the association storage unit is used for associating and storing the table differential quantity pattern file with the target table.
11. A computer device, comprising:
a processor, a memory;
the processor, when executing a program stored in the memory, performs the method of any of claims 1 to 9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011210549.5A CN112347747B (en) | 2020-11-03 | 2020-11-03 | Form style processing method and related device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011210549.5A CN112347747B (en) | 2020-11-03 | 2020-11-03 | Form style processing method and related device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112347747A true CN112347747A (en) | 2021-02-09 |
| CN112347747B CN112347747B (en) | 2024-03-19 |
Family
ID=74356366
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011210549.5A Active CN112347747B (en) | 2020-11-03 | 2020-11-03 | Form style processing method and related device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112347747B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113688616A (en) * | 2021-10-27 | 2021-11-23 | 深圳市明源云科技有限公司 | Method, device and equipment for detecting chart report difference and storage medium |
| WO2022233311A1 (en) * | 2021-05-06 | 2022-11-10 | 北京字跳网络技术有限公司 | Display method and apparatus, and electronic device |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2006350863A (en) * | 2005-06-17 | 2006-12-28 | Nippon Telegr & Teleph Corp <Ntt> | Method, device, system, and program for presenting subject, and a recording medium with program stored thereon |
| US7526719B1 (en) * | 2005-03-21 | 2009-04-28 | Autodesk, Inc. | File format for table styles |
| US20100174743A1 (en) * | 2009-01-08 | 2010-07-08 | Yamaha Corporation | Information Processing Apparatus and Method |
| CN102480494A (en) * | 2010-11-23 | 2012-05-30 | 金蝶软件（中国）有限公司 | File updating method, device and system |
| US20130212116A1 (en) * | 2012-02-13 | 2013-08-15 | Post Pro Finance Co., Inc. | Metadata engine and repository |
| CN110096626A (en) * | 2019-03-18 | 2019-08-06 | 平安普惠企业管理有限公司 | Processing method, device, equipment and the storage medium of contract text data |
| CN110489732A (en) * | 2019-07-23 | 2019-11-22 | 中国平安人寿保险股份有限公司 | Method for processing report data and equipment |
| CN111062195A (en) * | 2019-12-13 | 2020-04-24 | 深圳我家云网络科技有限公司 | File processing method, file processing device, equipment and storage medium |
| CN111177144A (en) * | 2019-10-17 | 2020-05-19 | 腾讯科技（深圳）有限公司 | Table synchronization method, device, equipment, storage medium and system |
-
2020
- 2020-11-03 CN CN202011210549.5A patent/CN112347747B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7526719B1 (en) * | 2005-03-21 | 2009-04-28 | Autodesk, Inc. | File format for table styles |
| JP2006350863A (en) * | 2005-06-17 | 2006-12-28 | Nippon Telegr & Teleph Corp <Ntt> | Method, device, system, and program for presenting subject, and a recording medium with program stored thereon |
| US20100174743A1 (en) * | 2009-01-08 | 2010-07-08 | Yamaha Corporation | Information Processing Apparatus and Method |
| CN102480494A (en) * | 2010-11-23 | 2012-05-30 | 金蝶软件（中国）有限公司 | File updating method, device and system |
| US20130212116A1 (en) * | 2012-02-13 | 2013-08-15 | Post Pro Finance Co., Inc. | Metadata engine and repository |
| CN110096626A (en) * | 2019-03-18 | 2019-08-06 | 平安普惠企业管理有限公司 | Processing method, device, equipment and the storage medium of contract text data |
| CN110489732A (en) * | 2019-07-23 | 2019-11-22 | 中国平安人寿保险股份有限公司 | Method for processing report data and equipment |
| CN111177144A (en) * | 2019-10-17 | 2020-05-19 | 腾讯科技（深圳）有限公司 | Table synchronization method, device, equipment, storage medium and system |
| CN111062195A (en) * | 2019-12-13 | 2020-04-24 | 深圳我家云网络科技有限公司 | File processing method, file processing device, equipment and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| 王晓兵: "Excel之玩转单元格样式", 《电脑迷》, no. 8, pages 66 * |
| 边龙龙等: "利用表样式、单元格样式实现表格快速排版", 《广东印刷》, no. 1, pages 34 - 37 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2022233311A1 (en) * | 2021-05-06 | 2022-11-10 | 北京字跳网络技术有限公司 | Display method and apparatus, and electronic device |
| US12050615B2 (en) | 2021-05-06 | 2024-07-30 | Beijing Zitiao Network Technology Co., Ltd. | Presentation method, apparatus and electronic device |
| CN113688616A (en) * | 2021-10-27 | 2021-11-23 | 深圳市明源云科技有限公司 | Method, device and equipment for detecting chart report difference and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112347747B (en) | 2024-03-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7287234B2 (en) | Methods, systems and computer program products for use of color saturation to highlight items in a tree map visualization | |
| CN112347747A (en) | Form style processing method and related device | |
| US9024952B2 (en) | Discovering and configuring representations of data via an insight taxonomy | |
| US7734664B2 (en) | Database application including split views | |
| CN106886511B (en) | Network table processing method and device | |
| WO2011026739A1 (en) | Creating, updating, saving, and propagating customized views of table and grid information | |
| US20090282325A1 (en) | Sparklines in the grid | |
| KR20160025519A (en) | Selecting and editing visual elements with attribute groups | |
| US20210042976A1 (en) | Control method | |
| US9880086B2 (en) | Non-overlapping visualization of data records of a scatter plot | |
| CN110806866A (en) | Generation method and device of front-end management system | |
| CN113255302A (en) | Method for operating tissue architecture diagram, computer device and computer storage medium | |
| CN105512096B (en) | A kind of optimization method and device based on font embedded in document | |
| US20210326497A1 (en) | Systems and methods for automatically grouping design elements | |
| US7703028B2 (en) | Modifying the graphical display of data entities and relational database structures | |
| US11880539B1 (en) | Pop-up preview of table data | |
| US20230127373A1 (en) | Video processing method and apparatus, device and computer readable storage medium | |
| CN115935917A (en) | Data processing method, device and equipment for visual chart and storage medium | |
| CN113688150B (en) | Keyword searching method and device, electronic equipment and storage medium | |
| CN109783786A (en) | Input method, mobile terminal and the device with store function of financial affairs receipt | |
| CN112637633B (en) | Program generating method and program generating device | |
| CN114218443A (en) | Configuration method and equipment of trend analysis chart | |
| US20170091969A1 (en) | WHATIF ONE-PAGE MULTI-Y AXIS GRAPHING SYSTEM for automated optimization and sensitivity analysis | |
| DE112021001309T5 (en) | User interface for manipulating images | |
| JP2855827B2 (en) | Map search method |
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 |