Method and device for displaying content in table, equipment and storage medium

Abstract

The invention relates to a method and device for displaying content in a table, equipment and a storage medium, and the method comprises the steps: obtaining first data content corresponding to a target cell region in response to a content viewing operation on the target cell region in the table; displaying a preset browsing interface; and displaying the first data content in the browsing interface. Therefore, a more efficient and flexible table content display mode can be realized, and the user experience and the data processing efficiency are improved.

Description

Technical Field

[0001] The present application relates to the field of computers, and in particular to a method, device, equipment and storage medium for displaying content in a table. Background Art

[0002] In existing data processing and display systems, tables are widely used in various software applications as an efficient and intuitive way to organize information.

[0003] At present, most spreadsheet processing software displays data content directly in the cells of the table or in the formula bar of the table. This method is more effective and direct when the amount of data is small and the data structure is simple, but with the increase in data volume and data complexity, this direct display method also faces many challenges. For example, when the data content is too long, too much, or contains data with a complex structure, it is difficult to fully display the data content in the cell, which not only reduces the user experience, but also easily causes visual confusion and interference, affecting the user's capture and understanding of the data. At the same time, the method of directly displaying data content in cells also limits the user's interaction with the data. The user can only perform simple viewing or editing operations on the data content, and it is difficult to perform other interactive operations on the data content, such as in-depth analysis or visual display. Summary of the invention

[0004] The present application provides a method, apparatus, device and storage medium for displaying the contents in a table, so as to solve the technical problems in the prior art of directly displaying data contents through cells or displaying data contents in the formula bar of a table, which have defects such as limited content and poor user interactivity when processing large amounts or complex data.

[0005] In a first aspect, the present application provides a method for displaying content in a table, the method comprising:

[0006] In response to a content viewing operation on a target cell area in the table, obtaining first data content corresponding to the target cell area;

[0007] Display the preset browsing interface;

[0008] The first data content is displayed in the browsing interface.

[0009] In a possible implementation manner, the acquiring the first data content corresponding to the target cell area includes:

[0010] Acquire the original cell content in the target cell area, and determine the original cell content as the first data content corresponding to the target cell area; and / or,

[0011] The original cell content is parsed to obtain parsed content of the original cell content; and the parsed content is determined as the first data content corresponding to the target cell area.

[0012] In a possible implementation manner, parsing the original cell content to obtain parsed content of the original cell content includes:

[0013] Performing information mining on the original cell content, and determining the information mining result as the parsed content of the original cell content; and / or,

[0014] Information expansion is performed on the original cell content, and the information expansion result is determined as the parsed content of the original cell content.

[0015] In a possible implementation manner, parsing the original cell content to obtain parsed content of the original cell content includes:

[0016] Determine the target parsing method;

[0017] The original cell content is parsed according to the target parsing method to obtain parsed content of the original cell content.

[0018] In a possible implementation, the determining the target parsing method includes:

[0019] Determine the content type of the original cell content;

[0020] The target parsing mode is determined according to the content type of the original cell content.

[0021] In a possible implementation, the determining the target parsing method includes:

[0022] In response to a triggering operation on any preset control in the browsing interface, a parsing mode encapsulated in the preset control corresponding to the triggering operation is determined as a target parsing mode.

[0023] In a possible implementation, the determining the target parsing method includes:

[0024] Obtaining a user instruction input by a user in the browsing interface;

[0025] The parsing method indicated by the user instruction is determined as the target parsing method.

[0026] In a possible implementation manner, the plurality of preset controls are displayed in the browsing interface in the following manner:

[0027] Determine the content type of the original cell content;

[0028] The corresponding preset controls are loaded and displayed in the browsing interface according to the content type of the original cell content.

[0029] In a possible implementation manner, the plurality of preset controls are displayed in the browsing interface in the following manner:

[0030] Obtain historical operation behavior data of the currently logged-in user of the form on the form;

[0031] The corresponding preset controls are loaded and displayed in the browsing interface according to the historical operation behavior data.

[0032] In a possible implementation manner, the plurality of preset controls are displayed in the browsing interface in the following manner:

[0033] Get the custom control of the currently logged-in user of the table;

[0034] The custom control is determined as a preset control, and the preset control is loaded and displayed in the browsing interface.

[0035] In a possible implementation manner, displaying the first data content in the browsing interface includes:

[0036] In the case where it is determined to adjust the browsing interface according to the first data content, the browsing interface is adjusted by at least one of the following adjustment methods: increasing the window size of the browsing interface, increasing the number of displayed pages of the browsing interface;

[0037] The first data content is displayed in the adjusted browsing interface.

[0038] In a possible implementation, the method further includes:

[0039] In response to a cell switching operation triggered in the browsing interface, a target cell is determined from adjacent cells of the target cell area according to the cell switching operation; or, in response to a triggering operation on a direction key on a keyboard, a target cell is determined from adjacent cells of the target cell area according to the triggered direction key;

[0040] Acquire the second data content corresponding to the target cell;

[0041] The first data content displayed in the browsing interface is changed to the second data content.

[0042] In a possible implementation, the method further includes:

[0043] In response to an editing operation on the first data content displayed in the browsing interface, acquiring edited content of the first data content displayed in the browsing interface;

[0044] The original cell contents in the target cell area are changed using the edited contents.

[0045] In a possible implementation, the method further includes:

[0046] In response to a triggering operation on the first data content displayed in the browsing interface, the original cell content in the target cell area is changed using the first data content.

[0047] In a second aspect, the present application provides a device for displaying content in a table, the device comprising:

[0048] A content acquisition module, configured to acquire first data content corresponding to a target cell area in a table in response to a content viewing operation on the target cell area in the table;

[0049] An interface display module, used to display a preset browsing interface;

[0050] The content display module is used to display the first data content in the browsing interface.

[0051] In a possible implementation, the content acquisition module includes:

[0052] a content extraction unit, configured to obtain original cell content in the target cell region, and determine the original cell content as first data content corresponding to the target cell region; and / or,

[0053] The content parsing unit is used to parse the original cell content to obtain parsed content of the original cell content; and determine the parsed content as the first data content corresponding to the target cell area.

[0054] In a possible implementation, the content parsing unit includes:

[0055] an information mining subunit, configured to perform information mining on the original cell content and determine the information mining result as the parsed content of the original cell content; and / or,

[0056] The information expansion subunit is used to expand the information of the original cell content and determine the information expansion result as the parsed content of the original cell content.

[0057] In a possible implementation, the content parsing unit includes:

[0058] A parsing method determination subunit is used to determine a target parsing method;

[0059] The parsing subunit is used to parse the original cell content according to the target parsing method to obtain the parsed content of the original cell content.

[0060] In a possible implementation manner, the subunit is determined in the parsing manner, specifically for:

[0061] Determine the content type of the original cell content;

[0062] The target parsing mode is determined according to the content type of the original cell content.

[0063] In a possible implementation manner, the subunit is determined in the parsing manner, specifically for:

[0064] In response to a triggering operation on any preset control in the browsing interface, a parsing mode encapsulated in the preset control corresponding to the triggering operation is determined as a target parsing mode.

[0065] In a possible implementation manner, the subunit is determined in the parsing manner, specifically for:

[0066] Obtaining a user instruction input by a user in the browsing interface;

[0067] The parsing method indicated by the user instruction is determined as the target parsing method.

[0068] In a possible implementation, the device further includes:

[0069] A control display module is used to display a plurality of preset controls in the browsing interface in the following manner:

