Table processing method and device, electronic equipment and program product

Abstract

The invention provides a table processing method and device, electronic equipment and a program product. The table processing method comprises the steps that in response to a first instruction for a first cell, a first detail display area is displayed, and detail content of the first cell is displayed in the first detail display area; in response to the second instruction, a second detail display area is displayed, and the position of the second detail display area is associated with the position of the first detail display area; and displaying the detail content of the second cell in the second detail display area in response to a third instruction for the second cell. Thus, detail contents of different cells can be synchronously presented to a user through the first detail display area and the second display area, convenient display and visual comparison of multi-cell details are achieved, and the comparison efficiency of cell data is effectively improved.

Description

Technical Field

[0001] This disclosure relates to the field of computer technology, and specifically to a table processing method, apparatus, electronic device, and program product. Background Technology

[0002] Spreadsheets, as a core tool for data storage, processing, and display, are widely used in various scenarios such as office collaboration, R&D testing, and data analysis. In related spreadsheet technologies, when cells are filled with large amounts of text or complex formatting, the content is often truncated due to space limitations. To view the complete content, users typically need to double-click the cell to enter edit mode or manually adjust the cell's row height and column width to fit the content. In some applications, if users need to compare the content of two rows or columns (such as verifying two sets of related data or comparing multiple output results under different schemes), they often need to repeatedly switch between the two rows or columns, and adjust the cell size after each switch to ensure complete display. This process is not only cumbersome but also prone to accidental touches due to frequent switching, severely reducing the efficiency of cell data comparison. Summary of the Invention

[0003] This summary section is provided to briefly introduce the concepts, which will be described in detail in the detailed description section below. This summary section is not intended to identify key or essential features of the claimed technical solution, nor is it intended to limit the scope of the claimed technical solution.

[0004] In a first aspect, according to one or more embodiments of this disclosure, a table processing method is provided, comprising:

[0005] In response to a first instruction on the first cell, a first details display area is displayed, in which the details content of the first cell is displayed;

[0006] In response to the second instruction, a second details display area is displayed, the position of which is associated with the position of the first details display area;

[0007] In response to the third instruction on the second cell, the details of the second cell are displayed in the second details display area.

[0008] Secondly, according to one or more embodiments of the present disclosure, a form processing apparatus is provided, comprising:

[0009] The first display unit is configured to display a first details display area in response to a first instruction on the first cell, and to display the details content of the first cell in the first details display area;

[0010] The second display unit is configured to display a second details display area in response to a second instruction, wherein the position of the second details display area is associated with the position of the first details display area;

[0011] The associated display unit is used to display the details of the second cell in the second details display area in response to a third instruction on the second cell.

[0012] Thirdly, according to one or more embodiments of the present disclosure, an electronic device is provided, comprising: at least one memory and at least one processor; wherein the memory is configured to store program code, and the processor is configured to invoke the program code stored in the memory to cause the electronic device to perform a method provided according to one or more embodiments of the present disclosure.

[0013] Fourthly, according to one or more embodiments of the present disclosure, a computer program product is provided, including a computer program / instructions that, when executed by a processor, implement the method provided according to one or more embodiments of the present disclosure.

[0014] According to one or more embodiments of this disclosure, a first details display area is displayed in response to a first instruction on a first cell, and the details of the first cell are displayed in the first details display area. In response to a second instruction, a second details display area is displayed, the position of the second details display area being associated with the position of the first details display area. In response to a third instruction on a second cell, the details of the second cell are displayed in the second details display area. In this way, the details of different cells can be presented to the user simultaneously through the first details display area and the second details display area, realizing convenient display and intuitive comparison of details of multiple cells, and effectively improving the comparison efficiency of cell data. Attached Figure Description

[0015] The above and other features, advantages, and aspects of the embodiments of this disclosure will become more apparent from the accompanying drawings and the following detailed description. Throughout the drawings, the same or similar reference numerals denote the same or similar elements. It should be understood that the drawings are schematic, and the originals and elements are not necessarily drawn to scale.

[0016] Figure 1 A flowchart illustrating a table processing method provided in an embodiment of this disclosure;

[0017] Figure 2 A flowchart illustrating a table processing method provided in another embodiment of this disclosure;

[0018] Figures 3A-3C A schematic diagram of a first details display area and a second details display area provided in an embodiment of this disclosure is shown;

[0019] Figures 4A-4B This illustration shows a schematic diagram of displaying preview content through a details display area according to an embodiment of the present disclosure;

[0020] Figure 5 Data flow diagram of a table processing method provided in yet another embodiment of this disclosure;

[0021] Figure 6 This is a schematic diagram of the structure of a table processing apparatus provided in an embodiment of the present disclosure;

[0022] Figure 7 This is a schematic diagram of the structure of an electronic device provided according to an embodiment of the present disclosure. Detailed Implementation

[0023] Embodiments of this disclosure will now be described in more detail with reference to the accompanying drawings. While some embodiments of this disclosure are shown in the drawings, it should be understood that this disclosure can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided to provide a more thorough and complete understanding of this disclosure. It should be understood that the accompanying drawings and embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of protection of this disclosure.

[0024] It should be understood that the steps described in the embodiments of this disclosure may be performed in different orders and / or in parallel. Furthermore, embodiments may include additional steps and / or omit the steps shown. The scope of this disclosure is not limited in this respect.

[0025] The term "comprising" and its variations as used herein are open-ended inclusion, meaning "including but not limited to". The term "based on" means "at least partially based on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". The term "in response to" and related terms mean that one signal or event is affected to some extent by another signal or event, but not necessarily completely or directly. If event x occurs "in response to" event y, then x may be directly or indirectly responsive to y. For example, the occurrence of y may ultimately lead to the occurrence of x, but there may be other intermediate events and / or conditions. In other cases, y may not necessarily lead to the occurrence of x, and x may occur even if y has not yet occurred. Furthermore, the term "in response to" can also mean "at least partially responsive to".

