Spreadsheet display method and apparatus, electronic device, and storage medium

By dividing spreadsheets into list cells and generating navigation information on terminal devices, and utilizing navigation labels and vertical display, the problem of frequent scrolling in tables with many columns is solved, improving viewing efficiency and user experience.

CN114997126BActive Publication Date: 2025-11-28BEIJING 58 INFORMATION TTECH CO LTD
View PDF 3 Cites 0 Cited by

Patent Information

Application Number
CN202210635882.3
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-06-07
Publication Date
2025-11-28
Estimated Expiration
2042-06-07

AI Technical Summary

Technical Problem

When viewing and editing spreadsheets with many columns on a terminal device, existing technologies require users to frequently swipe the screen, resulting in low efficiency.

Method used

By dividing the table into multiple list units, navigation information is generated and displayed on the terminal screen in a width-adaptive manner, reducing scrolling operations by utilizing the vertical display of navigation labels and list content.

Benefits of technology

It improves the efficiency of viewing spreadsheets, enhances user productivity and experience, and reduces reliance on screen scrolling.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN114997126B_ABST
    Figure CN114997126B_ABST
Patent Text Reader

Abstract

The application provides an electronic form display method and device, an electronic device and a storage medium. A method comprises: determining a target list unit in a plurality of list units of a target form, and generating navigation information; displaying the navigation information in a first display area of a terminal screen, and displaying at least list content corresponding to a currently selected navigation tab in the navigation information in a width adaptation manner in a second display area of the terminal screen. The viewing efficiency of the electronic form can be improved, and the work efficiency of a user can be improved. Another method comprises: redetermining a target list unit in a plurality of list units of a target form, and regenerating navigation information; displaying the regenerated navigation information in the first display area, and displaying at least list content corresponding to a currently selected navigation tab in the regenerated navigation information in a width adaptation manner in the second display area. A user can conveniently view corresponding list content according to switched navigation information.
Need to check novelty before this filing date? Find Prior Art

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of computer, in particular to an electronic form display method and device, electronic equipment and storage medium. BACKGROUND

[0002] With the rapid development of computer technology and terminal technology, mobile phones, tablet computers, notebook computers, desktop computers and other terminals have gradually become popular and become important tools for people's life and work. In the process of using the terminal, the user often needs to view and edit the electronic form, and the electronic form needs to be displayed on the terminal.

[0003] At present, when displaying the electronic form on the terminal, the row and column information of the electronic form is usually displayed in a flat manner.

[0004] In many application scenarios, such as daily management of human resources, the electronic form involved is usually a form with a large number of columns, which has a large width value. Such an electronic form needs to be scrolled left and right to view all column information when displayed on a PC (Personal Computer) terminal such as a notebook computer or a desktop computer. The screen width of a mobile terminal such as a mobile phone or a tablet computer is even more limited, and multiple left and right scrolling is required to view the column information.

[0005] Therefore, the current display method is not convenient for the user to view and edit the electronic form, and reduces the user's work efficiency. SUMMARY

[0006] The electronic form display method and device, electronic equipment and storage medium provided by the embodiments of the present application facilitate the user to view and edit the electronic form and improve the user's work efficiency.

[0007] To solve the above technical problems, the present application provides the following technical solutions:

[0008] In a first aspect, the embodiments of the present application provide an electronic form display method, comprising:

[0009] Receiving a target view conversion trigger instruction for a target form, the target form comprising a plurality of list units, the list unit being obtained by dividing the target form according to a first direction dimension;

[0010] Determining a target list unit in the plurality of list units of the target form, generating navigation information based on the target list unit, the navigation information comprising at least one navigation label;

[0011] The navigation information is displayed in a first display area of the terminal screen, and list content corresponding to a currently selected navigation tab in the navigation information is displayed in a width-adaptive manner in a second display area of the terminal screen, the list content corresponding to the currently selected navigation tab at least including list content corresponding to the currently selected navigation tab in a second direction dimension, the second direction dimension being perpendicular to the first direction dimension.

[0012] In an embodiment of the present application, the generating the navigation information based on the target list unit comprises:

[0013] The navigation information is generated according to content cells of the target list unit, each navigation tab in the navigation information corresponding to content of each content cell of the target list unit.

[0014] In an embodiment of the present application, the determining the target list unit from the plurality of list units of the target table comprises:

[0015] The target list unit is determined from the plurality of list units of the target table according to list unit information carried in the target view conversion trigger instruction; or

[0016] The first list unit of the target table is determined as the target list unit.

[0017] In an embodiment of the present application, the currently selected navigation tab is determined by:

[0018] A navigation tab at a first position in the first display area is determined as the currently selected navigation tab; or

[0019] In response to a first selection operation on a navigation tab in the navigation information, the navigation tab targeted by the first selection operation is determined as the currently selected navigation tab; or

[0020] In response to a sliding operation on a navigation tab in the navigation information, navigation tabs of the navigation information are displayed in the first display area by scrolling, and in a case where a second selection operation is detected, the navigation tab targeted by the second selection operation is determined as the currently selected navigation tab.

[0021] In an embodiment of the present application, after the displaying the list content corresponding to the currently selected navigation tab in the navigation information in the second display area of the terminal screen in a width-adaptive manner, the method further comprises:

[0022] In response to a sliding operation on the list content in the second display area, different list content is displayed by scrolling in the second display area, the currently selected navigation tab is switched to a navigation tab corresponding to the list content at a second position in the second display area, and the first display area is displayed; or

[0023] In response to a third selection operation on the list content switching control in the second display area, the list content is displayed by switching in the second display area, the currently selected navigation tab is switched to a navigation tab corresponding to the switched list content, and the first display area is displayed.

[0024] In one specific embodiment of the present application, the method further comprises:

[0025] In response to a switching trigger instruction on the target list unit in the first display area, the target list unit is re-determined in the plurality of list units of the target table, the steps of generating navigation information based on the target list unit, displaying the navigation information in the first display area of the terminal screen, and displaying the list content corresponding to the currently selected navigation tab in the navigation information in the second display area of the terminal screen in a width adaptive manner are repeatedly performed.

[0026] In one specific embodiment of the present application, the list content corresponding to the currently selected navigation tab includes the list content corresponding to the currently selected navigation tab in the second direction dimension and the tab content of the currently selected navigation tab.

[0027] In a second aspect, an embodiment of the present application provides an electronic table display method, comprising:

[0028] A switching trigger instruction on a target list unit of a target table is received, the current view of the target table is a target view, navigation information of the target table is displayed in a first display area of a terminal screen, and list content corresponding to a currently selected navigation tab in the navigation information is displayed in a second display area of the terminal screen in a width adaptive manner, the navigation information is information generated based on a target list unit determined in a plurality of list units of the target table, the navigation information includes at least one navigation tab, the list units are obtained by dividing the target table in a first direction dimension, the list content of the currently selected navigation tab includes at least list content corresponding to the currently selected navigation tab in a second direction dimension, and the second direction dimension is perpendicular to the first direction dimension;

[0029] The target list unit is re-determined in the plurality of list units of the target table, and the navigation information is re-generated based on the re-determined target list unit;

[0030] display the regenerated navigation information in the first display area, and display at least the list content corresponding to the currently selected navigation tab in the navigation information in a width-adaptive manner in the second display area.

[0031] In a third aspect, an embodiment of the present application provides an electronic table display device, comprising:

[0032] A first receiving unit is configured to receive a target view conversion trigger instruction for a target table, wherein the target table comprises a plurality of list units, and each list unit is obtained by dividing the target table in a first direction dimension;

[0033] A first generating unit is configured to determine a target list unit from the plurality of list units of the target table, and generate navigation information based on the target list unit, wherein the navigation information comprises at least one navigation tab;

[0034] A first display unit is configured to display the navigation information in a first display area of a terminal screen, and display at least the list content corresponding to the currently selected navigation tab in the navigation information in a width-adaptive manner in a second display area of the terminal screen, wherein the list content corresponding to the currently selected navigation tab at least comprises the list content corresponding to the currently selected navigation tab in a second direction dimension, and the second direction dimension is perpendicular to the first direction dimension.

[0035] In an embodiment of the present application, the first generating unit is configured to:

[0036] generate the navigation information according to the content cell order of the target list unit, and each navigation tab in the navigation information corresponds to the content of each content cell of the target list unit.

[0037] In an embodiment of the present application, the first generating unit is configured to:

[0038] determine the target list unit from the plurality of list units of the target table according to the list unit information carried in the target view conversion trigger instruction; or

[0039] determine the first list unit of the target table as the target list unit.

[0040] In an embodiment of the present application, further comprising a determining unit configured to determine the currently selected navigation tab by the following steps:

[0041] determine the navigation tab at a first position in the first display area as the currently selected navigation tab; or

