Multi-column table use optimization method and device, medium and product

Abstract

The embodiment of the invention relates to the technical field of image processing, and discloses a use optimization method and device for a multi-column table, a medium and a product. The method comprises the steps that when a table is displayed, left boundary absolute abscissas and right boundary absolute abscissas of a screen display range or a designated area are recognized; identifying a column absolute abscissa of a predetermined key column in the table; if the column absolute abscissa of the key column is smaller than the left boundary absolute abscissa or larger than the right boundary absolute abscissa, generating a quick access button of the key column; and in response to a click operation of the quick access button, moving the key column to the screen display range or the designated area. By adopting the scheme, the purpose of quickly displaying the specific column in the window range can be realized, the use of the table by a user is facilitated, the operation complexity is reduced, the data comparison is facilitated, and the probability of data comparison errors is reduced.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a method, device, medium and product for optimizing the use of a multi-column table. Background Art

[0002] In recent years, with the rapid development of science and technology, the use of forms has become particularly important for workers or students in all walks of life.

[0003] Data tables are commonly used data presentation tools in software development. They can better display data sets and facilitate comparison of the same field values ​​of different data.

[0004] When there are too many columns in a data table, for example, a table in a system has hundreds of columns, it becomes inconvenient to view the data in a specific column. For example, users often need to drag the mouse to scroll horizontally while confirming whether a specific column has been scrolled into the visible area. This not only brings great inconvenience to the operation, but also reduces the user's efficiency and easily causes errors in data comparison. Summary of the invention

[0005] One purpose of the present application is to provide a method, device, medium and product for optimizing the use of a multi-column table, at least to solve the problem that the display operation of a specific column in a table is complicated, inconvenient and prone to comparison errors. The present application identifies the absolute horizontal coordinates of the left boundary and the absolute horizontal coordinates of the right boundary of the screen display range or the specified area when displaying the table; identifies the absolute horizontal coordinates of the columns of the key columns predetermined in the table; if the absolute horizontal coordinates of the columns of the key columns are less than the absolute horizontal coordinates of the left boundary, or greater than the absolute horizontal coordinates of the right boundary, a quick access button for the key column is generated; and in response to a click operation on the quick access button, the key column is moved to the screen display range or the specified area. By adopting this solution, the purpose of quickly displaying a specific column within the window range can be achieved, which facilitates the user's use of the table, reduces the complexity of operation, facilitates data comparison, and reduces the probability of data comparison errors.

[0006] To achieve the above objectives, some embodiments of the present application provide the following aspects:

[0007] In a first aspect, some embodiments of the present application further provide a method for optimizing the use of a multi-column table, the method comprising:

[0008] When displaying a table, identify the absolute horizontal coordinates of the left and right boundaries of the screen display range or the specified area;

[0009] identifying the absolute column abscissa of a predetermined key column in the table;

[0010] If the absolute horizontal coordinate of the key column is smaller than the absolute horizontal coordinate of the left border, or larger than the absolute horizontal coordinate of the right border, then a quick access button for the key column is generated;

[0011] In response to a click operation of the quick access button, the key column is moved to within the screen display range or designated area.

[0012] In a second aspect, some embodiments of the present application further provide an electronic device, comprising: one or more processors; and a memory storing computer program instructions, wherein the computer program instructions, when executed, cause the processor to perform the steps of the method described above.

[0013] In a third aspect, some embodiments of the present application further provide a computer-readable medium having computer program instructions stored thereon, wherein the computer program instructions can be executed by a processor to implement the method as described above.

[0014] In a fourth aspect, some embodiments of the present application further provide a computer program product, comprising a computer program / instruction, which implements the steps of the method described above when executed by a processor.