[0026] The term "determine" broadly encompasses a wide variety of actions, including acquisition, calculation, computation, processing, derivation, investigation, search (e.g., searching in a table, database, or other data structure), discovery, and similar actions; it may also include receiving (e.g., receiving information), accessing (e.g., accessing data in memory), parsing, selecting, choosing, building, and similar actions, etc. Definitions for other terms will be provided below.

[0027] It is understood that the data involved in this technical solution (including but not limited to the data itself, the acquisition or use of the data) shall comply with the provisions of relevant laws and regulations.

[0028] As an optional but non-restrictive implementation, in response to a user's active request, a prompt message can be sent to the user, such as a pop-up window, where the prompt message can be presented in text format. Furthermore, the pop-up window can also include a selection control allowing the user to choose "agree" or "disagree" to provide personal information to the electronic device.

[0029] It is understood that the above notification and user authorization process is merely illustrative and does not constitute a limitation on the implementation of this disclosure. Other methods that comply with relevant laws and regulations may also be applied to the implementation of this disclosure.

[0030] It should be noted that the concepts of "first" and "second" mentioned in this disclosure are used only to distinguish different objects, devices, modules or units, and are not used to limit the order of the functions performed by these objects, devices, modules or units or their interdependencies.

[0031] It should be noted that the terms "a" and "a plurality of" used in this disclosure are illustrative rather than restrictive, and those skilled in the art should understand that, unless otherwise expressly indicated in the context, they should be understood as "one or more".

[0032] For the purposes of this disclosure, the phrase “A and / or B” means (A), (B) or (A and B).

[0033] The names of messages or information exchanged between multiple devices in the embodiments of this disclosure are for illustrative purposes only and are not intended to limit the scope of such messages or information.

[0034] refer to Figure 1 It illustrates a table processing method provided in an embodiment of this disclosure, including steps S110-S130:

[0035] Step S110: In response to the first instruction on the first cell, display the first details display area and display the details of the first cell in the first details display area.

[0036] In some embodiments, the table may include a local spreadsheet or an online spreadsheet. The execution entity of method 100 can be a client, such as an instant messaging (IM) client, which integrates online spreadsheet functionality. The client loads the online spreadsheet page by calling the browser kernel through an interface provided by the browser. Users can create and edit online spreadsheets based on the loaded page, and can also share online spreadsheets through the client. In other embodiments, the client integrates a browser kernel, and displays the online spreadsheet page on the client by calling the browser kernel. In other embodiments, the client is an online document client, and the loading and display of the online spreadsheet page is achieved by running an online document client. In still other embodiments, the loading and display of the online spreadsheet page can also be achieved through an online spreadsheet function applet.

[0037] A table interface typically includes basic functional areas such as a toolbar, cell area, status bar, and cell editing area. According to embodiments of this disclosure, the table interface may also display one or two detail display areas, such as a first detail display area and a second detail display area, which can be used to display the detailed content of their respective associated cells. The detail display area can be displayed in the sidebar, bottom bar, or other suitable location of the table interface that does not obscure the main content of the current cell area.

[0038] In some embodiments, after a user selects any cell in a table, a details display area corresponding to that cell is displayed via a first instruction. For example, after a user selects a cell in a table, the details display area can be displayed via a right-click menu or by triggering a preset control in the toolbar. For instance, a right-click menu can be pre-configured for the table area, and a function option (such as "View Cell Details") can be set in the menu and assigned a unique identifier. When the user clicks this function option, an instruction to display the sidebar is issued by calling the interface of the state management tool, modifying the relevant global state. After the sidebar component detects the state change, it triggers the component mounting process and reads the currently active cell position as the initial rendering parameter.

[0039] Step S120: In response to the second instruction, display the second details display area.

[0040] The second instruction is used to trigger the display of a second details display area. In some embodiments, the second cell display area may be displayed in response to the triggering of a preset control in the first cell display area. In other embodiments, the second details display area may be displayed in response to the triggering of a preset control in the toolbar.

[0041] In some embodiments, the position of the second details display area is associated with the position of the first details display area. For example, the second details display area and the first details display area can be positioned side-by-side or vertically aligned. By associating the positions of the first and second details display areas, users can easily compare data using the first and second details display areas.

[0042] In some embodiments, the first detail display area is associated with a first control and a second control; in response to the first control being triggered, the second detail display area is loaded and displayed side-by-side with the first detail display area; or, in response to the second control being triggered, the second detail display area is loaded and displayed vertically with the first detail display area. For example, a state variable can be defined and maintained specifically to record the sidebar layout mode (such as the first mode or the second mode). When the user triggers a mode switching operation, this state variable is updated in real time to ensure that the system can recognize the current column mode. Based on the column mode selected by the user, the array structure storing cell information internally is adjusted. If switching to columns (i.e., switching from a single cell detail area to two detail display areas), the length is set to 2 through array operations, corresponding to two columns respectively, and a unique identifier is assigned to each column for subsequent rendering identification. The outer container element of the sidebar has preset style logic. Based on the state variable, the corresponding style is dynamically applied to the container element of the sidebar, so that the two sidebars (i.e., the detail display areas) actually present a horizontal or vertical column effect.

[0043] Step S130: In response to the third instruction on the second cell, display the details of the second cell in the second details display area.

[0044] The third instruction is used to associate the second details display area with the second cell, so that the second details display area displays the details content of the second cell. In some embodiments, after creating the second details display area, the user can associate the second details display area with the second cell by selecting the second cell in the cell area, or by entering or selecting the index of the second cell in a preset area associated with the second details display area, but this disclosure is not limited thereto.