[0042] In response to a first selection operation on a navigation tag in the navigation information, the navigation tag targeted by the first selection operation is determined as the currently selected navigation tag; or

[0043] In response to a sliding operation on a navigation tag in the navigation information, navigation tags of the navigation information are displayed in the first display area in a scrolling manner, and in a case where a second selection operation is detected, the navigation tag targeted by the second selection operation is determined as the currently selected navigation tag.

[0044] In an embodiment of the present application, the first display unit is further configured to:

[0045] After the list content corresponding to the currently selected navigation tag in the navigation information is displayed in the second display area of the terminal screen in a width-adaptive manner, in response to a sliding operation on the list content in the second display area, different list content is displayed in the second display area in a scrolling manner, the currently selected navigation tag is switched to a navigation tag corresponding to the list content located at a second position in the second display area, and the navigation tag is displayed in the first display area; or

[0046] In response to a third selection operation on a list content switching control in the second display area, the list content is displayed in the second display area in a switching manner, the currently selected navigation tag is switched to a navigation tag corresponding to the switched list content, and the navigation tag is displayed in the first display area.

[0047] In an embodiment of the present application, the first display unit is further configured to:

[0048] In response to a switching trigger instruction on the target list unit in the first display area, the target list unit is re-determined among the plurality of list units of the target table, and the first generation unit is triggered to repeatedly perform the steps of generating navigation information based on the target list unit, displaying the navigation information in the first display area of the terminal screen, and displaying list content corresponding to a currently selected navigation tag in the navigation information in the second display area of the terminal screen in a width-adaptive manner.

[0049] In an embodiment of the present application, the list content corresponding to the currently selected navigation tag includes list content corresponding to the currently selected navigation tag in the second direction dimension and tag content of the currently selected navigation tag.

[0050] In a fourth aspect, an embodiment of the present application provides an electronic spreadsheet display device, comprising:

[0051] The second receiving unit is configured to receive a target list unit switching trigger instruction for a target table, the current view of the target table being a target view, navigation information of the target table being displayed in a first display area of a terminal screen, and list content corresponding to a currently selected navigation label in the navigation information being displayed in a second display area of the terminal screen in a width adaptation manner, the navigation information being generated based on a target list unit determined from a plurality of list units of the target table, the navigation information including at least one navigation label, the list units being obtained by dividing the target table in a first direction dimension, and the list content of the currently selected navigation label including at least list content corresponding to the currently selected navigation label in a second direction dimension, the second direction dimension being perpendicular to the first direction dimension.

[0052] The second generating unit is configured to redetermine the target list unit from the plurality of list units of the target table, and regenerate the navigation information based on the redetermined target list unit.

[0053] The second display unit is configured to display the regenerated navigation information in the first display area, and display list content corresponding to a currently selected navigation label in the regenerated navigation information in the second display area in a width adaptation manner.

[0054] In a fifth aspect, an embodiment of the present application provides an electronic device, including a processor, a memory, and a computer program stored in the memory and executable on the processor, when the computer program is executed by the processor, the computer program implements the electronic table display method in the first aspect, and / or the steps of the electronic table display method in the second aspect.

[0055] In a sixth aspect, an embodiment of the present application provides a computer readable storage medium, the computer readable storage medium storing a computer program, when the computer program is executed by a processor, the computer program implements the electronic table display method in the first aspect, and / or the steps of the electronic table display method in the second aspect.

[0056] In a seventh aspect, an embodiment of the present application provides a computer program product, the computer program product including computer instructions stored in a computer readable storage medium, and adapted to be read and executed by a processor, so that an electronic device with the processor executes the electronic table display method in the first aspect, and / or the steps of the electronic table display method in the second aspect.

[0057] By means of the technical solution provided in the embodiment of the present application, the current view of the target table is converted into the target view, the list content corresponding to the currently selected navigation label in the second display area of the terminal screen can be conveniently viewed through the navigation information in the first display area of the terminal screen, and the list content displayed in the second display area is adapted to the width of the second display area, so that the user can view the list content corresponding to the currently selected navigation label in the navigation information without left and right sliding, the viewing efficiency of the electronic table is improved, the work efficiency of the user is improved, and the use experience of the user is improved.

[0058] In addition, by switching the target list unit, the navigation information displayed in the first display area is also switched, so that the user can conveniently view the corresponding list content according to the switched navigation information, and the user demand can be better met.

[0059] It should be understood that the foregoing general description and the following detailed description are only exemplary and explanatory, and cannot limit the present application. BRIEF DESCRIPTION OF DRAWINGS

[0060] Figure 1 An implementation flowchart of an electronic table display method in the embodiment of the present application;

[0061] Figure 2 A default view display schematic diagram of an electronic table in the embodiment of the present application;

[0062] Figure 3 A target view display schematic diagram of an electronic table in the embodiment of the present application;

[0063] Figure 4 A schematic diagram of operating navigation information in the embodiment of the present application;

[0064] Figure 5 Another schematic diagram of operating navigation information in the embodiment of the present application;

[0065] Figure 6 A schematic diagram of switching list content in the embodiment of the present application;

[0066] Figure 7 A schematic diagram of switching a target list unit in the embodiment of the present application;

[0067] Figure 8 A schematic diagram of displaying label content of a navigation label in the embodiment of the present application;

[0068] Figure 9 An implementation flowchart of another electronic table display method in the embodiment of the present application

[0069] Figure 10 A schematic diagram of another electronic table display method in the embodiment of the present applicationFigure 1 A structural schematic diagram of a corresponding electronic table display device;

[0070] Figure 11 A structural schematic diagram of a corresponding electronic table display device; Figure 9 A structural schematic diagram of a corresponding electronic table display device;

[0071] Figure 12 A structural schematic diagram of a corresponding electronic table display device; DETAILED DESCRIPTION

[0072] The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are some but not all of the embodiments of the present application. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative work fall within the protection scope of the present application.

[0073] The core of the present application is to provide an electronic table display method, which can be applied to terminals such as mobile phones, tablet computers, notebook computers and desktop computers, etc. with operating systems and capable of displaying electronic tables. When the terminal receives a target view conversion trigger instruction for a target table, the terminal determines a target list unit in a plurality of list units of the target table, the list units of the target table being obtained by dividing the target table according to a first direction dimension, and then generates navigation information based on the target list unit, displays the navigation information in a first display area of a terminal screen, and displays at least the list content corresponding to the currently selected navigation tab in the navigation information in a second display area of the terminal screen in a width adaptation manner. The list content corresponding to the currently selected navigation tab at least includes the list content corresponding to the currently selected navigation tab in a second direction dimension, and the second direction dimension is perpendicular to the first direction dimension. In this way, the current view of the target table can be converted into the target view, and the list content corresponding to the currently selected navigation tab in the navigation information can be conveniently viewed in the second display area of the terminal screen through the navigation information in the first display area of the terminal screen, and the list content displayed in the second display area is adapted to the width of the second display area, so that the user can view the list content corresponding to the currently selected navigation tab in the navigation information without left and right sliding, which can improve the viewing efficiency of the electronic table, improve the work efficiency of the user, and improve the user experience.

[0074] Referring to Figure 1 An implementation flowchart of an electronic table display method provided by an embodiment of the present application is shown, which can include the following steps:

[0075] S110: receiving a target view conversion trigger instruction for a target table.

[0076] The target table includes a plurality of list units, and the list units are obtained by dividing the target table according to a first direction dimension.

[0077] In the embodiment of the present application, the target table can be any one of the electronic tables including a plurality of list units. The list units of the target table are obtained by dividing the target table according to a first direction dimension. The first direction dimension can be a row dimension or a column dimension. If the first direction dimension is the row dimension, the list units of the target table can be each row of the target table. If the first direction dimension is the column dimension, the list units of the target table can be each column of the target table.

[0078] The current view of the target table displayed in the terminal can be a default view, that is, the row and column information is tiled. As shown in FIG. 1, Figure 2 As shown in FIG. 1, it is a statistical report of “department position record statistics”, including a plurality of columns, and the column fields include “effective date”, “change type”, “employee name”, “employee type”, “affiliated organization”, “post name”, “work location” and the like. The display of the statistical report in the terminal is according to the default view. Limited by the width of the terminal screen, the current terminal screen can only display three or four column information of the statistical report, and the user needs to slide left and right to view the information of other columns.

[0079] The target view conversion control can be provided for the user, and the target view can also be referred to as an immersive view, such as Figure 2 the “immersive view” button displayed in the upper right corner of FIG. 1. When the user has a target view conversion demand, the user can trigger the conversion operation of the target view through the target view conversion control, and issue a corresponding target view conversion trigger instruction.

[0080] After receiving the target view conversion trigger instruction for the target table, the subsequent step operation can be continued.

