Data standardization method, device, electronic device and storage medium for electronic documents

Abstract

The embodiment of the present invention discloses a data standardization method, device, electronic device and storage medium for an electronic document. The method includes determining a first area of ​​an electronic document; setting the display attribute of the first area to a first style; and displaying the data content input into the first area in the first style. The method can ensure that the data content of the first area of ​​the electronic document is displayed in the first style, standardize the data content of the electronic document, and display the data content of the first area in the same style, so as to facilitate the use of the data content for data calculation, data statistics, data standardization display, etc., thereby realizing accurate application processing of the data content.

Description

Technical Field

[0001] The present invention relates to but is not limited to the field of automated office, and in particular to a data standardization method, device, electronic device and storage medium for electronic documents. Background Art

[0002] Currently, electronic document applications are widely used. Users can not only use electronic document applications to process data content in electronic documents individually, but also use electronic document applications for multi-person collaboration to process data content in the same electronic document from different clients.

[0003] In the related art, when a user uses an electronic document application, the format of the data content that he or she inputs into the electronic document first may be inconsistent with the format of the data content that he or she inputs into the electronic document later; when multiple users collaborate to process the data content in the same electronic document, the probability of inconsistent formats of the above data content is even greater because each user has different data content processing habits. The data content in the electronic document is mostly used for data calculation, data statistics, etc., and inconsistent data content formats will affect the accuracy of subsequent data calculations and data statistics. Summary of the invention

[0004] In order to solve the above technical problems, the embodiments of the present invention provide a method, device, electronic device and storage medium for standardizing data of an electronic document, which can standardize the data content of an electronic document to facilitate accurate use of the data content.

[0005] Specifically, the present invention is achieved through the following technical solutions:

[0006] In a first aspect, a method for standardizing data of an electronic document is provided, comprising:

[0007] determining a first region of the electronic document;

[0008] Setting the display attribute of the first area to a first style;

[0009] The data content input into the first area is displayed in the first style.

[0010] Optionally, setting the display attribute of the first area to a first style includes:

[0011] The display attributes of the first area are set to a consistent display format.

[0012] Optionally, setting the display attribute of the first area to a consistent display format includes:

[0013] According to the display attribute of the first area, the data content input into the first area is displayed according to the display format corresponding to the display attribute.

[0014] Optionally, setting the display attribute of the first area to a consistent display format includes:

[0015] Setting a template file corresponding to the display format in the first area;

[0016] Input data content into the template file;

[0017] The data content is displayed according to the template file.

[0018] Optionally, the setting of the template file corresponding to the display layout in the first area includes:

[0019] Get the template file list;

[0020] Add the template file corresponding to the display version in the template file list to the first area.

[0021] Optionally, adding the template file corresponding to the display version in the template file list to the first area includes:

[0022] Add at least one template file in the template file list to the first area.

[0023] Optionally, each template file is synchronously set at each data content input position in the first area.

[0024] Optionally, the template files in the template file list are from a template file library; or are newly generated.

[0025] Optionally, the method further comprises:

[0026] The display attribute of the first area is set according to the data content inputted into the first area.

[0027] Optionally, setting the display attribute of the first area to a consistent display format includes:

[0028] According to the display attribute of the first area, the data content input into the first area is displayed according to the display layout and the display format of the data content corresponding to the display attribute.

[0029] Optionally, before inputting the data content into the template file, the method further includes:

[0030] Determining whether the display format of the data content is consistent with the display format of the template file;

[0031] If it is determined that the display layout of the data content is consistent with the display layout of the template file, the data content input step is executed; if it is determined that the display layout of the data content is inconsistent with the display layout of the template file, the data content input step is not executed.

[0032] In a second aspect, a data standardization device for an electronic document is provided, comprising:

[0033] A region determination module, used to determine a first region of the electronic document;

[0034] A data specification module, used to set the display attribute of the first area to a first style;

[0035] The data display module is used to display the data content input into the first area in the first style.

[0036] According to a third aspect, an electronic device is provided, comprising a memory and a processor, wherein the memory stores a computer program for data standardization, and the processor is configured to read and run the computer program for data standardization to execute any of the above-described methods for data standardization of electronic documents.

[0037] According to a fourth aspect, a computer-readable storage medium is provided, wherein a computer program is stored in the storage medium, wherein the computer program is configured to execute any of the above-mentioned electronic document data standardization methods when run.