[0070] Determine the content type of the original cell content;

[0071] The corresponding preset controls are loaded and displayed in the browsing interface according to the content type of the original cell content.

[0072] In a possible implementation, the device further includes:

[0073] A control display module is used to display a plurality of preset controls in the browsing interface in the following manner:

[0074] Obtain historical operation behavior data of the currently logged-in user of the form on the form;

[0075] The corresponding preset controls are loaded and displayed in the browsing interface according to the historical operation behavior data.

[0076] In a possible implementation, the device further includes:

[0077] A control display module is used to display a plurality of preset controls in the browsing interface in the following manner:

[0078] Get the custom control of the currently logged-in user of the table;

[0079] The custom control is determined as a preset control, and the preset control is loaded and displayed in the browsing interface.

[0080] In a possible implementation, the content display module includes:

[0081] a window adjustment unit, configured to adjust the browsing interface by at least one of the following adjustment methods when it is determined to adjust the browsing interface according to the first data content: increasing the window size of the browsing interface, increasing the number of displayed pages of the browsing interface;

[0082] A display unit is used to display the first data content in the adjusted browsing interface.

[0083] In a possible implementation, the device further includes:

[0084] a cell switching module, for responding to a cell switching operation triggered in the browsing interface, determining a target cell from adjacent cells of the target cell region according to the cell switching operation; or, responding to a triggering operation on a direction key on a keyboard, determining a target cell from adjacent cells of the target cell region according to the triggered direction key;

[0085] Acquire the second data content corresponding to the target cell;

[0086] The first data content displayed in the browsing interface is changed to the second data content.

[0087] In a possible implementation, the device further includes:

[0088] a synchronous editing module, configured to obtain edited content of the first data content displayed in the browsing interface in response to an editing operation on the first data content displayed in the browsing interface;

[0089] The original cell contents in the target cell area are changed using the edited contents.

[0090] In a possible implementation, the device further includes:

[0091] The automatic editing module is used to respond to a triggering operation on the first data content displayed in the browsing interface and use the first data content to change the original cell content in the target cell area.

[0092] In a third aspect, the present application provides a device, comprising: a processor and a memory, wherein the processor is used to execute a display program for the content in a table stored in the memory to implement the method for displaying the content in a table described in any one of the first aspects.

[0093] In a fourth aspect, the present application provides a storage medium, characterized in that the storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to implement the method for displaying content in a table described in any one of the first aspects.

[0094] The above-mentioned technical scheme provided by the embodiment of the present application has the following advantages over the prior art: the method provided by the embodiment of the present application, by responding to the content viewing operation of the target cell area in the table, obtains the first data content corresponding to the target cell area, displays a preset browsing interface, and displays the first data content in the browsing interface, thereby realizing a more efficient and flexible parallel display method of table content. In this method, since the display area of ​​the additional browsing interface is larger and can be flexibly adjusted compared with the original cell, and the format type of the displayed content is not restricted, it can well overcome the defect of the prior art that the content is limited when processing large amounts of or complex data. At the same time, since the browsing interface can also be set to support additional data processing operations, it can meet the needs of users to interact with the data content in the table and the data processing needs in various complex scenarios, thereby overcoming the defect of poor user interactivity of the table content display method in the prior art and improving user experience and data processing efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0095] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.

[0096] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.

[0097] 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.

[0098] Figure 1 A flowchart of an embodiment of a method for displaying contents in a table provided in an embodiment of the present application;

[0099] Figure 2 A schematic diagram showing a browsing interface on a table display interface;

[0100] Figure 3 A schematic diagram showing a formula and information mining results corresponding to the formula in a browsing interface;

[0101] Figure 4 A flowchart of another method for displaying contents in a table provided in an embodiment of the present application;

[0102] Figure 5 A flowchart of another method for displaying contents in a table provided in an embodiment of the present application;

[0103] Figure 6 A flowchart of another method for displaying contents in a table provided in an embodiment of the present application;

[0104] Figure 7 A block diagram of an embodiment of a device for displaying contents in a table provided in an embodiment of the present application;

[0105] Figure 8 A schematic diagram of the structure of a device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0106] 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 making creative work are within the scope of protection of this application.

[0107] The disclosure below provides many different embodiments or examples to implement the different structures of the present application. In order to simplify the disclosure of the present application, the parts and settings of specific examples are described below. Of course, they are only examples, and the purpose is not to limit the present application. In addition, the present application can repeat reference numbers and / or letters in different examples. This repetition is for the purpose of simplification and clarity, and does not itself indicate the relationship between the various embodiments and / or settings discussed.

[0108] In order to solve the technical problem that the prior art method of directly displaying data content through cells has defects such as limited content and poor user interactivity when processing large or complex data, the present application provides a method, device, equipment and storage medium for displaying content in a table, which can achieve a more efficient and flexible table content display method, improve user experience and data processing efficiency.

[0109] Figure 1 The following is a flow chart of an embodiment of a method for displaying contents in a table provided in an embodiment of the present application. Figure 1 As shown, the process includes the following steps:

[0110] Step 101: In response to a content viewing operation on a target cell area in a table, first data content corresponding to the target cell area is obtained.

[0111] The above-mentioned table can be any table, which can be a table in a traditional format, such as a table in .xls, .xlsx and other formats, or a new generation of smart table, online table, and the embodiment of the present application does not limit this.

[0112] From the perspective of access methods, the above-mentioned table can be a collaborative document, which allows multiple users to collaboratively edit it online, or allows multiple users to spread it to each other through mobile storage media (such as USB flash drives) to collaboratively edit it. Taking online collaborative editing as an example, there are currently two different document collaboration methods, namely online collaborative documents and collaborative documents within a local area network. Among them, online collaborative documents are a way to share and edit documents through the Internet, store documents on a cloud server, allow multiple users to access, edit and comment on documents at the same time, and provide real-time collaboration and communication functions. Collaborative documents within a local area network refer to a method in which multiple users can edit and modify the same document in a local area network by sharing folders or using professional collaborative editing software. The table in the embodiment of the present application can be any of the above-mentioned collaborative documents, and the embodiment of the present application does not limit this.

[0113] The target cell area may include one cell or multiple cells. In the case where the target cell area includes multiple cells, the target cell area may be a single connected area consisting of multiple cells or a multiply connected area consisting of multiple cells. In layman's terms, the target cell area is a single connected area consisting of multiple cells, which means that the multiple cells are adjacent and continuous in the table, and it is not limited here whether the shape of the target cell area is regular. The target cell area is a multiply connected area consisting of multiple cells, which means that the multiple cells are not completely adjacent and continuous in the table, but are discretely distributed. Regardless of whether the target cell area includes one cell or multiple cells, the cells here can be any cell in the table (including merged cells, i.e., cells formed by merging at least two continuous independent cells in the table), and the embodiment of the present application does not limit the number of cells contained in the target cell area and the distribution of cells in the table.

[0114] As an optional implementation method, the user can select one or more cells in the table (i.e., select the target cell area) by operating the mouse or by entering cell location information, and then trigger a content viewing operation on the selected cells, for example, by triggering the content viewing icon in the table toolbar to trigger a content viewing operation on the selected cells.

[0115] As another optional implementation, the user can select one or more cells in the table (i.e., select the target cell area) by operating the mouse or by inputting the cell location information. When the user's selection operation on the target cell area is detected, the content viewing operation on the target cell area is detected by default. This processing method is simpler and more convenient, thereby improving the user's viewing efficiency of the cell content in the table.