[0081] S120: determining a target list unit in the plurality of list units of the target table, and generating navigation information based on the target list unit.

[0082] The navigation information includes at least one navigation label.

[0083] In the embodiment of the present application, when the target view conversion trigger instruction for the target table is received, it can be considered that there is a demand to convert to the target view at present. One of the plurality of list units of the target table can be selected and determined as the target list unit. For example, the first list unit of the target table is determined as the target list unit, or other specified list unit of the target table is determined as the target list unit. The target list unit can be any one of the plurality of list units included in the target table.

[0084] After the target list unit is determined in the plurality of list units of the target table, navigation information can be generated based on the target list unit, and the navigation information can include at least one navigation label. Each navigation label in the navigation information can correspond to the content of each cell of the target list unit. For example, if the target list unit is a column of the target table, the navigation information generated based on the target list unit includes each navigation label corresponding to the content of each cell in the column. Similarly, if the target list unit is a row of the target table, the navigation information generated based on the target list unit includes each navigation label corresponding to the content of each cell in the row.

[0085] As shown in FIG. 1, the first column in the “Department Record Statistics” statistical report, i.e., the column field is “Effective Date”, is determined as the target list unit. The navigation information generated based on the target list unit includes each navigation label corresponding to the content of each cell in the column, which are 2022-01-01, 2021-12-01, 2021-11-01, etc. Figure 3

[0086] S130: The navigation information is displayed in the first display area of the terminal screen, and the list content corresponding to the currently selected navigation label in the navigation information is displayed in the second display area of the terminal screen in a width-adaptive manner.

[0087] The list content corresponding to the currently selected navigation label includes at least the list content corresponding to the currently selected navigation label in the second direction dimension, and the second direction dimension is perpendicular to the first direction dimension.

[0088] In the embodiments of the present application, when the target view is converted, the terminal screen can be divided into at least two display areas, including a first display area and a second display area. The arrangement positions of the first display area and the second display area can be pre-set, such as shown in FIG. 1. Figure 3 As shown in FIG. 1, the first display area, i.e., the left area of the terminal screen, and the second display area, i.e., the right area of the terminal screen, are arranged left and right in the terminal screen.

[0089] After the target list unit is determined in the plurality of list units of the target table, and the navigation information is generated based on the target list unit, the navigation information can be displayed in the first display area of the terminal screen. Specifically, the navigation labels included in the navigation information can be displayed vertically.

[0090] Meanwhile, the list content corresponding to the currently selected navigation label in the navigation information can be displayed in the second display area of the terminal screen in a width-adaptive manner. The list content corresponding to the currently selected navigation label includes at least the list content corresponding to the currently selected navigation label in the second direction dimension. The second direction dimension is perpendicular to the first direction dimension. ​

[0091] For example, the first direction dimension is column dimension and the second direction dimension is row dimension, i.e. the target list cell is a column of the target table, and each navigation label included in the navigation information generated based on the target list cell corresponds to the content of each cell in the column, and for any one navigation label, the list content corresponding to the navigation label at least includes the list content corresponding to the navigation label in the row dimension, i.e. at least includes the list content of the row where the navigation label is located.

[0092] Likewise, if the first direction dimension is row dimension and the second direction dimension is column dimension, the target list cell is a row of the target table, and each navigation label included in the navigation information generated based on the target list cell corresponds to the content of each cell in the row, and for any one navigation label, the list content corresponding to the navigation label at least includes the list content corresponding to the navigation label in the column dimension, i.e. at least includes the list content of the column where the navigation label is located.

[0093] At the beginning of switching to the target view, each navigation label included in the navigation information can be sequentially displayed in the first display area, and the first navigation label is located at the top of the first display area, and the first navigation label can be determined as the currently selected navigation label. If there are many navigation labels, some of the navigation labels will not be visible in the first display area.

[0094] The list content corresponding to each navigation label can be sequentially displayed in the second display area in a width adaptive manner, and the list content corresponding to the first navigation label, i.e. the currently selected navigation label, is located at the top of the second display area.

[0095] If the list content corresponding to the currently selected navigation label is large, the second display area can only display all or part of the list content corresponding to the currently selected navigation label, and other list content corresponding to the currently selected navigation label or list content corresponding to other navigation labels is not visible in the second display area.

[0096] If the list content corresponding to the currently selected navigation label is small, the second display area can display the list content corresponding to other navigation labels, such as the second, third, etc. navigation labels, in addition to displaying all the list content corresponding to the currently selected navigation label.

[0097] Subsequently, the switching of the currently selected navigation label can be performed in the first display area according to the operation action of the user, and the list content corresponding to the currently selected navigation label is displayed in the second display area. The currently selected navigation label in the first display area is linked to the list content displayed in the second display area.

[0098] For example, Figure 3In the middle, the left area of the terminal screen is the first display area, and the right area is the second display area. The first navigation tab in the navigation information is the currently selected navigation tab, and the tab content of the currently selected navigation tab is "2022-01-01". The corresponding list content can include field names and specific cell contents, as follows:

[0099] Effective date: 2022-01-01;

[0100] Transaction type: transfer;

[0101] Employee name: Zhang San;

[0102] Employee type: regular employee;

[0103] Affiliated organization: A department;

[0104] Post name: Senior interaction designer;

[0105] Work location: Beijing headquarters-A1 building.

[0106] The above list content can be displayed in the second display area in a width adaptive manner.

[0107] The so-called width adaptive display means that the total width of the list content displayed in the second display area is less than or equal to the width of the second display area. If a certain item of information in the list content is too long, it can be displayed by line breaks or font size changes for all items of information, so that the total width of the displayed list content is less than or equal to the width of the second display area. This way, users don't need to swipe left and right to view information, making it easier for users to operate.

[0108] It should be noted that the second display area of the terminal screen can only display the list content corresponding to the currently selected navigation tab in the first display area. In addition to displaying the list content corresponding to the currently selected navigation tab in the first display area, it can also display the list content corresponding to the navigation tab before and / or after the currently selected navigation tab in the first display area.

[0109] For example, Figure 3 In the middle, the currently selected navigation tab in the first display area is the first navigation tab, and the corresponding list content is the content of the row where "2022-01-01" is located in the original table. Because the list content corresponding to the currently selected navigation tab is less, in addition to displaying the content of the row where "2022-01-01" is located in the second display area, the list content corresponding to the second navigation tab, i.e. the content of the row where "2021-12-01" is located, is also displayed.

[0110] By the method provided in the embodiment of the application, the current view of the target table is converted into the target view, the list content corresponding to the currently selected navigation label in the second display area of the terminal screen can be conveniently viewed through the navigation information in the first display area of the terminal screen, and the list content displayed in the second display area is adapted to the width of the second display area, so that the user can view the list content corresponding to the currently selected navigation label in the navigation information without left and right sliding, the viewing efficiency of the electronic table is improved, the work efficiency of the user is improved, and the use experience of the user is improved.

[0111] In an embodiment of the application, the generating of the navigation information based on the target list unit can include the following steps:

[0112] The navigation information is generated according to the content cell order of the target list unit, and each navigation label in the navigation information corresponds to the content of each content cell of the target list unit.

[0113] In the embodiment of the application, the target list unit determined from the multiple list units of the target table includes the field cell and at least one content cell, the navigation information is generated according to the content cell order of the target list unit, and each navigation label in the generated navigation information corresponds to the content of each content cell of the target list unit.

[0114] For example, the target list unit includes the field cell and three content cells, which are arranged in the content cell order as content cell 1, content cell 2 and content cell 3, the first navigation label in the generated navigation information corresponds to the content of the content cell 1, the second navigation label corresponds to the content of the content cell 2, and the third navigation label corresponds to the content of the content cell 3.

[0115] The navigation information generated according to the content cell order of the target list unit is consistent with the target list unit in the target table, and is more consistent with the viewing habit of the user. If the order is disturbed, the navigation information will be inconsistent with the target list unit in the target table, which may cause the user to fail to align the information between the target table and the navigation information when viewing the navigation information, and confusion occurs.

[0116] In an embodiment of the application, the determining of the target list unit from the multiple list units of the target table can include the following steps:

[0117] The target list unit is determined from the multiple list units of the target table according to the list unit information carried in the target view conversion trigger instruction.

[0118] In the embodiment of the present application, when the user operates the target view conversion control, the user can select a list unit in the plurality of list units of the target table according to actual needs, and the list unit information selected by the user can be carried in the target view conversion trigger instruction issued. When the terminal receives the target view conversion trigger instruction for the target table, the target list unit can be determined in the plurality of list units of the target table according to the list unit information carried in the target view conversion trigger instruction.