[0045] According to one or more embodiments of this disclosure, a first details display area is displayed in response to a first instruction on a first cell, and the details of the first cell are displayed in the first details display area. In response to a second instruction, a second details display area is displayed, and in response to a third instruction on a second cell, the details of the second cell are displayed in the second details display area. In this way, the details of different cells can be conveniently and synchronously presented to the user through the first details display area and the second details display area, realizing convenient display and intuitive comparison of details of multiple cells, and effectively improving the comparison efficiency of cell data.

[0046] refer to Figure 2 This illustrates a table processing method provided in another embodiment of the present disclosure, including steps S210-S230:

[0047] Step S210: Display the first detail display area and the second detail display area, where the first detail display area and the second detail display area display the details of the cells associated with each other.

[0048] In some embodiments, corresponding controls can be preset in the toolbar, which, when triggered, display a first details display area and / or a second details display area in the table interface.

[0049] In other embodiments, after a user selects any cell in the table, a menu is brought up via a preset command (such as right-clicking), and the user can open the details display area corresponding to that cell by selecting a preset function option in the menu. For example, a right-click menu can be pre-configured for the table area, and function options (such as "View Cell Details") can be set in the menu and assigned a unique identifier. When the user clicks this function option, a command to display the sidebar is issued by calling the interface of the state management tool, modifying the relevant global state. After the sidebar component detects the state change, it triggers the component mounting process and reads the position of the currently active cell as the initial rendering parameter.

[0050] In some embodiments, for any detail display area, the detail display area can be made active in response to an operation event (such as a click event) on the detail display area, and the active detail display area can be associated with the target cell in response to a selection event on the target cell.

[0051] For example, a status identifier can be pre-configured and maintained to record the unique identifier (ID) of the currently active detail display area; click event listeners can be bound to the first and second detail display areas respectively. When a user clicks on a detail display area, the event listener is triggered, updating the status identifier to the unique identifier of that detail display area; a global event subscriber is registered to listen for cell selection events; when a user selects a cell in the table, the index of that cell (such as row number and column number) is obtained synchronously, and based on the active display area recorded in the current status identifier, the index information of that cell is associated and stored in the data source corresponding to that active display area, thereby triggering the preview function module to load the complete content of the cell corresponding to that index and present it in the corresponding detail display area. Through the above operations, users can specify the associated cells for the first and second detail display areas.

[0052] Step S220: In response to the cell associated with the first details display area being updated from the first cell to the third cell, the cell associated with the second details display area is updated from the second cell to the fourth cell; wherein the relative positional relationship between the fourth cell and the third cell matches the relative positional relationship between the second cell and the first cell.

[0053] In some embodiments, the fourth cell is determined by the following steps:

[0054] The fourth cell is determined based on the position of the third cell and the relative positional relationship between the second cell and the first cell; or,

[0055] The fourth cell is determined based on the position of the second cell and the relative positional relationship between the third cell and the first cell.

[0056] In some embodiments, the relative positional relationship between the cells currently associated with the two detail display areas can be automatically recorded. In response to the switching of a cell associated with one detail display area, the other detail display area can automatically and synchronously switch its associated cell based on the relative positional relationship.

[0057] For example, when recording relative positional relationships, the data source status corresponding to the two detail display areas is first verified to confirm that both detail display areas are associated with valid cell indexes. Then, for the row / column range between associated cells, the visibility status of each row and column within that range is checked sequentially in the current view to prevent any rows or columns from being hidden, collapsed, or otherwise invisible. An incremental statistical method is used, traversing step-by-step from the index position of the first cell to the index position of the second cell. Each time a visible row or column is identified, the corresponding visual offset statistical value is incrementally updated, ultimately obtaining the visible row offset and visible column offset between the two cells, which are then persistently saved. When a change is detected in the cell associated with the first detail display area, the index of the updated associated cell (such as the latest row number and column number) is obtained. Based on the index of the updated cell (i.e., the third cell) and the visual offsets (i.e., the visible row offset and the visible column offset), the index of the target cell (i.e., the fourth cell) that the second detail display area should synchronously associate with is determined. To avoid errors in the target cell index due to hidden, collapsed, or otherwise invisible rows / columns, the target cell index is determined by starting with the index information of the switched cell and searching in the positive or negative direction of the visible offset. The visibility status of each row / column is monitored in real time during the search. If the current row / column is visible, one offset point is consumed, continuing until the offset point reaches zero, at which point the target cell index is obtained.

[0058] Step S230: Display the details of the third cell in the first details display area, and display the details of the fourth cell in the second details display area.

[0059] In this step, the details of the third cell can be displayed in the first details display area, and the details of the fourth cell can be displayed in the second details display area.

[0060] refer to Figure 3A The table interface 10 displays a first details display area 21 and a second details display area 22. The first details display area 21 is currently associated with cell A1 (i.e., the first cell). Due to cell size limitations, only a portion of the content in cell A1 can be displayed, while the first details display area 21 allows users to easily browse the detailed content of cell A1. Similarly, the second details display area 22 is currently associated with cell C1 (i.e., the second cell) and can be used to allow users to easily browse the detailed content of cell C1. The total number of characters in the content of the respective associated cells can be displayed at preset positions in the first and second details display areas.

[0061] refer to Figure 3B If a user uses methods such as mouse clicks or keyboard arrow keys to update the cell associated with the first details display area 21 from cell A1 to cell A2 (i.e., the third cell), the cell associated with the second details display area 22 will automatically update to cell C2 (i.e., the fourth cell), without the user needing to manually associate the second details display area 22 with cell C2. Similarly, see [reference needed]. Figure 3C If the user uses a mouse click or keyboard arrow keys to switch the cell associated with the first details display area 21 to cell B3, the cell associated with the second details display area 22 can be automatically updated to cell D3.