[0015] Compared with the related art, the solution provided by the embodiment of the present application is to identify the absolute horizontal coordinates of the left and right borders of the screen display range or the specified area when displaying a table; identify the absolute horizontal coordinates of the columns of the key columns predetermined in the table; if the absolute horizontal coordinates of the columns of the key columns are less than the absolute horizontal coordinates of the left border, or greater than the absolute horizontal coordinates of the right border, then generate a quick access button for the key column; in response to a click operation of the quick access button, move the key column to the screen display range or the specified area. By adopting this solution, the purpose of quickly displaying a specific column within the window range can be achieved, which facilitates the user's use of the table, reduces the complexity of operation, facilitates data comparison, and reduces the probability of data comparison errors. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] One or more embodiments are exemplarily described by pictures in the corresponding drawings, and these exemplified descriptions do not constitute limitations on the embodiments. Elements with the same reference numerals in the drawings represent similar elements, and unless otherwise stated, the figures in the drawings do not constitute proportional limitations.

[0017] Figure 1 An exemplary flow chart of a method for optimizing the use of a multi-column table according to some embodiments of the present application;

[0018] Figure 2 A schematic diagram showing a quick access button provided according to some embodiments of the present application;

[0019] Figure 3 Another display schematic diagram of a quick access button provided according to some embodiments of the present application;

[0020] Figure 4 An exemplary structural diagram of the electronic device is disclosed. DETAILED DESCRIPTION

[0021] In order to make the purpose, technical solution and advantages of the embodiments of the present application clearer, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0022] First embodiment

[0023] The first embodiment of the present application relates to a method for optimizing the use of a multi-column table. Figure 1 As shown, the method may include the following steps:

[0024] Step S101, when displaying a table, identifying the absolute horizontal coordinates of the left boundary and the absolute horizontal coordinates of the right boundary of the screen display range or the specified area;

[0025] The display of a table can be the display of the table content after the page (such as a webpage) carrying the table or the table file is opened. Since the table is composed of multiple rows and columns, it will be limited by the range of the window during the display process, and there is a phenomenon that some contents are displayed and some contents cannot be displayed.

[0026] The left boundary of the screen display range or the designated area may be the left boundary of the display screen, and the right boundary of the screen display range or the designated area may be the right boundary of the display screen.

[0027] The absolute horizontal coordinate of the left border of the screen display range or the specified area may be the horizontal coordinate position of the left border in the table, and the absolute horizontal coordinate of the right border of the screen display range or the specified area may be the horizontal coordinate position of the right border in the table.

[0028] Step S102, identifying the absolute horizontal coordinate of a key column predetermined in the table;

[0029] Key columns can be predetermined, automatically determined, or manually specified by the user.

[0030] Similarly, the absolute horizontal coordinate of the key column can be the horizontal coordinate position of the key column in the table. Specifically, it can be the horizontal coordinate position of the center of the key column in the table.

[0031] Step S103, if the absolute horizontal coordinate of the key column is smaller than the absolute horizontal coordinate of the left border, or larger than the absolute horizontal coordinate of the right border, then a quick access button for the key column is generated;

[0032] Among them, if the absolute horizontal coordinate of the key column is smaller than the absolute horizontal coordinate of the left boundary, or larger than the absolute horizontal coordinate of the right boundary, that is, the key column is not fully displayed within the screen display range or the specified area, a quick access button for the key column can be generated.

[0033] Specifically, the quick access button may be displayed in the form of a floating layer.

[0034] Step S104, in response to a click operation of the quick access button, moving the key column to the screen display range or designated area.

[0035] After the quick access buttons of the key columns are displayed, after it is recognized that a user clicks on the quick access button of a key column, the key column can be moved to the screen display range or the designated area.

[0036] In this embodiment, optionally, if the absolute horizontal coordinate of the key column is smaller than the absolute horizontal coordinate of the left border, or larger than the absolute horizontal coordinate of the right border, generating a quick access button for the key column includes:

[0037] If the column absolute horizontal coordinate of the key column is smaller than the absolute horizontal coordinate of the left border, a quick access button for the key column is generated in a preset range on the left side of the screen display range or the designated area;