[0119] For example, when the user operates the target view conversion control, the user selects the column of "employee name" in the target table, and the column information of the column of "employee name" is carried in the target view conversion trigger instruction issued. When the terminal receives the target view conversion trigger instruction, the column of "employee name" in the target table can be determined as the target list unit according to the column information of the column of "employee name" carried therein.

[0120] Further, the navigation information can be generated based on the target list unit, the navigation information is displayed in the first display area of the terminal screen, and the list content corresponding to the currently selected navigation tab in the navigation information is displayed in the second display area of the terminal screen in a width adaptation manner.

[0121] According to the list unit information carried in the target view conversion trigger instruction, the target list unit is determined in the plurality of list units of the target table, so that the determined target list unit is more in line with the user's expectation, and the user can conveniently view information.

[0122] In an embodiment of the present application, determining the target list unit in the plurality of list units of the target table can include the following steps:

[0123] The first list unit of the target table is determined as the target list unit.

[0124] It can be understood that, generally, when the user makes an electronic table, the user usually places the information with guidance in the first row or the first column of the electronic table, that is, the information expressed by the first list unit of an electronic table can be more guiding than the information expressed by other list units. Therefore, when the target view conversion trigger instruction for the target table is received, the first list unit of the target table can be determined as the target list unit. As shown in FIG. 6, the first column "effective date" in the statistical report of "department position record statistics" is taken as the target list unit. Figure 3

[0125] Further, the navigation information can be generated based on the target list unit, the navigation information is displayed in the first display area of the terminal screen, and the list content corresponding to the currently selected navigation tab in the navigation information is displayed in the second display area of the terminal screen in a width adaptation manner. ​

[0126] The first list cell of the target table is determined as a target list cell, and the navigation information is generated based on the target list cell, so that the navigation information is more guiding and convenient for the user to view information.

[0127] In an embodiment of the present application, the currently selected navigation tab is determined by the following steps:

[0128] The navigation tab at the first position in the first display area is determined as the currently selected navigation tab.

[0129] In an embodiment of the present application, when a target view conversion trigger instruction for a target table is received, a target list cell is determined in the list cells of the target table, and navigation information is generated based on the target list cell. When the navigation information is displayed in the first display area of the terminal screen, the navigation tab at the first position in the first display area is determined as the currently selected navigation tab, and the list content corresponding to the currently selected navigation tab in the navigation information is displayed in the second display area of the terminal screen in a width-adaptive manner.

[0130] As soon as the target view is entered, the navigation tab at the first position in the first display area can be selected as the currently selected navigation tab by default. Then, if there is a sliding operation or the like on the navigation information in the first display area, the navigation tab at the first position in the first display area will change constantly, and the navigation tab currently at the first position is determined as the currently selected navigation tab, and the currently selected navigation tab also changes constantly.

[0131] The first position can be pre-set, such as the uppermost position or the upper middle position of the first display area.

[0132] The navigation tab at the first position in the first display area is determined as the currently selected navigation tab, and then the list content corresponding to the currently selected navigation tab in the navigation information is displayed in the second display area of the terminal screen in a width-adaptive manner, so that the user can view the list content corresponding to the navigation tab at the first position in time.

[0133] In an embodiment of the present application, the currently selected navigation tab can be determined by the following steps:

[0134] In response to a first selection operation on a navigation tab in the navigation information, the navigation tab subjected to the first selection operation is determined as the currently selected navigation tab.

[0135] In the embodiment of the present application, in the case that the target view conversion trigger instruction for the target table is received, the target list unit is determined in the plurality of list units of the target table, the navigation information is generated based on the target list unit, and after the navigation information is displayed in the first display area of the terminal screen, the user can select the navigation label in the navigation information according to the actual viewing needs.

[0136] In response to the first selection operation for the navigation label in the navigation information, the navigation label to which the first selection operation is directed can be determined as the currently selected navigation label. The first selection operation can be a click operation or other trigger selection operation, such as a long press operation, etc.

[0137] As Figure 4 In the embodiment, the user can directly click the navigation label "2021-12-01" in the navigation information, and in response to the click operation, the navigation label can be determined as the currently selected navigation label, and then the list content corresponding to the currently selected navigation label can be displayed in the second display area of the terminal screen in a width-adaptive manner.

[0138] In response to the first selection operation for the navigation label in the navigation information, the navigation label to which the first selection operation is directed can be determined as the currently selected navigation label, and the list content corresponding to the currently selected navigation label can be displayed in the second display area of the terminal screen in a width-adaptive manner. This can realize continuous or discontinuous quick switching between different list contents.

[0139] In an embodiment of the present application, the currently selected navigation label can be determined by the following steps:

[0140] In response to the sliding operation for the navigation label in the navigation information, the navigation labels of the navigation information are scrolled and displayed in the first display area, and in the case that the second selection operation is detected, the navigation label to which the second click operation is directed is determined as the currently selected navigation label.

[0141] In the embodiment of the present application, in the case that the target view conversion trigger instruction for the target table is received, the target list unit is determined in the plurality of list units of the target table, the navigation information is generated based on the target list unit, and after the navigation information is displayed in the first display area of the terminal screen, the user can perform a sliding operation on the navigation label in the navigation information according to the actual viewing needs.

[0142] In response to the sliding operation on the navigation label in the navigation information, the navigation labels in the navigation information can be scrolled and displayed in the first display area, which helps the user to quickly browse the navigation labels in the navigation information, and the user can select the navigation label in the navigation information according to the viewing requirement. In the case where the second selection operation is detected, the navigation label to which the second selection operation is directed can be determined as the currently selected navigation label. The second selection operation can be a clicking operation or other operation triggering selection, such as a long-pressing operation.

[0143] That is, in the process of scrolling and displaying the navigation labels in the navigation information in the first display area, the currently selected navigation label does not change, and the list content displayed in the second display area does not change either. Only when the second selection operation is detected, the navigation label to which the second selection operation is directed can be determined as the currently selected navigation label, the switching of the currently selected navigation label is performed, and the list content corresponding to the switched currently selected navigation label is displayed in the second display area in the width adaptation mode.

[0144] For example, as shown in FIG. 1, the user can slide the navigation label in the navigation information, and in response to the sliding operation, the navigation labels in the navigation information can be scrolled and displayed in the first display area. Figure 5 In the embodiment, the user can hold the navigation label in the navigation information and slide it, and in response to the sliding operation, the navigation labels in the navigation information can be scrolled and displayed in the first display area. When the clicking operation on the navigation label is detected, the navigation label to which the clicking operation is directed can be determined as the currently selected navigation label.

[0145] Through the sliding operation, the user can quickly browse the navigation labels in the navigation information and find the desired navigation label. Then, in response to the selection operation, the currently selected navigation label can be determined, and the list content corresponding to the currently selected navigation label in the navigation information can be displayed in the second display area in the width adaptation mode. In this way, the user can quickly view the list content corresponding to the switched currently selected navigation label.

[0146] In an embodiment of the present application, after the list content corresponding to the currently selected navigation label in the navigation information is displayed in the second display area of the terminal screen in the width adaptation mode, the method can further include the following steps:

[0147] In response to the sliding operation on the list content in the second display area, different list content can be scrolled and displayed in the second display area, the currently selected navigation label can be switched to the navigation label corresponding to the list content located at the set second position in the second display area, and the navigation label can be displayed in the first display area.

[0148] In the embodiment of the present application, in the case that the target view conversion trigger instruction for the target table is received, the target list unit is determined in the plurality of list units of the target table, the navigation information is generated based on the target list unit, the navigation information is displayed in the first display area of the terminal screen, and after the list content corresponding to the currently selected navigation tab in the navigation information is displayed in the second display area of the terminal screen in a width adaptive manner, the user can perform a sliding operation on the list content in the second display area according to actual viewing needs.

[0149] In response to the sliding operation on the list content in the second display area, different list content can be displayed in the second display area, so that the user can view the information of the different list content.

[0150] Meanwhile, the currently selected navigation tab can be switched to the navigation tab corresponding to the list content at the second position in the second display area, and displayed in the first display area.

[0151] The list content at the second position in the second display area may change when different list content is displayed in the second display area, and the corresponding navigation tab also changes accordingly. It can be considered that the list content at the second position in the second display area is the list content that the user currently wants to view, and the navigation tab corresponding to the list content can be marked as selected, that is, the currently selected navigation tab is switched to the navigation tab, and displayed in the first display area, so as to facilitate the user to understand the navigation tab corresponding to the list content at the second position in the second display area. The second position can be preset, such as the top position or the middle position of the second display area.

[0152] Specifically, when the sliding operation on the list content in the second display area is an upward sliding operation, the list content displayed in the second display area slides upward, and if the top of the next list content of the list content corresponding to the currently selected navigation tab slides to the second position, the currently selected navigation tab can be switched to the navigation tab corresponding to the next list content, and so on.

