A data content display method and device, electronic equipment, and storage medium

Abstract

The application relates to the technical field of automation office technology and discloses a data content display method of a data collaboration document, which comprises the following steps: receiving a display condition of data content; wherein the data content comprises a plurality of data entries; grouping the data entries of the data content according to the display condition; and displaying the data content in the form of a plurality of groups. In this way, the whole data content of the data collaboration document can be displayed in groups, and meanwhile, part of the data content of the data collaboration document can be operated and processed in the same display interface. The user can conveniently check and edit the whole data content, and conveniently operate and process part of the data content, so that the work efficiency of the operation and processing of part of the data content is improved, and the user experience is improved. The application further discloses a data content display device of a data collaboration document, an electronic equipment and a storage medium.

Description

Technical Field

[0001] This application relates to the field of automated office technology, such as a data content display method and device, electronic device, and storage medium. Background Technology

[0002] Currently, data collaboration documents can be used to store, edit, and display data content. The data content in a data collaboration document can be displayed in the form of a grid table or a view. Depending on the usage requirements, users typically only manipulate a portion of the data content in the data collaboration document, such as sorting or editing only data content with the same characteristics.

[0003] In related technologies, the steps for processing partial data content in a collaborative data document are as follows: the user needs to delete / hide other data content, keeping only the part to be processed, and repeat the deletion / hiding of other data content until only the part to be processed is kept. Therefore, processing partial data content is cumbersome and redundant, resulting in low work efficiency and poor user experience. Summary of the Invention

[0004] To provide a basic understanding of some aspects of the disclosed embodiments, a brief summary is given below. This summary is not intended as a general commentary, nor is it intended to identify key / important components or describe the scope of protection of these embodiments, but rather as a prelude to the detailed description that follows.

[0005] This disclosure provides a method, apparatus, electronic device, and storage medium for displaying data content in a data collaboration document. This allows for sorting and other operations on a portion of the data content of the data collaboration document as an independent whole without deleting or hiding the data content, thereby improving the processing efficiency of that portion.

[0006] In some embodiments, the present invention provides a method for displaying data content in a data collaboration document, comprising: receiving display conditions for the data content; wherein the data content includes multiple data entries; grouping the data entries of the data content according to the display conditions; and displaying the data content in the form of multiple groups.

[0007] In some embodiments, grouping the data entries of the data content according to the display conditions includes: determining the matching result between the data entries and the display conditions; and grouping the data entries with matching results into the same group according to the matching result.

[0008] In some embodiments, dividing data entries that match the matching result into the same group according to the matching result includes: setting a group label for the data entry when the data entry matches the display conditions; and placing the data entries belonging to the same group label in the same display area of ​​the data collaboration document.

[0009] In some embodiments, determining the matching result between the data entry and the display conditions includes: determining a first data dimension and display attribute information of the display conditions; obtaining first attribute information of the data entry; comparing the first attribute information with the display attribute information, and determining the matching result between the data entry and the display conditions as a match if the first attribute information is included in the display attribute information.

[0010] In some embodiments, comparing the first attribute information with the display attribute information, and determining the matching result of the data entry and the display condition as a match when the first attribute information is included in the display attribute information, includes: comparing the first attribute information and the display attribute information using a comparison function to obtain a comparison result; and determining that the data entry corresponding to the first attribute information matches the display condition corresponding to the display attribute information when the comparison result indicates that the data category of the first attribute information belongs to the data category of the display attribute information.

[0011] In some embodiments, comparing the first attribute information with the display attribute information, and determining the matching result of the data entry and the display condition as a match when the first attribute information is included in the display attribute information, includes: performing regular expression matching on the first attribute information and the display attribute information to obtain a regular expression matching result; and determining that the data entry corresponding to the first attribute information matches the display condition corresponding to the display attribute information when the regular expression matching result indicates that the data category of the first attribute information belongs to the data category of the display attribute information.

[0012] In some embodiments, before comparing the first attribute information with the displayed attribute information, the method further includes: using a natural language model to perform unified information expression processing on the first attribute information.

[0013] In some embodiments, after displaying the data content in multiple groups, the method further includes performing at least one operation on the data content of at least one display area: filtering, sorting, calculating, freezing, or hiding.

[0014] In some embodiments, after displaying the data content in multiple groups, the method further includes: when editing the data content of the same group, the first attribute information of the data entry maintains a correspondence with the display attribute information corresponding to the group.

[0015] In some embodiments, after displaying the data content in the form of multiple groups, the method further includes: when adding a new group to the data collaboration document, the attribute period of the new group is assigned to the attribute period of the existing group.

[0016] In some embodiments, the present invention also provides a data content display device for a data collaboration document, comprising: a receiving module configured to receive display conditions for the data content; wherein the data content includes multiple data entries; a grouping module configured to group the data entries of the data content according to the display conditions; and a display module configured to display the data content in the form of multiple groups.

[0017] In some embodiments, the present invention also provides an electronic device including a processor and a memory storing program instructions, the processor being configured to execute, when running the program instructions, the data content display method for a data collaboration document as described above.

[0018] In some embodiments, the present invention also provides a storage medium storing program instructions that, when executed, perform the data content display method for data collaboration documents as described above.

[0019] This disclosure provides a method, apparatus, electronic device, and storage medium for displaying data content in a collaborative data document. The method for displaying data content in a collaborative data document provides the following technical effects: by receiving display conditions for the data content, and then grouping the data entries according to the display conditions; the data content in the collaborative data document is then displayed in multiple groups. This divides the data content of the collaborative data document into multiple independent parts, meaning that the data content between groups is independent and does not affect each other. Operations on one part of the data content do not interfere with the data content of other parts. This allows users to view all the data content of the collaborative data document, and also to operate on a portion of the data content within the same display interface. This facilitates users in viewing and editing all the data content, as well as in operating on a portion of the data content, improving the efficiency of operating on a portion of the data content and thus enhancing the user experience.