[0038] or,

[0039] If the column absolute horizontal coordinate of the key column is greater than the right border absolute horizontal coordinate, a quick access button for the key column is generated in a preset range on the right side of the screen display range or the designated area.

[0040] It can be understood that when the absolute horizontal coordinate of the key column is smaller than the absolute horizontal coordinate of the left border, it means that the key column is on the left side of the screen display range or the specified area. If a quick access button needs to be generated, a floating layer can be generated within the preset range on the left side of the screen display range or the specified area, such as a range of 5 cm in length inside the left border, and a quick access button is generated in the floating layer. Similarly, when the absolute horizontal coordinate of the key column is greater than the absolute horizontal coordinate of the right border, it means that the key column is on the right side of the screen display range or the specified area. If a quick access button needs to be generated, a floating layer can be generated within the preset range on the right side of the screen display range or the specified area, such as a range of 5 cm in length inside the right border, and a quick access button is generated in the floating layer.

[0041] Through such a setting, this solution can inform the user on which side of the screen display range or designated area the key column is currently located while displaying the quick access button, thereby improving the user experience.

[0042] In this embodiment, optionally, the quick access button includes column name information of the key column.

[0043] The quick access button may include the name information of the key column. For example, if the name of a key column is "student name", when the student name column is scrolled horizontally out of the screen display range or the specified area, the "student name" may be displayed in the button while the quick access button is generated, so that the user can more clearly know which key columns outside the screen range can be quickly restored by clicking.

[0044] By setting up the solution in this way, after the quick access button is displayed, the user can determine the key columns that he actually needs to view based on the column name information included therein, avoiding clicking a key column that does not actually show the result the user needs, thereby improving the convenience of user use.

[0045] In this embodiment, optionally, the method further includes:

[0046] In response to a key column selection operation on the table, the selected column is determined as the key column of the table.

[0047] In another solution, the key columns can be specified according to the user's operation during the display of the table. For example, after activating the key column selection operation, the user can select multiple columns from a table with 100 columns as key columns. Then click Save to generate one or more key columns selected by the user.

[0048] This solution provides users with the function of selecting key columns. Users can select key columns according to their needs when operating a table. It is not only easy to operate, but also the key column information can be displayed within the window display range at any time during subsequent use. This makes the displayed key columns more in line with the user's viewing needs.

[0049] In this embodiment, optionally, before determining the selected column as the key column of the table, the method further includes:

[0050] Identify whether the number of key columns of the table reaches a preset number;

[0051] If it is reached, a key column saturation prompt message is generated;

[0052] If not reached, the selected column is determined as the key column of the table.

[0053] In this solution, during the selection process, it is possible to identify in real time whether the number of key columns selected by the user has reached a preset number. If not, the selection can continue. If it has reached the preset number, a prompt message indicating that the key columns are saturated needs to be generated.

[0054] The preset number can be determined based on the total number of data columns in the table. For example, one tenth of the total number can be used as the preset number, that is, if the table has 100 columns, the user can select 10 columns as key columns. In addition, the preset number can be determined based on the width of the column and the width of the window display range. For example, if the window can display up to 10 columns, 10 columns can be used as the preset number. In addition, a fixed value can be set for any table. For example, no matter how many columns the table has, 12 columns can be set as key columns.

[0055] By setting the number of key columns, this solution can call up key columns at any time during actual use, while not causing the quick access buttons for the key columns to occupy too large an area of ​​the screen display range or the designated area due to too many key columns, affecting the user's normal viewing of the table data, thereby improving the user's usage experience.

[0056] In this embodiment, optionally, the method further includes:

[0057] In response to a key column deletion operation on the table, a designated column is deleted from the key columns of the table.