[0153] When the sliding operation on the list content in the second display area is a downward sliding operation, the list content displayed in the second display area slides downward, and if the bottom of the previous list content of the list content corresponding to the currently selected navigation tab slides to the second position, the currently selected navigation tab can be switched to the navigation tab corresponding to the previous list content, and so on.

[0154] The currently selected navigation tab needs to be displayed in the first display area, so as to facilitate the user to view. That is, if the navigation tab to be switched to the currently selected navigation tab is in the first display area and in a visible state, the navigation tab can be marked as selected. If the navigation tab to be switched to the currently selected navigation tab is out of the first display area and in an invisible state, the automatic sliding of the navigation tabs in the navigation information can be triggered, the navigation tab to be switched to the currently selected navigation tab is displayed in the first display area, and the navigation tab is in a visible state. The specific display position of the currently selected navigation tab in the first display area can be the uppermost part, the middle part, or the lowermost part.

[0155] Through the sliding operation, the user can quickly find the desired list content. In response to the sliding operation, different list contents can be displayed in the second display area by scrolling, and the currently selected navigation tab can be switched to the navigation tab corresponding to the list content in the second position in the second display area, that is, the navigation tab is marked as selected and displayed in the first display area.

[0156] In the process of displaying different list contents in the second display area by scrolling, the list content in the second position in the second display area changes constantly, and the corresponding navigation tab also changes constantly, so that the currently selected navigation tab is automatically switched and displayed in the first display area, facilitating the user to view which navigation tab the list content currently displayed in the second display area corresponds to.

[0157] In an embodiment of the present application, after the list content corresponding to the currently selected navigation tab in the navigation information is displayed in the second display area of the terminal screen in a width-adaptive manner, the method can further include the following steps:

[0158] In response to a third selection operation on the list content switching control in the second display area, the list content is displayed by switching in the second display area, the currently selected navigation tab is switched to the navigation tab corresponding to the switched list content, and the navigation tab is displayed in the first display area.

[0159] In the embodiment of the present application, in the case that the target view conversion trigger instruction for the target table is received, the target list unit is determined in the plurality of list units of the target table, the navigation information is generated based on the target list unit, the navigation information is displayed in the first display area of the terminal screen, and after the list content corresponding to the currently selected navigation tab in the navigation information is displayed in the second display area of the terminal screen in a width-adaptive manner, the user can click the list content switching control in the second display area according to actual viewing needs.

[0160] The list content switching control can be a button in the form of up and down arrows, such as Figure 3The button can also be in the form of "previous" / "next" text.

[0161] In response to a third selection operation on the list content switching control in the second display area, switching display of the list content can be performed in the second display area. The third selection operation can be a click operation or other operation triggering selection, such as a long press operation.

[0162] For example, in the case of Figure 6 In the case of

[0163] Similarly, if the navigation tab to be switched to the currently selected navigation tab is in the visible state in the first display area, the navigation tab can be marked as selected. If the navigation tab to be switched to the currently selected navigation tab is in the invisible state outside the first display area, automatic sliding of the navigation tab in the navigation information can be triggered, and the navigation tab to be switched to the currently selected navigation tab is displayed in the first display area to be in the visible state. The specific display position of the currently selected navigation tab in the first display area can be the uppermost part, the middle, or the lowermost part.

[0164] It should be noted that whether the navigation tab of the navigation information of the first display area is operated or the list content of the second display area is operated, the currently selected navigation tab in the first display area and the currently displayed list content in the second display area can be linked, so that the second display area can display at least the list content corresponding to the currently selected navigation tab.

[0165] In an embodiment of the present application, the method can further include the following steps:

[0166] In response to the target list unit switching trigger instruction in the first display area, the target list unit is re-determined in the plurality of list units of the target table, and the steps of generating navigation information based on the target list unit, displaying the navigation information in the first display area of the terminal screen, and displaying at least the list content corresponding to the currently selected navigation tab in the navigation information in the second display area of the terminal screen in a width adaptive manner are repeatedly performed.

[0167] In the embodiment of the present application, in the case that the target view conversion trigger instruction for the target table is received, the target list unit is determined in the plurality of list units of the target table, the navigation information is generated based on the target list unit, the navigation information is displayed in the first display area of the terminal screen, and after the list content corresponding to the currently selected navigation tab in the navigation information is displayed in the second display area of the terminal screen in the width adaptation manner, the user can switch the target list unit according to actual needs.

[0168] Specifically, the target list unit switching control can be provided for the user, such as Figure 7 The control behind the left area “effective date”, the user can issue the corresponding target list unit switching trigger instruction through the target list unit switching control.

[0169] In response to the target list unit switching trigger instruction in the first display area, the target list unit can be re-determined in the plurality of list units of the target table.

[0170] For example, Figure 7 In the embodiment, after detecting that the user clicks the target list unit switching control, the fields of each list unit contained in the target table can be displayed on the terminal screen, the user selects the list unit to be fixedly displayed according to needs, and the target list unit is re-determined according to the selection of the user.

[0171] After the target list unit is re-determined, the navigation information can be generated based on the target list unit, the navigation information is displayed in the first display area of the terminal screen, and the list content corresponding to the currently selected navigation tab in the navigation information is displayed in the second display area of the terminal screen in the width adaptation manner.

[0172] For example, Figure 8 In the embodiment, the re-determined target list unit is the column “employee name”, the navigation information is generated based on the column, displayed in the first display area, and the list content corresponding to the currently selected navigation tab in the navigation information is displayed in the second display area in the width adaptation manner.

[0173] In this way, the switching of the target list unit is realized, and the navigation information displayed in the first display area is also switched, so that the user can view the corresponding list content according to the switched navigation information, and the user demand can be better met.

[0174] In an embodiment of the present application, the method can further include the following steps:

[0175] The list content corresponding to the currently selected navigation tab includes the list content corresponding to the currently selected navigation tab in the second direction dimension, and the tab content of the currently selected navigation tab.

[0176] In the embodiment of the present application, in the case that a target view conversion trigger instruction for a target table is received, a target list unit is determined in the plurality of list units of the target table, navigation information is generated based on the target list unit, the navigation information is displayed in a first display area of a terminal screen, and list content corresponding to a currently selected navigation tab in the navigation information is displayed in a second display area of the terminal screen in a width adaptive manner. The list content corresponding to the currently selected navigation tab can include list content corresponding to the currently selected navigation tab in a second direction dimension and tab content of the currently selected navigation tab.

[0177] Specifically, the tab content of the currently selected navigation tab displayed in the second display area can be highlighted, such as by changing the font size, changing the font, changing the thickness, changing the color, and the like.

[0178] The navigation information displayed in the first display area includes a plurality of navigation tabs, each navigation tab has respective tab content, and when the list content corresponding to the currently selected navigation tab in the navigation information is displayed in the second display area, the list content corresponding to the currently selected navigation tab in the second direction dimension and the tab content of the currently selected navigation tab are also displayed.

[0179] For example, Figure 8 In the embodiment, the column of "employee name" in the statistical report of "department position record statistics" is determined as the target list unit, and navigation information is generated based on the target list unit, which includes a plurality of navigation tabs, such as a first navigation tab, a second navigation tab, and the like, each navigation tab has respective tab content, the tab content corresponding to the first navigation tab is "Zhang San", the tab content corresponding to the second navigation tab is "Li Si", and the like, and the tab content can be displayed in the second display area, such as "Zhang San", "Li Si", and the like.

[0180] The list content corresponding to the currently selected navigation tab also includes the tab content of the currently selected navigation tab, which can help the user to quickly locate.

[0181] Specifically, the tab content of the currently selected navigation tab can be in a corresponding position of the list content corresponding to the currently selected navigation tab in the second direction dimension, such as the right side or Figure 8 the upper side, and the like.

[0182] The embodiment of the present application effectively improves the display effect of the electronic table in the terminal, especially the mobile terminal, improves the viewing efficiency, and is compatible even if there are many list units, and has strong applicability.

[0183] Referring to Figure 9 Fig. 1 shows an implementation flowchart of an electronic table display method provided by the embodiment of the present application, which can include the following steps:

[0184] S910: receiving a target list unit switching trigger instruction for the target table;

[0185] The current view of the target table is a target view, navigation information of the target table is displayed in a first display area of a terminal screen, and list content corresponding to a currently selected navigation tab in the navigation information is displayed in a second display area of the terminal screen in a width adaptation manner. The navigation information is generated based on a target list unit determined from a plurality of list units of the target table, and the navigation information includes at least one navigation tab. The list unit is obtained by dividing the target table in a first direction dimension, and the list content of the currently selected navigation tab includes at least list content corresponding to the currently selected navigation tab in a second direction dimension, and the second direction dimension is perpendicular to the first direction dimension.