[0062] According to embodiments of this disclosure, by displaying a first detail display area and a second detail display area in the table interface, in response to the cell associated with the first detail display area being updated from the first cell to the third cell, the cell associated with the second detail display area being updated from the second cell to the fourth cell, the relative positional relationship between the fourth cell and the third cell matches the relative positional relationship between the second cell and the first cell. In this way, the cells associated with the first and second detail display areas can be switched synchronously, eliminating the need for the user to repeatedly manually associate cells, and greatly improving the efficiency of table data comparison.

[0063] In some embodiments, the function of synchronously switching between cells associated with one detail display area and cells associated with another detail display area can be enabled by default or actively enabled by the user through commands such as triggering corresponding controls.

[0064] In some embodiments, in response to the cell associated with the first details display area being updated from the first cell to the third cell, the cell associated with the second details display area is updated from the second cell to the fourth cell; wherein the fourth cell and the third cell have a first positional relationship, the second cell and the first cell have a second positional relationship, and the first positional relationship matches the second positional relationship.

[0065] In some embodiments, if the visible row offset between the second cell and the first cell is N and the visible column offset is M, then the visible row offset between the fourth cell and the third cell can also be N and M, respectively.

[0066] In some embodiments, the first positional relationship may include the second cell having the same row number or column number as the first cell, and correspondingly, the second positional relationship may include the fourth cell having the same row number or column number as the first cell.

[0067] In some embodiments, if the first cell and the second cell have the same row number or column number, a synchronization display instruction is received, and the two cells belonging to the same row number or the same column number are displayed synchronously in their respective detail display areas. For example, when the second cell selected by the user has the same row number or column number as the first cell, the spreadsheet can proactively issue a prompt message, prompting the user to trigger the corresponding control to perform linked operation on the detail display areas of the first and second cells. After this control is triggered, each time the user selects a target cell, the cells associated with the first and second detail display areas will be synchronously refreshed and displayed. For example, refer to... Figure 3A and Figure 3B When cells A1 and C1, which belong to the same row, are designated by the user as cells associated with the first detail display area 21 and the second detail display area 22, respectively, the user can trigger a synchronous display command through control 23; thereafter, when the user clicks cell A2, the first detail display area 21 and the second detail display area 22 will synchronously display the details of cells A2 and C2, and so on.

[0068] In some embodiments, the first detail display area and its associated cells are displayed using a first association display scheme, and the second detail display area and its associated cells are displayed using a second association display scheme, wherein the first association display scheme and the second association display scheme are different. For example, refer to... Figure 3AThis allows the first details display area to have a border of color A, and its associated cells to have the same or similar color scheme, such as making the border color and / or background color of the cell the same or similar to color A. Similarly, the second details display area can have an outer border of color B, and its associated cells to have the border color and / or background color the same or similar to color B, while colors A and B are different. In this way, users can quickly distinguish between the two details display areas and their respective associated cells in the table using different color schemes, avoiding confusion in the correspondence during comparison of multiple sets of data, and further improving the intuitiveness and efficiency of cell content comparison.

[0069] It should be noted that the first or second associated display scheme is not limited to the color display scheme based on the border color and / or background color mentioned above. It can also adopt display schemes that can make it easy for users to visually identify the association, such as marker symbol association, fill style association, dynamic effect association, or font feature association. This disclosure is not limited to these.

[0070] In some embodiments, displaying the details of the third cell in the first details display area and the details of the fourth cell in the second details display area includes: synchronously updating the position information of the third and fourth cells to the storage module; and controlling the first and second details display areas to synchronously refresh the content of the corresponding cells based on the updated position information. For example, the position information of the third and fourth cells can be synchronously updated to the data layer, and a preset scheduling mechanism can be used to ensure that the first and second details display areas are synchronously refreshed within the same rendering frame, achieving a synchronized switching display effect.

[0071] In some embodiments, in response to a scrolling operation of one of the detail display areas (the first and the second detail display areas), the content in the other detail display area can also be scrolled synchronously. For example, refer to... Figure 3A Both the first details display area 21 and the second details display area 22 have scroll bars on their right sides. When the user scrolls the first details display area 21 up and down, the second details display area 22 will scroll synchronously. Thus, when the content loaded in both details display areas is long (such as large blocks of text or multiple data records), the user does not need to adjust the scroll bars of each display area separately to achieve synchronous scrolling of the content in both columns, further improving data comparison efficiency.

[0072] In some embodiments, in response to a locking operation on a details display area, the cells associated with that details display area can be prevented from automatically switching with another details display area. The details display area can be either a first details display area or a second details display area. In some data comparison applications, the data used for comparison may be fixed data, and users may not want the cells associated with a details display area to switch synchronously with cells associated with another details display area. For example, a "lock" button can be set at a preset position in each details display area. When a user clicks the "lock" button in the second details display area, that display area enters a locked state, and its associated cells will retain their current data. When the user subsequently switches the cells associated with the first details display area, the second details display area will still display the original locked data and will not change synchronously with the first details display area. This retains the efficiency of synchronous switching while meeting the personalized needs of fixed data comparison.

[0073] In some embodiments, the details display area displays the identifier of its associated cell, so that users can intuitively know the location of the original table cell corresponding to the content of the current display area.

[0074] In some embodiments, the details display area includes a copy control to allow users to quickly copy the complete content in the current display area.

[0075] In some embodiments, the details display area (including a first or second details display area) supports displaying a visual preview of the rich elements corresponding to the associated cells. The rich elements include at least one of the following: structured text, multimedia files, document attachments, and web links. Structured text is formatted text with preset syntax rules and hierarchical structure, including but not limited to JSON, Markdown, XML, YAML, etc.; multimedia files include image files, video files, audio files, etc.; document attachments are documents inserted into the cell as attachments, and their formats include but are not limited to DOCX, XLSX, PPT, PDF, etc.