[0038] The technical solution provided by the embodiment of the present invention determines the first area of ​​the electronic document, sets the display attribute of the first area to the first style, and then displays the data content input into the first area in the first style. In this way, it can ensure that the data content of the first area of ​​the electronic document is displayed in the first style, standardize the data content of the electronic document, and make the data content of the first area displayed in the same style, so as to facilitate the use of the data content for data calculation, data statistics, data standard display, etc., and thus realize accurate application processing of the data content.

[0039] Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention can be realized and obtained by the structures particularly pointed out in the description, claims and drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] The accompanying drawings are used to provide a further understanding of the technical solution of the present invention and constitute a part of the specification. Together with the embodiments of the present invention, they are used to explain the technical solution of the present invention and do not constitute a limitation on the technical solution of the present invention.

[0041] Figure 1 A flow chart of a data standardization method for an electronic document shown in an embodiment of the present invention;

[0042] Figure 2 A flow chart of another method for standardizing data of an electronic document according to an embodiment of the present invention;

[0043] Figure 3 This is a schematic diagram of an operation interface in an example of an embodiment of the present invention;

[0044] Figure 4 This is a schematic diagram of an operation interface in an example of an embodiment of the present invention;

[0045] Figure 5 This is a schematic diagram of an operation interface in an example of an embodiment of the present invention;

[0046] Figure 6 The present invention is a schematic diagram of the structure of a data standardization device for an electronic document according to an embodiment of the present invention. DETAILED DESCRIPTION

[0047] To make the purpose, technical solution and advantages of the present invention more clear, the embodiments of the present invention will be described in detail with reference to the accompanying drawings. It should be noted that the embodiments and features in the embodiments of the present invention can be combined with each other arbitrarily without conflict.

[0048] The steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions. Also, although a logical sequence is shown in the flowchart, in some cases, the steps shown or described can be performed in a sequence different from that shown here.

[0049] Before describing the embodiments of the present invention, several related concepts are first described:

[0050] Electronic documents refer to text materials formed by users in social activities, which are carried by chemical magnetic materials such as computer disks, magnetic disks and optical disks. They rely on computer systems for access and can be transmitted on communication networks. In the present invention, electronic documents include text documents, spreadsheet documents, presentation documents, and data collaboration documents. Among them, text documents refer to word processing applications, spreadsheet documents refer to electronic spreadsheet software, presentation documents refer to graphic presentation software, and data collaboration documents refer to a data management document with multiple display forms, which can be displayed in the form of a grid table or in the form of a view.

[0051] The embodiment of the present invention provides a method for standardizing data of an electronic document, the process of which is as follows: Figure 1 As shown, the following steps are included:

[0052] Step 101, determining a first area of ​​an electronic document;

[0053] Step 102, setting the display attribute of the first area to a first style;

[0054] Step 103: Display the data content input into the first area in a first style.

[0055] The embodiment of the present invention takes a data collaboration document as an example to describe the technical solution.

[0056] In an exemplary embodiment, the first area of ​​the electronic document is determined, that is, the first area of ​​the data collaboration document is determined. Wherein, in the case where the data collaboration document is displayed in the form of a grid table, the first area corresponds to one or more rows in the grid table; or, corresponds to one or more columns in the grid table. A grid table refers to a plurality of cells arranged in a table form. There are many ways to determine a data collaboration document. For example, the row or column corresponding to the cell selected by the user manipulating the mouse or the touch display screen can be used as the first area. Specifically, a selection instruction in the terminal interface is received, and the cell circled in the terminal interface selected by the selection instruction is determined, and the row or column containing the cell is used as the first area; another exemplary method is to generate a selection window for selecting an area in the terminal interface, and enter the row identifier (for example, 1, 2, 3-5) or column identifier (for example, A, B, CE) of the cell to be set as the first area in the selection window for selecting the area, and determine the row identifier or column identifier as the first area according to the input row identifier or column identifier. The area selection window refers to a window displayed in the terminal interface, which can be displayed in the form of a pop-up window on the upper layer of the data collaboration document. Further, the upper layer refers to a layer covering the data content in the data collaboration document.

[0057] In the case where the first area is a plurality of rows or columns, the plurality of rows or columns may be adjacent rows or columns, or may be alternately arranged rows or alternately arranged columns.

[0058] In an exemplary embodiment, step 102 includes: setting the display attribute of the first area to a first style.

[0059] The display attribute refers to the display characteristics of the data content in a certain area (such as the first area) of the electronic document. The first style refers to the display format of the data content in the electronic document.

[0060] It should be noted that the first style is a collection of data content display formats, for example,

[0061] The first style 1 includes:

[0062] Title 1, centered;

[0063] Title 2, left;