[0116] It should be noted here that, in some embodiments, the cell data content can also be displayed through the formula bar, but the method of displaying the cell data content through the formula bar, compared with the method of directly displaying the data content in the cell, can to a certain extent solve the technical problem of incomplete display when displaying a large amount of data, but the method of displaying the cell data content through the formula bar is limited to only being able to display the data content of one cell, and cannot display the data content of multiple cells at the same time, nor can it display non-text content, and the display position and area are also fixed, lacking flexibility. It can be seen from the above description that the technical solution provided in the embodiment of the present application supports the simultaneous display of the data content of multiple cells (not the method of directly displaying the data content in the cell). Compared with the prior art, this realizes a more efficient and flexible table content display method that can meet the needs of users in complex scenarios.

[0117] Afterwards, in response to a content viewing operation on a target cell area in the table, first data content corresponding to the target cell area is obtained.

[0118] In one embodiment, the first data content corresponding to the target cell area is the original cell content in the target cell area. Accordingly, the specific implementation of obtaining the first data content corresponding to the target cell area in step 101 includes: obtaining the original cell content in the target cell area, and determining the original cell content as the first data content corresponding to the target cell area. Among them, the original cell content is not limited to the data content in the cell content filling area, and can also include content associated with the cell, such as error superscripts (such as error superscripts of formulas), cell comment content, annotation content, formula content, formula calculation results, etc. In addition, in an exemplary application scenario, when the target cell area includes merged cells, the original cell content of the merged cells may include the merged cell content in the merged cell (i.e., the cell content after the merge), and may also include the cell content in the cell before the merge. The embodiment of the present application does not limit this.

[0119] In another embodiment, the first data content corresponding to the target cell area is the parsed content of the original cell content. Accordingly, the specific implementation of obtaining the first data content corresponding to the target cell area in step 101 includes: parsing the original cell content to obtain the parsed content of the original cell content, and determining the parsed content as the first data content corresponding to the target cell area. Among them, the parsed content refers to the result obtained after processing the original cell content, and this processing process may include one or more content processing methods, such as data conversion, data splitting, data aggregation, etc. As for how to parse the original cell content and obtain the parsed content of the original cell content, it is explained through specific embodiments below and will not be described in detail here.

[0120] In another embodiment, the first data content corresponding to the target cell area includes the original cell content in the target cell area and the parsed content of the original cell content. Accordingly, the specific implementation of obtaining the first data content corresponding to the target cell area in step 101 includes: obtaining the original cell content in the target cell area, parsing the original cell content, obtaining the parsed content of the original cell content, and determining the original cell content and its parsed content as the first data content corresponding to the target cell area.

[0121] It can be seen from the above description that compared with the technical solution that can only display the original cell content of the cell, or display the formula contained in the cell through the formula bar, the technical solution further provided by the embodiment of the present application supports displaying the results of processing the original cell content using a variety of different processing methods, which realizes a more flexible and diversified processing method and display mechanism for the cell content in the table, can greatly enhance the functionality of the table processing software, and well solve the technical problems in the prior art such as limited content and poor user interactivity when processing large amounts of or complex data, meet the user's data processing needs in a variety of complex scenarios, and improve the user experience.

[0122] Step 102: Display a preset browsing interface.

[0123] Step 103: Display the first data content in the browsing interface.

[0124] In one embodiment, the preset browsing interface is an interface independent of the table display interface, which means that the browsing interface is a separate interface element. The table display interface is an interface for displaying a worksheet of a table. Further, as a separate interface element different from the table display interface, the preset browsing interface can be resized, moved, maximized, minimized, closed, etc., and these operations will not interfere with the display interface of the table.

[0125] In a specific embodiment, the preset browsing interface and the table display interface are displayed on the same layer, and the display areas of the two do not overlap. For example, the preset browsing interface is a sidebar or a bottom bar of the window where the table display interface is located.

[0126] In another specific embodiment, the preset browsing interface and the table display interface are displayed in different layers, such as the preset browsing interface is a pop-up window, a floating window, etc. In one embodiment, the preset browsing interface is set not to overlap with the target cell area.

[0127] The preset browsing interface is used to display data content, which can be of any type, such as text, numerical value, date, picture, chart, link, etc. It can be seen that the technical solution provided in the embodiment of the present application provides a more efficient and flexible table content display method through the preset browsing interface, which can well overcome the defect of limited content in the prior art when processing large or complex data.

[0128] The preset browsing interface also provides interactive functions for operating the displayed content, such as various operations (such as copying and pasting), content editing, etc. It can be seen that the technical solution provided by the embodiment of the present application provides a novel way for users to interact with the data content in the table through the preset browsing interface, which can well overcome the defect of poor user interactivity of the table content display method in the prior art, meet the data processing needs of users in various complex scenarios, and improve the user experience.

[0129] It can be seen from the description of step 101 and step 102 that in response to the content viewing operation of the target cell area in the table, a preset browsing interface is dynamically displayed, and the display position of the browsing interface supports dynamic adjustment. This is compared with the prior art in which the formula bar is fixed in the display interface of the table and its size and position cannot be adjusted. This has better flexibility and adaptability.

[0130] Optionally, the initial display position of the browsing interface is affected by the target cell area. For example, the initial display position of the browsing interface is determined according to the principle that the browsing interface does not block the target cell area, or does not block the row and column where the target cell area is located, and the browsing interface is displayed at the initial display position. Figure 2 , which is a schematic diagram of displaying a browsing interface on a table display interface. Thus, the table display interface and the preset browsing interface can be displayed simultaneously, which is convenient for users to compare the displayed contents in the table display interface and the preset browsing interface.

[0131] In addition, in one embodiment, the browsing interface is automatically adjusted according to the first data content. As an optional implementation, the specific implementation of displaying the first data content in the browsing interface includes: in the case of determining to adjust the browsing interface according to the first data content, adjusting the browsing interface by at least one of the following adjustment methods: increasing the window size of the browsing interface, increasing the number of display pages of the browsing interface; displaying the first data content in the adjusted browsing interface.

[0132] Optionally, when the volume of the first data content is too large, for example, the volume of the first data content is greater than a set threshold, or the size of the first data content (such as a picture, chart, etc.) is greater than a set size threshold, it is possible that the first data content cannot be fully displayed on the browsing interface. In this case, it can be determined to adjust the browsing interface. The adjustment method is, for example, increasing the window size of the browsing interface or increasing the number of displayed pages of the browsing interface.

[0133] Optionally, when the target cell area includes multiple cells, the browsing interface can be adjusted, for example, by setting the display page of the browsing interface according to the number of cells included in the target cell area, so that the data content of each cell can be independently displayed in a display page. This method helps to isolate data and avoid interference between data contents of different cells, resulting in data confusion.

[0134] The technical solution provided in the embodiment of the present application, by responding to the content viewing operation of the target cell area in the table, obtaining the first data content corresponding to the target cell area, displaying a preset browsing interface, and displaying the first data content in the browsing interface, realizes a more efficient and flexible table content display method. In this method, since the display area of ​​the browsing interface is larger and adjustable compared to the cell and the formula bar, and there is no restriction on the format type of the displayed content, it can well overcome the defect of the existing technology that the content is limited when processing large amounts of or complex data. At the same time, since the browsing interface can support additional data processing operations, it can meet the needs of users to interact with the data content in the table and the data processing needs in various complex scenarios, thereby overcoming the defect of poor user interactivity of the table content display method in the existing technology and improving user experience and data processing efficiency.