[0076] In some embodiments, if the rich element includes structured text, the corresponding structured representation is displayed in the details display area. This structured representation can show the grammatical rules and hierarchical structure of the structured text.

[0077] Taking JSON format as an example, the original JSON text presented in the cell is usually a compact string without indentation or hierarchical structure (such as {"name":"table","type":"JSON"}); in this embodiment, the details display area can display a structured view with hierarchical indentation and key-value color differentiation, supporting functions such as node collapse and expansion, which conforms to the general visual reading habits of JSON format.

[0078] Taking Markdown format as an example, the original Markdown text displayed in a cell is usually plain text with native syntax markers (such as # first-level heading, **bold text**, [link](https: / / xxx.com)), whose syntax markers are not parsed and rendered, but are only displayed as ordinary characters; in this embodiment, the details display area can parse the above syntax markers and convert them into corresponding format effects (such as heading styles, bold text, clickable links, etc.), presenting the rich text effect of this format.

[0079] In some embodiments, if the rich element includes a multimedia file, a playback or display view of the multimedia file is displayed in the details display area. For example, see [link to relevant documentation]. Figure 4A If the multimedia file is an image, the cell will usually display a small or thumbnail of the image, while the details display area will show a larger, higher-resolution image. If the multimedia file is a video or audio file, the cell will usually only display the file icon or address, while the details display area can show the corresponding playback interface, allowing users to directly perform operations such as play and pause.

[0080] In some embodiments, if the rich element includes a document attachment, then a preview of all or part of the document content can be displayed in the details display area.

[0081] In some embodiments, if the rich element includes a webpage link, a preview of the webpage corresponding to the link can be displayed in the details display area. (See also...) Figure 4B Cell C3 originally displays a webpage link xx.com, and the details display area associated with this cell can show a preview of the relevant webpage.

[0082] According to one or more embodiments of this disclosure, users can directly view the visual preview content of various rich elements in the details display area without jumping to external tools or pages, which improves the reading efficiency of table content and further enhances the data comparison experience.

[0083] refer to Figure 5 It illustrates a table processing method provided in an embodiment of this disclosure, including steps S510-S530:

[0084] Step S510: Display a details display area in the table interface. The details display area is used to display the details of the associated cells. In some embodiments, the display mode of the details display area includes a first mode and a second mode;

[0085] Step S520: In response to the details display area being displayed in the first mode, the original content of the associated cell is displayed in the details display area;

[0086] Step S530: In response to the details display area being displayed in the second mode, the preview content corresponding to the rich element in the associated cell is displayed in the details display area.

[0087] In some embodiments, the first mode can be the original mode and the second mode can be the parsed mode.

[0088] When the details display area is in the first mode, the original content of the associated cell is displayed in the details display area in the form of a rich text string.

[0089] When the details display area is in the second mode, the preview content corresponding to the rich element in the associated cell is displayed in the details display area. For example, the type of the rich element can be determined by a combination of one or more methods, such as regular expression matching, file extension recognition, content header feature detection, and the JSON.parse method. Then, based on the determination result, a parser component corresponding to the rich element type is loaded. This parser component performs structured parsing, format conversion, playback interface construction, or webpage content embedding on the rich element, and finally displays the parsed and rendered visual preview content in the details display area. In some embodiments, if no rich element type is detected, the original content of the cell can be displayed as a text string.

[0090] In some embodiments, the details display area is associated with a third control and a fourth control. The third control is used to set the display mode of the details display area to a first mode; the fourth control is used to set the display mode of the details display area to a second mode. The third and fourth controls can be displayed at preset positions in the details display area, and can also be displayed in drop-down controls or right-click menus associated with the details display area; this disclosure is not limited thereto.

[0091] According to one or more embodiments of this disclosure, users can switch the display mode of the details display area to conveniently view the original presentation or visual preview of the data as needed, thereby improving the efficiency of viewing table content and the user experience.

[0092] Accordingly, refer to Figure 6 According to one embodiment of this disclosure, a table processing apparatus 600 is provided, comprising:

[0093] The first display unit 601 is configured to display a first details display area in response to a first instruction on the first cell, and to display the details content of the first cell in the first details display area;

[0094] The second display unit 602 is configured to display a second details display area in response to a second instruction, wherein the position of the second details display area is associated with the position of the first details display area;

[0095] The associated display unit 603 is used to display the details of the second cell in the second details display area in response to a third instruction on the second cell.

[0096] In some embodiments, the form processing apparatus further includes:

[0097] A switching unit is configured to, in response to the cell associated with the first details display area being updated from the first cell to the third cell, update the cell associated with the second details display area from the second cell to the fourth cell; wherein the fourth cell and the third cell have a first positional relationship, and the second cell and the first cell have a second positional relationship, and the first positional relationship matches the second positional relationship;

[0098] The display unit is used to display the details of the third cell in the first details display area and the details of the fourth cell in the second details display area.

[0099] In some embodiments, if the first cell and the second cell have the same row number or column number, a synchronization display instruction is received, and the two cells belonging to the same row number or the same column number are displayed synchronously in the corresponding details display area.

[0100] In some embodiments, the second details display area is displayed side by side or vertically alongside the first details display area.

[0101] In some embodiments, the first details display area is associated with a first control and a second control; displaying the second details display area in response to a second instruction includes: loading the second details display area and displaying it side-by-side with the first details display area in response to the first control being triggered; or loading the second details display area and displaying it vertically with the first details display area in response to the second control being triggered.

[0102] In some embodiments, the fourth cell is determined by the following steps: determining the fourth cell based on the position of the third cell and a second positional relationship between the second cell and the first cell; or, determining the fourth cell based on the position of the second cell and a third positional relationship between the third cell and the first cell.

[0103] In some embodiments, the positional relationship between cells includes visible row offset and visible column offset.

[0104] In some embodiments, displaying the details of the third cell in the first details display area and the details of the fourth cell in the second details display area includes: synchronously updating the position information of the third cell and the fourth cell to the storage module; and controlling the first details display area and the second details display area to synchronously refresh the content of the corresponding cells based on the updated position information.

[0105] In some embodiments, the form processing apparatus further includes:

[0106] A synchronous scrolling unit is used to synchronously scroll and display the content in the other detail display area in response to a scrolling operation of one of the first detail display area and the second detail display area.

[0107] In some embodiments, the first detail display area and its associated cells are displayed using a first association display scheme, and the second detail display area and its associated cells are displayed using a second association display scheme, wherein the first association display scheme and the second association display scheme are different.

[0108] In some embodiments, a visual preview of the rich element in the associated cell is displayed in the details display area.

[0109] In some embodiments, the form processing apparatus further includes:

[0110] A first mode unit is configured to, in response to the details display area being set to the first mode, display the original content of the associated cell in the details display area; or,

[0111] The second mode unit is used to display the preview content corresponding to the rich element in the associated cell in the detail display area in response to the detail display area display mode being set to the second mode.

[0112] In some embodiments, the rich element includes at least one of the following: structured text, multimedia files, document attachments, and web page links; displaying a visual preview of the rich element corresponding to the rich element in the associated cell in the details display area includes: if the rich element includes structured text, then displaying the corresponding structured representation in the details display area; or if the rich element includes a multimedia file, then displaying a display view or playback interface of the multimedia file in the details display area; or if the rich element includes a document attachment, then displaying a preview of the document content in the details display area; or if the rich element includes a web page link, then displaying the web page corresponding to the web page link in the details display area.

[0113] In some embodiments, displaying a visual preview of the rich element in the associated cell in the details display area includes: determining the type of the rich element in the cell to be displayed; and performing structured rendering of the rich element using a parser component corresponding to the type.

[0114] According to one embodiment of this disclosure, a table processing apparatus is provided, comprising:

[0115] The details display area unit is used to display a first details display area and a second details display area, wherein the first details display area and the second details display area display the details content of their respective associated cells;

[0116] The associated update unit is used to update the cell associated with the first details display area from the first cell to the third cell, and update the cell associated with the second details display area from the second cell to the fourth cell in response to the cell being updated from the first cell to the third cell; wherein the relative positional relationship between the fourth cell and the third cell remains unchanged from the relative positional relationship between the second cell and the first cell;

[0117] The content update unit is used to display the details of the third cell in the first details display area and the details of the fourth cell in the second details display area.

[0118] For embodiments of the apparatus, since they basically correspond to the method embodiments, relevant details can be found in the descriptions of the method embodiments. The apparatus embodiments described above are merely illustrative, and the modules described as separate modules may or may not be separate. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs. Those skilled in the art can understand and implement this without any creative effort.

[0119] Accordingly, according to one or more embodiments of this disclosure, an electronic device is provided, comprising:

[0120] At least one memory and at least one processor;

[0121] The memory is used to store program code, and the processor is used to call the program code stored in the memory to cause the electronic device to execute the table processing method provided according to one or more embodiments of this disclosure.

[0122] Accordingly, according to one or more embodiments of the present disclosure, a computer program product is provided, including a computer program / instructions that, when executed by a processor, implement the table processing method provided according to one or more embodiments of the present disclosure.

[0123] The following is for reference. Figure 7This document illustrates a structural schematic of an electronic device (e.g., a terminal device or server) 800 suitable for implementing embodiments of the present disclosure. The terminal device in the embodiments of the present disclosure may include, but is not limited to, extended reality devices (such as head-mounted displays), mobile phones, laptops, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), in-vehicle terminals (e.g., in-vehicle navigation terminals), digital TVs, desktop computers, and other terminal devices. It should be noted that... Figure 7 The electronic device shown is merely an example and should not be construed as limiting the functionality and scope of the embodiments disclosed herein.