[0064] Main text, aligned left, 23 pt leading.

[0065] The first style 2 includes:

[0066] Title 1, left;

[0067] Main text, centered, first line indented 2 characters.

[0068] Each style includes the setting of the data content display format. The format included in each style is not limited to the aspects exemplified in this example. Based on the above examples, those skilled in the art can know other embodiments.

[0069] In an exemplary embodiment, step 103 includes: displaying the data content input into the first area in a first style. According to the setting of the first style for the first area, the data content input into the first area is displayed in the first style. That is, on the premise of setting the display layout of the first style for the first area, the data content is input into the first area. In this way, it is possible to ensure that the data content of the first area of ​​the electronic document is displayed in the first style, standardize the data content of the electronic document, and display the data content of the first area in the same style, so as to facilitate the use of the data content for data calculation, data statistics, data standard display, etc., thereby realizing accurate application processing of the data content.

[0070] The data specification refers to displaying the data contents belonging to the same display area in the same display format.

[0071] In an exemplary embodiment, setting the display attribute of the first area to the first style in step 102 includes:

[0072] Set the display properties of the first region to a consistent display layout.

[0073] Display layout refers to the display characteristics of data content. For example, data content is displayed in the style of a title, data content is displayed in the style of a text, etc. For a specific example, if the display attribute of the first area is set to the first style 1, then Title 1 in the first area is set to be displayed in the center, Title 2 in the first area is set to be displayed on the left, and the text in the first area is set to be displayed on the left with a line spacing of 23 points. For another specific example, if the display attribute of the first area is set to the first style 2, then Title 1 in the first area is set to be displayed on the left, and the text in the first area is set to be displayed in the center with the first line indented by 2 characters.

[0074] It can be seen that after executing step 103, the first area displays the data content in the first area according to the set first style. In an exemplary embodiment, the first area is one or more rows in the data collaboration document, and the data content of the one or more rows is displayed according to the same first style; in an exemplary embodiment, the first area is one or more columns in the data collaboration document, and the data content of the one or more columns is displayed according to the same first style.

[0075] In an exemplary embodiment, setting the display attribute of the first area to a consistent display format includes:

[0076] According to the display attribute of the first area, the data content input into the first area is displayed in a display format corresponding to the display attribute, that is, the data content of the first area is displayed in a fixed display format to standardize the display form of the data content in the electronic document.

[0077] Specifically, setting the display attribute of the first area to a consistent display format includes:

[0078] A template file corresponding to the display format is set in the first area;

[0079] Input data content into the template file;

[0080] Display data content according to the template file.

[0081] It can be seen that the display layout is set in the template file, and the template file is set in the first area of ​​the electronic document. When the user wants to enter data content, he clicks input, and the template file will be opened and displayed accordingly, so that the user can fill in the data content he needs to enter in the template file. The data content will be displayed in the set display layout. In this way, the data content in each cell of the first area is displayed in the form of a template file, that is, the file layout is added on the basis of the file content, so that the data content can be displayed in a standardized form, and is processed by the data standard applicable to multi-character data content such as articles and paragraphs.

[0082] Exemplarily, template file 1 defines: Title 1 is displayed in the center, Title 2 is displayed on the left, and the text is displayed on the left with a line spacing of 23 pounds. When the data content in the first area is recorded in template file 1, Title 1, Title 2, and the text of the data content will be identified, and Title 1 will be set to be displayed in the center, Title 2 will be set to be displayed on the left, and the text will be set to be displayed on the left with a line spacing of 23 pounds. The identification of the data content can be determined based on the number of words in each paragraph of the data content. For example, a paragraph with less than 15 words in the data content is determined as a title. According to the order of the text, the data content that is first determined as a title is designated as Title 1, and the data content that is secondly determined as a title is designated as Title 2. The paragraph with more than 2 lines of data content is determined as the text.

[0083] Furthermore, in an exemplary embodiment, setting the display attribute of the first area to a consistent display format includes:

[0084] According to the display attribute of the first area, the data content input into the first area is displayed according to the display layout and display format of the data content corresponding to the display attribute. That is, the data content of the first area is displayed according to a fixed display layout and display format to standardize the display form of the data content in the electronic document. The display format of the data content refers to the font, font size and other characteristics of the data content.

[0085] In an exemplary embodiment, a template file corresponding to the display layout is set in the first area, including:

[0086] Get the template file list;

[0087] Add the template file corresponding to the display version in the template file list to the first area.

[0088] Specifically, a template file list is displayed in the first area of ​​the electronic document, and the user can select a corresponding template file that he wants to set in the first area from the template file list, select the template file, and add the template file to the first area.

