A method, apparatus, device, and medium for processing information within a document

Abstract

Embodiments of the present disclosure relate to a method, apparatus, device, and medium for processing information in a document. The method includes: in response to receiving a table creation operation in the document, displaying a database table in the document; in response to receiving a comment request for a target area in the database table, identifying the target area and displaying a comment box on the interface of the document; where the target area includes at least one cell row and / or at least one cell column; in response to receiving comment information through the comment box, recording the association relationship between the comment information and the target area, and displaying the comment information in the document; where the display position of the comment information in the document is related to the position of the target area in the database table. Embodiments of the present disclosure effectively improve the information expression ability related to the database table in the document, and also provide convenience for users to comment on row data / column data in the database table in the document.

Description

Technical Field

[0001] The present disclosure relates to the field of computer technologies, and in particular, to a method, apparatus, device, and medium for processing information in a document. Background Art

[0002] In most of the existing text-editable documents, users can not only input text but also draw tables. Some related technologies propose a way to connect a database table to a document. However, the database table connected to the document is only used to display the data in the table, and its function is relatively single. Summary of the Invention

[0003] To solve the above technical problems or at least partially solve the above technical problems, the present disclosure provides a method, apparatus, device, and medium for processing information in a document.

[0004] An embodiment of the present disclosure provides a method for processing information in a document, which is applied to a client and includes: in response to receiving a table creation operation in the document, displaying a database table in the document; in response to receiving a comment request for a target area in the database table, identifying the target area and displaying a comment box on the interface of the document; where the target area includes at least one unit row and / or at least one unit column; in response to receiving comment information through the comment box, recording the association relationship between the comment information and the target area, and displaying the comment information in the document; where the display position of the comment information in the document is related to the position of the target area in the database table.

[0005] Optionally, the method further includes: updating the view information of the database table and the comment statistics information corresponding to the target area based on the comment information.

[0006] Optionally, the document is an online collaborative document; the method further includes: storing the comment information in a server.

[0007] Optionally, the method further includes: in the loading stage of the document, requesting the server to obtain all the comment information corresponding to the stored document; rendering the comment information based on all the comment information returned by the server and the current visible view of the database table displayed in the document.

[0008] Optionally, the step of rendering comment information based on all the comment information returned by the server and the current view of the database table displayed in the document includes: determining, according to the current visible view of the database table displayed in the document, target comment information that matches the current visible view from all the comment information returned by the server; determining a target area in the current visible view that corresponds to the target comment information, and based on a first position of the target area corresponding to the target comment information in the database table, determining a second position where the target comment information is displayed in the document; and displaying the target comment information at the second position.

[0009] Optionally, the method further includes: marking the target area corresponding to the target comment information with a specified icon.

[0010] Optionally, the method further includes: displaying the target comment information that matches the current visible view in a specified area of the document, and identifying the specified area in a preset manner.

[0011] An embodiment of the present disclosure further provides a device for processing information in a document, which is applied to a client and includes: a table display module, configured to display a database table in the document in response to receiving a table creation operation in the document; a comment request module, configured to identify a target area and display a comment box on the interface of the document in response to receiving a comment request for the target area in the database table, where the target area includes at least one cell row and / or at least one cell column; and a comment display module, configured to record an association relationship between the comment information and the target area in response to receiving the comment information through the comment box, and display the comment information in the document, where a display position of the comment information in the document is related to a position of the target area in the database table.

[0012] An embodiment of the present disclosure further provides an electronic device, which includes: a processor; a memory for storing executable instructions that can be executed by the processor; and the processor is configured to read the executable instructions from the memory and execute the instructions to implement the method for processing information in a document provided in the embodiment of the present disclosure.

[0013] An embodiment of the present disclosure further provides a computer-readable storage medium, where the storage medium stores a computer program, and the computer program is used to execute the method for processing information in a document provided in the embodiment of the present disclosure.

[0014] In the above technical solution provided by the embodiments of the present disclosure, the client can, in response to receiving a table creation operation in a document, display a database table in the document; and in response to a comment request from the user for a target area in the database table, identify the target area and display a comment box on the interface of the document; wherein the target area includes at least one cell row and / or at least one cell column; further in response to receiving comment information through the comment box, record the association relationship between the comment information and the target area, and display the comment information in the document; wherein the display position of the comment information in the document is related to the position of the target area in the database table. In the above manner, row-level comments / column-level comments on the database table can be implemented within the document, and the comment information is displayed in the document, effectively improving the information expression ability related to the database table in the document. Since there are usually certain commonalities in the row data or column data in the database table, and users may have a comment requirement for the entire row / column, the above manner also provides convenience for users to comment on the row data / column data in the database table in the document.

