Table content prompting method and device, storage medium and electronic equipment
By generating tooltips after shrinking the table content, the problem of text being difficult to read due to the small screen size of smart terminals is solved, thus improving the readability and positioning efficiency of table content.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- TENCENT TECHNOLOGY (SHENZHEN) CO LTD
- Filing Date
- 2022-04-07
- Publication Date
- 2026-05-12
AI Technical Summary
Because smart terminals have small screens, table content can easily become too small to read after being shrunk or adjusted, and existing technologies lack effective solutions.
After shrinking the table content, extract the content category titles and generate tooltips. Adjust the display size and tooltips to help locate the table content.
It improves the readability and positioning efficiency of table content when displayed in a minimized state, and solves the problem of the limited display methods for table content.
Smart Images

Figure CN116933744B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of computers, and more specifically, to a method and apparatus for displaying table content, a storage medium, and an electronic device. Background Technology
[0002] Today, smart devices run a wide variety of applications, including real-time interactive entertainment apps to enrich our lives, and many utility apps to assist with work. Among these, spreadsheet applications are quite common for facilitating data statistics and summarization.
[0003] However, due to the limited screen size of smart terminals, the complete content of a table cannot be displayed on one screen; that is, only a portion of the table content can often be shown. If more table content needs to be displayed, the table view needs to be scaled down. As the table view shrinks, the text content within the table also shrinks, making the text content difficult to read due to its small display size.
[0004] In other words, the display method of the table content provided by the relevant technology is relatively simple, which makes it easy for the table content to become unreadable after being shrunk or adjusted.
[0005] There is currently no effective solution to the above problems. Summary of the Invention
[0006] This invention provides a method and apparatus for displaying table content, a storage medium, and an electronic device to at least solve the technical problem of a limited range of ways to display table content.
[0007] According to one aspect of the present invention, a method for prompting table content is provided, comprising: displaying a target table on a display screen, wherein the target table includes a content category title; adjusting the table content in the currently displayed target table from a first display size to a second display size in response to an adjustment operation triggered by a display view of the target table, wherein the second display size is smaller than the first display size; extracting a target content category title from the content category title when the table content at the second display size meets the label prompting conditions; and prompting a target prompt label that matches the target content category title.
[0008] According to another aspect of the present invention, a table content prompting device is also provided, comprising: a display unit for displaying a target table on a display screen, wherein the target table includes a content category title; an adjustment unit for adjusting the table content in the currently displayed target table from a first display size to a second display size in response to an adjustment operation triggered by the display view of the target table, wherein the second display size is smaller than the first display size; an extraction unit for extracting a target content category title from the content category title when the table content at the second display size meets the label prompting conditions; and a prompting unit for prompting a target prompting label that matches the target content category title.
[0009] According to another aspect of the present invention, a computer-readable storage medium is also provided, wherein a computer program is stored in the computer program, wherein the computer program is configured to execute the above-described table content prompting method when it is run.
[0010] According to another aspect of the embodiments of this application, a computer program product or computer program is provided, which includes computer instructions stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium and executes the computer instructions, causing the computer device to perform the method described in the table above.
[0011] According to another aspect of the present invention, an electronic device is also provided, including a memory and a processor, wherein the memory stores a computer program and the processor is configured to execute the above-described table content prompting method through the computer program.
[0012] In this embodiment of the invention, by displaying a target table on a display screen, wherein the target table includes a content category title; in response to an adjustment operation triggered by the display view of the target table, the table content in the currently displayed target table is adjusted from a first display size to a second display size, wherein the second display size is smaller than the first display size; when the table content under the second display size meets the label prompt condition, the target content category title is extracted from the content category title; a target prompt label matching the target content category title is displayed, thereby improving the efficiency of locating the table content and solving the technical problem of the relatively simple display method of table content. Attached Figure Description
[0013] The accompanying drawings, which are included to provide a further understanding of the invention and form part of this application, illustrate exemplary embodiments of the invention and, together with their description, serve to explain the invention and do not constitute an undue limitation thereof. In the drawings:
[0014] Figure 1 This is a schematic diagram of the hardware environment for an optional table content display method according to an embodiment of the present invention;
[0015] Figure 2 This is a flowchart of an optional table content prompting method according to an embodiment of the present invention;
[0016] Figure 3 This is a schematic diagram of an optional table content prompting method according to an embodiment of the present invention;
[0017] Figure 4 This is a schematic diagram of another optional table content display method according to an embodiment of the present invention;
[0018] Figure 5 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0019] Figure 6 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0020] Figure 7 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0021] Figure 8 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0022] Figure 9 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0023] Figure 10 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0024] Figure 11 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0025] Figure 12 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0026] Figure 13 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0027] Figure 14This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0028] Figure 15 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0029] Figure 16 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0030] Figure 17 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0031] Figure 18 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0032] Figure 19 This is a schematic diagram of another optional table content prompting method according to an embodiment of the present invention;
[0033] Figure 20 This is a flowchart of an optional table content prompting method according to an embodiment of the present invention;
[0034] Figure 21 This is a schematic diagram of the structure of an optional table content prompting device according to an embodiment of the present invention;
[0035] Figure 22 This is a schematic diagram of the structure of an optional electronic device according to an embodiment of the present invention. Detailed Implementation
[0036] To enable those skilled in the art to better understand the present invention, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of the present invention.
[0037] It should be noted that the terms "first," "second," etc., in the specification, claims, and accompanying drawings of this invention 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 so that the embodiments of the invention described herein can be implemented in orders other than those illustrated or described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover a non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.
[0038] According to one aspect of the present invention, a method for prompting table content is provided. As an optional implementation, the above-described method for prompting table content can be applied to, but is not limited to, [examples of other methods]. Figure 1 The table content display system shown is composed of server 102 and terminal device 104. For example... Figure 1 As shown, server 102 is connected to terminal device 104 via network 110. This network may include, but is not limited to, wired networks and wireless networks. The wired network includes local area networks (LANs), metropolitan area networks (MANs), and wide area networks (WANs). The wireless network includes Bluetooth, Wi-Fi, and other networks enabling wireless communication. The terminal device may include, but is not limited to, at least one of the following: mobile phones (such as Android phones, iOS phones, etc.), laptops, tablets, PDAs, MIDs (Mobile Internet Devices), PADs, desktop computers, smart TVs, in-vehicle devices, etc. The terminal device may have a client installed, such as a document viewing client or a document editing client. The terminal device also includes a display, a processor, and a memory. The display can be used to display the spreadsheet document to be viewed; the processor can be used to process the operation information of the spreadsheet document, for example, converting the acquired touch operation information into adjustment operations on the spreadsheet document; the memory is used to store the spreadsheet document to be viewed. Understandably, after obtaining the form document to be viewed in the aforementioned terminal device 104, the terminal device 104 can send the form document to the server 102 via network 110. After receiving the form document, the server 102 determines the target prompt tag based on the content category titles in the form document. The terminal device 104 can then receive the target prompt tag returned by the server 102 via network 110. The server 102 can be a single server, a server cluster consisting of multiple servers, or a cloud server. The aforementioned server includes a database and a processing engine.
[0039] According to one aspect of the present invention, the above-described table content prompting system may further perform the following steps: The terminal device 104 performs steps S102 to S108, displaying a target table on a display screen, wherein the target table includes a content category title; in response to an adjustment operation triggered by the display view of the target table, the table content in the currently displayed target table is adjusted from a first display size to a second display size, wherein the second display size is smaller than the first display size; if the table content at the second display size meets the label prompting conditions, a target content category title is extracted from the content category title; then the terminal device 104 sends the table document to the server 102 via the network 110; the server 102 performs step S110, determining a target prompting label based on the content category title; then performs step S112, sending the target prompting label to the terminal device 104 via the network 110; the terminal device 104 performs step S114, prompting a target prompting label matching the target content category title.
[0040] In this embodiment of the invention, a target table is displayed on a display screen, wherein the target table includes a content category title; in response to an adjustment operation triggered by the display view of the target table, the table content in the currently displayed target table is adjusted from a first display size to a second display size, wherein the second display size is smaller than the first display size; when the table content under the second display size meets the label prompt condition, the target content category title is extracted from the content category title; a target prompt label matching the target content category title is displayed, thereby displaying a prompt label for locating the table content when the table display size changes, making the table content unsuitable for browsing, thus solving the technical problem of the relatively simple display method of table content.
[0041] The above is merely an example, and no limitation is made in this embodiment.
[0042] As an optional implementation method, such as Figure 2 As shown, the above table content prompting method includes the following steps:
[0043] S202, Display the target table on the display screen, wherein the target table includes content category titles;
[0044] It is understood that, in this embodiment, the aforementioned content category headings are content displayed within the target table itself, indicating the table content included in the target product's target column. For example, a row heading in a table might be "January," indicating that the data in that row corresponds to "January"; a column heading in a table might be "Profit," indicating that the data in that column is related to profit. In this method, the type of the aforementioned content category headings is not limited.
[0045] S204, in response to an adjustment operation triggered by the display view of the target table, the table content in the currently displayed target table is adjusted from a first display size to a second display size, wherein the second display size is smaller than the first display size;
[0046] The following describes the display view of the target table. It is understood that existing table document viewing applications typically support dragging and zooming of the table document. After dragging and zooming, the terminal's display interface can be divided into a display area and a non-display area; the display view described above corresponds to the display area of the table content.
[0047] It should be noted that the aforementioned display size can be used to indicate the pixel range occupied by the table content. For example, assuming the table content is a single character occupying a display pixel range of (0px, 0px) to (100px, 100px), this indicates the rectangular area occupied by the character with the diagonal lines of pixels (0px, 0px) and (100px, 100px) in the display interface. After shrinking the table, the pixel range occupied by the character becomes (0px, 0px) to (10px, 10px), indicating the rectangular area occupied by the character with the diagonal lines of pixels (0px, 0px) and (10px, 10px) in the display interface. In other words, the display area occupied by the character is reduced to 1 / 10 of its original size. It can be understood that the above method of adjusting the display area of characters in a table is an example of the adjustment operation, specifically a shrinking operation, the effect of which is to reduce the display area occupied by the content in the table.
[0048] From the perspective of the object being manipulated, the aforementioned scaling operation on the table allows for the display of more table content. However, due to the limited display capabilities of terminal devices, when the amount of table content increases and the display size of the table content decreases, it is easy to encounter problems where the table content cannot be clearly displayed.
[0049] S206, if the table content under the second display size meets the label prompt conditions, extract the target content category title from the content category title;
[0050] S208, prompting a target hint label that matches the target content category title.
[0051] It is understandable that when the user zooms out of the table on the display interface, although more table content can be displayed, the limited display capabilities of the terminal device may prevent the table content from being clearly displayed. This embodiment, upon determining that the label prompt condition has been met, extracts the target content category title and displays a target prompt label based on the target content category title, thereby providing prompts for the table content through the target prompt label.
[0052] The above-mentioned label prompting conditions can be based on the reduction ratio of the table content. For example, if the table content is reduced to half of its original display size, the label prompting condition is determined to be met, and the table content is prompted using the obtained target prompting label. Alternatively, the label prompting conditions can be based on the display pixel size of the table content. For example, if the display pixel size of the table content is smaller than a preset size after the reduction operation, the label prompting condition is determined to be met, and the table content is prompted using the obtained target prompting label. The methods for determining the above label prompting conditions are merely examples and do not limit the specific methods used to determine whether the above label prompting conditions are met.
[0053] The following combination Figures 3 to 6 The above implementation methods will be described in general.
[0054] like Figure 3 The image shown is a schematic diagram of an optional terminal display interface. Figure 3 The interface shown displays a spreadsheet application, and a portion of the target table's content is displayed in view 301. The table content includes column headings such as "Revenue," "Revenue," and "Revenue Growth Rate," as well as row headings such as "January," "February," "First Quarter," and "2018," and the table data indicated by these row and column headings. For example, the table data indicated by the row heading "2018" – "First Quarter" – "January" and the column heading "Revenue" is "1000."
[0055] Understandably, in Figure 3 The interface shown contains a lot of data and table items. If the user wants to understand the other data under other items in the table, they need to use operations such as zooming and moving to view other parts of the table.
[0056] Assuming the object being operated on is Figure 3 When a drag operation is performed on the terminal display interface shown, the target table is moved within the interface, and the display is as follows: Figure 4 As shown. Areas excluding table content are displayed as blank, while areas containing table content are displayed as view 401.
[0057] Assuming the object being operated on is Figure 4 When the zoom-out operation is performed on the terminal display interface shown, the interface further displays as follows: Figure 5 As shown. In Figure 5 In this case, it can be observed that the display size of the table content is reduced, and consequently, the display quality of the table headings and content also deteriorates. Assuming... Figure 5 If the displayed table content reaches the label prompt condition, such as Figure 5 As shown, the prompt label 501 "Revenue Item" and the prompt label 502 "First Quarter", "Second Quarter", etc. are highlighted in the non-table display view area.
[0058] Assuming the object being operated on is Figure 5 The interface shown has been further zoomed out, displaying as follows: Figure 6 The terminal display interface shown is shown. Figure 6 While the current display shows more table content, the table content is too small to be easily viewed. Therefore, it is possible to control the display of higher-level prompts, such as "First Branch Company" in prompt label 601, and year-related prompts in prompt label 602.
[0059] In this embodiment of the invention, a target table is displayed on a display screen, wherein the target table includes a content category title; in response to an adjustment operation triggered by the display view of the target table, the table content in the currently displayed target table is adjusted from a first display size to a second display size, wherein the second display size is smaller than the first display size; when the table content under the second display size meets the label prompt condition, the target content category title is extracted from the content category title; a target prompt label matching the target content category title is displayed, thereby displaying a prompt label for locating the table content when the table display size changes, making the table content unsuitable for browsing, thus solving the technical problem of the relatively simple display method of table content.
[0060] As an optional implementation, when the table content at the second display size meets the label prompt conditions, extracting the target content category title from the content category title includes:
[0061] S1, if the second display size is smaller than the display size used to distinguish the meaning of characters in the table content, determine that the table content under the second display size meets the label prompt condition;
[0062] S2, extract the target content category title from the content category titles;
[0063] S3, create target hint tags based on the target content category title.
[0064] Understandably, when most users zoom out to find the content they want to see in a table, they usually first browse the table's row and column headers. After finding the row or column they want to see, they then zoom in to see the specific cell content under the row or column header. Therefore, when users zoom out to find the content they want to see, the table's row and column headers are more important information for them.
[0065] Therefore, in this embodiment, when the table view is zoomed out to a state where the text is difficult to read, the row headers or column headers in the table are automatically extracted, and labels are created for the table. It can be understood that the tooltip labels in this embodiment can be controlled to remain readable even when the table is zoomed out; that is, the display size of the tooltip labels is controlled to be a display size that is easily readable by the user.
[0066] It is understandable that the display size used to distinguish the meaning of characters in the table content can be a standard preset value for the display size, indicating that the current display size is not easily readable by the object being manipulated. For example, the above standard preset value can be set to 100px, meaning that if the width or height of the display size of the meaning of characters in the table content is less than 100 pixels wide on the screen, the table content is determined to meet the label prompt condition. In another optional approach, the above standard preset value can be a specific length value, such as 0.5cm. That is, if the width or height of the display size of the meaning of characters in the table content is less than 0.5cm, the table content is determined to meet the label prompt condition.
[0067] Furthermore, since the table content that the operation object usually focuses on first is the content category title, it can be determined that the content category title meets the label prompt condition if the display size of the content category title is smaller than the display size used to distinguish the meaning of characters in the table content.
[0068] As an optional approach, when the content category title includes a first-level content category title, extracting the target content category title from the content category title further includes: using the first-level content category title as the target content category title.
[0069] Specifically, such as Figure 7 The displayed interface shows a table with only one level of content category headings. After zooming out the table using the operation object, assuming... Figure 7 If the displayed content category titles “Revenue”, “Revenue Growth Rate”, “Profit”, “Profit Growth Rate”, and “Liabilities” are 100px smaller than the preset display size, it is determined that the label prompt condition has been met. The above content category titles are directly obtained and used as target prompt labels. The content of the target prompt label determined directly by the above content category titles is displayed in the non-table view area.
[0070] Through the above-described embodiments of this application, when the second display size is smaller than the display size used to distinguish the meaning of characters in the table content, it is determined that the table content under the second display size meets the label prompting conditions; the target content category title is extracted from the content category title; and a target prompting label is created based on the target content category title. By creating a target prompting label when the label extraction conditions are clearly met, the target prompting label is created, thereby achieving the highlighting of the content category title when the table content display effect is poor, thus solving the technical problem of poor display effect in existing table display methods.
[0071] As an optional implementation, when the content category title includes at least two levels of content category titles, extracting the target content category title from the content category titles includes:
[0072] S1, when the second display size is smaller than the display size, extract the first-level content category title from at least two levels of content category titles according to the category priority; when the prompt labels corresponding to the extracted multiple first-level content category titles do not meet the label overlap display condition, the first-level content category title is taken as the target content category title;
[0073] S2, when the second display size is smaller than the display size, extract the first-level content category title from at least two levels of content category titles according to the category priority; when the prompt tags corresponding to the extracted multiple first-level content category titles meet the tag overlap display condition, the second-level content category title extracted from at least two levels of content category titles is used as the target content category title, wherein the category priority of the second-level content category title is higher than the category priority of the first-level content category title.
[0074] In this embodiment, the target table originally included at least two layers of content category titles.
[0075] It should be noted that the classification priority mentioned above refers to the order in which multiple classification operations are performed on a set of data within the target table. For example... Figure 8In the table shown, the data is first categorized into several types based on its data type: "Revenue," "Revenue Growth Rate," "Profit," "Profit Growth Rate," "Liabilities," and "Liabilities Ratio." These types constitute the first-level content category headings. Next, these categories are further categorized: "Revenue" and "Revenue Growth Rate" are grouped under "Revenue Item," "Profit" and "Profit Growth Rate" under "Profit Item," and "Liabilities" and "Liabilities Ratio" under "Liabilities Item." Therefore, "Revenue Item," "Profit Item," and "Liabilities Item" in the table are the second-level content category headings. Furthermore, since all the above data belongs to "First Branch Company," "First Branch Company" is the third-level content category heading.
[0076] It should be further explained that the above-mentioned overlapping display conditions are used to indicate the display status of the prompt label. If the prompt label does not meet the overlapping display conditions, indicating that displaying the prompt label content according to the preset easy-to-read display size will not cause the prompt label to overlap. However, if the prompt label meets the overlapping display conditions, indicating that displaying the prompt label content according to the preset easy-to-read display size will cause the prompt label to overlap.
[0077] like Figure 8 As shown, assuming in Figure 8 If the table content for the first-level category headings "Revenue," "Revenue Growth Rate," "Profit," "Profit Growth Rate," "Liabilities," and "Liabilities Ratio" is smaller than the preset display size in the original table, and assuming that the corresponding prompt labels for "Revenue," "Revenue Growth Rate," "Profit," "Profit Growth Rate," "Liabilities," and "Liabilities Ratio" do not overlap, then it is determined that the prompt labels corresponding to the extracted multiple first-level content category headings do not meet the label overlap display condition, and therefore... Figure 8 As shown, the prompt labels corresponding to the content category titles of the previous layer are displayed.
[0078] Assuming the operation objects are pairs Figure 8 The table in the table is further reduced in size. In this embodiment, the display size of the prompt labels corresponding to the content category titles of the first layer is controlled to remain unchanged regardless of the table's display method, in order to maintain readability. Therefore, when the prompt labels corresponding to the extracted multiple first-layer content category titles meet the label overlap display condition, the display... Figure 9 The prompt labels shown use the extracted second-level content category titles as the target content category titles, and then display the prompt labels "Revenue Items", "Profit Items" and "Liabilities Items".
[0079] Assuming the operation objects are pairs Figure 9 The table in the text can be further reduced in size, such as... Figure 10As shown, the prompt labels corresponding to the second-level content category titles also meet the conditions for overlapping display, that is, the prompt labels "First Branch" and "Second Branch" corresponding to the third-level content category titles are displayed.
[0080] Through the above embodiments of this application, when the second display size is smaller than the display size, the first-level content category title is extracted from at least two levels of content category titles according to category priority; when the prompt tags corresponding to the extracted multiple first-level content category titles do not meet the label overlap display condition, the first-level content category title is used as the target content category title; when the second display size is smaller than the display size, the first-level content category title is extracted from at least two levels of content category titles according to category priority; when the prompt tags corresponding to the extracted multiple first-level content category titles meet the label overlap display condition, the second-level content category title extracted from the at least two levels of content category titles is used as the target content category title, wherein the category priority of the second-level content category title is higher than the category priority of the first-level content category title, thereby achieving the technical effect of quickly determining the displayed prompt tags based on the scaling degree of the table when the target table itself has multiple levels of content category titles.
[0081] As an optional implementation, creating target hint tags based on the target content category title includes at least one of the following:
[0082] Determine the category tag of the category to which the target content category title belongs; use the category tag as the target prompt tag;
[0083] Use the category title of the target content as the target prompt label.
[0084] It should be noted that there are two ways to create target prompt labels in this embodiment.
[0085] In the first approach, the category tag of the category to which the target content category title belongs is first determined, and then the category tag is used as the target prompt tag.
[0086] For example, suppose the target content category titles displayed in the table are "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", and "December". If the table does not display subsequent content category titles, in this embodiment, the category to which the above content category titles belong can be determined as "Time" based on the content category titles. Therefore, multi-level category tags based on the above category titles can be directly determined without relying on the content category titles displayed in the table itself. For example, "January", "February", and "March" can be further divided into "First Quarter", "April", "May", and "June" into "Second Quarter", etc., that is, "First Quarter" is determined as the subsequent prompt tag for "January", "February", and "March", and "Second Quarter" is determined as the subsequent prompt tag for "April", "May", and "June"; furthermore, the above "First Quarter" and "Second Quarter" can be divided into "First Half of the Year", that is, "First Half of the Year" is determined as the subsequent tag for "First Quarter" and "Second Quarter".
[0087] For example, if the content category titles in the target table are "Net Profit", "Net Profit Margin", "Net Profit Year-on-Year Growth Rate", "Gross Profit", "Gross Profit Margin", and "Gross Profit Year-on-Year Growth Rate", in this embodiment, the higher-level prompt label corresponding to the above content category titles can be directly determined as "Profit Item" based on the category labels of the above category titles.
[0088] In the second approach, the category title of the target content is directly used as the target prompt label.
[0089] In one alternative approach, assuming that both the first and second tag creation methods can be used within a single table, the second tag creation method takes precedence over the first. That is, when the table contains multi-level content category headings, the content of these headings is used as the content for the tooltip tag. Only when the target table requires a tooltip tag but does not contain corresponding level content category headings, is the first tag creation method used to create the tooltip tag.
[0090] like Figure 11The table shown displays both row and column tooltips. Since the table itself contains multi-level column headings, the displayed column tooltips "Revenue" and "Profit" are directly derived from the column headings extracted from the table. For row tooltips, because the table's row headings only include "January" to "December," the corresponding headings for the second-level tooltips do not exist. Therefore, the class labels "First Quarter," "Second Quarter," "Third Quarter," and "Fourth Quarter," determined based on the first-level headings, are used as the second-level tooltips.
[0091] Through the above embodiments of this application, by creating prompt tags in two different ways, including determining the category to which the target content category title belongs and using the category tag as the target prompt tag, and using the target content category title as the target prompt tag, the flexibility of the tag creation method is improved, thereby improving the effect of table content display.
[0092] As an alternative approach, the target cue tags that match the target content category title include:
[0093] S1, determine the display parameters of the table content in the target table that is categorized based on the target content category title;
[0094] S2, In the display area outside the display view of the target table, and in the prompt area that matches the display parameters, display the target prompt label.
[0095] In this embodiment, the location for displaying the prompt label is determined using the method described above. It is understood that the prompt label in this embodiment is used to indicate the table content at a corresponding location, and therefore the prompt label needs to be displayed in a position that matches the table content.
[0096] The display parameters used to determine the position that matches the table content may include, but are not limited to, the width and height of the table content, the font size of the characters included in the table content, and the number of characters. No specific table display parameters are restricted here.
[0097] Through the above-described embodiments of this application, by determining the display parameters of the table content categorized based on the target content category title in the target table, and displaying the target prompt label in the display area outside the display view of the target table and in the prompt area that matches the display parameters, the display of the prompt label is controlled to be located at the position of the corresponding content category title, thereby facilitating the operation object to find the table content according to the prompt label and improving the display efficiency of the table content.
[0098] In one alternative implementation, in a display area outside the display view of the target table, and within a prompt area that matches the display parameters, the target prompt label includes:
[0099] S1, when the target content category title is a column header, display the target hint label in the hint area that matches the total column width of the table content of the category indicated by the target content category title;
[0100] S2, when the target content category title is a row title, display the target hint label in the hint area that matches the total row height of the table content of the category indicated by the target content category title.
[0101] In this embodiment, the location of the display prompt label is determined using the method described above. It is understood that the prompt label in this embodiment is used to indicate the table content at the corresponding location in the table being operated on, and therefore needs to be displayed in a position matching the table content. For example, for column labels, it is necessary to determine the column width and the position of the column center line of each column in the table, and display the column prompt label based on the column width and the position of the column center line of each column. For row labels, it is necessary to determine the row height and the position of the row center line of each row in the table, and display the column prompt label based on the row height and the position of the row center line of each row.
[0102] Correspondingly, in this embodiment, for column content category titles, it is necessary to determine the position of the column center line corresponding to the column category title, and determine the position of the corresponding column tooltip based on the position of the column center line; for row content category titles, it is necessary to determine the height position of the row center line corresponding to the row category title, and determine the height position of the corresponding row tooltip based on the height position of the row center line.
[0103] like Figure 12 As shown, the position of the column midline of the column content category title "Revenue Item" is displayed, thus determining that the display position of the column tooltip label "Revenue Item" matches the position of the midline; at the same time, the height of the row midline of the row content category titles "First Quarter", "Second Quarter", and "Third Quarter" is displayed, thus determining that the display height of the row tooltip labels "First Quarter", "Second Quarter", and "Third Quarter" matches the position of the midline.
[0104] After determining the display position of the prompt label using the above method, the display range of the corresponding label is further determined based on the row height and column width. As an optional method, the display range of the label can be 80% of the corresponding row height and column width. For example, if the column width of a label is 4cm, the display width of the corresponding column prompt label in that column is 3.2cm. Alternatively, the display range of the label can be 100% of the corresponding row height and column width. For example, if the column width of a label is 4cm, the display width of the corresponding column prompt label in that column is 4cm. The above methods of displaying prompt labels are merely illustrative examples and are not intended to impose any limitations.
[0105] Through the above-described embodiments of this application, when the target content category title is a column title, a target hint label is displayed in a hint area that matches the total column width of the table content in the category indicated by the target content category title; when the target content category title is a row title, a target hint label is displayed in a hint area that matches the total row height of the table content in the category indicated by the target content category title, thereby improving the display efficiency of table hint labels.
[0106] As an optional implementation, after displaying the target hint label that matches the target content category title, the following is also included:
[0107] S1, in response to the positioning operation performed on the key hint label in the target hint label, the display view of the target table displayed on the display screen is positioned at the location of the table content of the category indicated by the key content category title that matches the key hint label;
[0108] S2 highlights the table content indicated by the key content category headings.
[0109] It should be noted that, in this embodiment, the method of highlighting table content described above can be to restore the table content indicated by the key content category headings to a readable display scale. Alternatively, the method of highlighting can be to enlarge the table content indicated by the key content category headings. No specific highlighting method is limited here.
[0110] The following combination Figure 13 The above methods will be explained. For example... Figure 13 As shown in Figure (a), assuming that a detection of [the target] is made... Figure 13 The click operation on the "Profit Item" prompt label in Figure (a) indicates a location operation performed on the key prompt label, which in turn enlarges the interface display as shown. Figure 13 As shown in Figure (b), the table content related to the "Profit" item is highlighted.
[0111] In another optional embodiment, in response to the location operation of a key prompt label, the table content corresponding to the key prompt label and the corresponding row / column labels can be displayed together. For example, if the key prompt label determined by the location operation is a column label, the table content of the column corresponding to that label is displayed while the row content category titles are displayed together; similarly, if the key prompt label determined by the location operation is a row label, the table content of the row corresponding to that label is displayed while the column content category titles are displayed together. Thus, through the above-mentioned highlighting method, when the table content is highlighted, the row and column titles are displayed simultaneously, thereby clearly showing the specific meaning of each item in the table content. It is understood that after highlighting, if a restore or drag operation is detected, the original table display style can be restored.
[0112] The following combination Figure 14 The above methods will be explained. For example... Figure 14 As shown in Figure (a), assuming that a detection of [the target] is made... Figure 14 The click operation on the "Profit Item" prompt label in Figure (a) indicates a location operation detected on the key prompt label "Profit Item," which then displays the table as shown below. Figure 14 As shown in Figure (b), the table content related to the "Profit" item will be enlarged and highlighted. Simultaneously, the "Time" label and corresponding row labels such as "January," "February," etc., will be highlighted in the original position corresponding to the "Revenue" item. This, combined with the time row headings and corresponding column headings, clearly demonstrates the specific content of the table. Figure 14 The table content “11” in Figure (b) has the row title “January” and the column title “Profit”, which clearly indicates that the profit value of “First Branch” in January is “11”.
[0113] In another optional implementation, in response to the positioning operation of multiple key prompt labels, the table content corresponding to the multiple key prompt labels can be jointly highlighted. It is understood that, in this embodiment, after jointly highlighting the table content corresponding to multiple labels, if a restore or drag operation of the operation object is detected, the table style can be directly restored to its state before the highlighting.
[0114] The following combination Figure 15 The above method will be explained. Assume that an error is detected... Figure 15 In Figure (a), the click actions for the "Revenue" and "Liabilities" labels are only displayed together because the corresponding tables also include "Profit" related content, which is not relevant to the user's input. Figure 15 As shown in Figure (b), the table content for "Revenue" and "Liabilities" is extracted and displayed as a floating layer on top of the original table content. This allows for highlighting only the table content corresponding to the prompts relevant to the user, while displaying table content unrelated to the user, saving display space and improving display efficiency. It is understandable that in... Figure 15 If a restore or drag operation is detected in the interface shown in Figure (b), the table view can be restored to its original state. Figure 15 The table style shown in Figure (a) is as follows.
[0115] Through the above embodiments of this application, in response to a positioning operation performed on a key prompt label in a target prompt label, the display view of the target table displayed on the screen is positioned to the location of the table content in the category indicated by the key content category title that matches the key prompt label; the table content indicated by the key content category title is highlighted, thereby prompting the table content through the prompt label. Simultaneously, the user can locate and highlight the table content by touching the prompt label, improving the display efficiency of the table content.
[0116] As an optional implementation, after displaying the target hint label that matches the target content category title, the method further includes: updating the table content of the category indicated by the target hint label currently displayed on the display screen in response to a swipe operation triggered by a view of the target table.
[0117] Specifically, such as Figure 16 As shown, Figure 16 In Figure (a), due to the width limitation of the display terminal, only the corresponding "Revenue," "Profit," and "Liabilities" labels for the first branch are shown; the corresponding "Revenue," "Profit," and "Liabilities" labels and the corresponding table content for the second branch are not shown. Figure 16 In Figure (a), assuming a left swipe operation on the displayed view is detected, i.e., the target table is controlled to swipe left, and then... Figure 16 Figure (b) shows the corresponding “Revenue”, “Profit” and “Liabilities” labels and corresponding table contents for the second branch, while the relevant prompt labels and corresponding table contents for the first branch are not shown.
[0118] Through the above-described embodiments of this application, by responding to a sliding operation triggered by the display view of the target table, the table content of the category indicated by the target prompt label currently displayed on the display screen is updated, thereby achieving flexible display of the table content.
[0119] As an optional implementation, the target hint label that matches the target content category title includes:
[0120] S1, when the display distance between two adjacent target prompt labels is less than the first threshold, the label content in the target prompt label is partially hidden and the prompt area occupied by each target prompt label is reduced;
[0121] S2, when the display distance between two adjacent target prompt labels is less than the second threshold, the two adjacent target prompt labels are merged and the merged prompt label is displayed. The merged prompt label includes: prompt information of at least one target prompt label and the number of merged labels. The second threshold is less than the first threshold.
[0122] It should be noted that the aforementioned display distance can refer to the distance between the centerlines of the two prompt labels, or it can refer to the distance between the boundaries of the two prompt labels. The method for determining the display distance is not specifically limited here. Specifically, the condition for hiding the prompt labels can be determined when the distance between the centerlines of the two prompt labels is less than a preset threshold. That is, in this embodiment, when the display areas of the two prompt labels are relatively close or overlap, the display method of the prompt labels is controlled and adjusted to improve the readability of the prompt labels.
[0123] As an alternative approach, the above-mentioned hiding process can be used when the label content is lengthy, hiding some characters and displaying them in the form of "...". For example, if the content of the prompt label is "revenue growth rate", the hidden prompt label content would be "revenue...".
[0124] The following combination Figure 17 The above methods will be explained.
[0125] like Figure 17 As shown in Figure (a) in the figure, multiple labels are displayed in the non-table view area of the figure. Suppose that the operation object is further reduced in the table in the figure, that is, the display distance between two adjacent prompt labels is less than the first threshold, if the display method of the prompt labels is not adjusted, the display result will be as shown in Figure (d) in 17, that is, the display range of multiple prompt labels will overlap, affecting the prompting effect of the prompt labels.
[0126] In this embodiment, the target object is further reduced. Figure 17 The table in Figure (a) will partially hide the label content in the tooltip label, i.e., it will be displayed as shown below. Figure 17As shown in Figure (b) of the diagram, the original "Revenue Growth Rate" label is hidden and displayed as "Revenue Growth...", the original "Profit Growth Rate" label is hidden and displayed as "Profit...", and the original "Debt Ratio" label is hidden and displayed as "Negative...". If the table in the diagram is further reduced in size, i.e., the display distance between two adjacent prompt labels is less than the second threshold, without adjusting the display method of the prompt labels, the display result will be as shown in Figure (e) of section 17. That is, the display range of multiple prompt labels will overlap, still affecting the prompt label's prompting effect.
[0127] In this embodiment, the target object is further reduced. Figure 17 The table in Figure (b) will merge adjacent target cue labels, displaying them as shown below. Figure 17 As shown in Figure (c), the labels "Revenue" and "Revenue Growth Rate" are merged into "Revenue Growth Rate ②", "Profit" and "Profit Growth Rate" are merged into "Profit Growth Rate ②", and "Liabilities" and "Liabilities Ratio" are merged into "Liabilities Ratio ②". This avoids overlapping labels and improves the display effect of the labels.
[0128] Through the above-described embodiments of this application, when the display distance between two adjacent target prompt labels is less than a first threshold, the label content in the target prompt labels is partially hidden, and the prompt area occupied by each target prompt label is reduced; when the display distance between two adjacent target prompt labels is less than a second threshold, the two adjacent target prompt labels are merged, and the merged prompt label is displayed. The merged prompt label includes: prompt information of at least one target prompt label, and the number of merged labels. The second threshold is less than the first threshold, thereby improving the display effect of table prompt labels and thus improving the display efficiency of table content.
[0129] As an optional implementation, after merging two adjacent target prompt labels and displaying the merged prompt label, the method further includes:
[0130] S1, if the number of target prompt labels being fused is greater than or equal to the third threshold, a reference prompt label is determined, wherein the classification priority of the reference prompt label is higher than the classification priority of the currently displayed target prompt label;
[0131] S2, display the reference prompt label.
[0132] It is understandable that in this embodiment, after displaying the merged prompt label, if the display size of the table is further reduced, the display method of the prompt label needs to be further adjusted to improve the prompt label's prompting effect.
[0133] In this embodiment, after displaying the fused prompt labels, if the number of target prompt labels being fused is greater than or equal to a third threshold, it indicates that the display efficiency of the fused prompt labels is reduced, and thus a higher-level prompt label needs to be displayed to improve the display efficiency of the prompt labels.
[0134] In one alternative approach, the number of target tooltip labels to be merged can be the number of tooltip labels that need to be merged. That is, if the number of tooltip labels requiring merging exceeds a target threshold, it indicates that there are too many tooltip labels on the current interface, affecting the display efficiency of the tooltip labels, and even further merging processing cannot solve the problem of reduced display efficiency.
[0135] In another alternative approach, the number of target prompt labels being merged can be the number of prompt labels obtained after merging. That is, if the number of prompt labels obtained after merging exceeds the target threshold, it indicates that the current number of labels is too high, affecting the display efficiency of the prompt labels, and therefore the label display method needs further adjustment.
[0136] Specific combination Figure 18 The above methods will be explained.
[0137] like Figure 18 Figure (a) shows the merged tooltip labels "Revenue Growth Rate ②", "Profit Growth Rate ②", and "Debt Ratio ②". Assuming no processing is applied to the tooltip labels, and the table size is further reduced, the result would be as follows: Figure 18 As shown in Figure (c), the number of fused prompt labels exceeds the preset threshold, resulting in overlapping prompt labels and affecting the display efficiency of the prompt labels.
[0138] In this embodiment, if the number of fused prompt tags exceeds a preset threshold, such as... Figure 18 As shown in Figure (b), higher-level prompt labels "Revenue", "Profit" and "Liabilities" are displayed, thereby improving the efficiency of prompt label display.
[0139] Through the above-described embodiments of this application, when the display distance between two adjacent target prompt labels is less than a first threshold, the label content in the target prompt labels is partially hidden, and the prompt area occupied by each target prompt label is reduced; when the display distance between two adjacent target prompt labels is less than a second threshold, the two adjacent target prompt labels are merged, and the merged prompt label is displayed. The merged prompt label includes: prompt information of at least one target prompt label, and the number of merged labels. The second threshold is less than the first threshold, thereby improving the display efficiency of the prompt labels.
[0140] As an optional implementation, after displaying the target hint label that matches the target content category title, the following is also included:
[0141] S1, in response to an adjustment operation triggered by the display view of the target table displaying the target tooltip label, adjust the table content in the currently displayed target table from the second display size to the third display size, wherein the second display size is smaller than the third display size;
[0142] S2, if the table content at the third display size does not meet the label hint conditions, hide the target hint label.
[0143] As an optional implementation, when the table content at the third display size does not meet the label prompting conditions, hiding the target prompt label includes: determining to hide the target prompt label when the third display size reaches the display size used to distinguish the meaning of characters in the table content.
[0144] The following combination Figure 19 The above methods will be explained.
[0145] like Figure 19 Figure (a) shows a table view at the second display scale, along with the tooltip labels “Revenue Growth Rate ②”, “Profit Growth Rate ②”, and “Debt Ratio ②”.
[0146] When the table's display view is zoomed in, it will first display something like... Figure 19 The display interface shown in Figure (b) shows that when the table display scale is enlarged, the merged table tooltips are restored to the hidden table tooltips “Revenue”, “Revenue Increase…”, “Profit”, “Profit…”, “Liabilities”, “Negative…”.
[0147] When the table's display view is further zoomed in, it will display as follows: Figure 19The display interface shown in Figure (c) shows that when the table display scale is enlarged, the hidden table tooltip labels “Revenue”, “Revenue Growth Rate”, “Profit”, “Profit”, “Liabilities”, and “Debt Ratio” are restored to “Revenue”, “Revenue Growth Rate”, “Profit”, “Profit Growth Rate”, “Liabilities”, and “Debt Ratio”.
[0148] When the table's display view is further magnified, i.e., displayed at a third display scale, it is determined whether the third display size reaches the display size used to distinguish the meaning of characters in the table content. Figure 19 The third display scale of Figure (d) in the table reaches the above display size, that is, the table content is displayed in an easy-to-read size, and the above prompt label is canceled.
[0149] It is understandable that the above steps can also represent different display methods corresponding to different magnification levels during a single zoom-in operation of a table. In other words, assuming the object being operated on is directly zoomed in during a single zoom-in operation... Figure 19 Figure (a) in the middle is enlarged to Figure 19 The display size in Figure (d) can be shown sequentially during this zoom-in operation, as follows: Figure 19 Figure (b) in the middle Figure 19 The final display effect shown in Figure (c) is as follows: Figure 19 The display effect of (d) in the figure.
[0150] Through the above-described embodiments of this application, in response to an adjustment operation triggered by the display view of a target table displaying a target hint label, the table content in the currently displayed target table is adjusted from a second display size to a third display size, wherein the second display size is smaller than the third display size; if the table content under the third display size does not meet the label hint conditions, the target hint label is hidden, thereby hiding the hint label and directly displaying the table content when the operation object enlarges the display size of the table and the enlarged table size is an easily readable display size, thus improving the display efficiency of the table content.
[0151] The following combination Figure 20 The following flowchart illustrates the complete process of the table content prompting method provided in this application:
[0152] S2002, the backend identifies column headers in the table;
[0153] S2004, hierarchically divides column headers and reports data to the front end;
[0154] Specifically, the table content is imported into the backend, the backend identifies and judges the table title information, and then divides the title hierarchy for cases with multiple titles and reports it to the frontend.
[0155] S2006: The front end determines whether the display size of the text in the column header is lower than the preset value. If yes, then execute S2008; otherwise, the label is not displayed.
[0156] S2008: Create a tag and determine whether there is any overlap between adjacent tags displayed in the specified area on the front end. If yes, execute S2010; otherwise, display the tag normally.
[0157] S2010: Reduce the width of overlapping tags by marking the text content within the overlapping tags, and determine whether there is still overlap with adjacent tags under the minimum tag width. If yes, execute S2012; otherwise, display the tags.
[0158] S2012: Group the overlapping adjacent tags, merge the content, and determine whether the number of grouped tags is greater than or equal to 3. If yes, execute S2014; otherwise, display the tags.
[0159] S2014: Based on the title information hierarchy transmitted from the backend, the frontend determines whether the table has a higher level of information. If so, S2016 is executed; otherwise, the label is displayed.
[0160] S2016, create tags based on the title content at a higher level.
[0161] Specifically, the above steps can be implemented in the following ways.
[0162] like Figure 17 As shown, the front-end performs real-time judgment on the text display size of the table title. If the font size is not lower than the preset value, the label is not displayed; if the font size is lower than the preset value, the content of the lowest level title in the table is extracted and the label is created, as shown below. Figure 17 As shown in Figure (a), it is also determined whether there is overlap between adjacent labels in the label display area.
[0163] If adjacent labels do not overlap, the labels will be displayed normally; if they overlap (e.g., ...), the labels will be displayed normally. Figure 17 As shown in Figure (d), the label text is dotted to shorten the label length, thereby avoiding overlap between adjacent labels, i.e. Figure 17 As shown in Figure (b). If the labels do not overlap after dotting, the labels are displayed; if the labels still overlap after dotting (as shown in Figure (b)). Figure 17 As shown in Figure (e), overlapping labels are grouped and merged, and the number of overlapping labels is displayed after grouping. Figure 17 As shown in Figure (c).
[0164] like Figure 18As shown, the front-end requires that there are fewer than 3 overlapping tags before merging and grouping them. If there are 3 or more overlapping tags, the next step of the judgment logic is performed.
[0165] like Figure 18 As shown in Figure (c), if there are three or more overlapping labels, it is determined whether the table has a higher-level heading. If not, the higher-level labels are not displayed; if so, the higher-level heading information is labeled, as shown in Figure (c). Figure 18 As shown in Figure (b), the processing logic is the same as described above. Every time a user zooms in or out of the table view, the front end needs to perform the above logic check and display the label content based on the check result.
[0166] In this embodiment of the invention, a target table is displayed on a display screen, wherein the target table includes a content category title; in response to an adjustment operation triggered by the display view of the target table, the table content in the currently displayed target table is adjusted from a first display size to a second display size, wherein the second display size is smaller than the first display size; when the table content under the second display size meets the label prompt conditions, the target content category title is extracted from the content category title; a target prompt label matching the target content category title is displayed, thereby displaying a prompt label for locating the table content when the table display size changes, making the table content unsuitable for browsing, thus solving the technical problem of the relatively simple display method of table content.
[0167] It should be noted that, for the sake of simplicity, the foregoing method embodiments are all described as a series of actions. However, those skilled in the art should understand that the present invention is not limited to the described order of actions, because according to the present invention, some steps can be performed in other orders or simultaneously. Furthermore, those skilled in the art should also understand that the embodiments described in the specification are preferred embodiments, and the actions and modules involved are not necessarily essential to the present invention.
[0168] According to another aspect of the present invention, a table content prompting device for implementing the above-described table content prompting method is also provided. For example... Figure 21 As shown, the device includes:
[0169] Display unit 2102 is used to display a target table on a display screen, wherein the target table includes content category titles;
[0170] The adjustment unit 2104 is used to adjust the table content in the currently displayed target table from a first display size to a second display size in response to an adjustment operation triggered by the display view of the target table, wherein the second display size is smaller than the first display size;
[0171] Extraction unit 2106 is used to extract the target content category title from the content category title when the table content under the second display size meets the label prompt condition;
[0172] The prompt unit 2108 is used to prompt a target prompt label that matches the target content category title.
[0173] Optionally, in this embodiment, the implementation of each of the above-mentioned unit modules can be referred to the above-mentioned method embodiments, which will not be repeated here.
[0174] According to another aspect of the present invention, an electronic device for implementing the above-described table content prompting method is also provided. This electronic device may be... Figure 22 The terminal device or server shown. This embodiment uses this electronic device as an example for illustration. Figure 22 As shown, the electronic device includes a memory 2202 and a processor 2204. The memory 2202 stores a computer program, and the processor 2204 is configured to execute the steps of any of the above method embodiments through the computer program.
[0175] Optionally, in this embodiment, the aforementioned electronic device may be located in at least one of a plurality of network devices in a computer network.
[0176] Optionally, in this embodiment, the processor can be configured to perform the following steps via a computer program:
[0177] S1, Display the target table on the display screen, wherein the target table includes content category titles;
[0178] S2, in response to an adjustment operation triggered by the display view of the target table, adjust the table content in the currently displayed target table from a first display size to a second display size, wherein the second display size is smaller than the first display size;
[0179] S3, if the table content in the second display size meets the label prompt conditions, extract the target content category title from the content category title;
[0180] S4, a target hint label that matches the target content category title.
[0181] Alternatively, as those skilled in the art will understand, Figure 22 The structure shown is for illustrative purposes only. Electronic devices can also be in-vehicle terminals, smartphones (such as Android phones, iOS phones, etc.), tablets, handheld computers, mobile internet devices (MIDs), PADs, and other terminal devices. Figure 22 This does not limit the structure of the aforementioned electronic devices. For example, the electronic device may also include components that are more... Figure 22 The more or fewer components shown (such as network interfaces, etc.), or having the same Figure 22 The different configurations shown.
[0182] The memory 2202 can be used to store software programs and modules, such as the program instructions / modules corresponding to the table content prompting method and device in this embodiment of the invention. The processor 2204 executes various functional applications and data processing by running the software programs and modules stored in the memory 2202, thereby realizing the aforementioned table content prompting method. The memory 2202 may include high-speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some instances, the memory 2202 may further include memory remotely located relative to the processor 2204, and these remote memories can be connected to the terminal via a network. Examples of such networks include, but are not limited to, the Internet, corporate intranets, local area networks, mobile communication networks, and combinations thereof. Specifically, the memory 2202 may be used, but is not limited to, to store information such as various elements in the viewing angle screen and table content prompting information. As an example, such as Figure 22 As shown, the memory 2202 may include, but is not limited to, the display unit 2102, adjustment unit 2104, retrieval unit 2106, and prompting unit 2108 of the table content prompting device. Furthermore, it may include, but is not limited to, other module units of the table content prompting device, which will not be described further in this example.
[0183] Optionally, the transmission device 2206 described above is used to receive or send data via a network. Specific examples of the network described above may include wired networks and wireless networks. In one example, the transmission device 2206 includes a Network Interface Controller (NIC), which can be connected to other network devices and routers via a network cable to communicate with the Internet or a local area network. In another example, the transmission device 2206 is a radio frequency (RF) module, used for wireless communication with the Internet.
[0184] In addition, the above-mentioned electronic device also includes a display 2208 and a connection bus 2210 for connecting the various module components in the above-mentioned electronic device.
[0185] In other embodiments, the aforementioned terminal device or server can be a node in a distributed system, wherein the distributed system can be a blockchain system, which is a distributed system formed by connecting multiple nodes through network communication. The nodes can form a peer-to-peer (P2P) network, and any form of computing device, such as a server, terminal, or other electronic device, can become a node in the blockchain system by joining this peer-to-peer network.
[0186] According to one aspect of this application, a computer program product is provided, comprising a computer program / instructions containing program code for performing the methods shown in the flowchart. In such embodiments, the computer program can be downloaded and installed from a network via a communication component, and / or installed from a removable medium. When the computer program is executed by a central processing unit, it performs various functions provided in embodiments of this application.
[0187] The sequence numbers of the above embodiments of the present invention are for descriptive purposes only and do not represent the superiority or inferiority of the embodiments.
[0188] According to one aspect of this application, a computer-readable storage medium is provided, wherein a processor of a computer device reads computer instructions from the computer-readable storage medium, and the processor executes the computer instructions, causing the computer device to perform the above-described table content display method.
[0189] Optionally, in this embodiment, the computer-readable storage medium may be configured to store a computer program for performing the following steps:
[0190] S1, Display the target table on the display screen, wherein the target table includes content category titles;
[0191] S2, in response to an adjustment operation triggered by the display view of the target table, adjust the table content in the currently displayed target table from a first display size to a second display size, wherein the second display size is smaller than the first display size;
[0192] S3, if the table content in the second display size meets the label prompt conditions, extract the target content category title from the content category title;
[0193] S4, a target hint label that matches the target content category title.
[0194] Optionally, in this embodiment, those skilled in the art will understand that all or part of the steps in the various methods of the above embodiments can be implemented by a program instructing the hardware related to the terminal device. The program can be stored in a computer-readable storage medium, which may include: flash drive, read-only memory (ROM), random access memory (RAM), disk or optical disk, etc.
[0195] If the integrated units in the above embodiments are implemented as software functional units and sold or used as independent products, they can be stored in the aforementioned computer-readable storage medium. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or all or part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause one or more computer devices (which may be personal computers, servers, or network devices, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention.
[0196] In the above embodiments of the present invention, the descriptions of each embodiment have different focuses. For parts not described in detail in a certain embodiment, please refer to the relevant descriptions of other embodiments.
[0197] In the several embodiments provided in this application, it should be understood that the disclosed client can be implemented in other ways. The device embodiments described above are merely illustrative; for example, the division of units described above is only 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. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be through some interfaces, indirect coupling or communication connection between units or modules, and may be electrical or other forms.
[0198] The units described above 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 can be selected to achieve the purpose of this embodiment according to actual needs.
[0199] Furthermore, the functional units in the various embodiments of the present invention can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. The integrated unit can be implemented in hardware or as a software functional unit.
[0200] The above description is only a preferred embodiment of the present invention. It should be noted that for those skilled in the art, several improvements and modifications can be made without departing from the principle of the present invention, and these improvements and modifications should also be considered within the scope of protection of the present invention.
Claims
1. A method for displaying table content, characterized in that, include: Display the target table on the display screen, wherein the target table includes content category titles; In response to an adjustment operation triggered by the display view of the target table, the table content in the currently displayed target table is adjusted from a first display size to a second display size, wherein the second display size is smaller than the first display size; When the content category title includes at least two levels of content category titles, and the second display size is smaller than the display size used to distinguish the meaning of characters in the table content, the first level content category title and the second level content category title are extracted from the at least two levels of content category titles according to the classification priority, wherein the classification priority of the second level content category title is higher than the classification priority of the first level content category title; If the prompt tags corresponding to the extracted multiple first-level content category titles do not meet the tag overlap display condition, the first-level content category title shall be used as the target content category title; or, if the prompt tags corresponding to the extracted multiple first-level content category titles meet the tag overlap display condition, the second-level content category title shall be used as the target content category title. If the display distance between two adjacent target prompt labels that match the target content category title is less than a first threshold, the label content in the target prompt label is partially hidden. If the display distance between two adjacent target prompt labels is less than a second threshold, prompt information of at least one of the target prompt labels is displayed, wherein the second threshold is less than the first threshold.
2. The method according to claim 1, characterized in that, If the prompt tags corresponding to the extracted multiple first-level content category titles do not meet the tag overlap display condition, the first-level content category title is used as the target content category title; or, if the prompt tags corresponding to the extracted multiple first-level content category titles meet the tag overlap display condition, after using the second-level content category title as the target content category title, the method further includes: The target prompt label is created based on the target content category title.
3. The method according to claim 2, characterized in that, The creation of the target prompt label based on the target content category title includes at least one of the following: Determine the category tag of the category to which the target content category title belongs; use the category tag as the target prompt tag; The category title of the target content is used as the target prompt label.
4. The method according to claim 1, characterized in that, If the display distance between two adjacent target prompt labels that match the target content category title is less than a first threshold, the label content in the target prompt label is partially hidden. When the display distance between two adjacent target prompt labels is less than a second threshold, prompt information for at least one of the target prompt labels is displayed, wherein the second threshold is less than the first threshold, including: Determine the display parameters of the table content in the target table that is categorized based on the target content category title; The target prompt label is displayed in a display area outside the display view of the target table, and in a prompt area that matches the display parameters.
5. The method according to claim 4, characterized in that, In the display area outside the display view of the target table, and within the prompt area that matches the display parameters, the prompt label for the target table includes: When the target content category title is a column header, the target prompt label is displayed in a prompt area that matches the total column width of the table content in the category indicated by the target content category title; When the target content category title is a row title, the target prompt label is displayed in a prompt area that matches the total row height of the table content in the category indicated by the target content category title.
6. The method according to claim 1, characterized in that, If the display distance between two adjacent target prompt labels that match the target content category title is less than a first threshold, the label content in the target prompt label is partially hidden. If the display distance between two adjacent target prompt labels is less than a second threshold, display prompt information for at least one of the target prompt labels, wherein after the second threshold is less than the first threshold, the method further includes: In response to the positioning operation performed on the key prompt label in the target prompt label, the display view of the target table displayed on the display screen is positioned to the location of the table content of the category indicated by the key content category title that matches the key prompt label; Highlight the table content indicated by the key content category headings.
7. The method according to claim 1, characterized in that, If the display distance between two adjacent target prompt labels that match the target content category title is less than a first threshold, the label content in the target prompt label is partially hidden. If the display distance between two adjacent target prompt labels is less than a second threshold, display prompt information for at least one of the target prompt labels, wherein after the second threshold is less than the first threshold, the method further includes: In response to a swipe operation triggered by a display view of the target table, update the table content of the category indicated by the target tooltip currently displayed on the display screen.
8. The method according to claim 1, characterized in that, After partially hiding the label content in the target prompt labels, the method further includes: reducing the prompt area occupied by each target prompt label; When the display distance between two adjacent target prompt labels is less than a second threshold, displaying prompt information for at least one target prompt label includes: performing a fusion process on the two adjacent target prompt labels and displaying the fused prompt label, wherein the fused prompt label includes: prompt information for at least one target prompt label and the number of fused labels, and the second threshold is less than the first threshold.
9. The method according to claim 8, characterized in that, After merging two adjacent target prompt labels and displaying the merged prompt label, the method further includes: If the number of target prompt labels being merged is greater than or equal to a third threshold, a reference prompt label is determined, wherein the classification priority of the reference prompt label is higher than the classification priority of the currently displayed target prompt label; Display the reference prompt label.
10. The method according to claim 1, characterized in that, If the display distance between two adjacent target prompt labels that match the target content category title is less than a first threshold, the label content in the target prompt label is partially hidden. If the display distance between two adjacent target prompt labels is less than a second threshold, display prompt information for at least one of the target prompt labels, wherein after the second threshold is less than the first threshold, the method further includes: In response to an adjustment operation triggered on the display view of the target table displaying the target tooltip label, the table content in the currently displayed target table is adjusted from the second display size to the third display size, wherein the second display size is smaller than the third display size; If the table content at the third display size does not meet the label prompt conditions, the target prompt label is hidden.
11. The method according to claim 10, characterized in that, If the table content at the third display size does not meet the label prompting conditions, hiding the target prompt label includes: If the third display size reaches the display size used to distinguish the meaning of characters in the table content, the target prompt label is hidden.
12. A table content display device, characterized in that, include: A display unit is used to display a target table on a display screen, wherein the target table includes content category titles; An adjustment unit is configured to, in response to an adjustment operation triggered by the display view of the target table, adjust the table content in the currently displayed target table from a first display size to a second display size, wherein the second display size is smaller than the first display size; The extraction unit is configured to, when the content category title includes at least two layers of content category titles, and the second display size is smaller than the display size used to distinguish the meaning of characters in the table content, extract a first-level content category title and a second-level content category title from the at least two layers of content category titles according to category priority, wherein the category priority of the second-level content category title is higher than that of the first-level content category title; if the prompt tags corresponding to the extracted multiple first-level content category titles do not meet the label overlap display condition, the first-level content category title is used as the target content category title; or, if the prompt tags corresponding to the extracted multiple first-level content category titles meet the label overlap display condition, the second-level content category title is used as the target content category title. The prompting unit is configured to partially hide the label content in the target prompting label when the display distance between two adjacent target prompting labels that match the target content category title is less than a first threshold; and to display prompt information for at least one target prompting label when the display distance between two adjacent target prompting labels is less than a second threshold, wherein the second threshold is less than the first threshold.
13. A computer-readable storage medium, characterized in that, The computer-readable storage medium includes a stored program, wherein the program, when executed, performs the method described in any one of claims 1 to 11.
14. A computer program product comprising a computer program / instructions, characterized in that, When the computer program / instructions are executed by the processor, they implement the steps of the method according to any one of claims 1 to 11.
15. An electronic device comprising a memory and a processor, characterized in that, The memory stores a computer program, and the processor is configured to execute the method described in any one of claims 1 to 11 through the computer program.