[0135] In one embodiment, the specific implementation of parsing the original cell content in the target cell area to obtain the parsed content of the original cell content includes: performing information mining on the original cell content in the target cell area, and determining the information mining results as the parsed content of the original cell content.

[0136] In another embodiment, the specific implementation of parsing the original cell content in the target cell area to obtain the parsed content of the original cell content includes: expanding the information of the original cell content and determining the information expansion result as the parsed content of the original cell content.

[0137] In another embodiment, the original cell content in the target cell area is parsed to obtain the parsed content of the original cell content, which specifically includes: performing information mining and information expansion on the original cell content respectively, and determining both the information mining results and the information expansion results as the parsed content of the original cell content.

[0138] The information mining and information expansion mentioned above are two data analysis methods. In layman's terms, the difference between information mining and information expansion is that information mining focuses more on the depth of data, such as the internal structure and characteristics of data. By conducting in-depth analysis of the data, potential information, knowledge, resources, value or capabilities in the data are discovered. This in-depth analysis helps to reveal the laws and trends behind the data. Information expansion focuses more on the breadth of data, such as the relationship or association between external data. By expanding the data, the associated information, associated knowledge, associated resources, associated value or associated capabilities of the data can be obtained. This extensive analysis helps to increase the comprehensiveness of data analysis. It can be seen that information mining and information expansion are two different but interrelated data analysis methods. In practical applications, these two data analysis methods can be used in combination to achieve better data analysis results.

[0139] Regardless of whether information mining or information expansion is performed on the original cell content in the target cell area, there is a corresponding parsing method. Therefore, the specific implementation of parsing the original cell content in the target cell area to obtain the parsed content of the original cell content includes: determining the target parsing method; parsing the original cell content according to the target parsing method to obtain the parsed content of the original cell content.

[0140] Among them, in the data analysis method of performing information mining on the original cell content in the target cell area, the target parsing method can be: date parsing, numerical parsing, certificate parsing, formula parsing, image parsing, summary extraction, chart analysis, etc.

[0141] Among them, date parsing means that when the original cell content includes a date, information mining is performed on the date to obtain other information related to the date, such as the day of the week, solar terms, festivals, etc. For example, assuming that the original cell content is 2024 / 9 / 30, by mining the date, it is found that the day is Friday. Then the dates 2024 / 9 / 30 and Friday can be displayed simultaneously in the browsing interface. For another example, assuming that the original cell content is 2024 / 9 / 10, by mining the date, it is found that the day is Tuesday, Teacher's Day. Then 2024 / 9 / 10, Tuesday, and Teacher's Day can be displayed simultaneously in the browsing interface.

[0142] Numerical parsing refers to the process of mining information on numerical values ​​when the original cell content includes numerical values, and obtaining information about the number of digits, such as using a thousand-separated style to represent the numerical value. For example, if the original cell content is 100000, the value can be represented using a thousand-separated style to obtain 100,000. This makes it easier for users to read.

[0143] Document parsing refers to the process of mining information on a document photo (such as an ID card photo) when the original cell content includes the document photo, and obtaining the identity information of the subject, such as gender, age, date of birth, etc. Then the document photo and the parsed information can be displayed simultaneously in the browsing interface, which makes it easy for users to quickly obtain key information and use the information (such as copying).

[0144] Formula parsing refers to the process of information mining on formulas when the original cell content includes formulas, to obtain the formula's structure, syntax, possible execution results, and possible errors. Errors include, but are not limited to, syntax errors (such as mismatched brackets, spelling errors, etc.), reference errors (such as the referenced cell does not exist in the table, the referenced range exceeds the working boundary of the table, etc.), logical errors (such as using an incorrect formula), etc. Furthermore, corresponding modification suggestions can be generated for errors in the formula, such as spelling suggestions, reference suggestions, etc. Then, the formula and the corresponding information mining results of the formula can be displayed simultaneously in the browsing interface, which makes it convenient for users to quickly understand and check the formula. For example, see Figure 3 , which is a schematic diagram of displaying a formula and the information mining results corresponding to the formula in a browsing interface. Figure 3 The "calculation error" in the formula is the information mining result corresponding to the formula. Optionally, when the information mining result is triggered, more detailed information mining results, such as modification suggestions, can be further expanded.

[0145] Image parsing refers to the information mining of images when the original cell content includes images, including but not limited to the following aspects: color analysis, composition structure analysis, element analysis, storyline analysis, emotion recognition, etc. Among them, color analysis refers to the analysis of the color matching, color saturation, brightness, etc. used in the image, which helps to analyze the emotional tendency and visual effect of the image. Composition structure analysis refers to the analysis of the composition method of the image, such as symmetry, rule of thirds, golden section, etc., which helps to analyze the visual balance and focus setting of the image. Element analysis refers to the use of image analysis algorithms to extract key features in the image, such as edges, textures, shapes, etc., and then identify specific elements such as objects, people or scenes in the image through feature matching or classification algorithms. Storyline analysis refers to the interpretation of possible storylines or scenes from the image, which usually requires analysis in combination with the elements, layout and colors in the image. Emotion recognition refers to the recognition of the emotions or atmosphere expressed by the image, such as happiness, sadness, tranquility, tension, etc., which usually also requires analysis in combination with the elements, layout and colors in the image. Then the image and the information mining results of the image can be displayed simultaneously in the browsing interface, which makes it convenient for users to quickly understand the image and obtain deeper information, and also makes it convenient for users to use the information (such as copying).

[0146] Abstract extraction refers to extracting a brief, coherent summary that contains the main information of the original content from the original cell content. Abstract extraction technology can be divided into two categories: extractive summarization and generative summarization. Extractive summarization refers to directly selecting key sentences or short sentences from the original content when the original cell content includes text, and then combining them according to certain rules (such as sentence importance, redundancy, etc.) to form a summary. This method is relatively simple and easy to implement, and the generated summaries are usually more accurate in terms of syntax and semantics because they are direct fragments of the original content. Generative summarization refers to understanding the semantics of the original content when the original cell content includes text or pictures, and using natural language generation technology to reorganize the language to generate a new and more concise summary. This method can produce more fluent, coherent and innovative summaries. Then the original cell content and the extracted summary can be displayed simultaneously in the browsing interface. This makes it convenient for users to quickly understand the original cell content, quickly obtain key information, and use this information.

[0147] Among them, when the target cell area includes multiple cells, the original cell contents in these cells can be used as a whole for summary extraction. This processing method can ensure the integrity and comprehensiveness of the information, and better maintain the coherence of the contextual relationship, so that the generated summary is more logically reasonable. Of course, the user can also set which cells in the target cell area need to be summarized according to actual needs, or set which parts the multiple cells in the target cell area need to be divided into for summary extraction respectively. This increases the flexibility of the technical solution of the embodiment of the present application and can meet the complex needs of users.

[0148] Chart analysis refers to the display of data and information in a graphical form. Common chart types include but are not limited to bar charts, line charts, pie charts, scatter charts, candlestick charts, etc. These chart types have their own characteristics and are suitable for different data types and analysis purposes. For example, bar charts are suitable for displaying data comparisons between different categories; line charts are suitable for displaying data trends over time; pie charts are suitable for displaying the proportional relationship of data; scatter charts are suitable for displaying the correlation between two variables; candlestick charts are widely used in financial markets to display the changing trends of prices such as stocks and futures. In practical applications, chart analysis is mostly used in scenarios where the original cell content includes a large amount of data. This analysis method helps users to understand the data intuitively, such as understanding the distribution, trends and changes of the data, and further helps users analyze the data, such as discovering differences and patterns, and providing data support for subsequent decision-making.