[0015] It should be understood that the content described in this part is not intended to identify the key or important features of the embodiments of the present disclosure, nor is it used to limit the scope of the present disclosure. Other features of the present disclosure will become easily understood through the following description. Brief Description of the Drawings

[0016] The accompanying drawings herein are incorporated into the specification and form a part of the specification, showing embodiments consistent with the present disclosure and used together with the specification to explain the principles of the present disclosure.

[0017] In order to more clearly illustrate the technical solutions in the embodiments of the present disclosure or the prior art, the following will briefly introduce the accompanying drawings required for use in the description of the embodiments or the prior art. Obviously, for those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts.

[0018] Figure 1 It is a schematic flowchart of a method for processing information in a document provided by an embodiment of the present disclosure;

[0019] Figure 2 It is an interactive flowchart of a comment operation provided by an embodiment of the present disclosure;

[0020] Figure 3 It is an interactive flowchart of a rendering operation provided by an embodiment of the present disclosure;

[0021] Figure 4 It is a schematic structural diagram of a device for processing information in a document provided by an embodiment of the present disclosure;

[0022] Figure 5Schematic structural diagram of an electronic device provided by an embodiment of the present disclosure. Detailed implementation manners

[0023] In order to more clearly understand the above objects, features, and advantages of the present disclosure, the solutions of the present disclosure will be further described below. It should be noted that, without conflict, the embodiments of the present disclosure and the features in the embodiments may be combined with each other.

[0024] Many specific details are set forth in the following description in order to fully understand the present disclosure, but the present disclosure may also be implemented in other ways different from those described herein; obviously, the embodiments in the specification are only a part of the embodiments of the present disclosure, rather than all the embodiments.

[0025] In user-editable documents such as Word documents and most online collaborative documents, users can make annotation comments on the text, or make annotations on the content in a simple N-row M-column table drawn in the document in the form of an annotation box. The inventors found that some related technologies proposed a method of connecting a database table to a document, but the database table connected to the document is only used to display the data in the table, with a single function, and it is impossible to directly make annotations or comments on the content in the database table. Since there are usually certain commonalities in the row data or column data in the database table, users may have a comment need for the entire row / column, and at this time, the user needs cannot be met. In addition, although annotations can be made on the table in the database or comments can be made on the content in a table in software such as EXCEL spreadsheet software in related technologies, on the one hand, it is limited by the own formats of the database and EXCEL spreadsheet software, which is far less flexible than inserting a database table into a document (users can also perform text editing in other areas of the document in addition to the database table), and also, in the database and EXCEL spreadsheet software, users can only comment on cells, making it difficult to meet the user's row-level / column-level comment needs. It should be noted that the above-mentioned defects in the related technologies are also the results obtained by the applicant after practice and careful research. Therefore, the discovery process of the above-mentioned defects and the solutions proposed by the embodiments of the present disclosure below for the above-mentioned defects should both be recognized as the contributions made by the applicant to this application.

[0026] In order to improve or partially improve at least one of the above problems, embodiments of the present disclosure provide a method, apparatus, device, and medium for processing information in a document, which are described in detail below:

[0027] Figure 1A flowchart of a method for processing information in a document provided by an embodiment of the present disclosure. This method can be applied to a client, which can be implemented by software and / or hardware. For example, it can be a user device such as a computer or a mobile phone, and is generally integrated in an electronic device. As Figure 1 shown, the method mainly includes the following steps S102 to S106:

[0028] Step S102, in response to receiving a table creation operation in the document, display a database table in the document.

[0029] In practical applications, the user can perform a table creation operation on the document through a preset table creation component. This table creation operation can indicate the table information of the table to be created. The table information includes, but is not limited to, setting the table format to M rows and N columns (both M and N are positive integers), or may also include the view display form of the table to be created, etc. The embodiments of the present disclosure do not limit the table creation operation. The client can display the corresponding database table based on the table creation operation. In the embodiments of the present disclosure, the database table can be incorporated into the document. Exemplarily, it can be achieved by the interaction between the database front end (which can be implemented by a database table application component), the database back end (which can be implemented by a processing program of the database table), the document front end (which can be implemented by a document application program), and the document back end (which can be implemented by a background processing program of the document) to incorporate the database table into the document, so as to display the database table in the document. The incorporated database table is a structured table with database functions such as structured storage, SQL query, and data operation. For details, reference can be made to related technologies and will not be elaborated here. In addition, the document in the embodiments of the present disclosure is mainly an editable document, such as a doc format document, in which a database table can be incorporated and displayed, and text editing can also be performed in other areas outside the database table.