[0089] When the template file is added to the first area, each cell in the first area will display the data content input by the user in the template format, that is, the input data content is managed in the format of the template file.

[0090] The template files in the template file list may include template files selected by the user in history, or may be randomly retrieved template files, which is not limited in the present invention. The template file list may be displayed in the first area in the form of a drop-down list, with each template file being a row, and each item being displayed in a corresponding layout.

[0091] Further, the template file corresponding to the display version in the template file list is added to the first area, including:

[0092] Add at least one template file in the template file list to the first area.

[0093] In an exemplary embodiment, determining the template corresponding to the first style from the selectable template file list includes: selecting at least one template file from the template file list as the template file corresponding to the first style. That is, the first area can be set to one or more display layouts.

[0094] In an exemplary embodiment, setting the first area to multiple display layouts may include: selecting multiple template files from the template file list at one time to determine multiple template files corresponding to the first style; and may also include: selecting each template file from the template file list multiple times.

[0095] Furthermore, each template file is synchronously set at each data content data location in the first area. Synchronous setting means that the user completes the display layout setting of all cells in the first area at one time. Specifically, the user selects the first area, right-clicks the mouse or double-clicks the touch display screen, and selects the template file layout, then all cells in the first area are set to the display layout of the template file.

[0096] For example, the first area is a row in a data collaboration document, and each cell is a sub-area; setting a row to the first style includes: setting each cell in the row to the determined template file at one time, that is, each cell in the row can be set to the same determined template file in batches through one setting.

[0097] The template file may be in the form of a pop-up dialog box, a drop-down menu, or an attachment.

[0098] In an exemplary embodiment, when the template file is an attachment, the display attribute of the first area is set to the first style in step 102. For example, the template file is an attachment "Briefing Book.docx". Step 102 is executed to set the first area as the attachment "Briefing Book.docx". In an exemplary embodiment, the first area is a column in a data collaboration document, and step 102 is executed to set each cell in the column as the attachment "Briefing Book.docx" at a time.

[0099] The attachments can be files of multiple types. When the template file is set to include multiple files, the corresponding attachments can be files of the same type or files of different types. For example, two attachments are set in one row, and both attachments can be text documents; or one can be a text document and the other can be a table document.

[0100] In an exemplary embodiment, after the first area is set as an attachment, the attachments in each sub-area can be opened separately, and the data content can be edited and saved after receiving it. It can be seen that the data content editing based on the attachment can make each sub-area in the first area not only standardized in terms of data content according to the attachment requirements, but also standardized in terms of layout according to the attachment requirements. In this way, it can be achieved that the first area can meet the specifications in terms of data content and layout. After executing step 102 for setting, the data content of the first area will be able to be uniformly displayed according to the layout defined by the attachment. At this time, the data content of the first area is the content of the attachment file.

[0101] In an exemplary embodiment, after the first area is set as an attachment, the attachments in each sub-area can be saved after editing the file name. It can be seen that although the file name of the attachment is changed, the layout defined in the attachment is not changed, and each sub-area in the first area can still display the content according to the unified layout of the attachment. The modification of the attachment file name does not affect the display effect of the data content in the first area.

[0102] In an exemplary embodiment, when the template file is a pop-up dialog box, the first area is set as the same pop-up dialog box in step 102. The pop-up dialog box displays the content that needs to be standardized. For example, taking the "briefing book" as an example, the pop-up dialog box samples a determined format at a determined position and displays the "invention name", "background technology" and other contents. Execute step 102 to set the first area as a pop-up dialog box - "briefing book dialog box". In an exemplary embodiment, the first area is a column in a table, and execute step 102 to set each cell in the column as the "briefing book dialog box" at one time.

[0103] It should be noted that after the first area is set as a pop-up dialog box, the pop-up dialog box in each sub-area can be opened separately, and the data content can be edited and saved. It can be seen that the data content editing according to the pop-up dialog box can enable each sub-area in the first area to be standardized in terms of data content according to the requirements of the pop-up dialog box, and to maintain the specifications in terms of layout. In this way, it can be achieved that the first area can meet the specifications in terms of data content and layout. After executing step 102 for setting, the data content of the first area will be able to be uniformly displayed according to the layout of the pop-up dialog box. In this case, the data content of the first area is the information contained in the pop-up dialog box.