[0186] In the embodiment of the application, the target table includes a plurality of list units, and the list unit is obtained by dividing the target table in a first direction dimension. The first direction dimension can be a row dimension or a column dimension. If the first direction dimension is a row dimension, the list unit of the target table can be each row of the target table, and if the first direction dimension is a column dimension, the list unit of the target table can be each column of the target table.

[0187] The view of the target table can have a default view and a target view. The default view can be considered as a view in which row and column information is presented in a flat manner, and the target view can be considered as an immersive view.

[0188] When the current view of the target table is a target view, the navigation information of the target table can be displayed in a first display area of a terminal screen, and the list content corresponding to the currently selected navigation tab in the navigation information can be displayed in a second display area of the terminal screen in a width adaptation manner. The target list unit can be determined from a plurality of list units of the target table, and the navigation information can be generated based on the target list unit. The navigation information includes at least one navigation tab. The list content of the currently selected navigation tab includes at least list content corresponding to the currently selected navigation tab in a second direction dimension, and the second direction dimension is perpendicular to the first direction dimension.

[0189] The user can switch the target list unit according to actual needs. Specifically, the user can be provided with a target list unit switching control, such as Figure 7 The control behind the left area "effective date", the user can issue a corresponding target list unit switching trigger instruction through the target list unit switching control.

[0190] In the case of receiving a target list unit switching trigger instruction for the target table, the subsequent steps can be continued to be executed.

[0191] S920: Redetermine the target list unit in the plurality of list units of the target table, and regenerate the navigation information based on the redetermined target list unit.

[0192] After receiving the target list unit switching trigger instruction for the target table, it is considered that the user currently has a target list unit switching demand, and the target list unit can be redetermined in the plurality of list units of the target table.

[0193] Specifically, the target list unit can be redetermined in the plurality of list units of the target table according to the list unit information carried in the target list unit switching trigger instruction.

[0194] After the target list unit is redetermined, the navigation information can be regenerated based on the redetermined target list unit. Specifically, the navigation information can be generated in the order of the content cells of the redetermined target list unit, and each navigation label in the navigation information corresponds to the content of each content cell of the redetermined target list unit.

[0195] S930: Display the regenerated navigation information in the first display area, and display at least the list content corresponding to the currently selected navigation label in the regenerated navigation information in the second display area in a width adaptation manner.

[0196] After the target list unit is redetermined and the navigation information is regenerated based on the redetermined target list unit, the regenerated navigation information can be displayed in the first display area, that is, the navigation information displayed in the first display area is switched. In the second display area, at least the list content corresponding to the currently selected navigation label in the regenerated navigation information is displayed in a width adaptation manner. The currently selected navigation label is a navigation label included in the regenerated navigation information.

[0197] By applying the method provided by the embodiment of the application, the navigation information displayed in the first display area is switched through the switching of the target list unit, the user can view the corresponding list content according to the switched navigation information, and the user demand can be better met.

[0198] Corresponding to the method embodiment shown in Figure 1 The embodiment of the application also provides an electronic table display device, and the electronic table display device described below can be referred to each other corresponding to the electronic table display method described above.

[0199] Referring to Figure 10 The electronic table display device 1000 can include the following units:

[0200] The first receiving unit 1010 is configured to receive a target view conversion trigger instruction for a target table, the target table comprising a plurality of list units, the list units being obtained by dividing the target table according to a first direction dimension;

[0201] The first generating unit 1020 is configured to determine a target list unit from the plurality of list units of the target table, and generate navigation information based on the target list unit, the navigation information comprising at least one navigation label;

[0202] The first displaying unit 1030 is configured to display the navigation information in a first display area of a terminal screen, and display list content corresponding to a currently selected navigation label in the navigation information in a second display area of the terminal screen in a width adaptation manner, the list content corresponding to the currently selected navigation label comprising at least list content corresponding to the currently selected navigation label in a second direction dimension, the second direction dimension being perpendicular to the first direction dimension.

[0203] By using the device provided in the embodiment of the present application, the current view of the target table is converted into the target view, and the list content corresponding to the currently selected navigation label in the navigation information displayed in the first display area of the terminal screen can be conveniently viewed in the second display area of the terminal screen, and the list content displayed in the second display area is adapted to the width of the second display area, so that the user can view the list content corresponding to the currently selected navigation label in the navigation information without left and right sliding, the viewing efficiency of the electronic table is improved, the work efficiency of the user is improved, and the use experience of the user is improved.

[0204] In a specific embodiment of the present application, the first generating unit 1020 is configured to:

[0205] The navigation information is generated according to the order of the content cells of the target list unit, and each navigation label in the navigation information corresponds to the content of each content cell of the target list unit.

[0206] In a specific embodiment of the present application, the first generating unit 1020 is configured to:

[0207] The target list unit is determined according to the list unit information carried in the target view conversion trigger instruction, or

[0208] The first list unit of the target table is determined as the target list unit.

[0209] In a specific embodiment of the present application, the electronic table display device 1000 further comprises a determining unit configured to determine the currently selected navigation label by the following steps:

[0210] The navigation label located at the first position in the first display area is determined as the currently selected navigation label, or

[0211] in response to the first selection operation on the navigation label in the navigation information, determining the navigation label targeted by the first selection operation as the currently selected navigation label; or

[0212] in response to the sliding operation on the navigation label in the navigation information, scrolling to display the navigation labels of the navigation information in the first display area, and in the case that the second selection operation is detected, determining the navigation label targeted by the second selection operation as the currently selected navigation label.

[0213] In an embodiment of the present application, the first display unit 1030 is further configured to:

[0214] after displaying the list content corresponding to the currently selected navigation label in the navigation information in the second display area of the terminal screen in a width-adaptive manner, in response to the sliding operation on the list content in the second display area, scrolling to display different list content in the second display area, switching the currently selected navigation label to the navigation label corresponding to the list content located at the second position in the second display area, and displaying in the first display area; or

[0215] in response to the third selection operation on the list content switching control in the second display area, switching to display the list content in the second display area, switching the currently selected navigation label to the navigation label corresponding to the switched list content, and displaying in the first display area.

[0216] In an embodiment of the present application, the first display unit 1030 is further configured to:

[0217] in response to the switching trigger instruction on the target list unit in the first display area, re-determining the target list unit in the plurality of list units of the target table, triggering the first generation unit 1020 to repeatedly execute the steps of generating the navigation information based on the target list unit, displaying the navigation information in the first display area of the terminal screen, and displaying the list content corresponding to the currently selected navigation label in the navigation information in the second display area of the terminal screen in a width-adaptive manner.

[0218] In an embodiment of the present application, the list content corresponding to the currently selected navigation label includes the list content corresponding to the currently selected navigation label in the second direction dimension, and the label content of the currently selected navigation label.

[0219] As to the apparatus in the above-mentioned embodiments, the specific manners in which the units perform operations have been described in detail in the embodiments of the method, and will not be described in detail here.

[0220] Corresponding to Figure 9The method embodiment shown, the electronic table display device embodiment also provides an electronic table display device, the electronic table display device described below can be correspondingly referred to the electronic table display method described above.

[0221] Referring to Figure 11 As shown, the electronic table display device 1100 can include the following units:

[0222] The second receiving unit 1110 is configured to receive a target list unit switching trigger instruction for a target table, the current view of the target table is a target view, navigation information of the target table is displayed in a first display area of a terminal screen, and list content corresponding to a currently selected navigation tab in the navigation information is displayed in a second display area of the terminal screen in a width adaptation manner, the navigation information is generated based on a target list unit determined from a plurality of list units of the target table, the navigation information includes at least one navigation tab, the list unit is obtained by dividing the target table in a first direction dimension, and the list content of the currently selected navigation tab at least includes list content corresponding to the currently selected navigation tab in a second direction dimension, the second direction dimension is perpendicular to the first direction dimension.

[0223] The second generation unit 1120 is configured to re-determine the target list unit from the plurality of list units of the target table, and re-generate the navigation information based on the re-determined target list unit.

[0224] The second display unit 1130 is configured to display the re-generated navigation information in the first display area, and display the list content corresponding to the currently selected navigation tab in the re-generated navigation information in the second display area in a width adaptation manner.

[0225] The device provided by the embodiment of the present application can switch the target list unit, and thus the navigation information displayed in the first display area is also switched, the user can view the corresponding list content according to the switched navigation information, and the user demand can be better met.

[0226] As to the device in the above embodiment, the specific manner in which each unit performs an operation has been described in detail in the embodiment of the method, and will not be described here in detail.

[0227] Corresponding to the above method embodiment, the electronic device embodiment of the present application also provides an electronic device, which includes a processor, a memory, a computer program stored in the memory and executable on the processor, the computer program is executed by the processor to realize each process of the above electronic table display method embodiment, and the same technical effect can be achieved, to avoid repetition, which will not be described here.