[0030] Step S104, in response to receiving a comment request for a target area in the database table, identify the target area and display a comment box on the interface of the document; where the target area includes at least one unit row and / or at least one unit column. That is, when receiving a comment request for the target area, the target area can be regarded as the area to be evaluated in the database table, and the target area is identified and the comment box is displayed in a specified manner. In some embodiments, the comment box can be a temporary box for receiving the comment information input by the user. After confirming that the user has finished inputting the comment information, the comment box can be no longer displayed.

[0031] In practical applications, when a user accesses a database table in a word document, an online collaborative document, or other documents according to their own needs, a comment request can be further initiated for the unit rows / unit columns to be evaluated in the database table within the document. In some embodiments, the client can be provided with a corresponding comment front-end component for the document (which can also be referred to as a comment front-end, a comment container, or a comment component container). The user can select a target area to be evaluated through the comment front-end component and initiate a corresponding comment request.

[0032] The client can receive, through the comment front-end component, a comment request from the user for the target area in the database table within the document, use the target area as the area to be evaluated in the database table, and identify the target area in a specified manner. The specified manner includes, but is not limited to, highlighting the target area, or using an arrow to point to it, etc., to identify the target area.

[0033] The client can further display a comment box on the interface of the document through the comment front-end component. The comment box is mainly used to receive the comment information input by the user for the target area. The present disclosure does not limit the display position of the comment box. In some examples, the position of the comment box is related to the position of the target area, such as being near the position of the target area. In some embodiments, it can be set that after the comment box receives the comment information input by the user and obtains the user's confirmation completion instruction (or after a specified duration after receiving the comment information), the comment box is no longer displayed on the interface.

[0034] Step S106, in response to receiving comment information through the comment box, record the association relationship between the comment information and the target area, and display the comment information in the document; wherein, the display position of the comment information in the document is related to the position of the target area in the database table.

[0035] When the user inputs comment information for the target area through the comment box, the comment information can be associated with the target area, and it is determined that the comment information is for the target area. Subsequently, the association relationship between the comment information and the target area can be further stored locally and / or on the server. Further, the comment information can also be displayed in the document in a specified manner. The specified manner can be set according to requirements. For example, the specified manner includes: displaying the comment information on the right side of the document corresponding to the position of the target area in the database table, and / or highlighting the comment information in the current document. It can be understood that, in order to facilitate the user to view the comment information of the target area, the display position of the comment information in the current document is related to the position of the target area in the database table. For example, if the target area is the fourth row of the database table in the document, the comment information is also located at the corresponding position on the right side of the fourth row of the database table in the document.

[0036] In the above - mentioned manner, row - level comments / column - level comments for database tables can be realized within the document, and the comment information is displayed in the document, effectively improving the information expression ability related to database tables in the document. Since there are usually certain commonalities in the row data or column data in the database table, users may have a need to comment on the entire row / entire column. The above - mentioned manner also provides convenience for users to comment on the row data / column data in the database table in the document.

[0037] In order to more clearly show the evaluation effect to users, in some embodiments, the method provided by the embodiments of the present disclosure further includes: updating the view information of the database table and the comment statistical information corresponding to the target area based on the comment information. In some specific implementation examples, the view information includes a view UI (User Interface), and the comment statistical information may include, for example, the number of comments and / or the latest comment time. Since new comment information is added to the database table, the view UI of the database table can be updated based on the comment information to change the UI effect before and after the comment information. For example, a yellow triangle mark is set at the upper - right corner of the target area of the database table as the updated view UI of the database table. In addition, a target area may correspond to one or more comments. If the current document is an online collaborative document, the same target area may correspond to comments from different users. Therefore, the number of comments and / or the latest comment time can be marked at the target area, and as long as new comment information is added, the number of comments and / or the latest comment time corresponding to the target area will be updated.

[0038] In some embodiments, the document in the embodiments of the present disclosure is an online collaborative document; the above - mentioned method further includes: storing the comment information on the server - side. The server - side may be, for example, a server. Further, the server - side includes, for example, a comment backend. Among them, the above - mentioned method can store the comment information in the comment backend (which can be implemented by a background program for processing comments and can be set in the server). The comment backend can provide services for storing and updating comment information, that is, it can manage the comment information in the background. In addition, the server - side can further include a document backend, a database table backend, etc. Through the interaction between the document front - end, document backend, database table front - end, database table backend, comment front - end, and comment backend, the database table is accessed into the document, and comments are made on the database table within the document.

[0039] The above are all embodiments of adding comments to a loaded document. On this basis, the embodiments of the present disclosure also provide a way to render the comment information corresponding to the document when the document is initially loaded, that is, an embodiment of displaying the existing comment information after the document is initially opened. Exemplarily, the above - mentioned method further includes the following steps a and b:

[0040] Step a, in the document loading phase, request the server to obtain all comment information corresponding to the stored record document. The server can be a comment backend. Since the document sends the comment information to the server every time new comment information is added, the server records all comment information of the document.

[0041] Step b, render the comment information based on all the comment information returned by the server and the current visible view of the database table displayed in the document. In some embodiments, the client can receive all the comment information, but will not display all the comment information on the current interface of the document. Instead, it will determine the comment information to be displayed according to the current visible view of the database table displayed in the current document. Exemplarily, only the comment information corresponding to the current visible view of the database table is displayed. It can be understood that there may be multiple database tables in the current document, and each database table may also correspond to multiple views. The above step b can only render the comment information for the current visible view of the database table displayed in the document (the database table view that the user can currently see on the client) so that the user can intuitively see the comment information corresponding to the current visible view of the database table.

[0042] In some embodiments, the above step b can be executed with reference to the following steps b1 to b3:

[0043] Step b1, determine the target comment information that matches the current visible view from all the comment information returned by the server according to the current visible view of the database table displayed in the document.

[0044] In some embodiments, each comment information carries a database table identifier corresponding to it and is also associated with the position of the target area of the database table it comments on in the corresponding database table. Therefore, the comment information with the same table identifier as the database table displayed in the current document can be first screened out from all the comment information as candidate comment information, and then for each candidate comment information, it is determined whether it corresponds to the current visible view of the database table displayed in the current document. If so, the candidate comment information is the target comment information that matches the current visible view.

[0045] Step b2, determine the target area corresponding to the target comment information in the current visible view, and determine the second position where the target comment information is displayed in the document based on the first position of the target area corresponding to the target comment information in the database table. In some embodiments, taking the target area as the row of the database table cell as an example, a comment list can be established on the right (or left) side of the document, and then the position of the comment information corresponding to the row of the database table cell in the comment list corresponds to the position of the row of the database table cell, such as being in the same row. In some embodiments, taking the target area as the column of the database table cell as an example, a comment list can be established above (or below) the database table in the document, and then the position of the comment information corresponding to the column of the database table cell in the comment list corresponds to the position of the column of the database table cell, such as being in the same column.

[0046] Step b3, display the target comment information at the second position.

[0047] It should be understood that the above second position is the position in the document, that is, the comment information for the database table can be directly displayed in the document for the user to view.

[0048] On the basis of determining the target comment information, the above method further includes: marking the target area corresponding to the target comment information with a specified icon. This specified icon can also be understood as a UI represented in a specified form, such as yellow triangle icons, red exclamation marks, ellipsis icons, etc. The icon form can be set according to requirements and is not limited here. That is, at the target area corresponding to the target comment information, a UI represented in a specified form is used for comment identification. For example, the specified icon can be set at the upper right corner of the target area to remind the user that there is comment information in this target area.

[0049] To facilitate the user to view the target comment information as a whole, the above method further includes: displaying the target comment information matching the current visible view in a specified area of the document, and identifying the specified area in a preset manner. For example, the specified area is the right side of the current document (also the right side of the database table), and the preset manner includes but is not limited to representing the specified area with a comment list box, highlighting, or preset filling in the specified area, etc.

[0050] For ease of understanding, the embodiments of the present disclosure further provide a specific implementation manner of a method for processing information in a document. In this example, the client includes a document front end, a database table front end, and a comment front end component; the server includes a comment back end.

[0051] The client and the server implement comment operations through a first interaction method. Among them, in the first interaction method:

[0052] The front end of the database table is used to respond to a user's comment request for a target area in the database table within the current document, take the target area as the area to be evaluated in the database table, send the comment request to the front end of the document, and identify the target area in a specified manner;

[0053] The front end of the document is used to initiate a notification of adding a new comment to the comment front-end component after receiving the comment request;

[0054] The comment front-end component is used to display a comment box (such as rendering a temporary comment box) on the interface of the current document after receiving the notification of adding a new comment, receive the comment information input by the user through the comment box, and send the comment information to the comment back end for storage;

[0055] The front end of the database table is also used to update the view information (such as view UI) corresponding to the comment information, and notify the front end of the document of the position of the target area corresponding to the comment information in the database table.

[0056] The front end of the document is also used to display the comment information in a specified manner. The display position of the comment information in the current document is related to the position of the target area in the database table, and the association relationship between the comment information and the target area is recorded. Among them, after the comment front-end component receives the comment information through the comment box, the comment information can be directly sent to the front end of the document for display, or after the comment back end receives the comment information sent by the comment front-end component, the comment information is returned to the front end of the document for display.