[0020] The above general description and the description below are exemplary and illustrative only and are not intended to limit this application. Attached Figure Description

[0021] One or more embodiments are illustrated by way of example with reference to the accompanying drawings. These illustrations and drawings do not constitute a limitation on the embodiments. Elements having the same reference numerals in the drawings are shown as similar elements. The drawings are not to be scaled. And wherein:

[0022] Figure 1 This is a schematic diagram of a data content display method for a data collaboration document provided in an embodiment of this disclosure;

[0023] Figure 2 This is an application illustration of displaying the data content of a data collaboration document in the form of multiple groups, according to an embodiment of this disclosure;

[0024] Figure 3 This is another application illustration of displaying the data content of a data collaboration document in the form of multiple groups according to an embodiment of this disclosure;

[0025] Figure 4 This is another application illustration of displaying the data content of a data collaboration document in the form of multiple groups according to an embodiment of this disclosure;

[0026] Figure 5 This is another application illustration of displaying the data content of a data collaboration document in the form of multiple groups according to an embodiment of this disclosure;

[0027] Figure 6 This is a timing diagram of a data content display method for a data collaboration document provided in an embodiment of this disclosure;

[0028] Figure 7 This is a schematic diagram of a data content display device for a data collaboration document provided in an embodiment of this disclosure;

[0029] Figure 8 This is a schematic diagram of the structure of an electronic device provided in an embodiment of this disclosure. Detailed Implementation

[0030] To provide a more detailed understanding of the features and technical content of the embodiments of this disclosure, the implementation of the embodiments of this disclosure will be described in detail below with reference to the accompanying drawings. The accompanying drawings are for illustrative purposes only and are not intended to limit the embodiments of this disclosure. In the following technical description, for ease of explanation, several details are used to provide a full understanding of the disclosed embodiments. However, one or more embodiments may still be implemented without these details. In other cases, well-known structures and devices may be simplified in their depiction to simplify the drawings.

[0031] The terms "first," "second," etc., used in the specification, claims, and accompanying drawings of this disclosure are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate for the embodiments of this disclosure described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover non-exclusive inclusion.

[0032] Unless otherwise stated, the term "multiple" means two or more.

[0033] In this embodiment of the disclosure, the character " / " indicates that the objects before and after it are in an "or" relationship. For example, A / B means: A or B.

[0034] The term "and / or" describes an association between objects, indicating that three relationships can exist. For example, A and / or B means: A or B, or A and B.

[0035] The term "correspondence" can refer to an association or binding relationship. The correspondence between A and B means that there is an association or binding relationship between A and B.

[0036] Furthermore, in one or more embodiments of this specification, a first direction and a second direction are used. The first direction can be horizontal, and the corresponding second direction can be vertical; or the first direction can be vertical, and the corresponding second direction can be horizontal. The horizontal direction refers to the direction parallel to the horizontal ground, based on the data content displayed on the client's display interface, with the user's eye able to recognize the display interface at eye level, and the display interface displaying the data content normally and accurately. The vertical direction refers to the direction perpendicular to the horizontal ground, based on the data content displayed on the client's display interface, with the user's eye able to recognize the display interface at eye level, and the display interface displaying the data content normally and accurately.

[0037] This application can be applied to data collaboration documents, and also to online spreadsheets, table software, and other similar applications. Data collaboration documents can be displayed in grid table format or view format, making them a type of data management document with multiple display formats. When the data content in a data collaboration document is displayed in grid table format, the data content is arranged in the cells constituting rows and / or in the cells constituting columns. For the data content displayed on the client's interface, based on a display interface that is visually recognizable to the user at eye level and that the interface displays the data content correctly and accurately, rows are areas composed of horizontal lines; columns are areas composed of vertical lines; and the tables formed by the intersection of rows and columns are the cells.

[0038] It should be noted that the execution subject of this embodiment of the invention can be an application running on a browser, and the application is a web application of the browser on the terminal.

[0039] Furthermore, the terminal devices involved in the embodiments of the present invention may include, but are not limited to, mobile phones, personal digital assistants (PDAs), wireless handheld devices, tablet computers, personal computers (PCs), PDAs (personal digital assistants), wearable devices (such as smart glasses, smartwatches, etc.).

[0040] Combination Figure 1 As shown in the embodiments of this disclosure, a method for displaying data content in a data collaboration document is provided, including:

[0041] Step S101: Receive display conditions for the data content; wherein, the data content includes multiple data entries;

[0042] Step S102: Group the data entries of the data content according to the display conditions;

[0043] Step S103: Display the data content in multiple groups.

[0044] Data collaboration documents contain multiple data entries. Users may only need to process a portion of the data in the document without deleting or hiding other data that doesn't require processing. This solution allows for sorting and editing only a portion of the data. This solution receives display conditions for the data content in the collaboration document and groups the data entries accordingly. Then, it displays all the data in the document as multiple groups, where the sum of the data in each group equals the total data content. This way, processing only a portion of the data in one group doesn't interfere with other parts of the document. Displaying the data in a collaboration document using this solution saves one step, eliminating the need for users to manually delete or hide unnecessary data. However, it still meets the user's need to process only a portion of the data in the collaboration document.