[0104] In an exemplary embodiment, when the template is a drop-down box, the first area is set to the same drop-down box in step 102. The drop-down box displays the content that needs to be standardized. For example, taking "education level" as an example, the drop-down box samples and determines the layout, and displays "high school", "undergraduate", "master's degree" and other content. Execute step 102 to set the first area as a drop-down box - "education level drop-down box". In an exemplary embodiment, the first area is a column in a table, and execute step 102 to set each cell in the column to the "education level drop-down box" at a time.

[0105] In an exemplary embodiment, there are two template files, each of which is a drop-down box. In step 102, the first area is set as two drop-down boxes.

[0106] It should be noted that after the first area is set as a drop-down box, the drop-down boxes in each sub-area can be opened separately and saved after receiving the selection. It can be seen that the content editing according to the drop-down box can make each sub-area in the first area not only standardize the data content according to the requirements of the drop-down box, but also maintain the standard in the layout. In this way, it can be achieved that the first area can meet the specifications in terms of data content and layout. After executing step 102 for setting, the data content of the first area will be able to be uniformly displayed according to the layout of the drop-down box. At this time, the content of the first area is the option selected by the drop-down box.

[0107] In an exemplary embodiment, the template files in the template file list are from the template file library; or are newly generated. That is, the template files can be existing template files that have been previously generated and stored in the template file library; or they can be template files that meet personalized needs set by users according to work and life needs.

[0108] In an exemplary embodiment, when the template file is a newly created template, setting the first area to the same template file in step 102 includes:

[0109] According to the display layout of the template file to be generated, open the corresponding template file generation interface, set the display layout style in the template file generation interface, and then generate a new template file, save the new template file, then obtain the new template file, and set the new template file in the first area.

[0110] The display forms of the template file include: display in a pop-up dialog box, display in a drop-down box, display in an attachment, etc.

[0111] In an exemplary embodiment, the data standardization method of an electronic document provided by the present invention further includes: setting a display attribute of the first area according to the data content input into the first area.

[0112] Specifically, when the data content in the first area is not empty, based on the content of one or more sub-areas in the first area, a recommended first style can be determined to standardize the data content in the first area. For example, the first area is a column in a data collaboration document, including multiple cells, each of which records the name, gender, date of birth, household registration address, ID number, issuing authority and validity period, but the order of records in each cell may be different. Based on the data content in the cell, the relevant subsystem or component determines that it belongs to the resident ID card information, and recommends a template file similar to the display format of the physical ID card information, and automatically or after receiving user confirmation, the data content in the cells of this column is uniformly set to the recommended template file. That is, the data content in each cell of the column will be uniformly displayed in a display format similar to the physical ID card information.

[0113] Among them, the first style or template file is recommended according to the content in the first area. Those skilled in the art may select relevant technical solutions, which are not within the scope of limitation or protection of the embodiments of the present invention. For example, an AI intelligent recommendation solution may be used.

[0114] In an exemplary embodiment, setting the display attribute of the first area to the first style in step 102 further includes: setting the data content of the first area to the same display format.

[0115] The display format is used to define the display format of the data content, and different content data corresponds to different display formats. In an exemplary embodiment, the display format also includes date, currency, time, percentage, etc. The date can also be divided into different display formats, for example: date display format 1: YYYYMMDD, date display format 2: DD-MM-YYYY, etc. Currency can also be divided into multiple different display formats, for example: currency display format 1: ￥xxxxx.xx yuan, currency display format 2: €xx.xx yuan, etc.

[0116] It can be seen that executing step 102 also includes setting the first area to the same display format, that is, setting the content in the area to be standardized to be displayed according to the format specified in the same display format.

[0117] In one exemplary embodiment, the first region includes one or more sub-regions;

[0118] Setting the first area to have the same display format includes: setting the determined display format once for each of the one or more sub-areas.

[0119] For example, the first area is a column in a data collaboration document, the column includes multiple cells, and the format class is set to: date display format 1. Step 102 can also be performed to set the contents of multiple cells in the column to date display format 1 (YYYYMMDD) at one time. It can be seen that performing this step can standardize the data in the cells of the column in batches, so that the first area in the data collaboration document can be displayed and saved according to a unified specification after being set, effectively improving the standardization of the data.

[0120] For other display formats, those skilled in the art may know the corresponding implementation processes based on the above examples, which will not be described one by one here.

[0121] Among them, the relevant information of the data type setting is packaged and saved with the data collaboration document, which is not limited to a specific method, and those skilled in the art can implement it according to the relevant technical solutions.