[0057] On the basis of the foregoing, the embodiments of the present disclosure simply use an interaction flow chart of a comment operation as shown in Figure 2 for exemplary illustration, showing the interaction steps among the front end of the document, the front end of the database table, the comment front-end component, and the comment back end. Specifically:

[0058] S201, the front end of the database table sends a comment request from the user for a target area in the database table within the current document to the front end of the document.

[0059] S202, the front end of the database table highlights the target area. Exemplarily, the front end of the database table takes the target area as the active area and performs temporary highlighting on this area.

[0060] S203, the front end of the document initiates a notification of adding a new comment to the comment front-end component.

[0061] S204, the comment front-end component updates the view and renders a temporary comment box. That is, the comment front-end component receives the comment information input by the user through the temporary comment box.

[0062] S205, The comment front-end component sends the comment information received through the temporary comment box to the comment back-end. After storing the comment information, the comment back-end can return a save operation completion message to the comment front-end component. The comment front-end component can also re-render the comment component (to indicate to the user that the comment information has been saved), and return a save operation completion message to the document front-end.

[0063] S206, The document front-end displays the comment information in a specified manner. The display position of the comment information in the current document is related to the position of the target area in the database table. The document front-end returns a comment information display completion message to the database table front-end. In addition, the document front-end can also re-render the comment component, changing the display form of the comment component, to indicate to the user that the save operation for the comment information has been completed.

[0064] S207, The database table front-end updates the view UI of the database table and the comment count corresponding to the target area based on the comment information.

[0065] S208, The database table front-end notifies the document front-end of the position of the target area corresponding to the comment information in the database table. In addition, the database table front-end can further save the comment information, and notify the comment back-end and the document front-end of the message that the information saving is completed.

[0066] S209, The document front-end records the association relationship between the comment information and the target area. Specifically, this association relationship is bundled and recorded with the comment information and the position of its corresponding target area in the database table.

[0067] The above method exemplarily shows the comment operation interaction process among the document front-end, the database table front-end, the comment front-end component, and the comment back-end when the user adds a new comment. It should be noted that Figure 2 it is only a simple example showing the main interaction steps and should not be regarded as a limitation. In actual applications, more or fewer steps than those Figure 2 shown can also be used to implement. In addition, Figure 2 the specific implementation methods of each step in

[0068] The client and the server implement the comment operation through the above first interaction method. Based on the fact that the document has been loaded, the loaded document displays the existing comment information, and on this basis, when adding a new comment, the method as Figure 2The above - shown interaction method is implemented. Further, the embodiments of the present disclosure also provide that at the initial loading stage of the current document, the client and the server implement the rendering operation of comment information through a second interaction method, that is, a specific method of how to display the comment information corresponding to the document in the document when initially loading the document. Among them, in the second interaction method:

[0069] The comment front - end component is used to request from the comment back - end to obtain all comment information corresponding to the current document of the stored records, and return all the comment information received from the comment back - end to the document front - end.

[0070] The document front - end is used to initiate a comment update notification to the database table front - end based on all comment information.

[0071] The database table front - end is used to determine, according to the current visible view of the database table displayed for the current document, the target comment information that matches the current visible view from all comment information, and return the target comment information to the document front - end; the database table front - end is also used to update the UI of the database table view.

[0072] The document front - end is also used to display the target comment information; it is also used to notify the comment front - end component to update the comment UI after displaying the target comment information.

[0073] The comment front - end component is also used to perform comment identification at the target area corresponding to the target comment information in a specified form of UI (that is, mark the target area corresponding to the target comment information with a specified icon).

[0074] On the above basis, the embodiments of the present disclosure simply use an interaction flow chart of a rendering operation as shown in Figure 3 for exemplary illustration, showing the interaction steps among the document front - end, the database table front - end, the comment front - end component, and the comment back - end. Specifically:

[0075] S301, the comment front - end component passes the component instance to the document front - end. Specifically, the comment front - end component instantiates the comment component, and the document front - end instantiates the business component (the component related to the document business). When the current document is initially loaded, if there are comments in the document, the comment component will be rendered.

[0076] S302, the comment front - end component requests from the comment back - end to obtain all comment information corresponding to the current document of the stored records.

[0077] S303, the comment back - end returns all comment information to the comment front - end component.

[0078] S304, the comment front - end component returns all comment information to the document front - end and notifies the update of comment information. In addition, the comment front - end component also renders the comment UI.

[0079] S305, The document front-end returns all comment information to the database table front-end and notifies the update of the comment information.

[0080] S306, The database table front-end determines the target comment information that matches the current visible view of the database table displayed in the current document from all the comment information, and updates the UI of the database table view.