[0228] As Figure 12As shown, the electronic device can include a processor 10, a memory 11, a communication interface 12, a communication bus 13 and a display 14. The processor 10, the memory 11, the communication interface 12 and the display 14 can communicate with each other through the communication bus 13.

[0229] In the embodiment of the present application, the processor 10 can be a central processing unit (CPU), an application specific integrated circuit, a digital signal processor, a field programmable gate array or other programmable logic device, etc.

[0230] The processor 10 can invoke a computer program stored in the memory 11. Specifically, the processor 10 can perform the operations in the embodiments of the electronic table display method.

[0231] The memory 11 stores one or more programs, which can include program codes including computer operation instructions. In the embodiment of the present application, the memory 11 stores at least programs for implementing the following functions:

[0232] Receiving a target view conversion trigger instruction for a target table, the target table including a plurality of list units, the list units being obtained by dividing the target table according to a first direction dimension;

[0233] Determining a target list unit from the list units of the target table, generating navigation information based on the target list unit, the navigation information including at least one navigation label;

[0234] Displaying the navigation information in a first display area of a terminal screen, and displaying at least list content corresponding to a currently selected navigation label in the navigation information in a second display area of the terminal screen in a width adaptation manner, the list content corresponding to the currently selected navigation label including at least list content corresponding to the currently selected navigation label in a second direction dimension, the second direction dimension being perpendicular to the first direction dimension;

[0235] And / or,

[0236] The terminal receives a target list unit switching trigger instruction for a target table, a current view of the target table is a target view, navigation information of the target table is displayed in a first display area of a terminal screen, and list content corresponding to a currently selected navigation label in the navigation information is displayed in a second display area of the terminal screen in a width adaptation manner, the navigation information is generated based on a target list unit determined from a plurality of list units of the target table, the navigation information includes at least one navigation label, the list unit is obtained by dividing the target table in a first direction dimension, and the list content of the currently selected navigation label at least includes list content corresponding to the currently selected navigation label in a second direction dimension, the second direction dimension is perpendicular to the first direction dimension.

[0237] The target list unit is re-determined from the plurality of list units of the target table, and the navigation information is re-generated based on the re-determined target list unit.

[0238] The re-generated navigation information is displayed in the first display area, and the list content corresponding to the currently selected navigation label in the re-generated navigation information is displayed in the second display area in the width adaptation manner.

[0239] In a possible implementation, the memory 11 can include a program storage area and a data storage area, where the program storage area can store an operating system and application programs required by at least one function (such as an instruction receiving function and an information display function), and the data storage area can store data created during use, such as navigation information data and list content data.

[0240] In addition, the memory 11 can include a high-speed random access memory, and can also include a non-volatile memory, for example, at least one magnetic disk storage device or other volatile solid-state storage device.

[0241] The communication interface 12 can be an interface of a communication module, used for connecting with other devices or systems.

[0242] The display 14 can display corresponding information.

[0243] Of course, it should be noted that, Figure 12 The structures shown do not constitute a limitation on the electronic device in the embodiments of the present application, and in actual applications, the electronic device can include more or fewer components than Figure 12 those shown, or some components can be combined.

[0244] The embodiment of the present application further provides a computer readable storage medium, and the computer readable storage medium stores a computer program. The computer program is executed by a processor to implement each process of the above-described spreadsheet display method embodiment, and the same technical effects can be achieved. To avoid repetition, details are not described herein. The computer readable storage medium includes a read-only memory (ROM), a random access memory (RAM), a magnetic disk, an optical disk, and the like.

[0245] In addition, the embodiment of the present application further provides a computer program product or a computer program. The computer program product or the computer program can include computer instructions stored in a computer readable storage medium. The processor of the electronic device reads the computer instructions from the computer readable storage medium. The processor can execute the computer instructions to enable the computer device to perform the description of the spreadsheet display method in the above-described embodiment. Therefore, details are not described herein. In addition, the beneficial effects of the same method are not described. For technical details not disclosed in the computer program product or the computer program embodiment of the present application, refer to the description of the method embodiment of the present application.

[0246] It should be noted that in this document, the term "comprising" or "including" or any other variant thereof is intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements not only includes those elements, but also includes other elements not explicitly listed or inherent to such a process, method, article or device. Without more limitations, the element defined by the statement "including a" does not exclude the presence of another identical element in the process, method, article or device including the element.

[0247] From the above description of the embodiments, those skilled in the art can clearly understand that the above-mentioned embodiment method can be realized by means of software and necessary general hardware platform, of course, it can also be realized by hardware, but in many cases, the former is a better embodiment. Based on this understanding, the technical solutions of the present application or the part that contributes to the prior art can be embodied in the form of a software product, which is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk) and includes a plurality of instructions for enabling a terminal (which can be a mobile phone, computer, server, air conditioner, or network device, etc.) to execute the method described in each embodiment of the present application.

[0248] The embodiments of the present application are described above with reference to the accompanying drawings, but the present application is not limited to the above-described specific embodiments, and the above-described specific embodiments are merely illustrative, but not restrictive, and a person of ordinary skill in the art can make many forms under the inspiration of the present application without departing from the purpose of the present application and the scope protected by the claims, and all of them belong to the protection of the present application.

[0249] Those skilled in the art can understand that the units and algorithm steps of each example described in combination with the embodiments disclosed in the embodiments of the present application can be realized by electronic hardware or a combination of computer software and electronic hardware. Whether the functions are realized in hardware or software mode depends on the specific application and design constraints of the technical solution. A person skilled in the art can use different methods to realize the described functions for each specific application, but such implementation should not be considered beyond the scope of the present application.

[0250] Those skilled in the art can clearly understand that, for the convenience and brevity of the description, the specific working processes of the above-described system, device and unit can refer to the corresponding processes in the foregoing method embodiments, which will not be repeated here.

[0251] In the embodiments provided by the present application, it should be understood that the disclosed device and method can be implemented by other ways. For example, the device embodiments described above are only illustrative, for example, the division of the units is only a logical function division, and actual implementation can have another division manner, for example, a plurality of units or components can be combined or integrated into another system, or some features can be ignored or not executed. In addition, the coupling or direct coupling or communication connection between the units shown or discussed can be indirect coupling or communication connection through some interface, device or unit, and can be electrical, mechanical or other forms.

[0252] The units described as separate components can or can not be physically separate, and the components shown as units can or can not be physical units, that is, they can be located in one place, or can be distributed on a plurality of network units. Some or all of the units can be selected to achieve the purpose of the embodiment according to actual needs.

[0253] In addition, each functional unit in each embodiment of the present application can be integrated into a processing unit, or each unit can exist physically, or two or more units can be integrated into one unit.

[0254] If the functions are realized in the form of software function units and sold or used as independent products, they can be stored in a computer readable storage medium. Based on this understanding, the technical solutions of the present application or the parts of the present application that essentially contribute to the prior art or the parts of the technical solutions can be embodied in the form of software products. The computer software product is stored in a storage medium and includes a plurality of instructions for causing a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the method described in the various embodiments of the present application. The aforementioned storage medium includes various storage media that can store program codes, such as a U disk, a mobile hard disk, a ROM, a RAM, a magnetic disk or an optical disk.

[0255] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art can easily think of changes or replacements within the technical range disclosed by the present application, which should be covered within the protection scope of the present application. Therefore, the protection scope of the present application should be subject to the protection scope of the claims.

Claims

1. An electronic spreadsheet presentation method, characterized by, The method comprises: receiving a target view conversion trigger instruction for a target table, the target table comprising a plurality of list units, the list units being obtained by dividing the target table in a first direction dimension; the first direction dimension being a row dimension or a column dimension; determining a target list unit from the plurality of list units of the target table, and generating navigation information based on the target list unit, the navigation information comprising at least one navigation label; each navigation label in the navigation information corresponding to the content of each content cell of the target list unit; displaying the navigation information in a first display area of a terminal screen, and displaying at least the list content corresponding to a currently selected navigation label in the navigation information in a second display area of the terminal screen in a width adaptive manner, the list content corresponding to the currently selected navigation label comprising at least the list content corresponding to the currently selected navigation label in a second direction dimension, the second direction dimension being perpendicular to the first direction dimension; the list content corresponding to the currently selected navigation label comprising the list content corresponding to the currently selected navigation label in the second direction dimension and the label content of the currently selected navigation label, the width adaptive manner comprising at least line breaking or font size changing of content exceeding the width of the second display area, so that the total width of the displayed list content and label content is less than or equal to the width of the second display area.

2. The electronic spreadsheet presentation method of claim 1, wherein, The generating of the navigation information based on the target list unit comprises: generating the navigation information in the order of the content cells of the target list unit.