[0122] It can be seen that according to the solution provided by an embodiment of the present invention, the setting area (first area) in the data collaboration document can be set to a unified data type. According to the set unified data type, the layout and / or format of the content that has been entered or to be entered in the setting area is standardized, thereby ensuring the standardization of the input content and display layout\format in the data collaboration document and significantly improving the collaboration efficiency.

[0123] Furthermore, before inputting the data content into the template file, the data standardization method of the electronic document provided by the present invention further includes:

[0124] Determine whether the display format of the data content is consistent with the display format of the template file;

[0125] If the display layout of the data content is determined to be consistent with the display layout of the template file, the data content step is executed; if the display layout of the data content is determined to be inconsistent with the display layout of the template file, the data content step is not executed. In this way, the display layout of the displayed data content can be strictly controlled to ensure the standardization of the data content.

[0126] The embodiment of the present invention also provides a data standardization method for an electronic document, such as Figure 2 As shown, in this embodiment, the electronic document is a data collaboration document, and the method includes:

[0127] Step 201, determining a first area of ​​a data collaboration document;

[0128] Step 202, obtaining a template file corresponding to the first area;

[0129] Step 203: Set the first area to a display style corresponding to the same template file.

[0130] In an exemplary embodiment, obtaining the template file corresponding to the first area includes: determining one or more template files from a corresponding template file list.

[0131] In an exemplary embodiment, the method further includes: Step 200, setting a template list of the first area.

[0132] The step of setting the first area to a display style corresponding to the same template file includes: setting the content in the first area to be displayed according to a style set in the same template file.

[0133] In an exemplary embodiment, the first area includes one or more sub-areas, and in step 203, all the sub-areas included in the first area are set at once to the display style corresponding to the same template file.

[0134] In an exemplary embodiment, the template file is an attachment, and the same attachment can be generated in each sub-area of ​​the first area at one time in step 203. These attachments can be further edited independently, and different data contents can be written, but the layout type remains unchanged. In an exemplary embodiment, the attachment file name can also be further modified independently, but its layout type remains unchanged. In an exemplary embodiment, the template file is an attachment, and the template list in step 200 corresponds to the attachment list.

[0135] Other steps that are the same or similar to the above-mentioned embodiments are not described in detail here, and those skilled in the art can know them by referring to the above-mentioned embodiments.

[0136] It should be noted that the template file set in the first area can be selected from a range limited by a preset template file list, can be selected from all available template files, and can also be selected after creating a new template.

[0137] It can be seen that according to the solution provided by the embodiment of the present invention, when the data type is defined by an attachment, the same attachment can be generated at one time for multiple sub-areas included in the first area. When the first area only includes one sub-area, an attachment is generated for this sub-area. Based on the generated attachment, the next step of content editing is performed, which can effectively improve the data standardization of the data collaboration document. After the same attachment is set in the first area, different collaborative users only need to edit the content according to the set attachment. Compared with the solution in the related art, in which each collaborative user submits their own attachment, it can avoid the problem of non-standard or incorrect attachments chosen by different users, and can more effectively ensure that the attachments finally included in the data collaboration document are more standardized.

[0138] Example

[0139] This example provides a data standard method for an electronic document. The electronic document in this example is a spreadsheet document, and its interface is as follows: Figure 3 As shown, the data standardization method includes:

[0140] Step 301, determining that the first area is the cells in the fifth column;

[0141] Step 302, select the attachment "Company Unified Briefing Document Template" from the optional attachment list;

[0142] Step 303, set the cell in the fifth column as the attachment "Company Unified Briefing Document Template".

[0143] After step 303 is completed, the result is as follows Figure 4 As shown. You can further open the attachment "Company Unified Briefing Book Template" in any cell in the 5th column and edit the content according to the content and format of the attachment. When you open the attachment later, it will also be displayed after loading the content according to the "Company Unified Briefing Book Template". In this way, the attachment in the cell of the 5th column is a standardized attachment file, and its content and format are standardized.

[0144] Alternatively, data normalization methods include:

[0145] Step 401, determining that the first area is the fifth column;

[0146] Step 402, select the attachment "Related Technology List" from the optional attachment list;

[0147] Step 403, set all cells in the fifth column as the attachment "Related Technology List".

[0148] After step 403 is completed, the result is similar to Figure 4 As shown, only the attachment icon has changed. You can further open the attachment "Related Technology List" in the cells of each row of the 5th column and edit the content according to the content and format of the attachment. When you open each attachment later, it will also be displayed after loading the content according to the "Related Technology List". In this way, the attachments in all cells of the 5th column are standard attachment files, and their content and format are all standardized.