[0045] The data content display method for collaborative documents provided in this disclosure can divide the data content of a collaborative document into multiple independent parts. That is, the data content between groups is independent and does not affect each other; operations on one part of the data content do not interfere with the data content of other parts. This allows users to view all the data content of a collaborative document, and also to operate on a portion of the data content within the same display interface. This facilitates users in viewing and editing all the data content, as well as in operating on a portion of the data content, improving the efficiency of operating on specific parts of the data and thus enhancing the user experience.

[0046] In some embodiments, the data content is text, numbers, characters, letters, or images filled in at least one cell. A data entry can be the data content of each row in a data collaboration document, or it can be the data content of each column in a data collaboration document. For example, if a data collaboration document contains multiple rows and at least one column of data content, then each row of data content constitutes a data entry; or, if a data collaboration document contains multiple columns and at least one row of data content, then each column of data content constitutes a data entry. A data entry contains at least one data dimension, wherein the data content of each cell in a data entry corresponds to one data dimension.

[0047] In some embodiments, display conditions are elements that set the display format of data content in a data collaboration document. Display conditions include user-defined data dimensions and corresponding grouping types. For example, if a user wants to group data items belonging to the same month in a data collaboration document into the same area for display, they can set the data dimension to the time dimension and the grouping type to group by month. This allows for more granular grouping of data items according to the user-defined data dimensions and corresponding grouping types, enabling a more refined breakdown of the data content in the data collaboration document.

[0048] Displaying data content in multiple groups refers to dividing all data content in a data collaboration document into multiple groups.

[0049] Optionally, the data entries of the data content are grouped according to the display conditions, including: determining the matching results between the data entries and the display conditions; and grouping the data entries that match the matching results into the same group.

[0050] The matching results include cases where data entries match the display conditions, and cases where data entries do not match the display conditions. In the implementation of this invention, when the matching result is that a data entry matches the display conditions, the corresponding data entries are selected and grouped together. This allows data entries with similar properties to be displayed in the same independent area of ​​the data collaboration document, facilitating users' viewing and processing of the data content.

[0051] Optionally, determining the matching result between the data entry and the display conditions includes: determining the first data dimension and display attribute information of the display conditions; obtaining the first attribute information of the data entry; comparing the first attribute information with the display attribute information, and determining the matching result between the data entry and the display conditions as a match if the first attribute information is included in the display attribute information.

[0052] In some embodiments, the first data dimension of the display conditions is the data dimension set by the user. In response to a user's click of the grouping function button, the client displays an editing interface for the display conditions. The user sets the display conditions by selecting a data dimension in the data dimension selection area of ​​the editing interface and a grouping type in the grouping type selection area. Once the user has completed the selection of the data dimension, the corresponding grouping type options are displayed in the grouping type selection area.

[0053] Optionally, obtaining the first attribute information of a data entry includes: obtaining the data content in the cell corresponding to the first data dimension in the data entry, and determining the data content in the cell as the first attribute information of the data entry.

[0054] Optionally, determining the display attribute information of the display conditions includes: determining the display attribute information of the display conditions based on the first dimension information of the display conditions and the corresponding grouping type.

[0055] In some embodiments, the data dimension set by the user is a time dimension, and the corresponding grouping type includes one or more of the following: grouped by day, grouped by week, grouped by month, and grouped by year. For example, if the grouping type is grouped by week, the corresponding display attribute information is "2021.12.06~2021.12.12", "2021.12.13~2021.12.19", etc.; or, if the grouping type is grouped by month, the corresponding display attribute information is "2021.11.", "2021.12.", etc.

[0056] In some embodiments, the data dimension set by the user is the address information dimension, and the corresponding grouping type includes one or more of the following: grouping by province, grouping by prefecture-level city, grouping by region, and grouping by street. For example, if the grouping type is grouped by province, the corresponding display attribute information is "Beijing", "Guangdong", "Sichuan", etc.

[0057] In some embodiments, the data dimension set by the user is the ID card information dimension, and the corresponding grouping type includes one or more of the following: grouping by ID card number location, grouping by the birth year corresponding to the ID card number, etc. For example, if the grouping type is grouping by the birth year corresponding to the ID card number, the corresponding displayed attribute information will be "1999", "2000", etc.

[0058] In some embodiments, the data dimension set by the user is the name data dimension, and the corresponding grouping type includes one or more of the following: grouping by surname, grouping by the number of characters in the given name, etc. For example, if the grouping type is grouped by surname, the corresponding display attribute information will be "Zhao", "Qian", "Sun", "Li", etc.

[0059] In some embodiments, the data dimension set by the user is the email address data dimension, and the corresponding grouping type includes grouping by email domain. For example, if the grouping type is email domain grouping, that is, grouping emails with the same email domain together, the corresponding display attribute information will be "@wps", "@kingsoft", "@qq", etc.

[0060] The first attribute information is included in the display attribute information, that is, the data category of the first attribute information belongs to the data category of the display attribute information.

[0061] Optionally, based on the matching results, data entries that match are grouped into the same group, including: setting group labels for data entries when they match the display conditions; and placing data entries belonging to the same group label in the same display area of ​​the data collaboration document.

[0062] Using group labels to identify different groups makes it easier for users to distinguish the data items contained in each group, making the structure of the data content in the data collaboration document clearer. The same display area refers to multiple consecutive rows of data items identified by rows or columns in the data collaboration document. Consecutive row and column labels mean that row labels are equally spaced by numbers, with each adjacent label differing by 1. For example, four rows labeled 1, 2, 3, and 4 constitute the same display area. Consecutive column labels mean that column labels are equally spaced by letters, with adjacent labels represented by corresponding letters of the alphabet. For example, four columns labeled B, C, D, and E constitute the same display area.

