Table data presentation method, device, electronic device, and storage medium
The method and device convert selected table data into signboard, picture book, or Gantt chart views, addressing the lack of diverse presentation modes in existing database products and enhancing user experience.
Patent Information
- Application Number
- JP2023579421
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Priority Date
- 2021-10-27
- Filing Date
- 2022-10-27
- Publication Date
- 2025-11-05
- Estimated Expiration
- 2042-10-27
AI Technical Summary
Current database products lack the ability to convert specific areas of a table into a Gantt chart, picture book, or signboard, failing to meet user needs for diverse presentation modes.
A method and device that allows users to select table data on an original page, highlighting it and converting it into different presentation formats such as signboard, picture book, or Gantt chart views upon triggering specific conversion elements, enabling multiple presentation modes.
Enables users to present table data in various formats, meeting diverse user needs and enhancing user experience by allowing conversion to signboard, picture book, or Gantt chart views.
Smart Images

Figure 0007764508000002 
Figure 0007764508000003 
Figure 0007764508000004
Abstract
Description
[Technical Field]
[0001] [Cross-reference to related applications] This application claims priority to Chinese Application No. 202111257787.6 filed on October 27, 2021 (titled "Method, device, electronic device and storage medium for presenting table data") and incorporates all of the contents of that Chinese application by reference.
[0002] [Technical field] The present disclosure relates to the technical field of computer devices, and in particular to a table data presentation method, device, electronic device, and storage medium. [Background technology]
[0003] A relational database, or database table (also called a table), is a set of two-dimensional arrays used to represent and store relationships between data objects. A table is the basic structure that makes up a tablespace and is made up of sections. A table consists of vertical columns and horizontal rows. For example, in a table called authors, which holds information about authors, each column contains a particular type of information, such as "last name," for all authors, and each row contains all the information for a particular author, such as last name, first name, and address.
[0004] A particular database table typically has a predetermined number of columns, each identified by a column name, while the number of rows can vary dynamically over time. Rows are typically identifiable based on the data in one or more columns.
[0005] Currently, database products on the market mainly provide online tables and dimension tables, but there is no way to convert a certain area of a table into a Gantt chart, picture book, or signboard, which cannot meet the needs of users. Summary of the Invention
[0006] In order to solve or at least partially solve the above-mentioned technical problems, the present disclosure provides a table data presentation method, device, electronic device and storage medium that realize a variety of presentation modes for table data.
[0007] According to a first aspect, the disclosed embodiment comprises: In response to a selection operation of at least a part of table data on the original table page, highlighting the selected table data on the original table page; A method for presenting table data is provided, including presenting selected table data in a target table page in a target presentation manner associated with the target conversion element in response to a trigger operation on the target conversion element.
[0008] Preferably, the target conversion elements include at least a first target conversion element, a second target conversion element, and / or a third target conversion element; presenting the selected table data in a target presentation manner on a target table page in response to a trigger operation on the target conversion element, presenting the selected table data in a signage view on a target table page in response to a trigger operation on a first target transducer element; and / or and / or, in response to a trigger operation on a second target conversion element, presenting the selected table data in a picture book view on the target table page. In response to a trigger operation on a third target conversion element, presenting the selected table data in a Gantt chart view on a target table page.
[0009] Preferably, in response to a trigger operation on the first target conversion element, presenting the selected table data in a signboard view on a target table page includes: In response to a trigger operation on a first target conversion element, the selected table data is presented in a signboard view on the target table page based on a set signboard presentation method.
[0010] Preferably, the sign presentation method includes sorting the table data by corresponding identification information in a target column; Presenting the selected table data in a signboard view on a target table page based on a set signboard presentation manner, The method includes classifying the selected table data according to the corresponding identification information in the target column of data in different rows of the selected table data, and then presenting the selected table data in a signboard view.
[0011] Preferably, in response to a trigger operation on the second target conversion element, presenting the selected table data in a picture book view on the target table page includes: In response to a trigger operation on a second target conversion element, the selected table data is presented in a picture book view on the target table page based on the set picture book presentation method.
[0012] Preferably, the picture book presentation method includes presenting corresponding identification information in a preset number of target columns in table data; Presenting the selected table data in a picture book view on a target table page based on a set picture book presentation method, The method includes obtaining target table data corresponding to a preset number of target columns corresponding to different rows of the selected table data, and presenting the selected target table data in a picture book view corresponding to the different rows on a target table page.
[0013] Preferably, in response to a trigger operation on the third target conversion element, presenting the selected table data in a Gantt chart view on a target table page includes: In response to a trigger operation on a third target conversion element, the selected table data is presented in a Gantt chart view on the target table page based on the set Gantt chart presentation method.
[0014] Preferably, the Gantt chart presentation method includes presenting the event information corresponding to different rows of the table data in a time axis manner; Presenting the selected table data in a Gantt chart view on a target table page based on a set Gantt chart presentation method; This includes obtaining corresponding event information in different rows of the selected table data, and displaying the event information corresponding to the rows on a time axis corresponding to the different rows for the selected table data in the target table page.
[0015] Preferably, the method further comprises: presenting a target signage view in a card format in response to a trigger operation on the target signage view of the target table page; or In response to a trigger operation on a target picture book view of a target table page, presenting the target picture book view in a card format; or In response to a trigger operation on event information corresponding to a target Gantt chart view of a target table page, the target Gantt chart view is presented in a card format.
[0016] Preferably, the method further comprises: Responsive to a trigger operation on a preset position on the card page, the content of the preset position is corrected and / or deleted.
[0017] Preferably, correcting and / or deleting content at the preset position in response to a trigger operation on the preset position of the card page includes: Responsive to a trigger operation on a first type area at a preset position on the card page, the method includes correcting the content of the first type area.
[0018] Preferably, correcting and / or deleting content at the preset position in response to a trigger operation on the preset position of the card page includes: In response to a trigger operation on a second type area at a preset position on the card page, the content of the second type area is corrected or deleted.
[0019] Preferably, the method further comprises: In response to a trigger operation on the setting element, correcting the set presentation style in the target table page.
[0020] According to a second aspect, the disclosed embodiment comprises: a table data selection module for highlighting the selected table data on the original table page in response to a selection operation of at least a part of the table data on the original table page; a presentation module for presenting the selected table data in a target table page in a target presentation manner associated with the target conversion element in response to a trigger operation on the target conversion element; We provide a table data presentation device.
[0021] According to a third aspect, the disclosed embodiment comprises: at least one processor; a memory for storing at least one program; The present invention also provides an electronic device that, when the at least one program is executed by the at least one processor, causes the at least one processor to implement any one of the methods described in the first aspect.
[0022] According to a fourth aspect, the disclosed embodiment comprises: A computer-readable storage medium having a computer program stored therein, the computer program implementing any one of the methods described in the first aspect when executed by a processor.
[0023] The technical solutions according to the embodiments of the present disclosure have the following advantages over the prior art.
[0024] The table data presentation method, device, electronic device, and computer-readable storage medium according to the disclosed embodiments highlight the selected table data on the original table page in response to a selection operation of at least a portion of the table data on the original table page, and present the selected table data on the target table page in a target presentation manner associated with the target conversion element in response to a trigger operation on the target conversion element, thereby allowing the user to present the table data of the target area on the original table page in the target presentation manner, and present the table data in different presentation manners in the table, thereby realizing a variety of presentation methods for table data and meeting different needs of users. [Brief explanation of the drawings]
[0025] The drawings herein are incorporated into this specification, illustrate embodiments consistent with the present disclosure, and together with the specification serve to explain the principles of the present disclosure.
[0026] In order to more clearly describe the technical solutions in the embodiments or prior art of the present disclosure, the following briefly introduces drawings necessary for describing the embodiments or prior art, and it is obvious to those skilled in the art that other drawings can be obtained based on these drawings without any creative efforts. [Figure 1] 1 is a flow diagram of a table data presentation method according to an embodiment of the present disclosure; [Figure 1A]FIG. 10 is a screen diagram showing table data according to an embodiment of the present disclosure. [Figure 1B] FIG. 10 is a screen diagram showing table data according to an embodiment of the present disclosure. [Figure 1C] FIG. 10 is a screen diagram showing table data according to an embodiment of the present disclosure. [Figure 1D] FIG. 10 is a screen diagram showing table data according to an embodiment of the present disclosure. [Figure 1E] FIG. 10 is a screen diagram showing table data according to an embodiment of the present disclosure. [Figure 2] 1 is a flow diagram of another table data presentation method according to an embodiment of the present disclosure; [Figure 2A] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 2B] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 2C] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 2D] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 3] 1 is a flow diagram of another table data presentation method according to an embodiment of the present disclosure; [Figure 3A] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 3B] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 3C] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 4] 1 is a flow diagram of another table data presentation method according to an embodiment of the present disclosure; [Figure 4A] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 4B] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 4C] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 5]1 is a flow diagram of another table data presentation method according to an embodiment of the present disclosure; [Figure 5A] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 5B] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 5C] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 6A] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 6B] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 6C] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 7A] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 7B] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 7C] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 8A] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 8B] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 8C] FIG. 10 is a screen diagram of another table data presentation according to an embodiment of the present disclosure. [Figure 9] 1 is a schematic diagram illustrating the configuration of a table data presentation device according to an embodiment of the present disclosure. [Figure 10] 1 is a schematic diagram illustrating the configuration of an electronic device according to an embodiment of the present disclosure. DETAILED DESCRIPTION OF THE INVENTION
[0027] In order to more clearly understand the above objects, features and advantages of the present disclosure, the embodiments of the present disclosure will be further described below. It should be noted that, unless there is a conflict, the embodiments and features in the embodiments of the present disclosure can be combined with each other.
[0028] In the following description, numerous specific details are set forth to provide a thorough understanding of the present disclosure, but the present disclosure may be embodied in other forms different from those described herein. It is apparent that the embodiments in the specification are merely some of the embodiments of the present disclosure, and not all of the embodiments.
[0029] For example, this disclosure provides a table data presentation method, device, electronic device, and storage medium. In a document table page application scenario, after selecting some table data in the document table page, based on a trigger operation on a target conversion element, the selected table data is presented in the target table page in a target presentation manner related to the target conversion element, so that the table data in the target area in the table is presented in the target presentation manner, thereby improving the user's experience of using the table.
[0030] The table data presentation method of the present disclosure is executed by an electronic device or an application, web page, official account, etc. in the electronic device. The electronic device may be a tablet, mobile phone, wearable, in-vehicle device, augmented reality (AR) / virtual reality (VR), laptop, ultra-mobile personal computer (UMPC), netbook, personal digital assistant (PDA), smart TV, smart screen, HD TV, 4K TV, smart speaker, smart projector, etc. The present disclosure does not limit the specific type of electronic device.
[0031] Here, the present disclosure does not limit the type of operating system of the electronic device, for example, Android system, Linux system, Windows system, iOS system, etc.
[0032] The following will illustrate the technical solutions of the present disclosure in detail through some specific examples.
[0033] 1 is a flow diagram of the table data presentation method according to the present disclosure. As shown in FIG. 1, the method of this embodiment is as follows:
[0034] In S10, in response to a selection operation of at least a part of the table data on the original table page, the selected table data is highlighted on the original table page.
[0035] Specifically, the original table page 100 is a table page created or opened by a user, and includes table data introduced or created by a user. As shown in FIG. 1A, the selected table data is 101. After a user selects at least a part of the table data 101 on the original table page 100, the selected table data 101 is displayed in a highlighted manner.
[0036] The user's selection operation means selecting at least a part of the table data on the original table page by clicking the left button of the mouse and moving the mouse.
[0037] The highlighting may be a display of selected table data 101 in a highlight color, a display of table data in a text box, or a display of selected table data by varying brightness. The embodiments of the present disclosure are not limited to a specific form of highlighting selected table data.
[0038] At S20, in response to a trigger operation on the target conversion element, the selected table data is presented in the target table page in a target presentation format associated with the target conversion element.
[0039] The target table page is the newly created page after the user triggers the target transformation element 103 .
[0040] When a user selects at least a part of the table data 101 on the original table page 100, the target conversion element 102 is triggered. At this time, the table data 101 selected by the user on the original table page 100 is presented on the target table page 103 in a target presentation manner.
[0041] Specifically, the target conversion element 102 includes at least a first target conversion element, a second target conversion element, and a third target conversion element. As shown in FIG. 1B, after a user triggers any one of the target conversion elements 102, the table data 101 selected by the user on the original table page is presented in a target presentation manner on the target table page 103. Specifically, FIGS. 1C to 1E each show a target presentation manner, and by presenting the table data selected on the target table page in the target presentation manner, a variety of table data presentation manners can be realized and different needs of users can be met.
[0042] An embodiment of the present disclosure provides a table data presentation method for highlighting the selected table data in the original table page in response to a selection operation of at least a portion of the table data in the original table page, and presenting the selected table data in the target table page in a target presentation manner associated with the target conversion component in response to a trigger operation of the target conversion component, thereby allowing a user to present the table data in the target area of the original table page in the target presentation manner and present the table data in different presentation manners in the table, thereby realizing a variety of table data presentation manners and meeting different needs of users.
[0043] 2 shows another table data presentation method according to an embodiment of the present disclosure. In addition to the above-mentioned embodiment, as shown in FIG. 2, the possible form of step S20 is: In response to a trigger operation on a first target conversion element, the selected table data is presented in a signboard view on the target table page (S21).
[0044] In Figures 1A and 1B, After a user selects at least a portion of table data 101 on the original table page 100, the target conversion element 102 is triggered to present the table data 101 selected by the user on the original table page 100 in a target presentation manner on the target table page 103. Specifically, the target conversion element 102 includes at least a first target conversion element 102A, a second target conversion element 102B, and a third target conversion element 102C. After the user triggers the first target conversion element 102A of the target conversion elements 102, the table data 101 selected in a signboard view is presented on the target table page 103, as shown in FIG. 2A. For example, a specific presentation manner for presenting the table data 101 selected in a signboard view is shown in FIG. 1C.
[0045] In FIG. 1C, each sign view corresponds to the table data for one row in the table.
[0046] In S22, in response to a trigger operation on the second target conversion element, the selected table data is presented in a picture book view on the target table page.
[0047] After the user triggers the second target conversion element 102B in the target conversion element 102, the table data selected in the picture book view is presented in the target table page, as shown in Fig. 2B. For example, a specific presentation manner of presenting the table data selected in the picture book view is shown in Fig. 1D.
[0048] In Figure 1D, each picture book view corresponds to a row of table data in the table. In the picture book view, the selected table data is presented in the original table page in the order of the table data rows.
[0049] In S23, in response to a trigger operation on the third target conversion element, the selected table data is presented in a Gantt chart view on the target table page.
[0050] After the user triggers the third target conversion element 102C in the target conversion elements, the table data selected in the Gantt chart view is presented in the target table page, as shown in Fig. 2C. Exemplarily, a specific presentation manner for presenting the table data selected in the Gantt chart view is to present the selected table data in the original table page in the order of table data rows in the Gantt chart view, as shown in Fig. 1E.
[0051] In the above-described embodiment, when a user triggers a first target conversion element and the target table page presents selected table data in a signboard view, the target table page refers to the table page corresponding to the signboard view. When a user triggers a second target conversion element and the target table page presents selected table data in a picture book view, the target table page refers to the table page corresponding to the picture book view. When a user triggers a third target conversion element and the target table page presents selected table data in a Gantt chart view, the target table page refers to the table page corresponding to the Gantt chart view.
[0052] In another possible embodiment, a user triggers a first target transformation element 102A to present selected table data in a billboard view 101, then triggers a second target transformation element 102B to present selected table data in a picture book view 101, and then triggers a third target transformation element 102C to present selected table data in a Gantt chart view 101. In this case, the corresponding target table pages include a table page corresponding to the billboard view, a table page corresponding to the picture book view, and a table page corresponding to the Gantt chart view. For example, as shown in FIG. 2D, the target table pages include a table page 103A corresponding to the billboard view, a table page 103B corresponding to the picture book view, and a table page 103C corresponding to the Gantt chart view. That is, after the user triggers the first target conversion element 102A, the second target conversion element 102B, and the third target conversion element 102C, respectively, on the same original table page, on the target table page 103, the selected table data is presented in a signboard view, on the target table page, the selected table data is presented in a picture book view, and on the target table page, the selected table data is presented in a Gantt chart view.
[0053] 2D exemplarily shows that a user switches to table page 103A corresponding to a signboard view. After the user switches to table page 103B corresponding to a picture book, the target table page is presented in a manner corresponding to FIG. 1D. After the user switches to table page 103C corresponding to a Gantt chart, the target table page is presented in a manner corresponding to FIG. 1E.
[0054] The table data presentation method according to the disclosed embodiment presents selected table data in a signboard view on the target table page in response to a trigger operation on a first target conversion among the target elements, and / or presents selected table data in a picture book view on the target table page in response to a trigger operation on a second target conversion element, and / or presents selected table data in a Gantt chart view on the target table page in response to a trigger operation on a third target conversion element.A user triggers one of the target conversion elements to present table data in the target area of the original table page in a target presentation method corresponding to the target conversion element, thereby realizing a variety of presentation methods for table data.
[0055] The following describes, through specific examples, the implementation methods of presenting selected table data on the target table page in a signboard view, presenting selected table data on the target table page in a picture book view, and presenting selected table data on the target table page in a Gantt chart view.
[0056] 3 is a flow diagram of another table data presentation method according to an embodiment of the present disclosure. In addition to the above embodiment, as shown in FIG. 3, the possible form of step S21 is as follows: In response to a trigger operation on the first target conversion element, the selected table data is presented in a signboard view on the target table page based on the set signboard presentation manner (S210).
[0057] Specifically, the sign presentation manner is related to a user's custom setting. In an original table page, different columns of table data correspond to different classifications. The user's set sign presentation manner determines whether the table data corresponding to the user's custom-set classification is presented when the selected table data is presented in sign view in the target table page.
[0058] For example, as shown in Fig. 1A, in the original table page, the table data 101 includes classification identifications such as job title, department, category, number of vacancies, city, etc. If the table data 101 of the original table page 100 selected by the user is all row data including classification identifications such as job title, department, category, number of vacancies, city, recruitment type, and years of work, the selected table data is presented in a signboard view in the target table page based on the set signboard presentation method, as shown in Fig. 3A.
[0059] Preferably, presenting the selected table data in a signboard view on the target table page based on the set signboard presentation manner includes: Based on the corresponding identification information in the target column of data in different rows of each selected table data, the selected table data is sorted by the corresponding identification information in the target column, and then presented in a signboard view.
[0060] When the amount of data in the original table page is large, in order to allow a user to more intuitively obtain a signboard view for a certain classification identification, when setting a signboard presentation method, the table data is classified according to the corresponding identification information in the target column, and the selected table data is then classified according to the corresponding identification information in the target column and then presented in a signboard view.
[0061] 1A, in the original table page, the classification identification of the table data 101 includes job title, department, category, number of employees, city, etc. The table data 101 of the original table page 100 selected by the user is all row data whose classification identification includes job title, department, category, number of employees, city, recruitment type, and years of work. The sign presentation method customized by the user presents table data corresponding to the classification identification of job title, department, category, number of employees, city, recruitment type, and years of work on each sign, and classifies the selected table data by the department of the identification information. A specific presentation method is shown in FIG. 3A.
[0062] In Figure 3A, each sign presents table data in which the classification identification of one row of the table in the original table page is job title, department, category, and number of positions available. Each sign is classified by department, that is, when converted to a sign view presentation, row data of the same department among the table data selected in the original table page is presented in the same column.
[0063] The table data presentation method according to the disclosed embodiment presents the selected table data in a signboard view presentation manner by classifying the selected table data by corresponding identification information in the target column based on corresponding identification information in the target column of data in different rows of each selected table data in response to a trigger operation on a first target element, and then presenting the selected table data in a signboard view.
[0064] Corresponding to step S210, the method further comprises: In response to a trigger operation on the target sign view of the target table page, presenting the target sign view in a card format.
[0065] After a user triggers a target signboard view on a target table page, the target signboard view is presented in a card format, and all the identification information selected on the user's original table page is displayed on the card.
[0066] Specifically, the table data of the user-selected original table page is all row data including classification identifications such as job title, department, category, number of available positions, city, recruitment type, and years of work experience, and the user's customized sign presentation manner presents table data corresponding to the job title, department, category, number of available positions, city, recruitment type, and years of work experience classification identifications on each sign. Based on the customized sign presentation manner, the target table page presents the selected table data in a sign view. As shown in Figure 3B, when the user triggers sign 200 in Figure 3B, all selected column data of a table in a row corresponding to sign 200 is presented in a card format. As shown in Figure 3C, the card presents the data of job title, department, category, number of available positions, city, recruitment type, and years of work experience.
[0067] 4 is a flow diagram of another table data presentation method according to an embodiment of the present disclosure. In addition to the above embodiment, as shown in FIG. 4, the possible form of step S22 is: In response to a trigger operation on the second target element, the selected table data is presented in a picture book view on the target table page based on the set picture book presentation method (S220).
[0068] Specifically, the picture book presentation method is related to the user's custom settings. Since different columns of table data in the original table page correspond to different classification identifications, the user sets the picture book presentation method so that when the selected table data is presented in picture book view in the target table page, the table data corresponding to the user's custom-set classification identification is presented based on the method.
[0069] For example, as shown in FIG. 1A , in the original table page, the table data includes classification identifications such as job title, department, category, number of vacancies, city, etc. The table data of the user-selected original table page is all row data including classification identifications such as job title, department, category, number of vacancies, city, recruitment type, and years of work, and when the user's custom-set picture book presentation method presents table data corresponding to the job title, department, and category classification identification in each picture book, the selected table data is presented in a picture book view in the target table page based on the set picture book presentation method, as shown in FIG.
[0070] Preferably, presenting the selected table data in a picture book view on the target table page based on the set picture book presentation manner includes: The method includes acquiring target table data corresponding to a preset number of target columns corresponding to different rows of the selected table data, and displaying the acquired target table data in a picture book view corresponding to the different rows on the target table page.
[0071] When the amount of data in the selected original table page is large, in order to allow the user to more intuitively obtain the corresponding data under important classification identification, when setting the picture book presentation method, target table data corresponding to a preset number of target columns corresponding to different rows of the selected table data is obtained, and in the target table page, the obtained target table data is presented in picture book views corresponding to different rows.
[0072] Specifically, referring to FIG. 1A, in the original table page, the table data includes classification identifications such as job title, department, category, number of applicants, city, etc. The table data of the original table page selected by the user is all row data including classification identifications such as job title, department, category, number of applicants, city, recruitment type, and years of work. When the user's customized sign presentation method presents table data corresponding to the job title, department, and category classification identifications on each sign, it obtains target table data for each row of the selected table data whose classification identification is the presented job title, department, and category, and presents the obtained target table data in a picture book view corresponding to different rows on the target table page. A specific presentation method is shown in FIG. 4A.
[0073] In FIG. 4A, each picture book presents table data in which the classification identification in one row of the table on the original table page is job title, department, and category, and each picture book is presented in the order of each row of data in the original table.
[0074] The table data presentation method according to the disclosed embodiment obtains target table data corresponding to a preset number of target columns corresponding to different rows of the selected table data in response to a trigger operation on a second target element, presents the selected target table data in a picture book view corresponding to the different rows on the target table page, and presents the selected table data in a picture book view presentation manner.
[0075] Corresponding to step S220, the method further comprises: In response to a trigger operation on the target picture book view of the target table page, presenting the target sign view in a card format.
[0076] After a user triggers a target picture book view on a target table page, the target picture book view is presented in a card format, in which all the identification information selected by the user on the original table page is displayed.
[0077] Specifically, the table data of the original table page selected by the user is all row data including classification identifications such as job title, department, category, number of positions available, city, recruitment type, and years of work experience. The user's customized sign presentation method presents the table data corresponding to the job title, department, and category classification identification on each sign, and the selected table data is presented in a picture book view on the target table page based on the configured picture book presentation method. As shown in Figure 4B, when the user triggers the picture book 300 in Figure 4B, all selected column data of a certain row of the table corresponding to the picture book 300 is presented in a card format. As shown in Figure 4C, the data of job title, department, category, number of positions available, city, recruitment type, and years of work experience are presented on the card.
[0078] 5 is a flow diagram of another table data presentation method according to an embodiment of the present disclosure. In addition to the above embodiment, as shown in FIG. 5, the possible form of step S23 is as follows: In response to a trigger operation on the third target element, the selected table data is presented in a Gantt chart view on the target table page based on the set Gantt chart presentation style (S230).
[0079] Specifically, the Gantt chart presentation method is related to the user's custom settings. In the original table page, different columns of table data correspond to different classification identifications. Therefore, when the user sets the Gantt chart presentation method and the selected table data is presented in Gantt chart view in the target table page, the presentation method will be based on whether the table data corresponding to the classification identifications custom set by the user is presented, and the event information on the corresponding time axis will be displayed.
[0080] For example, as shown in FIG. 1A , in the original table page, the table data includes classification identifications such as job title, department, category, number of vacancies, city, etc. The table data of the user-selected original table page includes all row data such as job title, department, category, number of vacancies, city, recruitment type, years of work, HR, job opening time, and job closing time as classification identifications, and the user's customized Gantt chart presentation method presents the table data corresponding to the job title and the event information for the job title in the Gantt chart. As shown in FIG. 5A , the selected table data is presented in a Gantt chart view in the target table page based on the configured Gantt chart presentation method.
[0081] Preferably, presenting the selected table data in a Gantt chart view on the target table page based on the set Gantt chart presentation style includes: This includes obtaining corresponding event information in different rows of the selected table data, and displaying the event information corresponding to the row on a corresponding time axis in the different rows of the selected table data in the target table page.
[0082] When the selected original table page data contains event information, in order to allow the user to more intuitively obtain the event stream corresponding to the event information, when setting the Gantt chart presentation method, the corresponding event information in different rows of the selected table data is obtained, and in the target table page, the event information corresponding to the row is displayed on the corresponding time axis in the different rows of the selected table data.
[0083] Specifically, referring to FIG. 1A , in the original table page, the table data includes classification identifications such as job title, department, category, number of available positions, city, etc. The table data of the original table page selected by the user includes all row data, such as job title, department, category, number of available positions, city, recruitment type, years of experience, HR, position open time, and position closing time, as classification identifications. When presenting table data corresponding to job titles and event information for the job titles in the Gantt chart, the user's customized Gantt chart presentation method retrieves table data for each row with job title classification identification from the selected table data, retrieves corresponding event information in different rows of the selected table data, and displays the event information corresponding to the row on the corresponding time axis of the selected table data in the different rows in the target table page. A specific presentation method is shown in FIG. 5A .
[0084] The table data presentation method according to the disclosed embodiment presents the selected table data in a picture book view presentation manner by obtaining target table data corresponding to a preset number of target columns corresponding to different rows of the selected table data in response to a trigger operation on a third target element, and presenting the selected target table data in a picture book view corresponding to the different rows on the target table page.
[0085] Corresponding to step S230, the method further comprises: In response to a trigger operation on event information corresponding to the target Gantt chart view of the target table page, the target Gantt chart view is presented in a card format.
[0086] After a user triggers event information corresponding to a target Gantt view in the target table page, the target Gantt chart view is presented in a card format, and all the identification information selected by the user in the original table page is displayed in the card.
[0087] For example, in the disclosed embodiment, the event information corresponding to different rows of the table data refers to the opening time and closing time corresponding to the row data, but in other possible embodiments, the event information may be in other forms, which is not specifically limited in the disclosed embodiment.
[0088] Specifically, the table data of the original table page selected by the user is all row data including classification identifications of job title, department, category, number of positions available, city, recruitment type, and years of work experience, and the user's customized Gantt chart presentation style is to present table data corresponding to the classification identification of job title and time information corresponding to the job title in each Gantt chart. Based on the customized Gantt chart presentation style, the selected table data is presented in a Gantt chart view on the target table page. As shown in Figure 5B, when the user triggers event information 400 in Figure 5B, all selected column data of a row of the table corresponding to event information 400 is presented in a card format. As shown in Figure 4C, the card presents data of the selected table data, including job title, department, category, number of positions available, city, recruitment type, and years of work experience, for which job title corresponds to job title 6.
[0089] Preferably, the method further comprises: Responsive to a trigger operation on the preset location on the card page, the content of the preset location is corrected and / or deleted.
[0090] Referring to FIGS. 3C, 4C and 5C, after a user triggers a preset position of a card page, the user can correct the content at the preset position at the preset position of the trigger.
[0091] Specifically, the preset position includes a first type area and a second type area, where the first type area is identification information corresponding to each column of the table data, and the second type area is table data corresponding to each table of the table data.
[0092] Illustratively, as shown in FIG. 3C, the first type area includes job title, department, category, number of applicants, city, type of applicant, and years of work, and the second type area includes job title 2, department 1, product 1, (outside 1) JPEG0007764508000001.jpg2846 Includes social recruitment and 5-8 years.
[0093] In one possible embodiment, in response to a trigger operation on a first type area at a preset position on the card page, the content of the first type area is corrected.
[0094] When a user triggers a target Gantt chart view on a target table page corresponding to a Gantt chart view and presents the target Gantt chart view in a card format, the user can correct the content of the first type area after triggering a first type area at a preset position on the card page. As shown in FIG. 6A, after the user triggers a first type area corresponding to a job title on the card page, the user corrects the job title identification information on the page shown in FIG. 6B. For example, as shown in FIG. 6C, the user corrects the identification information of the job title to "job title manipulation" and clicks "OK" to store the correction. In this case, when the user triggers any target Gantt chart view on the target table page, the identification information corresponding to the job title is corrected to "job title manipulation."
[0095] As shown in the above-described embodiment, one target Gantt chart view may be triggered in a target table page corresponding to a Gantt chart view, and the content of the first type area may be corrected in a card page corresponding to the target Gantt chart view. In another possible embodiment, one target picture book view may be triggered in a target table page corresponding to a picture book view, and the content of the first type area may be corrected in a card page corresponding to the target picture book view. In this case, the user may trigger any target picture book view in a target table page corresponding to a picture book view, and the identification information corresponding to each job title may be corrected to the identification information "job title manipulation." In a target table page corresponding to a signboard view, one target signboard view may be triggered, and the content of the first type area may be corrected in a card page corresponding to the target signboard view. In this case, the user may trigger any target signboard view in a target table page corresponding to a signboard view, and the identification information corresponding to each job title may be corrected to the identification information "job title manipulation."
[0096] In another possible embodiment, the content of the second type area is corrected or deleted in response to triggering the second type area at a preset position on the card page.
[0097] When a user triggers a target Gantt chart view in a target table page corresponding to a Gantt chart view and presents the target Gantt chart view in a card format, the user can delete or correct the content of the second type area after triggering a second type area at a preset position on the card page. As shown in FIG. 7A, after the user triggers a second type area corresponding to Job Title 6 on the card page, the job title information can be corrected on the page shown in FIG. 7A. For example, as shown in FIG. 7B, when the user corrects the job title information to Job Title 1 and clicks OK to store the correction, the job title information in the target Gantt chart view in the target table page corresponding to the Gantt chart becomes Job Title 1, as shown in FIG. 7C.
[0098] It should be noted that although FIGS. 7B and 7C exemplarily show the content of the second type region being corrected, in other possible embodiments the content of the second type region may be deleted.
[0099] Preferably, the method further includes correcting the set presentation style in the target table page in response to a trigger operation on a setting element in the target table page.
[0100] Specifically, as shown in Fig. 8A, after a user triggers a setting element on a target table page, the user can select a presentation mode for the target table page. For example, when a user triggers a setting element 500 to hide a status corresponding to years of work, as shown in Fig. 8B, the user stores the setting screen and returns to the target table page, and as shown in Fig. 8C, the information corresponding to years of work is not displayed on the target table page.
[0101] In the table data presentation method according to the above embodiment, the specific data conversion logic for the table is as follows: in the table title field, if it is a checkbox, it is converted to true / false, if it is a picture, it is displayed as pic1 or pic2, if it is a formula, it is displayed as the calculated value of the formula, if the text name is duplicated, subscript numbers 1, 2, ... are used, and if it exceeds 100 characters, it is truncated, if there is a special character, it is converted to a space, and trailing spaces are truncated.
[0102] The data conversion logic for each table is as follows: if the drop-down list in the table is radio, it will be converted to the corresponding character for the radio; if the drop-down list in the table is checked, it will be converted to the corresponding character for each selection; if the table summary contains @person, it will be converted to a person field (the default is checked); if the table contains numbers, it will be converted to a number field and the maximum decimal point for that column will be retained; if the table contains dates, it will be converted to a date field and the corresponding date format will be retained (the default is YYY / MM / DD); if it is a checkbox, it will be converted to a checkbox field; if it is a picture, it will be converted to an attachment field; if it is text, it will be converted to a radio field if 2<= number of unique text items in the column<=10, and the number of unique items / number of rows in the selected range<=0.5, and there is no link, and it is converted to a text field; if the above conditions are not met, it will be converted to a text field.
[0103] Furthermore, if the columns in the selection range are not in a single format, the number of pictures, drop-down types, checkboxes, and other types (text, date, number, @ person) in that column are calculated and compared, and if the number of picture types is the most, it is converted to a picture field, and if the number of checkboxes is the most, it is converted to a checkbox field.If the number of drop-down types is the most and both are radio, it is converted to radio, and if it contains a drop-down check, it is converted to a check.
[0104] Furthermore, if part of the selected table data exceeds the upper limit of 10,000 rows, it will be truncated at 10,000 rows; if part of the selected table data exceeds the upper limit of 100 columns, it will be truncated at 100 columns; if the number of pictures is greater than 4,000, it will be truncated at 4,000 pictures; and if the amount of text contained in a single cell is greater than 50,000, it will be truncated at 500,000 pieces of text in the cell.
[0105] 9 is a schematic diagram of the configuration of a table data presentation device according to an embodiment of the present disclosure. As shown in FIG. 9, the table data presentation device a table data selection module 910 for highlighting the selected table data in the original table page in response to a selection operation of at least a portion of the table data in the table page; and a presentation module 920 for presenting the selected table data in the target table page in a target presentation manner associated with the target conversion element in response to a trigger operation on the target conversion element.
[0106] The table data presentation method of the disclosed embodiment includes: in response to a selection operation of at least a portion of table data on an original table page by a table data selection module, highlighting the selected table data on the original table page; and in response to a trigger operation on a target conversion element of a presentation module, presenting the selected table data on the target table page in a target presentation manner related to the target conversion element, thereby presenting the table data in the target area of the user's original table page in the target presentation manner, and presenting the table data in different presentation manners in the table, thereby realizing a variety of presentation methods for table data and meeting different needs of users.
[0107] Preferably, a signage view presentation module for presenting the selected table data in a signage view in the target table page in response to a trigger operation on the first target transducer element; and / or a picture book view presentation module for presenting the selected table data in a picture book view in the target table page in response to a trigger operation on the second target conversion element; and / or The system further comprises a Gantt chart view presentation module for presenting the selected table data in a Gantt chart view in the target table page in response to a trigger operation on the third target transformation element.
[0108] Preferably, The device further includes a first signboard view presenting unit for presenting the selected table data in a signboard view on the target table page based on the set signboard presentation manner in response to a trigger operation on the first target element.
[0109] Preferably,
[0110] The apparatus further comprises a second signboard view presenting unit for presenting the selected table data in a signboard view after classifying the selected table data by the corresponding identification information in the target column based on the corresponding identification information in the target column of data in different rows of each selected table data.
[0111] Preferably, The device further includes a first picture book view presenting unit for presenting the selected table data in a picture book view on the target table page based on the set picture book presenting method in response to a trigger operation on the second target element.
[0112] Preferably, The device further includes a second picture book view presenting unit for obtaining target table data corresponding to a preset number of target columns corresponding to different rows of the selected table data, and presenting the selected target table data in a picture book view corresponding to the different rows on the target table page.
[0113] Preferably, The device further includes a first Gantt chart view presentation unit for presenting the selected table data in a Gantt chart view on the target table page based on the set Gantt chart presentation manner in response to a trigger operation on the third target element.
[0114] Preferably, The device further includes a second Gantt chart view presentation unit for obtaining corresponding event information in different rows of the selected table data, and displaying the event information corresponding to the rows on a time axis corresponding to the different rows for the selected table data in the target table page. Preferably, a first card presentation module for presenting the target signage view in a card manner in response to a trigger operation on the target signage view of the target table page; or a second card presentation module for presenting the target picture book view in a card manner in response to a trigger operation on the target picture book view of the target table page; or The system further comprises a third card presentation module for presenting the target Gantt chart view in a card format in response to a trigger operation on the event information corresponding to the target Gantt chart view of the target table page.
[0115] Preferably, The card further comprises an operation module for amending and / or deleting the content of the preset position in response to a trigger operation on the preset position of the card page.
[0116] Preferably, The card further comprises a first operating unit for amending the content of the first type area in response to a trigger operation on the first type area at the preset position on the card page.
[0117] Preferably, The card further comprises a first operation unit for correcting or deleting the content of the second type area in response to a trigger operation on the second type area at the preset position on the card page.
[0118] Preferably, The display device further includes a setting correction module for correcting the presentation style set in the target table page in response to a trigger operation on the setting element.
[0119] The apparatus according to the embodiments of the present invention can execute the methods according to any embodiments of the present invention, and has functional modules and beneficial effects obtained by executing the methods.
[0120] FIG. 10 is a schematic diagram of an electronic device according to an embodiment of the present disclosure. As shown in FIG. 10, the electronic device includes a processor 810, a memory 820, an input device 830, and an output device 840. The number of processors 810 in the electronic device may be one or more. FIG. 10 illustrates one processor 810. The processor 810, memory 820, input device 830, and output device 840 of the electronic device can be connected via a bus or other method. FIG. 10 illustrates connection via a bus.
[0121] The memory 820 is a computer-readable storage medium and can be used to store software programs, computer-executable programs and modules, such as program instructions / modules corresponding to the object recommendation method according to an embodiment of the present invention. The processor 810 executes the software program instructions and modules stored in the memory 820 to perform various functional applications and data processing of the electronic device, i.e., to implement the method according to an embodiment of the present invention.
[0122] The memory 820 may primarily include a program storage area and a data storage area. The program storage area may store an operating system, an application required for at least one function, and the like. The data storage area may store data generated in response to use of the terminal, and the like. Furthermore, the memory 820 may include high-speed random access memory or non-volatile memory such as at least one disk storage device, flash memory device, or other volatile solid-state storage device. In some embodiments, the memory 820 further includes memory located remotely from the processor 810 that is connectable to the computer device via a network. Examples of such networks include, but are not limited to, the Internet, an enterprise network, a local area network, a mobile communication network, and combinations thereof.
[0123] The input device 830 can be used to receive input digital or textual information and generate signal inputs related to user settings and function control of the electronic device, and may include a keyboard, a mouse, etc. The output device 840 may include a display device such as a display panel.
[0124] An embodiment of the present disclosure further provides a storage medium containing computer-executable instructions that, when executed by a computer processor, are used to implement a method according to an embodiment of the present invention.
[0125] Of course, in a storage medium containing computer-executable instructions according to an embodiment of the present invention, the computer-executable instructions are not limited to the method operations described above, but may perform related operations of a method according to any embodiment of the present invention.
[0126] The present disclosure further provides a computer program product, which, when executed on a computer, causes the computer to perform the method of the application of the above embodiments.
[0127] It should be noted that, in this specification, relational terms such as "first" and "second" are used only to distinguish one entity or operation from another and do not necessarily require or imply that such an actual relationship or order exists between those entities or operations. Furthermore, the terms "comprise," "include," or any other variant thereof are intended to cover a non-exclusive "comprise," whereby a process, method, article, or device that includes a set of elements not only includes those elements, but also other elements not expressly listed, or further elements inherent in such process, method, article, or device. Absent further limitations, an element defined by the phrase "comprises a ..." does not exclude the presence of other identical elements in the process, method, article, or device that includes that element.
[0128] The foregoing are merely specific embodiments of the present disclosure that will enable those skilled in the art to understand or implement the present disclosure. Various modifications of these examples will be apparent to those skilled in the art, and the general principles defined herein may be implemented in other examples without departing from the spirit or scope of the present disclosure. Therefore, the present disclosure is not intended to be limited to the examples set forth herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims
1. In response to a selection operation on at least a part of table data on the original table page, highlighting the selected table data on the original table page; In response to a trigger operation on a target conversion element, presenting the selected table data in a target table page in a target presentation manner associated with the target conversion element; The target presentation manner presents table data of different rows in the selected table data in a target table page corresponding to the target conversion element; the target conversion elements include at least a first target conversion element, a second target conversion element, and / or a third target conversion element; presenting the selected table data in a target presentation manner on a target table page in response to a trigger operation on the target conversion element, presenting the selected table data in a signage view on a target table page in response to a trigger operation on a first target transducer element; and / or and / or, in response to a trigger operation on a second target conversion element, presenting the selected table data in a picture book view on the target table page. presenting the selected table data in a Gantt chart view on a target table page in response to a trigger operation on a third target conversion element; presenting a target signage view in a card format in response to a trigger operation on the target signage view of the target table page; or In response to a trigger operation on a target picture book view of a target table page, presenting the target picture book view in a card format; or presenting the target Gantt chart view in a card format in response to a trigger operation on event information corresponding to the target Gantt chart view of the target table page; amending and / or deleting content at a preset position on the card page in response to a trigger operation on the preset position; Further comprising: A table data presentation method comprising:
2. In response to a trigger operation on the first target conversion element, presenting the selected table data in a sign view on a target table page, presenting the selected table data in a signboard view on a target table page based on a set signboard presentation manner in response to a trigger operation on a first target conversion element; 2. The method of claim 1, wherein
3. The sign presentation method includes classifying table data according to corresponding identification information in a target column; Presenting the selected table data in a signboard view on a target table page based on a set signboard presentation manner, and classifying the selected table data by the corresponding identification information in the target column based on the corresponding identification information in the target column of data in different rows of each of the selected table data, and then presenting the selected table data in a signboard view.
3. The method according to claim 2, wherein
4. presenting the selected table data in a picture book view on a target table page in response to a trigger operation on the second target conversion element, presenting the selected table data in a picture book view on the target table page based on the set picture book presentation method in response to a trigger operation on the second target conversion element; 2. The method of claim 1, wherein
5. The picture book presentation method includes presenting corresponding identification information in a preset number of target columns in table data; Presenting the selected table data in a picture book view on a target table page based on a set picture book presentation method, obtaining target table data corresponding to a preset number of target columns corresponding to different rows of the selected table data, and presenting the selected target table data in a picture book view corresponding to the different rows in a target table page; 5. The method according to claim 4, wherein
6. presenting the selected table data in a Gantt chart view on a target table page in response to a trigger operation on the third target conversion element, presenting the selected table data in a Gantt chart view on a target table page based on a set Gantt chart presentation format in response to a trigger operation on a third target conversion element; 2. The method of claim 1, wherein
7. The Gantt chart presentation method includes presenting the event information corresponding to different rows of the table data in a time axis manner; Presenting the selected table data in a Gantt chart view on a target table page based on a set Gantt chart presentation method; acquiring corresponding event information in different rows of the selected table data, and displaying the event information corresponding to the different rows on a time axis corresponding to the selected table data in the target table page; 7. The method according to claim 6, wherein
8. In response to a trigger operation on the preset position of the card page, correcting and / or deleting the content of the preset position includes: amending the content of the first type area in response to a trigger operation on the first type area in a preset position on the card page; 2. The method of claim 1, wherein
9. In response to a trigger operation on the preset position of the card page, correcting and / or deleting the content of the preset position includes: and correcting or deleting content of a second type area in response to a trigger operation on the second type area in a preset position on the card page.
2. The method of claim 1, wherein
10. and correcting the set presentation style in the target table page in response to a trigger operation on the setting element.
2. The method of claim 1 .
11. a table data selection module for highlighting selected table data on the original table page in response to a selection operation on at least a portion of table data on the original table page; a presentation module for presenting the selected table data in a target table page in a target presentation manner associated with the target conversion element in response to a trigger operation on the target conversion element; The target presentation manner presents table data of different rows in the selected table data in a target table page corresponding to the target conversion element; the target conversion elements include at least a first target conversion element, a second target conversion element, and / or a third target conversion element; presenting the selected table data in a target presentation manner on a target table page in response to a trigger operation on the target conversion element, presenting the selected table data in a signage view on a target table page in response to a trigger operation on a first target transducer element; and / or and / or, in response to a trigger operation on a second target conversion element, presenting the selected table data in a picture book view on the target table page. presenting the selected table data in a Gantt chart view on a target table page in response to a trigger operation on a third target conversion element; presenting a target signage view in a card format in response to a trigger operation on the target signage view of the target table page; or In response to a trigger operation on a target picture book view of a target table page, presenting the target picture book view in a card format; or presenting the target Gantt chart view in a card format in response to a trigger operation on event information corresponding to the target Gantt chart view of the target table page; and further comprising: correcting and / or deleting content at a preset position on the card page in response to a trigger operation on the preset position. A table data presentation device comprising:
12. at least one processor; a memory configured to store at least one program; An electronic device, wherein said at least one program, when executed by said at least one processor, causes said at least one processor to implement the method of any one of claims 1 to 10.
13. A computer-readable storage medium having a computer program stored thereon, the computer program implementing the method of any one of claims 1 to 10 when executed by a processor.
14. A computer program which, when executed by a processor, implements the method according to any one of claims 1 to 10.
Citation Information
Patent Citations
Temporary formatting and graphing of selected data
JP2013528860A
Information processing apparatus, system, control method, and program
JP2017084243A
Generating charts from data in a data table
US20180088753A1
Interactive chart recommender
US20200372077A1
Computer messaging analytics systems and methods
US20210266397A1