[0149] Among them, under the data analysis method of expanding the information of the original cell content in the target cell area, the target parsing method can be: weather expansion, link content expansion, text description expansion, text translation expansion, etc.

[0150] Among them, weather expansion means that when the original cell content includes place names or geographical location information, the weather of the geographical location can be expanded. Furthermore, the impact of weather on local agriculture, transportation, etc. can be expanded to analyze. Then the geographical location and the weather conditions of the geographical location will be displayed simultaneously in the browsing interface. This processing method can quickly obtain the weather conditions of the relevant geographical location without the user having to perform additional operations, which can bring a good experience to the user.

[0151] Link content expansion means that when the link address is included in the original cell content, the data content in the link address is expanded. Furthermore, the summary of the data content in the link address can be deeply analyzed, which is similar to combining information mining and information expansion. Then, the link address and the data content corresponding to the link address (which can be the original text or the extracted content summary) will be displayed in the browsing interface at the same time. This processing method can quickly obtain the associated data content without the user having to perform additional operations (such as copying the link address to the browser), which can simplify user operations and bring a good user experience.

[0152] Text description expansion refers to providing detailed definitions and explanations for key terms or concepts in the original cell content to help readers better understand the meaning behind the data. For example, the original cell content includes "URL". By expanding the text description of "URL", the following extended information is obtained: "Uniform Resource Locator (URL) is a concise representation of the location and access method of resources available on the Internet. It is the address of standard resources on the Internet. Every file on the Internet has a unique URL, which contains information indicating the location of the file and how the browser should handle it." This processing method can help users better understand the cell content.

[0153] Text translation extension is to translate the original cell content to assist readers in understanding the data. For example, the original cell content includes non-Chinese content (such as English). By performing text translation extension on these contents, the corresponding Chinese content is obtained, which can assist readers in understanding the data. Here, users are supported to set the translation language according to actual needs, such as Chinese, English, French and other languages, and the embodiments of the present application do not limit this.

[0154] It should be noted that the target parsing methods listed above are only examples. In actual applications, there may be other target parsing methods, and the embodiments of the present application do not limit this.

[0155] The following describes several specific implementations of determining target parsing methods through different embodiments:

[0156] In one embodiment, the specific implementation of determining the target parsing method includes: determining the content type of the original cell content; and determining the target parsing method according to the content type of the original cell content.

[0157] The content type of the original cell content may be a value type, a date type, a text type, a picture type, a link address type, and the like.

[0158] From the above description of the target parsing method, it can be seen that different parsing methods have their own characteristics and are suitable for different content types and analysis purposes. For example, date parsing is suitable for information mining of date type data content, image parsing is suitable for information mining of image type data content, summary extraction is suitable for information mining of text type or image type data content, link content expansion is suitable for information expansion of link address type data content, etc. Based on this, the target parsing method can be determined according to the content type of the original cell content.

[0159] As an optional implementation method, the correspondence between content types and parsing methods is pre-set. These correspondences can be one-to-one or one-to-many, that is, one content type can correspond to at least one parsing method. For example, the content type of link address can correspond to two parsing methods: link content expansion and summary extraction. Then, when determining the target parsing method, determine the content type of the original cell content, and then search for the above correspondence based on the content type, and determine the parsing method corresponding to the content type as the target parsing method.

[0160] The above embodiment implements a method of automatically determining a target parsing method according to the content type of the original cell content, and then parsing the original cell content using the target parsing method. This method can automatically select a suitable parsing method by automatically identifying the type of the original cell content, which avoids possible errors when manually specifying the parsing method, and can reduce the time and labor cost required for manually setting parsing rules, thereby improving the user experience.

[0161] In another embodiment, a user instruction input by the user in the browsing interface is obtained; and the parsing method indicated by the user instruction is determined as the target parsing method.

[0162] In this embodiment, a command input control may be provided in the browsing interface. As an optional implementation method, the command input control is connected to the artificial intelligence model through an interface, which is the presentation method of the artificial intelligence model on the display interface. Here, the artificial intelligence model, as a server for content analysis, can provide the various content analysis methods described above. In terms of deployment implementation, the artificial intelligence model can be loaded onto the spreadsheet processing software or deployed in the cloud. Among them, the deployment of the artificial intelligence model in the cloud can, on the one hand, make the spreadsheet processing software lightweight, and on the other hand, since the hardware resources in the cloud usually have higher computing efficiency, deploying the artificial intelligence model in the cloud can improve the processing efficiency of content analysis. On the other hand, from the perspective of the stability of the entire system, deploying the artificial intelligence model in the cloud facilitates the update and function expansion of the artificial intelligence model.

[0163] In addition, as an optional implementation, the command input control may be displayed in the browsing interface in response to a user operation. Here, the user operation is, for example, a click operation of a specified icon on the browsing interface by the user, and in response to the click operation, the command input control is displayed in the browsing interface. This method of displaying the command input control in the browsing interface in response to a user operation can make the display interface of the browsing interface more concise.

[0164] Based on the above description, in this embodiment, the user can enter user instructions in the instruction input control. After the user triggers the instruction submission, the execution entity of the embodiment of the present application obtains the user instructions entered in the instruction input control, and then determines the parsing method indicated by the user instruction, and determines the parsing method as the target parsing method.

[0165] As an optional implementation method, the user instruction can be an instruction in text form. For example, if the user instruction is "Help me check the weather", then by analyzing the user instruction, it can be determined that the target parsing method is: weather extension. For another example, if the user instruction is "Help me parse the picture", then by analyzing the user instruction, it can be determined that the target parsing method is: picture parsing.

[0166] As another optional implementation, the user instruction can be an instruction in the form of voice, and accordingly, an icon for triggering audio collection is provided in the above-mentioned instruction input control. Then when the user inputs the user instruction in the form of voice, the icon is first triggered (for example, a click operation or a long press operation) so that the instruction input control calls the audio acquisition device of the hardware device where the execution subject of the embodiment of the present application is located through the interface to collect the user's voice instruction. Here, the audio acquisition device is, for example, a microphone, and the audio acquisition device can be a module of the hardware device where the execution subject of the embodiment of the present application is located, or it can be an external device of the hardware device where the execution subject of the embodiment of the present application is located, and the present application does not make specific restrictions on this. Here, it also involves speech recognition technology, so as to parse the user instruction in the form of voice, obtain the user instruction in the form of text, and then analyze the user instruction in the form of text through natural language processing technology to determine the target parsing method.

[0167] Optionally, whether the user instruction is in text form or in voice form, the machine model technology can be used to identify the user's intention from the user instruction, and then determine the target parsing method based on the user's intention. For example, if the user instruction is "help me parse the picture", by performing intent recognition on the user instruction, it can be determined that the user's intention is to parse the picture, and then the target parsing method can be determined to be picture parsing.

[0168] The above embodiment implements a method of determining a target parsing method according to an input user instruction, and then using the target parsing method to parse the original cell content. This method supports users to specify the parsing method by inputting instructions according to their specific needs, which can make the parsing results of the content more in line with the user's expectations, thereby ensuring the accuracy and reliability of the parsing results.