[0063] This enables the grouping and display of data content. When the data content contains data items with multiple grouping characteristics, it can group and display data items with different grouping characteristics, making it easier to group and display data content. In this way, when users want to group and display data items with different grouping characteristics, they do not need to perform multiple filtering operations through the filtering function, simplifying the grouping and display operation.

[0064] Optionally, when a data entry matches the display conditions, group labels are set for the data entry, including: determining the display attribute information as the group label for the data entry that matches the display conditions.

[0065] Optionally, after grouping the matching data entries into the same group based on the matching results, the method further includes setting a group label for the data entries in each group.

[0066] Optionally, group labels are set for each group of data entries, including: using the display attribute information corresponding to the same group of data entries as the group labels for that group of data entries.

[0067] For data entries in the same group, the continuous interval from the position of the first data entry to the position of the last data entry constitutes the same display area. Displaying data content in multiple groups means displaying the grouped data entries in different display areas.

[0068] Optionally, comparing the first attribute information with the display attribute information, and determining the matching result of the data entry and the display condition as a match when the first attribute information is included in the display attribute information, includes: comparing the first attribute information and the display attribute information using a comparison function to obtain a comparison result; and determining that the data entry corresponding to the first attribute information matches the display condition corresponding to the display attribute information when the comparison result indicates that the data category of the first attribute information belongs to the data category of the display attribute information. In this way, using a comparison function to determine the inclusion relationship between the first attribute information and the display attribute information can more accurately determine whether the data entry matches the display condition, thereby improving the accuracy of grouping data entries.

[0069] In some embodiments, if the comparison result indicates that the data scope of the first attribute information does not belong to the data scope of the display attribute information, it is determined that the first attribute information and the display attribute information do not match.

[0070] In some embodiments, the comparison dimensions of the comparison function include year, month, day, etc.; the comparison dimensions of the comparison function are set according to the data dimensions set by the user and the corresponding grouping type. For example, if the user sets the data dimension to a time dimension and the grouping type to monthly grouping, then the comparison dimension of the comparison function is year and month. For example, if the user sets the grouping type to weekly grouping, the weekday function is used to judge the first attribute information of the first data dimension in the data entries; the time of each week can be customized, for example, only Monday to Friday can be taken.

[0071] Optionally, comparing the first attribute information with the display attribute information, and determining the matching result of the data entry and the display condition as a match when the first attribute information is contained within the display attribute information, includes: performing regular expression matching on the first attribute information and the display attribute information to obtain a regular expression matching result; and determining that the data entry corresponding to the first attribute information matches the display condition corresponding to the display attribute information when the regular expression matching result indicates that the data category of the first attribute information belongs to the data category of the display attribute information. Thus, using regular expression matching to determine the inclusion relationship between the first attribute information and the display attribute information can more accurately determine whether the data entry matches the display condition, thereby improving the accuracy of grouping data entries.

[0072] In some embodiments, if the regular expression matching result indicates that the data category of the first attribute information does not belong to the data category of the display attribute information, it is determined that the data entry corresponding to the first attribute information does not match the display conditions corresponding to the display attribute information.

[0073] Optionally, the first attribute information and the display attribute information are matched using regular expressions to obtain the regular expression matching result, including: performing a search operation on the display attribute information in the first attribute information; if the display attribute information is found in the first attribute information, then the data scope of the first attribute information is determined to belong to the data scope of the display attribute information; if the display attribute information is not found in the first attribute information, then the data scope of the first attribute information is determined not to belong to the data scope of the display attribute information.

[0074] For example, if the user sets the data dimension to address information and the grouping type to be grouped by prefecture-level city, the corresponding display attribute information would be Beijing, Shanghai, Chongqing, etc. A regular expression is used to match the first attribute information in the cell corresponding to the address information dimension of the data entry with the display attribute information. If "Beijing" is matched in the first attribute information of the data entry, then the first attribute information of that data entry is determined to match the display attribute information, meaning that the data entry matches the display condition.

[0075] Optionally, before comparing the first attribute information and the display attribute information, the method further includes: using a natural language model to perform unified information representation processing on the first attribute information of each data entry. This facilitates a more accurate acquisition of the inclusion relationship between the first attribute information and the display attribute information, thereby improving the accuracy of grouping data content.

[0076] In some embodiments, the natural language model is an NLP (Natural Language Processing) model. By inputting the first attribute information corresponding to the first data dimension in the data entries into the NLP model, a unified information representation processing of the first attribute information corresponding to the first data dimension in the data entries is achieved. In some embodiments, the description or format of the first attribute information in different data entries is inconsistent. For example, the first data dimension is the address information dimension. In some data entries, the first attribute information in the cell corresponding to the address information dimension is "street office," while in other data entries, the first attribute information in the cell corresponding to the address information dimension is "street office." Through unified information representation processing using the NLP model, the first attribute information of all data entries is "street office."

[0077] Optionally, based on the display conditions, the data entries of the data content are grouped, including: inputting the first attribute information of the data entries into a grouping model for classification processing to classify the data entries of the data content; wherein, the grouping model is determined based on the data dimensions and corresponding grouping types set by the user. In this way, using a classification model to determine the classification of data entries in the data content allows for faster classification of the data entries.

[0078] Optionally, the grouping model is determined based on the data dimensions and corresponding grouping types set by the user, including: obtaining training data samples and sample labels based on the data dimensions and corresponding grouping types set by the user; and training the clustering model using the training data samples and sample labels to obtain a classification model.

[0079] Optionally, the editing interface for displaying conditions may also include a display order selection area.