[0149] The optional attachment list (attachment file list) in steps 302 and 402 is determined in the following manner: a list of optional templates (attachment file list) in the first region is set. Figure 5 As shown, determine the first area, display a pop-up dialog box, set the property information of the first area, including the column name, the type is attachment, and select an existing attachment to add to the optional attachment list (attachment file list).

[0150] It can be seen that according to the data standard scheme of the electronic document in this example, the same style is reflected as the same attachment template file; the first area is set to the same first style, that is, each sub-area in the first area is set to the attachment file corresponding to the attachment template. Based on this attachment, the content of each attachment file is further edited and displayed, which can ensure the standardization of input content and display format.

[0151] The embodiment of the present invention also provides a data standardization device for electronic documents, the structure of which is as follows: Figure 6 As shown, including:

[0152] The region determination module 601 is used to determine a first region of the electronic document;

[0153] A data specification module 602, configured to set the display attribute of the first region to a first style;

[0154] The data display module 603 is used to display the data content input into the first area in a first style.

[0155] The embodiment of the present invention takes a data collaboration document as an example to describe the technical solution.

[0156] In an exemplary embodiment, the first area of ​​the electronic document is determined, that is, the first area of ​​the data collaboration document is determined. Wherein, when the data collaboration document is displayed in the form of a grid table, the first area corresponds to one or more rows in the grid table; or, corresponds to one or more columns in the grid table. Wherein, when the first area is multiple rows or multiple columns, the multiple rows or multiple columns may be adjacent multiple rows or multiple columns, or may be multiple rows or multiple columns arranged at intervals.

[0157] In an exemplary embodiment, the data specification module 602 is specifically used to set the display attribute of the first area to a first style. It should be noted that the first style is a collection of data content display formats.

[0158] In an exemplary embodiment, the data specification module 602 is also specifically used to display the data content input into the first area in the first style according to the setting of the first style for the first area. That is, the data content is input into the first area on the premise of setting the display layout of the first style for the first area. In this way, it can ensure that the data content of the first area of ​​the electronic document is displayed in the first style, standardize the data content of the electronic document, and make the data content of the first area displayed in the same style, so as to facilitate the use of the data content for data calculation, data statistics, data standard display, etc., thereby realizing accurate application processing of the data content.

[0159] In an exemplary embodiment, the data specification module 602 is specifically used to set a template file corresponding to the display format in the first area; input the data content into the template file; and display the data content according to the template file.

[0160] In an exemplary embodiment, the data specification module 602 is specifically used to obtain a template file list; and add the template file corresponding to the display version in the template file list to the first area.

[0161] In an exemplary embodiment, the data specification module 602 is further specifically configured to add at least one template file in the template file list to the first area.

[0162] In an exemplary embodiment, the data specification module 602 is also specifically used to synchronize the settings of each template file at each data content input position in the first area. Synchronous setting means that the user completes the display layout setting of all cells in the first area at one time. For example, the user selects the first area, right-clicks the mouse or double-clicks the touch display screen, and selects the template file layout, then all cells in the first area are set to the display layout of the template file.

[0163] The template files in the template file list are from the template file library, or are newly generated. That is, the template files can be existing template files that have been previously generated and stored in the template file library, or they can be template files that meet personalized needs set by users according to work and life needs.

[0164] In an exemplary embodiment, the data specification module 602 is further used to display the data content input into the first area according to the display layout and display format of the data content corresponding to the display attribute according to the display attribute of the first area. That is, the data content of the first area is displayed according to a fixed display layout and display format to standardize the display form of the data content in the electronic document. The display format of the data content refers to the font, font size and other characteristics of the data content; or the display format of the data content also includes date, currency, time, percentage and the like.

[0165] In an exemplary embodiment, the data specification module 602 is further specifically used to set the display attribute of the first area according to the data content input in the first area. When the data content in the first area is not empty, a recommended first style can be determined according to the content of one or more sub-areas in the first area to uniformly standardize the data content in the first area.

[0166] In an exemplary embodiment, the data specification module 602 is further used to determine whether the display format of the data content is consistent with the display format of the template file;

[0167] When it is determined that the display layout of the data content is consistent with the display layout of the template file, the data content input step is executed; when it is determined that the display layout of the data content is inconsistent with the display layout of the template file, the data content input step is not executed.

[0168] An embodiment of the present invention also provides an electronic device, including a memory and a processor, wherein the memory stores a computer program for data standardization, and the processor is configured to read and run the computer program for data standardization of electronic documents to execute the data standardization method for electronic documents described in any of the above embodiments.