[0058] It is understandable that after determining the key columns, the user may not pay much attention to the data in some key columns when using the table. In this case, the user can delete the key columns according to the needs. For example, when entering the activation key column deletion page, the key columns can be deleted according to the data columns selected by the user, or the column corresponding to the quick access button can be deleted from the key columns by right-clicking the mouse on a key column in the displayed quick access buttons and deleting it.

[0059] Through such a setting, this solution can achieve flexible control of key columns and improve user convenience.

[0060] In this embodiment, optionally, the method further includes:

[0061] When displaying a table, listen for the horizontal scrolling event of the table;

[0062] Identify the absolute abscissa of the left boundary and the absolute abscissa of the right boundary of the screen display range or the specified area, and identify the absolute abscissa of the columns of the pre-determined key columns in the table to identify whether the key columns have moved out of the screen display range or the specified area;

[0063] If so, generate a quick access button for the key column.

[0064] Among them, this solution proposes to generate a quick access button for the key columns that move out of the visible area. When the user clicks the quick access button, the table will automatically scroll horizontally to display the key columns selected by the user.

[0065] The specific steps are as follows:

[0066] Obtain the absolute abscissa of the screen on the left and right sides of the visible area of the table, named view_left and view_right;

[0067] Listen for the horizontal scroll event of the table;

[0068] When the user scrolls the table horizontally, obtain the absolute abscissa column_A_left and column_A_right on the left and right sides of the key column A;

[0069] Judge whether these key columns have moved out of the visible area while scrolling. For example: column_A_right < view_left indicates that the key column A has moved out of the visible area to the left; column_A_left > view_right indicates that the key column A has moved out of the visible area to the right.

[0070] If it has scrolled out of the visible area, generate a quick access button. The user can click the button to quickly scroll the key column A back to the visible area automatically.

[0071] Figure 2 FIG. is a schematic diagram of the display of the quick access button provided according to some embodiments of the present application; Figure 3 FIG. is another schematic diagram of the display of the quick access button provided according to some embodiments of the present application. As Figure 2 shown, when the key column moves outside the right side of the visible area, the quick access button of the key column can be displayed within a certain range on the right side of the table. For example, "permission module", "maximum number of database connections", and "number of concurrent logged-in users" among them. The user can click on a quick access button to display the key column within the visible range. Similarly, as Figure 3As shown in the figure, when a key column moves out of the left side of the visible area, a quick access button of the key column can be displayed in a certain range on the left side of the table. For example, among the "Customer ID", "System Name", "System Version" and "License Loading Time", the user can click on a quick access button to display the key column in the visible range.

[0072] Through this solution, a quick access button can be generated for the key columns of the table that are moved out of the visible area. When the user clicks the quick access button, the table automatically scrolls to the corresponding key column, saving the user's time in finding the key column and improving work efficiency.

[0073] In addition, some embodiments of the present application also provide an electronic device. The electronic device may be a digital computer in various forms, such as a laptop computer, a desktop computer, a workbench, a personal digital assistant, a server, a blade server, a mainframe computer, etc. The electronic device may also be a mobile device in various forms, such as a personal digital processing, a cellular phone, a smart phone, a wearable device, and other similar computing devices.

[0074] The electronic device includes: one or more processors; and a memory storing computer program instructions, wherein when the computer program instructions are executed, the processor executes the steps of the method provided in any one or more of the above embodiments. Figure 4 An exemplary structural diagram of the electronic device is disclosed. Figure 4 As shown, the electronic device includes: one or more processors 401, memory 402, and interfaces for connecting various components, including high-speed interfaces and low-speed interfaces. The various components are connected to each other using different buses and can be installed on a common mainboard or installed in other ways as needed. The processor can process instructions executed in the electronic device, including instructions stored in or on the memory to display the graphical information of the GUI on an external input / output device (such as a display device coupled to the interface). In some other embodiments, if necessary, multiple processors and / or multiple buses can be used together with multiple memories and multiple memories. Similarly, multiple electronic devices can be connected, and each device provides some necessary operations (for example, as a server array, a group of blade servers, or a multi-processor system). Among them, the components shown in this article, their connections and relationships, and their functions are only used as examples, and are not intended to limit the implementation of the present application described and / or required herein.