3. The electronic spreadsheet presentation method of claim 1, wherein, The determining of the target list unit from the plurality of list units of the target table comprises: determining the target list unit from the plurality of list units of the target table according to the list unit information carried in the target view conversion trigger instruction; or determining the first list unit of the target table as the target list unit.

4. The spreadsheet presentation method of claim 1, wherein, The currently selected navigation label is determined by: determining the navigation label at a set first position in the first display area as the currently selected navigation label; or in response to a first selection operation on a navigation label in the navigation information, determining the navigation label targeted by the first selection operation as the currently selected navigation label; or in response to a sliding operation on a navigation label in the navigation information, scrolling the navigation labels of the navigation information in the first display area, and in the case that a second selection operation is detected, determining the navigation label targeted by the second selection operation as the currently selected navigation label.

5. The spreadsheet presentation method of claim 1, wherein, After the displaying of the list content corresponding to the currently selected navigation label in the navigation information in the second display area of the terminal screen in the width adaptive manner, the method further comprises: in response to a sliding operation on the list content in the second display area, scrolling different list content in the second display area, switching the currently selected navigation label to the navigation label corresponding to the list content at a set second position in the second display area, and displaying in the first display area; or in response to a sliding operation on the list content in the second display area, scrolling different list content in the second display area, switching the currently selected navigation label to the navigation label corresponding to the list content at a set second position in the second display area, and displaying in the first display area; or In response to a third selection operation on the list content switching control in the second display area, switching display of the list content is performed in the second display area, the current selected navigation tab is switched to a navigation tab corresponding to the switched list content, and the switched list content is displayed in the first display area.

6. The spreadsheet presentation method of claim 1, wherein, Also includes: In response to a target list unit switching trigger instruction for the target table, the target list unit in the target table is re-determined, the navigation information is re-generated based on the re-determined target list unit, and the re-generated navigation information is displayed in the first display area of the terminal screen and at least the list content corresponding to the current selected navigation tab in the re-generated navigation information is displayed in the second display area of the terminal screen in a width adaptive manner.

7. An electronic spreadsheet presentation method, characterized by, Includes: A target list unit switching trigger instruction for a target table is received, the current view of the target table is a target view, navigation information of the target table is displayed in the first display area of the terminal screen, and at least the list content corresponding to the current selected navigation tab in the navigation information is displayed in the second display area of the terminal screen in a width adaptive manner. The navigation information is generated based on the target list unit determined in the plurality of list units of the target table, and the navigation information includes at least one navigation tab. The list unit is obtained by dividing the target table in a first direction dimension. The current selected navigation tab includes at least the list content corresponding to the current selected navigation tab in a second direction dimension, and the second direction dimension is perpendicular to the first direction dimension. The first direction dimension is a row dimension or a column dimension. Each navigation tab in the navigation information corresponds to the content of each content cell of the target list unit. The current selected navigation tab corresponds to the list content corresponding to the current selected navigation tab in the second direction dimension, and the label content of the current selected navigation tab. The width adaptive manner includes at least line breaking or font size conversion of content exceeding the width of the second display area, so that the total width of the displayed list content and label content is less than or equal to the width of the second display area. The target list unit in the plurality of list units of the target table is re-determined, and the navigation information is re-generated based on the re-determined target list unit. The re-generated navigation information is displayed in the first display area, and at least the list content corresponding to the current selected navigation tab in the re-generated navigation information is displayed in the second display area in a width adaptive manner.

8. An electronic spreadsheet presentation device, characterized by Includes: A first receiving unit is configured to receive a target view conversion trigger instruction for a target table, the target table including a plurality of list units, and the list units being obtained by dividing the target table in a first direction dimension. The first direction dimension is a row dimension or a column dimension. A first generating unit is configured to determine a target list unit in the plurality of list units of the target table, and generate navigation information based on the target list unit. The navigation information includes at least one navigation tab. Each navigation label in the navigation information corresponds to content of each content cell of the target list unit respectively; The first display unit is configured to display the navigation information in a first display area of a terminal screen, and display at least list content corresponding to a currently selected navigation label in the navigation information in a second display area of the terminal screen in a width adaptation manner, the list content corresponding to the currently selected navigation label at least including list content corresponding to the currently selected navigation label in a second direction dimension, the second direction dimension being perpendicular to the first direction dimension; the list content corresponding to the currently selected navigation label including the list content corresponding to the currently selected navigation label in the second direction dimension and label content of the currently selected navigation label, and the width adaptation manner at least including line breaking or font size changing of content exceeding a width of the second display area, so that a total width of the displayed list content and the label content is less than or equal to the width of the second display area.

9. The spreadsheet presentation device of claim 8, wherein, The first generation unit is configured to: generate navigation information according to a content cell sequence of the target list unit, each navigation label in the navigation information corresponding to content of each content cell of the target list unit respectively.

10. The spreadsheet presentation device of claim 8, wherein, The first generation unit is configured to: determine a target list unit in the target table according to list unit information carried in the target view conversion trigger instruction; or determine a first list unit of the target table as the target list unit.

11. The spreadsheet presentation device of claim 8, wherein, The determination unit is further configured to determine the currently selected navigation label by the following steps: determine a navigation label at a set first position in the first display area as the currently selected navigation label; or in response to a first selection operation on a navigation label in the navigation information, determine the navigation label targeted by the first selection operation as the currently selected navigation label; or in response to a sliding operation on a navigation label in the navigation information, scroll display the navigation labels of the navigation information in the first display area, and in a case where a second selection operation is detected, determine the navigation label targeted by the second selection operation as the currently selected navigation label.

12. The spreadsheet presentation device of claim 8, wherein, The first display unit is further configured to: after displaying at least the list content corresponding to the currently selected navigation label in the navigation information in the second display area of the terminal screen in the width adaptation manner, in response to a sliding operation on the list content in the second display area, scroll display different list content in the second display area, switch the currently selected navigation label to a navigation label corresponding to list content at a set second position in the second display area, and display in the first display area; or in response to a third selection operation on a list content switching control in the second display area, perform switching display of the list content in the second display area, switch the currently selected navigation label to a navigation label corresponding to switched list content, and display in the first display area.

13. The spreadsheet presentation device of claim 8, wherein, The first display unit is further configured to: In response to the target list cell switching trigger instruction in the first display area, the target list cell is re-determined in the plurality of list cells of the target table, and the first generation unit is triggered to repeatedly perform the generation of the navigation information based on the target list cell, the display of the navigation information in the first display area of the terminal screen, and the display of the list content corresponding to the currently selected navigation tab in the navigation information in the second display area of the terminal screen in a width adaptation manner.

14. An electronic spreadsheet presentation device, characterized by Comprise: The second receiving unit is used for receiving a target list cell switching trigger instruction for a target table, the current view of the target table is a target view, the navigation information of the target table is displayed in the first display area of the terminal screen, and the list content corresponding to the currently selected navigation tab in the navigation information is displayed in the second display area of the terminal screen in a width adaptation manner, the navigation information is information generated based on the target list cell determined in the plurality of list cells of the target table, the navigation information comprises at least one navigation tab, the list cell is obtained by dividing the target table in a first direction dimension, the list content of the currently selected navigation tab at least comprises the list content corresponding to the currently selected navigation tab in a second direction dimension, and the second direction dimension is perpendicular to the first direction dimension; the first direction dimension is a row dimension or a column dimension, each navigation tab in the navigation information corresponds to the content of each content cell of the target list cell, the list content corresponding to the currently selected navigation tab comprises the list content corresponding to the currently selected navigation tab in the second direction dimension and the tab content of the currently selected navigation tab, and the width adaptation manner at least comprises line breaking or font size conversion of the content exceeding the width of the second display area, so that the total width of the displayed list content and the tab content is less than or equal to the width of the second display area; The second generation unit is used for re-determining the target list cell in the plurality of list cells of the target table, and re-generating the navigation information based on the re-determined target list cell; The second display unit is used for displaying the re-generated navigation information in the first display area, and displaying the list content corresponding to the currently selected navigation tab in the re-generated navigation information in the second display area in a width adaptation manner.

15. An electronic device, comprising: Comprise: The processor, the memory, and the computer program stored on the memory and executable on the processor, when the computer program is executed by the processor, realize the spreadsheet display method in any one of claims 1 to 6, and / or the steps of the spreadsheet display method in claim 7.

16. A computer-readable storage medium, characterized in that, The computer program is stored on the computer readable storage medium, and when the computer program is executed by the processor, realizes the spreadsheet display method in any one of claims 1 to 6, and / or the steps of the spreadsheet display method in claim 7.

Citation Information

Patent Citations

  • Table information display method and device, equipment and storage medium

    CN111241796A

  • Information display method, information display device, medium and electronic equipment

    CN113177175A

  • Data display method, computing device and storage medium

    CN114169299A