[0080] Optionally, the display conditions may also include the display order of the data content in each group. For example, the data content can be set to be displayed in ascending or descending order of time. This way, displaying the grouped data content in the user-defined display order makes it easier for users to view.

[0081] Combination Figure 2 As shown, in some embodiments, the data collaboration document is an online form. Figure 2The online table shown contains multiple data entries, each including data dimensions such as the request name, project team, email address information, and final draft date; it accepts user-defined display conditions, such as... Figure 2 As shown, the user-defined data dimension is the final draft date, the user-defined grouping type is grouped by day, and the user-defined display order is sorted in ascending order by time. Therefore, the corresponding display attribute information is "2021 / 2 / 25", "2021 / 3 / 6", and "2021 / 3 / 21". In this data content, all data is grouped by the final draft date by day, and then each group is sorted in ascending order by time before being displayed, resulting in the following: Figure 2 The data shown is grouped by day according to the final draft date. The group labels for the data items displayed in order are "2021 / 2 / 25", "2021 / 3 / 6", "2021 / 3 / 21", etc.

[0082] In some embodiments, when the user-defined grouping condition is a time dimension, the grouping type selection area includes a "skip public holidays" selection area. When the user sets the option to skip public holidays, the corresponding display attribute information will exclude public holidays. For example, when grouping by week, the data entries are not grouped by natural weeks, but rather by the working week weeks after removing public holidays.

[0083] Combination Figure 3 As shown, in some embodiments, Figure 3 The online form shown contains multiple data entries, each including data dimensions such as feedback questions, multiple options, and final draft date. It accepts user-defined display conditions, such as... Figure 3 As shown, the user-defined data dimension is the final draft date, the user-defined grouping type is weekly grouping with skipping statutory holidays, and the user-defined display order is ascending time sorting. Since October 1st-7th are statutory holidays, October 8th-9th constitutes a working week, and the corresponding display attribute information is "10.8-10.9", "10.11-10.15", "10.18-10.22", and "10.25-10.29". Therefore, all data items in this data content are grouped according to the user-defined display conditions, and data items in the same group are placed in the same area of ​​the data collaboration document, resulting in the following... Figure 3 The data content is displayed in groups as shown; the data entries corresponding to each working week are displayed in groups in sequence, that is, the group labels of each group of data entries are "10.8-10.9", "10.11-10.15", "10.18-10.22", "10.25-10.29", etc.

[0084] In some embodiments, the display conditions set by the user include at least two data dimensions and corresponding grouping types for the data dimensions. The first and second data dimensions of the display conditions, the first display attribute information corresponding to the first data dimension, and the second display attribute information corresponding to the second data dimension are determined. The first and second attribute information of the data entries are obtained. The first attribute information is compared with the first display attribute information; if the first attribute information is contained within the first display attribute information, the data entries corresponding to the first attribute information are grouped into the same group, i.e., displayed in the same first display area. For each data entry in the first display area, the following steps are performed: the second attribute information of the data entries in the first display area is compared with the second display attribute information; if the second attribute information is contained within the second display attribute information, the data entries corresponding to the second attribute information are grouped into the same group, i.e., displayed in the same second display area. The second display area is set within the first display area. The first attribute information is the information in the cell corresponding to the first data dimension in the data entry. The second attribute information is the information in the cell corresponding to the second data dimension in the data entry. In this way, multi-dimensional grouping of multiple columns of data content enables more granular segmentation of the data content of data collaboration documents.

[0085] Combination Figure 4 As shown, in some embodiments, Figure 4 The online table shown is a data table of the Chinese and Mathematics scores of all students in Class A. The data contains multiple data entries, each including data dimensions such as name, subject, and score. It accepts user-defined display conditions, such as... Figure 4 As shown, the user-defined first data dimension is the subject data dimension, and the second data dimension is the exam score data dimension. The corresponding grouping type is first grouped by subject, and then grouped by the corresponding grade of the exam score. The first display attribute information corresponding to the first data dimension is "Chinese" and "Mathematics", and the second display attribute information corresponding to the second data dimension is "Excellent", "Pass", "Fail", etc. Among them, the grade corresponding to the exam score below 60 is "Fail"; the grade corresponding to the exam score between 60 and 70 is "Pass"; and the grade corresponding to the exam score between 71 and 100 is "Excellent". The first attribute information in the cell corresponding to the subject in each data entry is compared with the first display attribute information. If the first attribute information is contained within the first display attribute information, the data entry corresponding to the first attribute information is grouped into the same group, that is, displayed in the same first display area, such as... Figure 4The first display area 401 and the first display area 402 are defined. The following operations are performed on the first display areas 401 and 402 respectively: The second attribute information in the cell corresponding to the exam score of the data entry in the first display area is compared with the second display attribute information. If the second attribute information is contained within the second display attribute information, the data entry corresponding to that second attribute information is grouped into the same group, i.e., placed in the same second display area. For example... Figure 4 The system includes second display areas 4011, 4012, and 4013 within the first display area 401, and second display areas 4021 and 4022 within the first display area 402. It also displays grouping labels for each data group. The first grouping label for the first display area is "Chinese" and "Mathematics," while the second grouping labels for the second display areas are "Excellent," "Pass," and "Fail." This process first groups the data by subject (e.g., Chinese, Mathematics), then further groups the data items within each group according to exam scores (Excellent, Pass, Fail), and finally displays the data content across multiple groups. This division into multiple independent parts ensures that the data content within each group is independent and does not affect other groups. Operations on one part of the data can be performed without interfering with other parts. This allows users to view all the data in a collaborative document and also to manipulate specific portions of the data within the same display interface. This facilitates both viewing and editing the entire data content and manipulating specific data, improving efficiency and ultimately enhancing the user experience.