[0169] In another embodiment, the specific implementation of determining the target resolution method includes: the specific implementation of determining the target resolution method includes: in response to a trigger operation on any preset control in the browsing interface, determining the resolution method encapsulated in the preset control corresponding to the trigger operation as the target resolution method.

[0170] In this embodiment, a series of preset controls are set in the browsing interface. These preset controls can be icons, drop-down menu items, radio buttons, check boxes, or any other interface elements suitable for user selection. For example, see Figure 2 , including a schematic diagram of preset controls set in the browsing interface. In addition, each preset control represents a parsing method, and a mapping relationship between the preset controls and the parsing methods is established in the internal system of the spreadsheet processing software. This mapping relationship can be implemented through a configuration file, a database, or hard-coded in the application.

[0171] Based on this, the spreadsheet processing software can continuously monitor user interaction events in the browsing interface. When a user triggers a preset control, it can capture the event, identify the parsing method represented by the triggered preset event, and determine the parsing method as the target parsing method.

[0172] The above embodiment implements a method of determining a target parsing method according to a user's triggering operation on a preset control, and then using the target parsing method to parse the original cell content. This method allows users to specify a parsing method through simple operations, thereby simplifying user operations and enhancing the user's interactive experience. Moreover, since the target parsing method is determined according to the user's triggering operation on the preset control, the parsing result of the content can be more in line with the user's expectations, thereby ensuring the accuracy and reliability of the parsing result.

[0173] The technical solution provided by the embodiment of the present application also allows the user to freely switch preset controls in the browsing interface. Switching preset controls also means switching the target parsing mode, and the displayed content in the browsing interface will also switch accordingly. For example, the user first clicks on control 1, at which time the parsing mode corresponding to control 1 is determined as the target parsing mode, and the original cell content is parsed according to the target parsing mode, and the parsed content at this time is displayed in the browsing interface. After that, the user clicks on control 2 again, at which time the parsing mode corresponding to control 21 is determined as the new target parsing mode, and the original cell content is parsed according to the new target parsing mode, and the parsed content at this time is displayed in the browsing interface.

[0174] The above method allows the user to switch the parsing method and then switch the display content in the browsing interface without frequently switching between the table and the browsing interface. This method allows the user to process table data more flexibly and efficiently.

[0175] In addition, in the above embodiment, the preset controls can be fixed in the browsing interface, that is, in any case, the same preset controls are always displayed in the browsing interface, and these preset controls are always displayed in the same order. This method is relatively simple to implement but may have some defects. For example, for some users or specific tasks, some preset controls may not be relevant or not needed at all, so these controls are still displayed in the browsing interface, which will affect the user's selection and reduce the user's work efficiency; for example, fixed preset controls may not provide the best options to users, thereby failing to meet user needs and affecting user use.

[0176] In this regard, the technical solution of the embodiment of the present application proposes to dynamically set the preset controls displayed in the browsing interface. The dynamic display here includes two aspects: one is to dynamically select which preset controls are displayed in the browsing interface, and the other is to dynamically set the order of the preset controls displayed in the browsing interface. This method can display and prioritize the preset controls required by the user in the browsing interface, thereby helping to better meet the needs of the user and improve the user's work efficiency and accuracy.

[0177] In one embodiment, a plurality of preset controls are displayed in the browsing interface in the following manner: determining the content type of the original cell content; and loading and displaying corresponding preset controls in the browsing interface according to the content type of the original cell content.

[0178] In this embodiment, as an optional implementation, a correspondence between content types and preset controls can be preset, wherein each content type corresponds to one or more preset controls. Then, when the content type of the original cell content is determined, the corresponding preset control can be determined according to the above correspondence, and then the preset control can be loaded and displayed in the browsing interface.

[0179] Optionally, the HTML code of the preset control is dynamically generated using front-end technology, and inserted into the DOM structure of the browsing interface to load and display the preset control in the browsing interface. Alternatively, the preset control is dynamically loaded from the server through an API, and the loaded control is embedded into the browsing interface to load and display the preset control in the browsing interface.

[0180] In another embodiment, multiple preset controls are displayed in the browsing interface in the following manner: historical operation behavior data of the table by the currently logged-in user of the table is obtained; and corresponding preset controls are loaded and displayed in the browsing interface according to the historical operation behavior data.

[0181] The historical operation behavior data of users on the table include but are not limited to: the number of times users access the table, the types of operations performed by users on the table (such as editing, deleting, sorting, filtering, etc.), the parsing method selected by users when parsing cell contents, etc. The above data can be collected through log records, event tracking or user behavior analysis tools. Of course, when collecting these behavior data, it is necessary to comply with relevant privacy policies and data protection regulations to ensure that the collection and use of user data is legal and permitted by the user.

[0182] When determining the preset controls that need to be loaded based on the user's historical operation behavior data on the table, the historical operation behavior data can be analyzed through machine learning and / or statistical methods to identify the parsing method that the user tends to use when parsing cell content, or the commonly used parsing method, and then predict the parsing method that the user may currently need, and load and display the corresponding preset controls in the browsing interface accordingly. In addition, the preset controls loaded in the browsing interface can also be sorted according to the prediction results, and the preset controls that the user is most likely to use can be placed in a more prominent position (such as the top or left).

[0183] This approach can recommend preset controls corresponding to analysis methods that may be of interest to users based on their historical behavior, so that the executor of the embodiments of the present application can more intelligently optimize the controls and their layout in the browsing interface based on the user's historical behavior, provide a more personalized and efficient data processing experience, and help to better meet user needs and improve user work efficiency and accuracy.

[0184] In yet another embodiment, a plurality of preset controls are displayed in the browsing interface in the following manner: a custom control of a currently logged-in user of a table is obtained; the custom control is determined as a preset control, and the preset control is loaded and displayed in the browsing interface.

[0185] It can be seen from the above description that the technical solution provided by the embodiment of the present application allows users to create and define controls (i.e., custom controls) according to their own needs. These custom controls will be loaded and displayed in the browsing interface as part of the preset controls.

[0186] Among them, as an optional implementation method, a user interface is provided, which is a special editor that supports users to define various aspects of controls, including control type: select the basic type of control (such as a drop-down menu, text box, button, etc.); label and description: add easy-to-understand labels and descriptions to the control; functional logic: define the operation that the control should perform or the function that is called when it is triggered; appearance style: customize the visual properties of the control such as style, color, size, etc. Accordingly, users can create and edit custom controls through the user interface. After the user creates the custom controls, these custom controls are saved so that when the user uses the browsing interface, the user-defined controls are loaded and displayed. In addition, in some application scenarios, users can also authorize their own custom controls to other users, which provides a more flexible control setting and usage method. In addition, users are allowed to manage their own custom controls, including but not limited to editing the properties of the control, deleting controls that are no longer needed, and creating new controls, etc., which are not limited in the embodiments of the present application.

[0187] The above embodiments can more flexibly support the personalized needs of users by supporting the creation and use of custom controls, thereby improving the efficiency and accuracy of data processing and enhancing user satisfaction.

[0188] Figure 4 A flowchart of an embodiment of another method for displaying contents in a table provided in an embodiment of the present application. Figure 4 The process shown in Figure 1 Based on the process shown, the following steps are included:

[0189] Step 401: In response to a content viewing operation on a target cell area in a table, first data content corresponding to the target cell area is obtained.

[0190] Step 402: Display a preset browsing interface.

[0191] Step 403: Display the first data content in the browsing interface.

[0192] For detailed descriptions of steps 401 to 403, please refer to the relevant descriptions in the above embodiments, which will not be repeated here.