[0075] The electronic device may further include: an input device 403 and an output device 404. The processor 401, the memory 402, the input device 403 and the output device 404 may be connected via a bus or other means. Figure 4The example of connecting through bus is taken in the following.

[0076] The input device 403 can receive input digital or character information, and generate key signal input related to the user settings and function control of the electronic device, such as a touch screen, a keypad, a mouse, a track pad, a touch pad, an indicator bar, one or more mouse buttons, a trackball, a joystick and other input devices. The output device 404 may include a display device, an auxiliary lighting device (e.g., an LED) and a tactile feedback device (e.g., a vibration motor), etc. The display device may include, but is not limited to, a liquid crystal display (LCD), a light emitting diode (LED) display and a plasma display. In some embodiments, the display device may be a touch screen.

[0077] To provide interaction with a user, the electronic device may be a computer. The computer has: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and a pointing device (e.g., a mouse or a trackball), through which the user can provide input to the computer. Other types of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, voice input, or tactile input).

[0078] In the embodiments of the present application, a computer program / instruction is stored on a computer-readable medium, and when the computer program / instruction is executed by a processor, the steps of the method provided by any one or more of the above embodiments are implemented. The computer-readable medium may be included in the electronic device described in the above embodiments; or it may exist independently without being assembled into the device. The above computer-readable medium carries one or more computer-readable instructions.

[0079] The memory 402 can be used as a non-transient computer-readable storage medium, which can be used to store non-transient software programs, non-transient computer executable programs and modules. The processor 401 executes various functional applications and data processing of the server by running the non-transient software programs, instructions and modules stored in the memory 402, so as to implement the program instructions / modules corresponding to the method provided by any one or more of the above embodiments in the embodiments of the present application.

[0080] The memory 402 may include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application required for at least one function; the data storage area may store data created according to the use of the electronic device, etc. In addition, the memory 402 may include a high-speed random access memory, and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage devices. In some embodiments, the memory 402 may optionally include a memory remotely arranged relative to the processor 401, and these remote memories may be connected to the electronic device via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0081] It should be noted that the computer-readable medium described in the present application may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present application, a computer-readable medium may be any tangible medium containing or storing a program that can be used by or in combination with an instruction execution system, device or device.

[0082] Computer readable media include permanent and non-permanent, removable and non-removable media, and can be implemented by any method or technology to store information. Information can be computer readable instructions, data structures, modules of programs or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, read-only compact disk (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape disk storage or other magnetic storage devices or any other non-transmission medium that can be used to store information that can be accessed by a computing device.

[0083] Computer program code for performing the operations of the present application may be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages, such as Java, Smalltalk, C++, and conventional procedural programming languages, such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0084] In the above-described embodiments, it can be implemented in whole or in part by software, hardware, firmware or any combination thereof. For example, it can be implemented by using an application specific integrated circuit (ASIC), a general-purpose computer or any other similar hardware device. In certain embodiments, the software program of the present application can be executed by a processor to implement the above steps or functions. Similarly, the software program of the present application (including relevant data structures) can be stored in a computer-readable recording medium, for example, a RAM memory, a magnetic or optical drive or a floppy disk and similar devices. In addition, some steps or functions of the present application can be implemented by hardware, for example, as a circuit that cooperates with a processor to perform each step or function.