[0081] Exemplarily, taking the unit row comment (row-level comment) as an example, after the database table front-end receives all the comment information, for each piece of comment information, it will determine whether the comment information matches the currently displayed database table. If the database table identifier carried by the comment information is the same as the identifier of the currently displayed database table, it matches; otherwise, it does not match. If it matches, it will continue to determine whether there is corresponding comment row information in the current view (or determine whether there is a corresponding visible view row for the comment information). If the current view row exists and has not been filtered (i.e., it is the current visible view row), it will display and update the view UI, and at the same time determine the position information of the current visible view row in the database table, and it can also return it to the document front-end; if there is no corresponding visible view row for the comment row information, no processing is required. If it does not match, the view rendering effect will be stopped.

[0082] S307, The database table front-end returns the target comment information that needs to be displayed to the document front-end.

[0083] S308, The document front-end displays the target comment information. Based on the example in S306 above, the database table front-end can notify the document front-end of the position of the visible view row corresponding to the target comment information (i.e., the aforementioned target area) in the database table. Therefore, when the document front-end displays the target comment information, it can determine the display position of the target comment information based on the position of the visible view row corresponding to the target comment information in the database table.

[0084] S309, The document front-end notifies the comment front-end component to update the component UI, which can also be referred to as the container UI. Exemplarily, after the document front-end displays the target comment information, it can inform the comment front-end component to change the UI effect, so as to remind the user through the component UI that the comment information has been rendered in the current document and to inform the user of the position corresponding to the comment information in the database table.

[0085] The above method exemplarily shows the comment rendering interaction process among the document front-end, the database table front-end, the comment front-end component, and the comment back-end when the document is initially loaded. It should be noted that Figure 3 It is only a simple example showing the main interaction steps and should not be regarded as a limitation. In actual applications, it is also possible to adopt a method Figure 3The steps shown may be implemented with more or fewer steps. Additionally, Figure 3 For the specific implementation methods of the steps in Figure 3 , reference may be made to the foregoing relevant content, which will not be elaborated here.

[0086] In practical applications, when initially loading a document, operations such as Figure 3 performing a comment information rendering operation can be referred to, so as to render and display the existing comment information of the document on the document. When there is a new comment in the current document, reference may be made to Figure 2 performing a comment information addition operation (which can also be referred to as a comment operation).

[0087] In summary, the method for processing the information in the document provided by the embodiments of the present disclosure can implement row-level comments / column-level comments on a database table within the document and display the comment information in the document, effectively improving the information expression ability related to the database table in the document. Since there are usually certain commonalities in the row data or column data in the database table, users may have a need to comment on the entire row / entire column. The above method also provides convenience for users to comment on the row data / column data in the database table in the document.

[0088] In addition, the embodiments of the present disclosure focus on how to comment on the unit rows and / or unit columns of the database tables accessed in the document, and how to render the existing comment information of the document when the document is initially loaded, providing a row / column-level comment function for the document that can access the database table. In the related art, although comments can be made on the table, they can only be made on the tables in the database or the table content in software such as EXCEL spreadsheets, and cannot directly comment on the database tables embedded in the document. Moreover, the comment information cannot be displayed in the document, and only the cells in the database table can be commented on, and the comment information is only displayed at the cell, and row-level or column-level comments cannot be made on the entire unit row / entire unit column. Moreover, limited by the own formats of the database and EXCEL spreadsheet software, the comment method is far less flexible than commenting on the database tables inserted in the document. Through the embodiments of the present disclosure, users can directly make row-level or column-level comments on the database tables in the document and clearly view the corresponding comment information in the document. Moreover, the document can be a doc document. In addition to accessing the database table, text editing and the like can also be performed at other positions in the document, providing a more rich and convenient document editing experience for users. In addition, it should be noted that in the related art, what can be achieved in the doc document currently is only to simply draw a table (non-database table) in the document and use the annotation method to comment on the data in the table, rather than directly commenting on the database tables accessed in the document as in the embodiments of the present disclosure. The database tables in the embodiments of the present disclosure have database-related functions compared with the tables simply drawn in the document. For example, accessing the database table has database functions such as structured storage, SQL query, and data operation, and at the same time, it also makes the document have stronger data management capabilities. In addition, the effect of simply annotating the document table in the related art is far less than the comment effect that can be achieved by using the embodiments of the present disclosure to comment on the database table.

[0089] Furthermore, the document in the embodiments of the present disclosure can be an online collaborative document. On this basis, the effect of multiple people commenting on the database tables in the document can be achieved, enhancing the interactivity of the document table. Multiple users can express their views on the row data / column data in the database table, realizing an interactive discussion with responses.

[0090] Because users can also perform text editing and the like in other areas of the document except for the database table, and in the database and EXCEL spreadsheet software, for example, only the cells can be commented on, it is difficult to meet the row-level / column-level comment requirements of users.