[0193] Step 404: in response to a cell switching operation triggered in the browsing interface, determine the target cell from the adjacent cells of the target cell area according to the cell switching operation; or, in response to a triggering operation on an up-arrow key on the keyboard, determine the target cell from the adjacent cells of the target cell area according to the triggered up-arrow key.

[0194] As an optional implementation, the browsing interface is provided with four arrow icons, namely "up", "down", "left" and "right", and the user can trigger the cell switching operation by triggering any of the four icons. For example, assuming that the target cell area is the cell at position B13 (row 13, column B), and assuming that the user triggers a click operation on the "up" arrow icon, the cell at position B12 is determined as the target cell.

[0195] In addition, when the target cell area includes multiple cells, the target cell can also be multiple cells, and the number of target cells is the same as the number of cells included in the target cell area, and the shape of the area composed of multiple target cells can also be the same as the shape of the target cell area. This is similar to translating the target cell area in the manner indicated by the triggered direction key to obtain a new target cell. Optionally, the translation distance is the length of the target cell area in the translation direction.

[0196] For example, assuming that the target cell area is the cell area composed of cells at the four positions B13, C13, B14, and C14, and assuming that the user triggers a click operation on the "right" arrow icon, then the cells at the positions D13, E13, D14, and E14 are determined as target cells.

[0197] Step 405: Obtain the second data content corresponding to the target cell.

[0198] As for how to obtain the second data content of the target cell pair, please refer to the relevant description of obtaining the first data content corresponding to the target cell area in the above embodiment, which will not be repeated here.

[0199] Step 406: Change the first data content displayed in the browsing interface to the second data content.

[0200] Figure 4 The process shown implements a method that allows users to switch target cells in the browsing interface or through the keyboard, and view the data content corresponding to the new target cell in real time. This method eliminates the need for users to frequently switch between the table and the browsing interface, making it more flexible and efficient when processing table data.

[0201] Figure 5 A flowchart of an embodiment of another method for displaying contents in a table provided in an embodiment of the present application. Figure 5 The process shown in Figure 1 Based on the process shown, the following steps are included:

[0202] Step 501: In response to a content viewing operation on a target cell area in a table, first data content corresponding to the target cell area is obtained.

[0203] Step 502: Display a preset browsing interface.

[0204] Step 503: Display the first data content in the browsing interface.

[0205] For detailed descriptions of steps 501 to 503, please refer to the relevant descriptions in the above embodiments, which will not be repeated here.

[0206] Step 504: In response to an editing operation on the first data content displayed in the browsing interface, the edited content of the first data content displayed in the browsing interface is obtained.

[0207] Step 505: Use the edited content to change the original cell content in the target cell area.

[0208] The above-mentioned editing operations include, for example, modifying data content, deleting (all or part of) data content, changing data options (such as when the original cell content is a drop-down list), etc.

[0209] Figure 5 The process shown implements a method of editing data in a table in a browsing interface and updating the edited data back to the corresponding cells in the original table in real time. This method allows users to modify and update table data directly in the browsing interface, greatly improving the efficiency and convenience of data processing.

[0210] Figure 5 The process shown provides a way for a user to manually modify the data in the table through a browsing interface based on the above embodiments. In one embodiment, the data in the table can also be automatically modified according to the first data content. For example, when the first data content includes a possible error in the formula in the original cell content and a modification suggestion generated for the error, the error in the formula is automatically corrected using the modification suggestion. Accordingly, the present application also provides the following embodiments:

[0211] Figure 6 A flowchart of an embodiment of a method for displaying contents in a table provided in another embodiment of the present application. Figure 6 The process shown in Figure 1 Based on the process shown, the following steps are included:

[0212] Step 601: In response to a content viewing operation on a target cell area in a table, first data content corresponding to the target cell area is obtained.

[0213] Step 602: Display a preset browsing interface.

[0214] Step 603: Display the first data content in the browsing interface.

[0215] For detailed descriptions of steps 601 to 603, please refer to the relevant descriptions in the above embodiments, which will not be repeated here.

[0216] Step 604: In response to a triggering operation on the first data content displayed in the browsing interface, the original cell content in the target cell area is changed using the first data content.

[0217] The trigger operation is, for example, a click operation on a corresponding icon / control in the browsing interface. The icon / control usually has a function of indicating that the corresponding original cell content is changed using the first data content.

[0218] Figure 6The process shown implements a method of displaying the first data content in a browsing interface, and allowing the user to independently choose to use the first data content to change the original cell content in the corresponding cell in the table according to actual conditions. This method enables the user to directly trigger the automatic modification and update of the table data in the browsing interface, greatly improving the efficiency and convenience of data processing.

[0219] Figure 7 This is a block diagram of an embodiment of a device for displaying content in a table provided in an embodiment of the present application. Figure 7 As shown, the device comprises:

[0220] A content acquisition module 71, configured to acquire first data content corresponding to a target cell area in a table in response to a content viewing operation on the target cell area in the table;

[0221] The interface display module 72 is used to display a preset browsing interface;

[0222] The content display module 73 is used to display the first data content in the browsing interface.

[0223] In a possible implementation, the content acquisition module 73 includes:

[0224] a content extraction unit, configured to obtain original cell content in the target cell region, and determine the original cell content as first data content corresponding to the target cell region; and / or,

[0225] The content parsing unit is used to parse the original cell content to obtain parsed content of the original cell content; and determine the parsed content as the first data content corresponding to the target cell area.

[0226] In a possible implementation, the content parsing unit includes:

[0227] an information mining subunit, configured to perform information mining on the original cell content and determine the information mining result as the parsed content of the original cell content; and / or,

[0228] The information expansion subunit is used to expand the information of the original cell content and determine the information expansion result as the parsed content of the original cell content.

[0229] In a possible implementation, the content parsing unit includes:

[0230] A parsing method determination subunit is used to determine a target parsing method;

[0231] The parsing subunit is used to parse the original cell content according to the target parsing method to obtain the parsed content of the original cell content.

[0232] In a possible implementation manner, the subunit is determined in the parsing manner, specifically for:

[0233] Determine the content type of the original cell content;

[0234] The target parsing mode is determined according to the content type of the original cell content.

[0235] In a possible implementation manner, the subunit is determined in the parsing manner, specifically for:

[0236] In response to a triggering operation on any preset control in the browsing interface, a parsing mode encapsulated in the preset control corresponding to the triggering operation is determined as a target parsing mode.

[0237] In a possible implementation manner, the subunit is determined in the parsing manner, specifically for:

[0238] Obtaining a user instruction input by a user in the browsing interface;

[0239] The parsing method indicated by the user instruction is determined as the target parsing method.

[0240] In a possible implementation, the device further includes:

[0241] A control display module is used to display a plurality of preset controls in the browsing interface in the following manner:

[0242] Determine the content type of the original cell content;

[0243] The corresponding preset controls are loaded and displayed in the browsing interface according to the content type of the original cell content.

[0244] In a possible implementation, the device further includes:

[0245] A control display module is used to display a plurality of preset controls in the browsing interface in the following manner:

[0246] Obtain historical operation behavior data of the currently logged-in user of the form on the form;

[0247] The corresponding preset controls are loaded and displayed in the browsing interface according to the historical operation behavior data.

[0248] In a possible implementation, the device further includes:

[0249] A control display module is used to display a plurality of preset controls in the browsing interface in the following manner:

[0250] Get the custom control of the currently logged-in user of the table;