[0086] Optionally, after displaying the data content in multiple groups, the method further includes at least one of the following operations: filtering, sorting, calculating, freezing, and hiding the data content in at least one display area.

[0087] By grouping and displaying data content within a collaborative document, with each group's data content being independent and unaffected by others, operations such as filtering, sorting, calculating, freezing, or hiding the data content in the first group (any group within the collaborative document) can be easily performed. This allows for manipulation of a portion of the collaborative document's data on a single display interface without impacting other data, improving efficiency for handling specific data and ultimately enhancing the user experience.

[0088] If the data content is displayed in multiple groups, and the data content in one of the display areas is sorted in ascending order by time, then only the data content in that display area will be sorted in ascending order by time, and the data content in other display areas will not be affected.

[0089] Optionally, after displaying the data content in multiple groups, the method further includes ensuring that, when editing the data content of the same group, the first attribute information of the data entry maintains a correspondence with the display attribute information of that group. For example, if the first data dimension of a data entry is date, then the corresponding first attribute information can only be generated within the date range of the corresponding display attribute information; dates within other ranges are either not displayed or automatically adjusted to other groups.

[0090] Optionally, after displaying the data content in multiple groups, the method further includes: when adding a new group to the data collaboration document; the attribute period of the new group is assigned to the attribute period of the existing group.

[0091] Here, "after" refers to the period following the longest attribute period of the data collaboration document. Taking dates as an example, the longest attribute period refers to the time period closest to the end of the current year.

[0092] In some embodiments, when the data dimension set by the user is time and the data is grouped by week, the client displays an editing area for newly added groups. For example, for data displayed in weekly groups, if the last attribute period in the existing group's attribute period is "10.25-10.29", the attribute period for the newly added group set by the user will be displayed after the attribute period of the existing group, and the attribute period of the newly added group will be "11.1-11.5".

[0093] Combination Figure 5 As shown, in some embodiments, the data collaboration document displays data content in the form of a view, which can be a project view, a catalog view, or a dashboard view. For example, the data collaboration document displays data content in the form of a project view, where the data content contains multiple data entries, and each data entry is a display card. Data entries include multiple data dimensions such as project group type and processing progress; project group types include text projects, table projects, etc., and processing progress includes "processing," "developing," "testing," and "completed." Upon receiving the display conditions set by the user, the first data dimension set by the user is project type, and the second data dimension is processing progress. The corresponding grouping type is first grouped by project type, then by processing progress. The first display attribute information corresponding to the first data dimension is "text" and "table"; the second display attribute information corresponding to the second data dimension is "processing," "developing," "testing," and "completed." The first attribute information of the project type in each data entry is compared with the first display attribute information. If the first attribute information is included within the first display attribute information, the data entries corresponding to that first attribute information are grouped into the same group, i.e., displayed in the same first display area, such as... Figure 5The first display area 501 and the first display area 502 are defined. The following operations are performed on the first display area 501 and the first display area 502 respectively: The second attribute information of the processing progress of data entries within the first display area is compared with the second display attribute information. If the second attribute information is included within the second display attribute information, the data entries corresponding to the second attribute information are grouped together, i.e., deployed in the same second display area. For example... Figure 5 In the first display area 501, there is a second display area 5011; in the first display area 502, there are second display areas 5021 and 5022. The group label for the first display area 501 is "Text"; the group label for the second display area 5011 is "Pending Processing"; the group label for the first display area 502 is "Table"; the group label for the second display area 5021 is "Under Development"; and the group label for the second display area 5022 is "Completed".

[0094] In some embodiments, such as Figure 6 As shown in the embodiments of this disclosure, a method for displaying data content in a data collaboration document is provided, including:

[0095] Step S601: The client receives the display conditions for the data content;

[0096] Step S602: The client sends the display conditions to the server;

[0097] Step S603: The server determines the data entries that match the display conditions based on the display conditions sent by the receiving client.

[0098] Step S604: If the data item matches the display conditions, the server sets group labels for the data item;

[0099] Step S605: The server groups data entries belonging to the same group label into the same group;

[0100] Step S606: The server sends the grouped data entries to the client;

[0101] Step S607: The client receives the grouped data entries sent by the server and displays the data entries in the same group in the same display area;

[0102] This allows for the grouping and display of all data content in a collaborative document. Furthermore, when data entries include attribute information with multiple grouping characteristics, the system can group and display attribute information with different grouping characteristics, facilitating user viewing and editing of all data content, as well as enabling users to manipulate and process partial data content. This improves the efficiency of processing partial data content and ultimately enhances the user experience.

[0103] Combination Figure 7 As shown in the figure, this disclosure provides a data content display device for a data collaboration document, including: a receiving module 701, a grouping module 702, and a display module 703. The receiving module 701 is configured to receive display conditions for the data content; wherein, the data content includes multiple data entries; the grouping module 702 is configured to group the data entries of the data content according to the display conditions; and the display module 703 is configured to display the data content in the form of multiple groups.

[0104] The data content display device for collaborative documents provided in this disclosure receives display conditions for the data content and then groups the data items according to these conditions; subsequently, the data content in the collaborative document is displayed in multiple groups. This divides the data content of the collaborative document into multiple independent parts, meaning the data content between groups is independent and does not affect each other. Operations on one part of the data content do not interfere with other parts. This allows users to view all the data content of the collaborative document and also to operate on a portion of the data content on the same display interface. This facilitates users in viewing and editing all the data content, as well as in operating on a portion of the data content, improving the efficiency of operating on specific parts of the data content and thus enhancing the user experience.