[0091] Corresponding to the foregoing method for commenting on the table in the document, the embodiments of the present disclosure provide a device for processing information in the document. See Figure 4The structural schematic diagram of a processing device for information in a document. The device can be implemented by software and / or hardware and is generally integrated in an electronic device that can be used as a client (such as a mobile phone, a computer, etc.). It includes:

[0092] A table display module 402, configured to display a database table in the document in response to receiving a table creation operation in the document;

[0093] A comment request module 404, configured to identify a target area and display a comment box on the interface of the document in response to receiving a comment request for the target area in the database table; wherein, the target area includes at least one cell row and / or at least one cell column;

[0094] A comment display module 406, configured to record the association relationship between the comment information and the target area and display the comment information in the document in response to receiving the comment information through the comment box; wherein, the display position of the comment information in the document is related to the position of the target area in the database table.

[0095] Through the above device, row-level comments / column-level comments for the database table can be realized in the document, and the comment information is displayed in the document, effectively improving the information expression ability related to the database table in the document. Since there are usually certain commonalities in the row data or column data in the database table, users may have a need to comment on the entire row / entire column. The above method also provides convenience for users to comment on the row data / column data in the database table in the document.

[0096] In some embodiments, the device further includes: an update module, configured to update the view information of the database table and the comment statistics information corresponding to the target area based on the comment information.

[0097] In some embodiments, the document is an online collaborative document; the device further includes: a storage module, configured to store the comment information on the server side.

[0098] In some embodiments, the device further includes: an information acquisition module, configured to request and acquire all comment information corresponding to the stored document from the server side during the loading stage of the document; an information rendering module, configured to render the comment information based on all the comment information returned by the server side and the current visible view of the database table displayed in the document.

[0099] An information rendering module, specifically used for: determining target comment information that matches the current visual view from all the comment information returned by the server according to the current visual view of the database table displayed in the document; determining a target area in the current visual view that corresponds to the target comment information, and determining a second position where the target comment information is displayed in the document based on a first position of the target area corresponding to the target comment information in the database table; and displaying the target comment information at the second position.

[0100] In some embodiments, the device further includes: an icon marking module, configured to mark the target area corresponding to the target comment information with a specified icon.

[0101] In some embodiments, the device further includes: a region identification module, configured to display the target comment information that matches the current visual view in a specified area of the document, and identify the specified area in a preset manner.

[0102] The document information processing device provided by the embodiments of the present disclosure can execute the document information processing method provided by any embodiment of the present disclosure, and has corresponding functional modules and beneficial effects for executing the method.

[0103] Those skilled in the art can clearly understand that for the convenience and simplicity of description, the specific working process of the device embodiments described above can refer to the corresponding process in the method embodiments, and will not be elaborated herein.

[0104] The embodiments of the present disclosure provide an electronic device, which includes: a processor; a memory for storing executable instructions of the processor; and the processor, configured to read the executable instructions from the memory and execute the instructions to implement the document information processing method of any one of the above.

[0105] Figure 5 It is a schematic structural diagram of an electronic device provided by an embodiment of the present disclosure. As Figure 5 shown, the electronic device 500 includes one or more processors 501 and a memory 502.

[0106] The processor 501 can be a central processing unit (CPU) or other forms of processing units with data processing capabilities and / or instruction execution capabilities, and can control other components in the electronic device 500 to execute desired functions.

[0107] The memory 502 may include one or more computer program products, and the computer program products may include various forms of computer-readable storage media, such as volatile memory and / or non-volatile memory. The volatile memory may include, for example, random access memory (RAM) and / or cache memory, etc. The non-volatile memory may include, for example, read-only memory (ROM), hard disk, flash memory, etc. One or more computer program instructions may be stored on the computer-readable storage media, and the processor 501 may run the program instructions to implement the method for processing in-document information of the embodiments of the present disclosure described above and / or other desired functions. Various contents such as input signals, signal components, noise components, etc. may also be stored in the computer-readable storage media.

[0108] In one example, the electronic device 500 may further include: an input device 503 and an output device 504, and these components are interconnected through a bus system and / or other forms of connection mechanisms (not shown).

[0109] In addition, the input device 503 may further include, for example, a keyboard, a mouse, and so on.

[0110] The output device 504 may output various information to the outside, including the determined distance information, direction information, etc. The output device 504 may include, for example, a display, a speaker, a printer, and a communication network and its connected remote output devices, and so on.

[0111] Of course, for simplicity, Figure 5 only some of the components related to the present disclosure in the electronic device 500 are shown, and components such as buses, input / output interfaces, etc. are omitted. In addition, according to specific application scenarios, the electronic device 500 may further include any other appropriate components.