[0251] The custom control is determined as a preset control, and the preset control is loaded and displayed in the browsing interface.

[0252] In a possible implementation, the content display module includes:

[0253] a window adjustment unit, configured to adjust the browsing interface by at least one of the following adjustment methods when it is determined to adjust the browsing interface according to the first data content: increasing the window size of the browsing interface, increasing the number of displayed pages of the browsing interface;

[0254] A display unit is used to display the first data content in the adjusted browsing interface.

[0255] In a possible implementation, the device further includes:

[0256] a cell switching module, for responding to a cell switching operation triggered in the browsing interface, determining a target cell from adjacent cells of the target cell region according to the cell switching operation; or, responding to a triggering operation on a direction key on a keyboard, determining a target cell from adjacent cells of the target cell region according to the triggered direction key;

[0257] Acquire the second data content corresponding to the target cell;

[0258] The first data content displayed in the browsing interface is changed to the second data content.

[0259] In a possible implementation, the device further includes:

[0260] a synchronous editing module, configured to obtain edited content of the first data content displayed in the browsing interface in response to an editing operation on the first data content displayed in the browsing interface;

[0261] The original cell contents in the target cell area are changed using the edited contents.

[0262] In a possible implementation, the device further includes:

[0263] The automatic editing module is used to respond to a triggering operation on the first data content displayed in the browsing interface and use the first data content to change the original cell content in the target cell area.

[0264] like Figure 8 As shown, an embodiment of the present application provides a device, including a processor 111, a communication interface 112, a memory 113 and a communication bus 114, wherein the processor 111, the communication interface 112, and the memory 113 communicate with each other through the communication bus 114.

[0265] Memory 113, used for storing computer programs;

[0266] In one embodiment of the present application, the processor 111 is used to execute the program stored in the memory 113 to implement the method for displaying the content in the table provided by any one of the aforementioned method embodiments, including:

[0267] In response to a content viewing operation on a target cell area in the table, obtaining first data content corresponding to the target cell area;

[0268] Display the preset browsing interface;

[0269] The first data content is displayed in the browsing interface.

[0270] An embodiment of the present application further provides a computer-readable storage medium having a computer program stored thereon. When the computer program is executed by a processor, the steps of the method for displaying contents in a table provided in any one of the aforementioned method embodiments are implemented.

[0271] The device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0272] Through the description of the above implementation methods, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a general hardware platform, and of course, by hardware. Based on this understanding, the above technical solution is essentially or the part that contributes to the relevant technology can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiments.

[0273] It should be understood that the terms used in the text are only for the purpose of describing specific example embodiments, and are not intended to be limiting. Unless the context clearly indicates otherwise, the singular forms "one", "an" and "said" as used in the text may also be meant to include plural forms. The terms "include", "comprise", "contain", and "have" are inclusive, and therefore specify the existence of stated features, steps, operations, elements and / or parts, but do not exclude the existence or addition of one or more other features, steps, operations, elements, parts, and / or combinations thereof. The method steps, processes, and operations described herein are not interpreted as necessarily requiring them to be performed in the specific order described or illustrated, unless the execution order is clearly indicated. It should also be understood that additional or alternative steps may be used.

[0274] The above description is only a specific implementation of the present application, so that those skilled in the art can understand or implement the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein can be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest range consistent with the principles and novel features applied for herein.

Claims

1. A method for displaying content in a table, characterized in that: The method comprises: In response to a content viewing operation on a target cell area in the table, obtaining first data content corresponding to the target cell area; Display the preset browsing interface; The first data content is displayed in the browsing interface.

2. The method according to claim 1, characterized in that The obtaining of the first data content corresponding to the target cell area includes: Acquire the original cell content in the target cell area, and determine the original cell content as the first data content corresponding to the target cell area; and / or, The original cell content is parsed to obtain parsed content of the original cell content; and the parsed content is determined as the first data content corresponding to the target cell area.

3. The method according to claim 2, characterized in that The parsing of the original cell content to obtain the parsed content of the original cell content includes: Performing information mining on the original cell content, and determining the information mining result as the parsed content of the original cell content; and / or, Information expansion is performed on the original cell content, and the information expansion result is determined as the parsed content of the original cell content.

4. The method according to claim 2, characterized in that: The parsing of the original cell content to obtain the parsed content of the original cell content includes: Determine the target parsing method; The original cell content is parsed according to the target parsing method to obtain parsed content of the original cell content.

5. The method according to claim 4, characterized in that The method of determining the target parsing method includes: Determine the content type of the original cell content; The target parsing mode is determined according to the content type of the original cell content.

6. The method according to claim 4, characterized in that The method of determining the target parsing method includes: In response to a triggering operation on any preset control in the browsing interface, a parsing mode encapsulated in the preset control corresponding to the triggering operation is determined as a target parsing mode.

7. The method according to claim 4, characterized in that The method of determining the target parsing method includes: Obtaining a user instruction input by a user in the browsing interface; The parsing method indicated by the user instruction is determined as the target parsing method.

8. The method according to claim 6, characterized in that The plurality of preset controls are displayed in the browsing interface in the following manner: Determine the content type of the original cell content; The corresponding preset controls are loaded and displayed in the browsing interface according to the content type of the original cell content.

9. The method according to claim 6, characterized in that The plurality of preset controls are displayed in the browsing interface in the following manner: Obtain historical operation behavior data of the currently logged-in user of the form on the form; The corresponding preset controls are loaded and displayed in the browsing interface according to the historical operation behavior data.

10. The method according to claim 6, characterized in that The plurality of preset controls are displayed in the browsing interface in the following manner: Get the custom control of the currently logged-in user of the table; The custom control is determined as a preset control, and the preset control is loaded and displayed in the browsing interface.

11. The method according to claim 1, characterized in that: The displaying the first data content in the browsing interface includes: In the case where it is determined to adjust the browsing interface according to the first data content, the browsing interface is adjusted by at least one of the following adjustment methods: increasing the window size of the browsing interface, increasing the number of displayed pages of the browsing interface; The first data content is displayed in the adjusted browsing interface.

12. The method according to claim 1, characterized in that The method further comprises: In response to a cell switching operation triggered in the browsing interface, a target cell is determined from adjacent cells of the target cell area according to the cell switching operation; or, in response to a triggering operation on a direction key on a keyboard, a target cell is determined from adjacent cells of the target cell area according to the triggered direction key; Acquire the second data content corresponding to the target cell; The first data content displayed in the browsing interface is changed to the second data content.

13. The method according to claim 1, characterized in that The method further comprises: In response to an editing operation on the first data content displayed in the browsing interface, acquiring edited content of the first data content displayed in the browsing interface; The original cell contents in the target cell area are changed using the edited contents.

14. The method according to claim 1, characterized in that The method further comprises: In response to a triggering operation on the first data content displayed in the browsing interface, the original cell content in the target cell area is changed using the first data content.

15. A device for displaying contents in a table, characterized in that: The device also includes: A content acquisition module, configured to acquire first data content corresponding to a target cell area in a table in response to a content viewing operation on the target cell area in the table; An interface display module, used to display a preset browsing interface; The content display module is used to display the first data content in the browsing interface.

16. A device, characterized in that include: A processor and a memory, wherein the processor is used to execute a display program for the contents in a table stored in the memory, so as to implement the method for displaying the contents in a table according to any one of claims 1 to 14.

17. A storage medium, characterized in that: The storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to implement the method for displaying content in a table according to any one of claims 1 to 14.

Images