[0124] like Figure 7 As shown, the electronic device 800 may include a processing device (e.g., a central processing unit, a graphics processor, etc.) 801, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 802 or a program loaded from a storage device 808 into a random access memory (RAM) 803. The RAM 803 also stores various programs and data required for the operation of the electronic device 800. The processing device 801, ROM 802, and RAM 803 are interconnected via a bus 804. An input / output (I / O) interface 805 is also connected to the bus 804.

[0125] Typically, the following devices can be connected to I / O interface 805: input devices 806 including, for example, touchscreens, touchpads, keyboards, mice, cameras, microphones, accelerometers, gyroscopes, etc.; output devices 807 including, for example, liquid crystal displays (LCDs), speakers, vibrators, etc.; storage devices 808 including, for example, magnetic tapes, hard disks, etc.; and communication devices 809. Communication device 809 allows electronic device 800 to communicate wirelessly or wiredly with other devices to exchange data. Although Figure 7 An electronic device 800 with various devices is shown; however, it should be understood that it is not required to implement or possess all of the devices shown. More or fewer devices may be implemented or possessed alternatively.

[0126] In particular, according to embodiments of this disclosure, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments of this disclosure include a computer program product comprising a computer program / instructions carried on a computer-readable medium, which, when executed by a processor, implements various methods or actions of various embodiments of this disclosure. In such embodiments, the computer program can be downloaded and installed from a network via a communication device 809, or installed from a storage device 808, or installed from a ROM 802. When the computer program is executed by a processing device 801, the steps defined in the methods of embodiments of this disclosure are performed.