[0112] In addition to the above methods and devices, the embodiments of the present disclosure may also be a computer program product, which includes computer program instructions that cause the processor to execute the method for processing in-document information provided by the embodiments of the present disclosure when the computer program instructions are run by the processor.

[0113] The computer program product may be written in any combination of one or more programming languages for executing the program code of the operations of the embodiments of the present disclosure. The programming languages include object-oriented programming languages such as Java, C++, etc., and also include conventional procedural programming languages such as the "C" language or similar programming languages. The program code may be executed entirely on the user's computing device, partially on the user's device, executed as a stand-alone software package, partially on the user's computing device and partially on a remote computing device, or entirely on a remote computing device or server.

[0114] In addition, an embodiment of the present disclosure may also be a computer-readable storage medium having stored thereon computer program instructions that, when run by a processor, cause the processor to execute the method for processing the information in the document provided by the embodiments of the present disclosure.

[0115] The computer-readable storage medium may employ any combination of one or more readable media. The readable media may be a readable signal medium or a readable storage medium. The readable storage medium may, for example, include but is not limited to an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the above. More specific examples (a non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above.

[0116] The embodiments of the present disclosure also provide a computer program product including computer programs / instructions that, when executed by a processor, implement the method for processing the information in the document in the embodiments of the present disclosure.

[0117] It should be noted that in this document, relational terms such as "first" and "second" are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any actual relationship or order between these entities or operations. Moreover, the term "comprising", "including" or any other variation thereof is intended to cover a non-exclusive inclusion, such that a process, method, article or device comprising a series of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such process, method, article or device. Without further limitation, an element defined by the phrase "comprising an..." does not exclude the presence of additional identical elements in the process, method, article or device comprising the element.

[0118] The above are only specific embodiments of the present disclosure, enabling those skilled in the art to understand or implement the present disclosure. Various modifications to these embodiments will be obvious 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 disclosure. Therefore, the present disclosure will not be limited to these embodiments described herein, but rather will be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for processing information within a document, characterized in that, Applied to the client, including: In response to receiving a table creation operation in the document, display a database table in the document; In response to receiving a comment request for a target area in the database table, identify the target area and display a comment box on the interface of the document; wherein, the target area includes at least one cell row and / or at least one cell column; In response to receiving comment information through the comment box, record the association relationship between the comment information and the target area, and display the comment information in the document; wherein, the display position of the comment information in the document is related to the position of the target area in the database table; The document is an online collaborative document; the method further includes: storing the comment information in the server; in the loading stage of the document, request the server to obtain all the comment information corresponding to the stored document; determine the target comment information that matches the current visual view from all the comment information returned by the server according to the current visual view of the database table displayed in the document; determine the target area corresponding to the target comment information in the current visual view, and based on the first position of the target area corresponding to the target comment information in the database table, determine the second position where the target comment information is displayed in the document; display the target comment information at the second position.

2. The method according to claim 1, characterized in that, The method further includes: Update the view information of the database table and the comment statistics information corresponding to the target area based on the comment information.

3. The method according to claim 1, wherein The method further includes: Mark the target area corresponding to the target comment information with a specified icon.

4. The method according to claim 1, wherein The method further includes: Display the target comment information that matches the current visual view in a specified area of the document, and identify the specified area in a preset manner.

5. An information processing device within a document, characterized in that, Applied to the client, including: A table display module, configured to display a database table in the document in response to receiving a table creation operation in the document; A comment request module, configured to identify the target area and display a comment box on the interface of the document in response to receiving a comment request for a target area in the database table; wherein, the target area includes at least one cell row and / or at least one cell column; a comment display module, configured to record the association relationship between the comment information and the target area and display the comment information in the document in response to receiving comment information through the comment box; wherein, the display position of the comment information in the document is related to the position of the target area in the database table; The document is an online collaborative document; the device further includes: a storage module, configured to store the comment information on a server; an information acquisition module, configured to, during a loading stage of the document, request the server to obtain all comment information corresponding to the stored record of the document; determine target comment information matching the current visual view from all the comment information returned by the server according to the current visual view of a database table displayed in the document; determine a target area corresponding to the target comment information in the current visual view, and determine a second position where the target comment information is displayed in the document based on a first position of the target area corresponding to the target comment information in the database table; and display the target comment information at the second position.

6. An electronic device, characterized in that, The electronic device includes: a processor; a memory for storing executable instructions of the processor; The processor is configured to read the executable instructions from the memory and execute the instructions to implement the method for processing information in a document according to any one of claims 1-4 above.

7. A computer-readable storage medium, characterized in that, The storage medium stores a computer program, and the computer program is used to execute the method for processing information in a document according to any one of claims 1-4 above.

Images