[0169] An embodiment of the present invention further provides a computer-readable storage medium, in which a computer program is stored, wherein the computer program is configured to execute the data standardization method for an electronic document described in any of the above embodiments when running.

[0170] It can be seen that according to the data standardization scheme described above in this example, the same data type is reflected as the same attachment template; the first area is set to the same data type, that is, each sub-area in the first area is set as an attachment corresponding to the attachment template. Based on this attachment, the content of each attachment file is further edited and displayed, which can ensure the standardization of input content and display format.

[0171] It will be appreciated by those skilled in the art that all or some of the steps, systems, and functional modules / units in the methods disclosed above may be implemented as software, firmware, hardware, and appropriate combinations thereof. In hardware implementations, the division between the functional modules / units mentioned in the above description does not necessarily correspond to the division of physical components; for example, a physical component may have multiple functions, or a function or step may be performed by several physical components in cooperation. Some or all components may be implemented as software executed by a processor, such as a digital signal processor or a microprocessor, or implemented as hardware, or implemented as an integrated circuit, such as an application-specific integrated circuit. Such software may be distributed on a computer-readable medium, which may include a computer storage medium (or non-transitory medium) and a communication medium (or temporary medium). As known to those skilled in the art, the term computer storage medium includes volatile and non-volatile, removable and non-removable media implemented in any method or technology for storing information (such as computer-readable instructions, data structures, program modules, or other data). Computer storage media include, but are not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, digital versatile disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tapes, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to store the desired information and can be accessed by a computer. In addition, it is well known to those of ordinary skill in the art that communication media typically contain computer-readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave or other transport mechanism, and may include any information delivery media.

Claims

1. A data standardization method for an electronic document, characterized in that: include: Determine a first area of ​​the electronic document; wherein the first area includes: a cell, a row, multiple rows, a column or multiple columns; Setting the display attribute of the first area to a first style includes: setting a template file corresponding to the display layout in the first area; The data content input into the first area is displayed in the first style, including: when the user needs to input data in the first area, the data content input into the template file after the user opens the template file set for the first area is displayed in the display format corresponding to the template file.

2. The method according to claim 1, characterized in that The step of setting the display attribute of the first area to a first style includes: The display attributes of the first area are set to a consistent display format.

3. The method according to claim 2, characterized in that The step of setting the display attribute of the first area to a consistent display format includes: According to the display attribute of the first area, the data content input into the first area is displayed according to the display format corresponding to the display attribute.

4. The method according to claim 1, characterized in that The step of setting a template file corresponding to the display layout in the first area includes: Get the template file list; Add the template file corresponding to the display layout in the template file list to the first area.

5. The method according to claim 4, characterized in that The step of adding the template file corresponding to the display layout in the template file list to the first area includes: Add at least one template file in the template file list to the first area.

6. The method according to any one of claims 1 to 5, characterized in that: Each template file is synchronously set at each data content input position in the first area.

7. The method according to claim 5, characterized in that The template files in the template file list are from a template file library; or are newly generated.

8. The method according to claim 1, characterized in that The method further comprises: The display attribute of the first area is set according to the data content inputted into the first area.

9. The method according to claim 2, characterized in that: The step of setting the display attribute of the first area to a consistent display format includes: According to the display attribute of the first area, the data content input into the first area is displayed according to the display layout and the display format of the data content corresponding to the display attribute.

10. The method according to claim 1, characterized in that Before inputting the data content into the template file, the method further includes: Determining whether the display format of the data content is consistent with the display format of the template file; If it is determined that the display layout of the data content is consistent with the display layout of the template file, the data content input step is executed; if it is determined that the display layout of the data content is inconsistent with the display layout of the template file, the data content input step is not executed.

11. A data standardization device for an electronic document, characterized in that: include: An area determination module, used to determine a first area of ​​the electronic document; wherein the first area includes: a cell, a row, multiple rows, a column or multiple columns; A data specification module, used to set the display attribute of the first area to a first style, including: setting a template file corresponding to the display format in the first area; The data display module is used to display the data content input into the first area in the first style, including: when the user needs to input data in the first area, the data content input in the template file after the user opens the template file set for the first area is displayed in the display format corresponding to the template file.

12. An electronic device comprising a memory and a processor, characterized in that: The memory stores a computer program for data standardization, and the processor is configured to read and run the computer program for data standardization to execute the data standardization method for electronic documents as described in any one of claims 1 to 10.

13. A computer-readable storage medium, characterized in that: The storage medium stores a computer program, wherein the computer program is configured to execute the electronic document data standardization method described in any one of claims 1 to 10 when running.

Images