[0127] It should be noted that the computer-readable medium described in this disclosure can be a computer-readable signal medium or a computer-readable storage medium, or any combination thereof. A computer-readable storage medium can be, for example,—but not limited to—an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of a computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this disclosure, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. In this disclosure, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals can take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A computer-readable signal medium can be any computer-readable medium other than a computer-readable storage medium, which can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to: wires, optical fibers, RF (radio frequency), etc., or any suitable combination thereof.

[0128] In some implementations, clients and servers can communicate using any currently known or future-developed network protocol such as HTTP (Hypertext Transfer Protocol) and can interconnect with digital data communication (e.g., communication networks) of any form or medium. Examples of communication networks include local area networks (“LANs”), wide area networks (“WANs”), the Internet (e.g., the Internet of Things), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future-developed networks.

[0129] The aforementioned computer-readable medium may be included in the aforementioned electronic device; or it may exist independently and not assembled into the electronic device.

[0130] The aforementioned computer-readable medium carries one or more programs, which, when executed by the electronic device, cause the electronic device to perform the methods of the present disclosure.

[0131] Computer program code for performing the operations of this disclosure can be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, and C++, and conventional procedural programming languages ​​such as the "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone 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 remote computers, the remote computer can 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 can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0132] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this disclosure. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0133] The units described in the embodiments of this disclosure can be implemented in software or in hardware. The names of the units are not, in some cases, intended to limit the specific unit.

[0134] The functions described above in this document can be performed at least in part by one or more hardware logic components. For example, exemplary types of hardware logic components that can be used, without limitation, include: field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), system-on-a-chip (SoCs), complex programmable logic devices (CPLDs), and so on.

[0135] In the context of this disclosure, a machine-readable medium can be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, apparatus, or device. A machine-readable medium can be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium can be, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination of the foregoing. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing.

[0136] According to one or more embodiments of this disclosure, a table processing method is provided, comprising: displaying a first details display area in response to a first instruction on a first cell, and displaying details of the first cell in the first details display area; displaying a second details display area in response to a second instruction, wherein the position of the second details display area is associated with the position of the first details display area; and displaying details of the second cell in the second details display area in response to a third instruction on a second cell.

[0137] According to one or more embodiments of this disclosure, the table processing method further includes: in response to the cell associated with the first details display area being updated from the first cell to the third cell, updating the cell associated with the second details display area from the second cell to the fourth cell; wherein the fourth cell and the third cell have a first positional relationship, the second cell and the first cell have a second positional relationship, and the first positional relationship matches the second positional relationship; displaying the details of the third cell in the first details display area, and displaying the details of the fourth cell in the second details display area.

[0138] According to one or more embodiments of this disclosure, if the first cell and the second cell have the same row number or column number, a synchronization display instruction is received, and the two cells belonging to the same row number or the same column number are displayed synchronously in the corresponding details display area.

[0139] According to one or more embodiments of this disclosure, the second details display area is displayed side by side or vertically alongside the first details display area.

[0140] According to one or more embodiments of this disclosure, the first details display area is associated with a first control and a second control; the step of displaying the second details display area in response to a second instruction includes: in response to the first control being triggered, loading the second details display area and displaying it side by side with the first details display area; or, in response to the second control being triggered, loading the second details display area and displaying it vertically with the first details display area.

[0141] According to one or more embodiments of this disclosure, the fourth cell is determined by the following steps: determining the fourth cell based on the position of the third cell and a second positional relationship between the second cell and the first cell; or, determining the fourth cell based on the position of the second cell and a third positional relationship between the third cell and the first cell.

[0142] According to one or more embodiments of this disclosure, the positional relationship between cells includes a visible row offset and a visible column offset.

[0143] According to one or more embodiments of this disclosure, displaying the details of the third cell in the first details display area and displaying the details of the fourth cell in the second details display area includes: synchronously updating the position information of the third cell and the fourth cell to the storage module; controlling the first details display area and the second details display area to synchronously refresh the content of the corresponding cells based on the updated position information.

[0144] According to one or more embodiments of this disclosure, the table processing method further includes: in response to a scrolling display operation of one of the first detail display area and the second detail display area, synchronously scrolling the content of the other detail display area.

[0145] According to one or more embodiments of this disclosure, the first detail display area and its associated cells are displayed using a first association display scheme, and the second detail display area and its associated cells are displayed using a second association display scheme, wherein the first association display scheme and the second association display scheme are different.

[0146] According to one or more embodiments of this disclosure, a visual preview of the rich element corresponding to the associated cell is displayed in the details display area.

[0147] According to one or more embodiments of this disclosure, the table processing method further includes: in response to the details display area display mode being a first mode, displaying the original content of the associated cell in the details display area; or, in response to the details display area display mode being a second mode, displaying the preview content corresponding to the rich element in the associated cell in the details display area.

[0148] According to one or more embodiments of this disclosure, the table processing method further includes: the rich element includes at least one of the following: structured text, multimedia files, document attachments, and web page links; displaying a visual preview of the rich element corresponding to the rich element in the associated cell in the details display area, including: if the rich element includes structured text, then displaying the corresponding structured representation in the details display area; or if the rich element includes a multimedia file, then displaying a display view or playback interface of the multimedia file in the details display area; or if the rich element includes a document attachment, then displaying a preview of the document content in the details display area; or if the rich element includes a web page link, then displaying the web page corresponding to the web page link in the details display area.

[0149] According to one or more embodiments of this disclosure, displaying a visual preview of rich elements in an associated cell in a details display area includes: determining the type of rich elements in the cell to be displayed; and performing structured rendering of the rich elements using a parser component corresponding to the type.