[0105] Optionally, the grouping module is configured to group data entries of the data content according to display conditions by: determining the matching result between the data entries and the display conditions; and dividing the data entries with matching results into the same group according to the matching result.

[0106] Optionally, the grouping module is configured to group matching data entries into the same group based on the matching results in the following ways: when a data entry matches the display conditions, a grouping label is set for the data entry; and data entries belonging to the same grouping label are arranged in the same display area of ​​the data collaboration document.

[0107] Optionally, the grouping module is configured to determine the matching result between the data entry and the display conditions by: determining the first data dimension and display attribute information of the display conditions; obtaining the first attribute information corresponding to the first data dimension in the data entry; comparing the first attribute information with the display attribute information, and determining the matching result between the data entry and the display conditions as a match if the first attribute information is included in the display attribute information.

[0108] Optionally, the grouping module is configured to compare the first attribute information with the display attribute information in the following manner: if the first attribute information is included in the display attribute information, the matching result of the data entry and the display condition is determined to be a match: the first attribute information and the display attribute information are compared using a comparison function to obtain a comparison result; if the comparison result indicates that the data range of the first attribute information belongs to the data range of the display attribute information, the data entry corresponding to the first attribute information is determined to match the display condition corresponding to the display attribute information.

[0109] Optionally, the grouping module is configured to compare the first attribute information with the display attribute information in the following manner: if the first attribute information is included in the display attribute information, determine that the matching result of the data entry and the display condition is a match: perform regular expression matching on the first attribute information and the display attribute information to obtain a regular expression matching result; if the regular expression matching result indicates that the data category of the first attribute information belongs to the data category of the display attribute information, determine that the data entry corresponding to the first attribute information matches the display condition corresponding to the display attribute information.

[0110] Optionally, the data content display device for the data collaboration document further includes: an information expression unified processing module, configured to use a natural language model to perform unified information expression processing on the first attribute information corresponding to the data dimension in each data entry.

[0111] Optionally, the data content display device for data collaboration documents further includes: an operation processing module configured to perform at least one of the following operations on the data content of at least one display area: filtering, sorting, calculating, freezing, and hiding.

[0112] Optionally, the data content display device for the data collaboration document further includes an editing module configured to maintain a correspondence between the first attribute information of the data entry and the display attribute information corresponding to the group when editing the data content of the same group.

[0113] Optionally, the data content display device for the data collaboration document further includes: a new group module, configured to, when a new group is added to the data collaboration document, divide the attribute period of the new group after the attribute period of the existing group.

[0114] Combination Figure 8As shown, this disclosure provides an electronic device including a processor 800 and a memory 801 storing program instructions. Optionally, the electronic device may further include a communication interface 802 and a bus 803. The processor 800, communication interface 802, and memory 801 can communicate with each other via the bus 803. The communication interface 802 can be used for information transmission. The processor 800 can call logical instructions in the memory 801 to execute the data content display method of the data collaboration document described in the above embodiment.

[0115] Furthermore, the program instructions in the aforementioned memory 801 can be implemented as software functional units and, when sold or used as independent products, can be stored in a computer-readable storage medium.

[0116] The memory 801, as a computer-readable storage medium, can be used to store software programs and computer-executable programs, such as program instructions / modules corresponding to the methods in the embodiments of this disclosure. The processor 800 executes functional applications and data processing by running the program instructions / modules stored in the memory 801, thereby implementing the data content display method for data collaboration documents in the above embodiments.

[0117] The memory 801 may include a program storage area and a data storage area. The program storage area may store the operating system and application programs required for at least one function; the data storage area may store data created based on the use of the terminal device. Furthermore, the memory 801 may include high-speed random access memory and may also include non-volatile memory.

[0118] Optionally, electronic devices include computers, servers, etc.

[0119] This disclosure provides a storage medium in which program instructions, when executed, perform the data content display method for data collaboration documents as described above.

[0120] This disclosure provides a computer program product, which includes a computer program stored on a computer-readable storage medium. The computer program includes program instructions, which, when executed by a computer, cause the computer to perform the aforementioned data content display method for data collaboration documents.

[0121] The aforementioned computer-readable storage medium may be a transient computer-readable storage medium or a non-transitory computer-readable storage medium.

[0122] The technical solutions of this disclosure can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes one or more instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the method described in this disclosure. The aforementioned storage medium can be a non-transitory storage medium, including: a USB flash drive, a portable hard drive, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk, and other media capable of storing program code; it can also be a transient storage medium.

[0123] The foregoing description and accompanying drawings fully illustrate embodiments of this disclosure to enable those skilled in the art to practice them. Other embodiments may include structural, logical, electrical, procedural, and other changes. The embodiments represent only possible variations. Individual components and functions are optional unless explicitly required, and the order of operation may vary. Parts and features of some embodiments may be included in or replace parts and features of other embodiments. Moreover, the terminology used in this application is for describing embodiments only and is not intended to limit the claims. As used in the description of embodiments and claims, the singular forms “a,” “an,” and “the” are intended to equally include the plural forms unless the context clearly indicates otherwise. Similarly, the term “and / or” as used in this application means including one or more of the associated listed items and all possible combinations thereof. Additionally, when used in this application, the term "comprise" and its variations "comprises" and / or "comprising" refer to the presence of stated features, integrals, steps, operations, elements, and / or components, but do not exclude the presence or addition of one or more other features, integrals, steps, operations, elements, components, and / or groups thereof. Without further limitations, an element defined by the phrase "comprises a..." does not exclude the presence of other identical elements in the process, method, or apparatus that includes said element. In this document, each embodiment may focus on the differences from other embodiments, and similar or identical parts between embodiments can be referred to mutually. For methods, products, etc., disclosed in the embodiments, if they correspond to the method section disclosed in the embodiments, the relevant parts can be referred to the description of the method section.