[0085] The computer program product provided in the embodiment of the present application includes one or more computer programs / instructions, and when the computer program / instructions are executed by the processor, the process or function described in the embodiment of the present application is generated in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable devices. The computer instructions may be stored in a computer-readable storage medium, or transmitted from a computer-readable storage medium to another computer-readable storage medium, for example, the computer instructions may be transmitted from a website site, a computer, a server or a data center by wired (e.g., coaxial cable, optical fiber, digital subscriber line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.) mode to another website site, computer, server or data center. The computer-readable storage medium may be any available medium that a computer can access or a data storage device such as a server or a data center that includes one or more available media integrations. The available medium may be a magnetic medium, (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a semiconductor medium (e.g., a solid state disk (SSD)), etc.

[0086] The flow chart or block diagram in the accompanying drawings shows the possible architecture, function and operation of the equipment, method and computer program product according to various embodiments of the present application. In this regard, each box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram and / or flow chart, and the combination of the boxes in the block diagram and / or flow chart can be implemented with a dedicated system for hardware that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0087] The scope of the present application is defined by the appended claims rather than the above description, and it is intended that all changes that fall within the meaning and scope of the equivalent elements of the claims are included in the present application. Any figure mark in the claims should not be regarded as limiting the claims involved. In addition, it is clear that the word "comprising" does not exclude other units or steps, and the singular does not exclude the plural. Multiple units or devices stated in the device claim may also be implemented by one unit or device through software or hardware. The words "first", "second", etc. are only used to distinguish the description, and do not indicate any particular order, nor can they be understood as indicating or implying relative importance.

[0088] 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 mention changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims, and the above embodiments should be regarded as exemplary and non-restrictive.

Claims

1. A method for optimizing the use of a multi-column table, characterized in that: When displaying a table, identify the absolute horizontal coordinates of the left and right boundaries of the screen display range or the specified area; identifying the absolute column abscissa of a predetermined key column in the table; If the absolute horizontal coordinate of the key column is smaller than the absolute horizontal coordinate of the left border, or larger than the absolute horizontal coordinate of the right border, then a quick access button for the key column is generated; In response to a click operation of the quick access button, the key column is moved to within the screen display range or designated area.

2. The method according to claim 1, characterized in that If the absolute horizontal coordinate of the key column is less than the absolute horizontal coordinate of the left border, or greater than the absolute horizontal coordinate of the right border, then generating a quick access button for the key column includes: If the column absolute horizontal coordinate of the key column is smaller than the absolute horizontal coordinate of the left border, a quick access button for the key column is generated in a preset range on the left side of the screen display range or the designated area; or, If the column absolute horizontal coordinate of the key column is greater than the right border absolute horizontal coordinate, a quick access button for the key column is generated in a preset range on the right side of the screen display range or the designated area.

3. The method according to claim 2, characterized in that The quick access button includes the column name information of the key column.

4. The method according to claim 1, characterized in that: The method further comprises: In response to a key column selection operation on the table, the selected column is determined as the key column of the table.

5. The method according to claim 4, characterized in that Before determining the selected column as a key column of the table, the method further includes: Identify whether the number of key columns of the table reaches a preset number; If it is reached, a key column saturation prompt message is generated; If not reached, the selected column is determined as the key column of the table.

6. The method according to claim 1, characterized in that The method further comprises: In response to a key column deletion operation on the table, a designated column is deleted from the key columns of the table.

7. The method according to claim 1, characterized in that The method further comprises: When displaying a table, listen for the horizontal scrolling event of the table; Identify the absolute horizontal coordinates of the left boundary and the right boundary of the screen display range or the designated area, and identify the absolute horizontal coordinates of the key columns predetermined in the table to identify whether the key columns are moved out of the screen display range or the designated area; If so, a quick access button for the key column is generated.

8. An electronic device, characterized in that: The electronic device comprises: one or more processors; and A memory storing computer program instructions, which, when executed, cause the processor to perform the steps of the method as claimed in any one of claims 1 to 7.

9. A computer readable medium having a computer program / instruction stored thereon, characterized in that: When the computer program / instructions are executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.

10. A computer program product comprising a computer program / instructions, characterized in that When the computer program / instructions are executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.

Images