[0150] According to one or more embodiments of this disclosure, a table processing apparatus is provided, comprising: a first display unit, configured to display a first details display area in response to a first instruction on a first cell, wherein details of the first cell are displayed in the first details display area; a second display unit, configured to display a second details display area in response to a second instruction, wherein the position of the second details display area is associated with the position of the first details display area; and an associated display unit, configured to display details of the second cell in the second details display area in response to a third instruction on a second cell.

[0151] The above description is merely a preferred embodiment of this disclosure and an explanation of the technical principles employed. Those skilled in the art should understand that the scope of this disclosure is not limited to technical solutions formed by specific combinations of the above-described technical features, but should also cover other technical solutions formed by arbitrary combinations of the above-described technical features or their equivalents without departing from the above-described concept. For example, technical solutions formed by substituting the above features with (but not limited to) technical features disclosed in this disclosure that have similar functions.

[0152] Furthermore, while the operations are described in a specific order, this should not be construed as requiring these operations to be performed in the specific order shown or in a sequential order. In certain environments, multitasking and parallel processing may be advantageous. Similarly, while several specific implementation details are included in the above discussion, these should not be construed as limiting the scope of this disclosure. Certain features described in the context of individual embodiments may also be implemented in combination in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented individually or in any suitable sub-combination in multiple embodiments.

[0153] Although the subject matter has been described using language specific to structural features and / or methodological logic, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. Rather, the specific features and actions described above are merely illustrative examples of implementing the claims.

Claims

1. A table processing method, characterized in that, include: In response to a first instruction on the first cell, a first details display area is displayed, in which the details content of the first cell is displayed; In response to the second instruction, a second details display area is displayed, the position of which is associated with the position of the first details display area; In response to the third instruction on the second cell, the details of the second cell are displayed in the second details display area.

2. The method according to claim 1, characterized in that, Also includes: In response to the cell associated with the first details display area being updated from the first cell to the third cell, the cell associated with the second details display area is updated from the second cell to the fourth cell; wherein, the fourth cell and the third cell have a first positional relationship, the second cell and the first cell have a second positional relationship, and the first positional relationship matches the second positional relationship; The details of the third cell are displayed in the first details display area, and the details of the fourth cell are displayed in the second details display area.

3. The method according to claim 2, characterized in that, If the first cell and the second cell have the same row number or column number, a synchronization display instruction is received, and the two cells belonging to the same row number or the same column number are displayed synchronously in the corresponding details display area.

4. The method according to claim 1, characterized in that, The second details display area is displayed side by side or vertically alongside the first details display area.

5. The method according to claim 1, characterized in that, The first details display area is associated with a first control and a second control; The step of responding to the second instruction to display the second details display area includes: responding to the first control being triggered by loading the second details display area and displaying it side by side with the first details display area; or, responding to the second control being triggered by loading the second details display area and displaying it vertically with the first details display area.

6. The method according to claim 2, characterized in that, The fourth cell is determined through the following steps: The fourth cell is determined based on the position of the third cell and the second positional relationship between the second cell and the first cell; or, The fourth cell is determined based on the position of the second cell and the third positional relationship between the third cell and the first cell.

7. The method according to claim 2, characterized in that, The positional relationship between cells includes the visible row offset and the visible column offset.

8. The method according to claim 2, characterized in that, The step of displaying the details of the third cell in the first details display area and the details of the fourth cell in the second details display area includes: The location information of the third cell and the fourth cell is synchronously updated to the storage module; Control the first and second detail display areas to synchronously refresh the content of the corresponding cells based on the updated position information.

9. The method according to claim 1, characterized in that, Also includes: In response to a scrolling operation of one of the detail display areas, the content of the other detail display area is simultaneously scrolled and displayed.

10. The method according to claim 1, characterized in that, The first details display area and its associated cells are displayed using a first association display scheme, and the second details display area and its associated cells are displayed using a second association display scheme. The first association display scheme and the second association display scheme are different.

11. The method according to claim 1, characterized in that, The details display area shows a visual preview of the rich elements in the associated cells.

12. The method according to claim 1, characterized in that, Also includes: In response to the details display area being displayed in the first mode, the original content of the associated cell is displayed in the details display area; or, In response to the details display area being set to the second display mode, preview content corresponding to the rich element in the associated cell is displayed in the details display area.

13. The method according to claim 11 or 12, characterized in that, The rich elements include at least one of the following: structured text, multimedia files, document attachments, and web page links; The details display area shows a visual preview of the rich elements in the associated cells, including: If the rich element includes structured text, then the corresponding structured representation is displayed in the details display area; or If the rich element includes a multimedia file, then the display view or playback interface of the multimedia file is displayed in the details display area; or If the rich element includes a document attachment, then a preview of the document content is displayed in the details display area; or If the rich element includes a webpage link, then the webpage corresponding to the webpage link is displayed in the details display area.

14. The method according to claim 11 or 12, characterized in that, The details display area shows a visual preview of the rich elements in the associated cells, including: Determine the type of rich elements in the cell to be displayed; The rich elements are rendered in a structured manner using a parser component corresponding to the type.

15. A form processing device, characterized in that, include: The first display unit is configured to display a first details display area in response to a first instruction on the first cell, and to display the details content of the first cell in the first details display area; The second display unit is configured to display a second details display area in response to a second instruction, wherein the position of the second details display area is associated with the position of the first details display area; The associated display unit is used to display the details of the second cell in the second details display area in response to a third instruction on the second cell.

16. An electronic device, characterized in that, include: At least one memory and at least one processor; The memory is used to store program code, and the processor is used to call the program code stored in the memory to cause the electronic device to perform the method of any one of claims 1 to 14.

17. A computer program product comprising a computer program / instructions, characterized in that, When the computer program / instructions are executed by the processor, they implement the method of any one of claims 1 to 14.

Images