[0124] Those skilled in the art will recognize that the units and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of the embodiments of this disclosure. Those skilled in the art will clearly understand that, for the sake of convenience and brevity, the specific working processes of the systems, devices, and units described above can be referred to the corresponding processes in the foregoing method embodiments, and will not be repeated here.

[0125] The methods and products (including but not limited to devices and equipment) disclosed in the embodiments herein can be implemented in other ways. For example, the device embodiments described above are merely illustrative. For instance, the division of units may be merely a logical functional division, and in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. In addition, the coupling or direct coupling or communication connection between the shown or discussed units may be through some interfaces, and the indirect coupling or communication connection between devices or units may be electrical, mechanical, or other forms. The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units, that is, they may be located in one place or distributed across multiple network units. Some or all of the units may be selected to implement this embodiment according to actual needs. Furthermore, the functional units in the embodiments of this disclosure may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

[0126] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to embodiments of this disclosure. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. In some alternative implementations, the functions marked in the blocks may occur in a different order than that shown in the drawings. For example, two consecutive blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. In the descriptions corresponding to the flowcharts and block diagrams in the accompanying drawings, the operations or steps corresponding to different blocks may also occur in a different order than disclosed in the description, and sometimes there is no specific order between different operations or steps. For example, two consecutive operations or steps may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. Each block in a block diagram and / or flowchart, and combinations of blocks in a block diagram and / or flowchart, can be implemented using a dedicated hardware-based system that performs the specified function or action, or using a combination of dedicated hardware and computer instructions.

Claims

1. A method for displaying data content in a collaborative data document, characterized in that, include: Receive display conditions for data content; wherein, the data content includes multiple data entries; Based on the display conditions, the data entries of the data content are grouped; The data content is displayed in multiple groups; The step of grouping data entries of the data content according to the display conditions includes: determining the first data dimension and display attribute information of the display conditions; obtaining the first attribute information of the data entries; comparing the first attribute information with the display attribute information, and determining the matching result of the data entries and the display conditions as a match when the first attribute information is included in the display attribute information; setting group labels for the data entries when the data entries match the display conditions; and dividing the data entries belonging to the same group label into the same display area of ​​the data collaboration document. The data collaboration document is displayed in the form of a grid table or in the form of a view. When the data content in the data collaboration document is displayed in the form of a grid table, the data content is arranged in the cells that make up the rows and / or in the cells that make up the columns.

2. The method according to claim 1, characterized in that, The step of comparing the first attribute information with the display attribute information, and determining the matching result of the data entry and the display condition as a match when the first attribute information is included in the display attribute information, includes: The first attribute information and the display attribute information are compared using a comparison function to obtain a comparison result; If the comparison result indicates that the data category of the first attribute information belongs to the data category of the display attribute information, then the data entry corresponding to the first attribute information is determined to match the display conditions corresponding to the display attribute information.

3. The method according to claim 1, characterized in that, The step of comparing the first attribute information with the display attribute information, and determining the matching result of the data entry and the display condition as a match when the first attribute information is included in the display attribute information, includes: The first attribute information and the display attribute information are matched using regular expressions to obtain the regular expression matching result. If the regular expression matching result indicates that the data category of the first attribute information belongs to the data category of the display attribute information, then the data entry corresponding to the first attribute information is determined to match the display condition corresponding to the display attribute information.

4. The method according to claim 1, characterized in that, Before comparing the first attribute information with the displayed attribute information, the method further includes: The first attribute information is processed using a natural language model for unified information representation.

5. The method according to any one of claims 2 to 4, characterized in that, After displaying the data content in multiple groups, the method further includes: Perform at least one of the following operations on the data content of at least one display area: filtering, sorting, calculating, freezing, or hiding.

6. The method according to claim 5, characterized in that, After displaying the data content in multiple groups, the method further includes: When editing the same set of data content, the first attribute information of the data entry maintains a correspondence with the display attribute information of the corresponding set.

7. The method according to claim 6, characterized in that, After displaying the data content in multiple groups, the method further includes: When a new group is added to a data collaboration document, the attribute period of the new group is assigned after the attribute period of the existing group.

8. A data content display device for collaborative data documents, characterized in that, include: The receiving module is configured to receive display conditions for data content; wherein the data content includes multiple data entries; The grouping module is configured to group the data entries of the data content according to the display conditions; The display module is configured to display the data content in multiple groups. The step of grouping data entries of the data content according to the display conditions includes: determining the first data dimension and display attribute information of the display conditions; obtaining the first attribute information of the data entries; comparing the first attribute information with the display attribute information, and determining the matching result of the data entries and the display conditions as a match when the first attribute information is included in the display attribute information; setting group labels for the data entries when the data entries match the display conditions; and dividing the data entries belonging to the same group label into the same display area of ​​the data collaboration document. The data collaboration document is displayed in the form of a grid table or in the form of a view. When the data content in the data collaboration document is displayed in the form of a grid table, the data content is arranged in the cells that make up the rows and / or in the cells that make up the columns.

9. An electronic device comprising a processor and a memory storing program instructions, characterized in that, The processor is configured to, when executing the program instructions, perform the data content display method for a data collaboration document as described in any one of claims 1 to 7.

10. A storage medium storing program instructions, characterized in that, When the program instructions are executed, they perform the data content display method for data collaboration documents as described in any one of claims 1 to 7.

Images