Table data processing method, device, electronic device, storage medium, and computer program

Abstract

A method, device, electronic device, and storage medium for processing table data are provided, which display at least one update record of a first cell in an online document in response to a first preset user operation on a first cell, and obtain entity update content that corresponds to the first update record and includes rich elements in response to a second preset user operation on the first update record, thereby not only obtaining text content corresponding to the update record but also facilitating a user to restore or copy the entity update content including the rich elements.

Description

[Technical Field]

[0001] [CROSS-REFERENCE TO RELATED APPLICATIONS] This application claims priority from a Chinese patent application bearing application number 202310159186.4, entitled "Table Data Processing Method, Apparatus, Electronic Device, and Storage Medium," filed on February 15, 2023, the entire contents of which are incorporated herein by reference.

[0002] [Technical field] The present disclosure relates to the field of computer technology, and more particularly to a table data processing method, device, electronic device, and storage medium. [Background technology]

[0003] Document collaboration techniques allow multiple users to work on the same document in real time, without the users having to hand the document over to each other before working on it, thereby improving the efficiency of document work. During spreadsheet collaboration, after the content of a cell has been updated multiple times, a user may want to restore or obtain (e.g., copy) a version of the updated content. Summary of the Invention [Means for solving the problem]

[0004] This Summary of the Invention section is provided to facilitate introducing in a simplified form concepts that are described in more detail in the Specific Embodiments section below. This Summary of the Invention section is not intended to identify key features or required features of the claimed solution, nor is it intended to limit the scope of the claimed solution.

[0005] In a first aspect, according to one or more embodiments of the present disclosure, 1. A method for processing table data, the method comprising: displaying at least one update record for a first cell in an online document in response to a first preset user operation on the first cell; In response to a second preset user operation on a first update record of the at least one update record, obtaining entity update content corresponding to the first update record; The entity update content of the first update record provides a method for processing table data, including rich elements including at least one of a picture, a document, a hyperlink, and a function module.

[0006] In a second aspect, according to one or more embodiments of the present disclosure, An apparatus for processing table data, the apparatus comprising: a display unit adapted to display at least one update record of a first cell in an online document in response to a first preset user operation on the first cell; an acquisition unit used to acquire entity update content corresponding to a first update record of the at least one update record in response to a second preset user operation on the first update record; The entity update content of the first update record provides an apparatus for processing table data, the apparatus including rich elements including at least one of a picture, a document, a hyperlink, and a function module.

[0007] In a third aspect, according to one or more embodiments of the present disclosure, there is provided an electronic device, the electronic device including at least one memory and at least one processor, the memory being used to store program code, and the processor being used to call the program code stored in the memory to cause the electronic device to perform a method for processing table data provided by one or more embodiments of the present disclosure.

[0008] In a fourth aspect, according to one or more embodiments of the present disclosure, there is provided a non-transitory computer storage medium having stored thereon program code that, when executed by a computing device, causes the computing device to perform a method for processing table data provided by one or more embodiments of the present disclosure. [Effects of the Invention]

[0009] According to one or more embodiments of the present disclosure, in response to a first preset user operation on a first cell in an online document, at least one update record of the first cell is displayed, and in response to a second preset user operation on the first update record, entity update content corresponding to the first update record and including rich elements is obtained, thereby not only obtaining text content corresponding to the update record but also facilitating the user to accurately and comprehensively restore or copy the entity update content including the rich elements. [Brief explanation of the drawings]

[0010] The above and other features, advantages, and aspects of each embodiment of the present disclosure will become more apparent with reference to the following specific embodiments in conjunction with the drawings. Throughout the drawings, identical or similar reference numerals represent identical or similar elements. It should be understood that the drawings are schematic and that the structures and elements are not necessarily drawn to scale.

[0011] [Figure 1] 1 is a flowchart of a table data processing method provided by an embodiment of the present disclosure. [Figure 2] 1 illustrates a cell update record interface provided by one embodiment of the present disclosure. [Figure 3] 1 is a schematic diagram illustrating the configuration of a table data processing device provided by an embodiment of the present disclosure. [Figure 4] FIG. 1 is a schematic diagram illustrating the configuration of an electronic device provided according to an embodiment of the present disclosure. DETAILED DESCRIPTION OF THE INVENTION

[0012] Hereinafter, embodiments of the present disclosure will be described in more detail with reference to the drawings. Although the drawings show several embodiments of the present disclosure, it should be understood that the present disclosure can be realized in various forms and should not be construed as being limited to the embodiments described herein, but rather, these embodiments are provided to provide a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the present disclosure are used for illustration purposes only and are not used to limit the scope of protection of the present disclosure.

[0013] It should be understood that the steps described in the embodiments of the present disclosure may be performed in different orders and / or in parallel. Also, embodiments may include additional steps and / or omit the performance of steps shown. The scope of the present disclosure is not limited in this respect. As used herein, the term "comprises" and variations thereof are intended to be open-ended, meaning "including but not limited to." The term "based on" means "based at least in part on." The term "in one embodiment" means "at least one embodiment," the term "another embodiment" means "at least one other embodiment," and the term "some embodiments" means "at least some embodiments." The term "responsive to" and related terms mean that one signal or event is influenced to some extent by another signal or event, but not necessarily completely or directly. If event x occurs "in response to" event y, then x may respond directly or indirectly to y. For example, the occurrence of y may ultimately cause the occurrence of x, but there may be other intermediary events and / or conditions. In other cases, y does not necessarily cause the occurrence of x, and x may occur even if y has not yet occurred. The term "responsive to" may also mean "at least partially responsive to."

[0014] The term "determining" broadly encompasses various operations and may include obtaining, operating, calculating, processing, deriving, examining, retrieving (e.g., searching in a table, database, or other data structure), ascertaining, and similar operations, as well as receiving (e.g., receiving information), accessing (e.g., accessing data in a memory), and similar operations, as well as analyzing, selecting, culling, establishing, and similar operations. Relevant definitions of other terms are provided in the description below.

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

[0016] It can be understood that before using the technical solutions disclosed in each embodiment of the present disclosure, the user must be notified of the type, scope of use, usage scenario, etc. of the personal information related to the present disclosure in an appropriate manner in accordance with relevant laws and regulations, and permission from the user must be obtained. For example, in response to receiving an active request from the user, prompt information may be sent to the user explicitly informing them that the operation they are requested to perform requires the acquisition and use of their personal information, allowing the user to autonomously choose whether or not to provide personal information to software or hardware, such as an electronic device, application, server, or storage medium, that performs the operation of the technical solution of the present disclosure, according to the prompt information.

[0017] As an optional but non-limiting implementation method, the method of sending prompt information to the user in response to receiving an active request from the user may be, for example, a pop-up window, or the prompt information may be presented in text form in the pop-up window, and the pop-up window may include a selection control for the user to select "agree" or "disagree" to providing personal information to the electronic device.

[0018] It will be appreciated that the above-described notification and user permission acquisition procedures are merely exemplary and are not intended to limit the implementation of the present disclosure, and that other methods that comply with relevant laws and regulations may also be applied to the implementation of the present disclosure.

[0019] It should be noted that the concepts of "first," "second," etc. referred to in this disclosure are merely intended to distinguish between different devices, modules, or units, and are not intended to limit the order or interdependence of the functions performed by these devices, modules, or units.

[0020] It should be understood by those skilled in the art that the modifications "one" and "multiple" referred to in the present disclosure are exemplary and not limiting, and should be understood as "one or more" unless the context clearly indicates otherwise.

[0021] For purposes of this disclosure, the phrase "A and / or B" means (A), (B), or (A and B). The names of messages or information interacting between multiple devices in the embodiments of the present disclosure are for illustrative purposes only and are not intended to limit the scope of these messages or information.

[0022] Referring to FIG. 1, FIG. 1 is a flowchart of a method 100 for processing table data provided by one embodiment of the present disclosure, which includes steps S120 and S140.

[0023] Step S120: In response to a first preset user operation on a first cell in an online document, display at least one update record of the first cell.

[0024] Step S140: In response to a second preset user operation on a first update record of the at least one update record, obtain entity update content corresponding to the first update record.

[0025] The entity update content of the first update record includes a rich element including at least one of a picture, a document, a hyperlink, and a function module. In some embodiments, the function module is used to perform a pre-configured function, such as a schedule reminder, a user reminder, a document reminder, or other function component that provides functionality in a table.

[0026] In some embodiments, online documents are documents that users edit online and store in the cloud in real-time, collaborative, multi-user environments, where the documents can be displayed through pages in HyperText Markup Language (HTML) or similar, and rely on client-server communication to synchronize user edited content.

[0027] In some embodiments, the execution entity of method 100 may be a client, such as an instant messaging (IM) client, which has an online document function integrated into it. Based on a user's click operation, the client invokes a browser kernel through an interface provided by the browser to load an online document page. The user can create and edit an online document based on the loaded page, and of course, the user can share the online document through the client. In other embodiments, the client incorporates a browser kernel, which invokes the browser kernel to display the online document page on the client. In other embodiments, the client is an online document client, which executes the online document client to load and display the online document client page. In other embodiments, an applet corresponding to the online document function exists, and the client downloads and executes the source code of the online document applet to load and display the online document page.

[0028] The first preset operation for the first cell is used to display the update record of the first cell. In some embodiments, the first preset operation includes, but is not limited to, a haptic control operation, a gesture control operation, a sway operation, a touch operation, a voice control command, or an operation on an external control device. Illustratively, after selecting the first cell, a user can activate a preset menu with a right mouse button, which can provide a function option for displaying the update record of the cell for the user to further select. When the user clicks this function option, an update record interface for the cell pops up.

[0029] A second preset operation for the first update record is used to obtain entity update content corresponding to the first update record. In some embodiments, the second preset operation includes, but is not limited to, a haptic control operation, a gesture control operation, a waving eye movement operation, a touch operation, a voice control command, or an operation on an external control device. Exemplarily, the entity update content of the first update record may be obtained in response to a user triggering a preset virtual button corresponding to the first update record.

[0030] FIG. 2 illustrates a cell update record interface provided by one embodiment of the present disclosure. The update record interface 10 displays update records for cell B2, and currently displays a total of four update records for cell B2 by users A, B, C, and D in a list format. The display content of each update record includes the user name, the update time, and the specific update content. Referring to FIG. 2, if an update includes inserting a document as an attachment into a cell, the name of the document as an attachment (e.g., "xx sales data") may be displayed. If an update includes inserting a picture as an attachment into a cell, a thumbnail of the picture may be displayed in the corresponding update record. If an update includes inserting a hyperlink as an attachment into a cell, the name of the hyperlink defined by the user (e.g., "xx web page") may be displayed in the corresponding update record.

[0031] The update record interface 10 currently displays a copy identifier 11, and when a user triggers this copy identifier 11, the table document "xx sales data", which is the entity update content of cell B2, can be obtained, but is not limited to obtaining only the text title "xx sales data" of the table document, which is the display format of cell B2.

[0032] In some embodiments, the update record interface may further display multiple update records in a page-turning format, although the present disclosure is not limited in this respect.

[0033] It should be noted that the first cell may be any cell in the online document or a pre-set cell, and the present disclosure is not limited thereto.

[0034] In addition to inputting text content into cells, online spreadsheets can provide a rich element insertion function, for example, to insert attachments, pictures, hyperlinks, or function modules into cells. After the inventors' research, they found that the related online documents cannot provide restoration of updated records of rich elements, and therefore, after the rich element data of a cell is changed, such data will be lost.

[0035] In contrast, according to one or more embodiments of the present disclosure, in response to a first preset user operation on a first cell in an online document, at least one update record of the first cell is displayed, and in response to a second preset user operation on the first update record, entity update content corresponding to the first update record and including rich elements is obtained, thereby not only obtaining text content corresponding to the update record but also facilitating the user to restore or copy the entity update content including rich elements.

[0036] In some embodiments, step S140 includes obtaining stored data corresponding to the rich element, and generating clip content that supports cell pasting based on the stored data corresponding to the rich element and the associated text or hyperlink of the rich element.

[0037] In some implementations, the associated text of a rich element includes the name or title of the rich element.

[0038] In some embodiments, when the rich element is a document, clip content supporting cell pasting is generated based on storage data corresponding to the rich element and the associated text of the rich element; or when the rich element is one of a picture, a hyperlink, or a function module, clip content supporting cell pasting is generated based on storage data corresponding to the rich element and the hyperlink of the rich element.

[0039] In some embodiments, for data extraction when pasting clip content, the label attribute of the cell label may store stored data corresponding to the rich element, and the cell label may be embedded with the associated text of the rich element, so that the associated text is used as the text representation of the rich element after pasting.

[0040] In some embodiments, for data extraction when pasting clip content, the stored data may be stored in the label attribute of a cell label, a label defining a hyperlink may be embedded in the cell label, and a hyperlink corresponding to the rich element may be written in the label defining the hyperlink as an attribute of an address specifying the hyperlink destination.

[0041] In some embodiments, the stored data corresponding to the rich element is data of a non-ordinary text data structure, the cell labels are standard cell labels in an HTML (HyperText Markup Language) table, and the tag attributes include HTML tag attributes.

[0042] In one specific embodiment, to facilitate data extraction during pasting, the stored data corresponding to the rich element, such as data stored in a SegmentArray array format, may be stored in an attribute (e.g., a data-sheet-value attribute) that can be pasted and extracted from a cell label (e.g., a td label), and the corresponding label or text may be embedded in the label for display during pasting. Finally, a recognizable HyperText Markup Language (HTML) string is generated and written to the clipboard in the HTML format when pasted into a table. For example, if the rich element is a document, the file name of the document may be embedded in the td tag, so that the pasted rich element can be displayed in the cell in the file name format. When a user clicks on the file name displayed in the cell, not only is the file name displayed in plain text in the copied cell, but the document content can also be obtained and queried. If the rich element is a picture, hyperlink, or function module, a label (such as an a label) that defines a hyperlink can be embedded in this cell label, and a hyperlink corresponding to the rich element can be written in the URL attribute (such as an href attribute) that specifies the hyperlink destination of this label that defines a hyperlink. In this way, after pasting, the user can directly click on the corresponding cell to view the content of this rich element through the hyperlink.

[0043] In some embodiments, the method 100 further includes displaying a content preview interface of the rich element in response to a third preset operation on a first update record of the at least one update record.

[0044] The third preset operation includes, but is not limited to, a haptic control operation, a gesture control operation, a waving eye movement operation, a touch operation, a voice control command, or an operation on an external control device. Exemplarily, in response to a user triggering the expression of the first update record or a rich element (e.g., a title) in the first update record, a content preview interface of the rich element may be displayed. Exemplarily, when the rich element is a document, the user can preview the content of the document through the third preset operation.

[0045] In some embodiments, the method 100 further includes, after obtaining the entity update content corresponding to the first update record, updating the content of a target cell in the online document with the entity update content in response to a fourth preset user operation. Here, the fourth preset operation is used to update the content of the target cell with the obtained entity update content, and the fourth preset operation includes, but is not limited to, a haptic control operation, a gesture control operation, a sway operation, a touch operation, a voice control command, or an operation on an external control device. The target cell may include the first cell or a cell other than the first cell, and the present disclosure is not limited thereto. In this embodiment, updating the content of the target cell in the online document with the entity update content in response to the fourth preset user operation can realize pasting or restoring of a rich element in a cell.

[0046] Therefore, referring to FIG. 3, an apparatus 600 for processing table data provided by one embodiment of the present disclosure includes: a display unit 601 adapted to display at least one update record of a first cell in an online document in response to a first preset user operation on the first cell; an acquiring unit 602, used to acquire entity update content corresponding to a first update record of the at least one update record in response to a second preset user operation on the first update record; The entity update content of the first update record includes at least one of a picture, a document, a hyperlink, and a function module.

[0047] In some embodiments, the obtaining unit is further used to generate clip content that supports cell pasting based on the stored data corresponding to the rich element and the associated text or hyperlink of the rich element.

[0048] In some embodiments, the acquisition unit: a first acquisition subunit, when the rich element is a document, used to generate clip content supporting cell pasting based on stored data corresponding to the rich element and related text of the rich element; or and a second acquisition subunit used to generate clip content that supports cell pasting based on stored data corresponding to the rich element and the hyperlink of the rich element when the rich element is one of a picture, a hyperlink, or a function module.

[0049] In some embodiments, the associated text is used as a pasted textual representation of the rich element, and the hyperlink is used to refer to the textual content of the rich element.

[0050] In some embodiments, the associated text includes the name of the rich element.

[0051] In some embodiments, the display unit is adapted to display a thumbnail image of a picture when the update content in the at least one update record includes the picture.

[0052] In some embodiments, the device for processing the table data comprises: The system further includes a preview unit, which is used to display a content preview interface of the rich element in response to a third preset operation on a first update record of the at least one update record.

[0053] In some embodiments, the device for processing the table data comprises: and a cell update unit, which is used to update the content of a target cell in the online document to the entity update content in response to a fourth preset operation of the user after obtaining the entity update content corresponding to the first update record.

[0054] In some embodiments, the first acquisition subunit is further used to store the stored data in a label attribute of a cell label for data extraction when pasting clip content, and to embed the associated text in the cell label so that the associated text is used as a text representation of the rich element after pasting.

[0055] In some embodiments, the second acquisition sub-unit is further used to store the stored data in a label attribute of a cell label for data extraction when pasting clip content, embed a label defining a hyperlink in the cell label, and write a hyperlink corresponding to the rich element in an address attribute specifying a hyperlink destination of the label defining the hyperlink. The apparatus embodiments basically correspond to the method embodiments, so please refer to the description of the method embodiments for relevant parts. The apparatus embodiments described above are for illustrative purposes only, and the modules described as separate modules therein may or may not be separate. Depending on actual needs, some or all of the modules may be selected to achieve the objectives of the solutions of the embodiments. Those skilled in the art can understand and implement them without any creative effort.

[0056] Thus, according to one or more embodiments of the present disclosure, there is provided an electronic device, the electronic device comprising: at least one memory and at least one processor; An electronic device is provided, wherein the memory is used to store program code, and the processor is used to call the program code stored in the memory to cause the electronic device to perform a method for processing table data provided by one or more embodiments of the present disclosure.

[0057] Thus, in accordance with one or more embodiments of the present disclosure, there is provided a non-transitory computer storage medium having stored thereon program code that, when executed by a computing device, causes the computing device to perform a method for processing table data provided by one or more embodiments of the present disclosure.

[0058] Referring now to FIG. 4, FIG. 4 is a schematic diagram illustrating the configuration of an electronic device 800 (e.g., a terminal device or a server) suitable for implementing an embodiment of the present disclosure. The terminal device in the embodiment of the present disclosure may include, but is not limited to, mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet personal computers), PMPs (portable multimedia players), and in-vehicle terminals (e.g., car navigation terminals), as well as fixed terminals such as digital TVs and desktop computers. The electronic device illustrated in FIG. 4 is merely an example and should not limit the functionality or scope of use of the embodiment of the present disclosure.

[0059] 4, electronic device 800 may include a processing unit (e.g., a central processing unit, a graphics processor, etc.) 801 that can perform various appropriate operations and processes in accordance with programs stored in read-only memory (ROM) 802 or loaded from storage device 808 into random access memory (RAM) 803. RAM 803 also stores various programs and data necessary for the operation of electronic device 800. Processing unit 801, ROM 802, and RAM 803 are connected to one another via bus 804. Input / output (I / O) interface 805 is also connected to bus 804.

[0060] Typically, I / O interface 805 may communicatively couple input devices 806 including, for example, a touchscreen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; output devices 807 including, for example, a liquid crystal display (LCD), speaker, vibrator, etc.; storage devices 808 including, for example, a magnetic tape, hard disk, etc.; and communication devices 809. Communication devices 809 may allow electronic device 800 to communicate wirelessly or via wires with other devices to exchange data. While FIG. 4 illustrates electronic device 800 having various devices, it should be understood that electronic device 800 need not embody or include all of the devices shown. More or fewer devices may alternatively be implemented or included.

[0061] In particular, according to embodiments of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product, the computer program product being stored in a computer-readable medium and including program code for performing the methods illustrated in the flowcharts. In such embodiments, the computer program may be downloaded and installed from a network via the communication device 809, installed from the storage device 808, or installed from the ROM 802. When executed by the processing device 801, the computer program performs the aforementioned functions provided by the methods of the embodiments of the present disclosure.

[0062] It should be noted that the computer-readable medium referred to in this disclosure may be a computer-readable signal medium, a computer-readable storage medium, or any combination of the above. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the above. More specific examples of the computer-readable storage medium may include, but are not limited to, an electrical connection having one or more wires, a portable computer disk, a hard disk, 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 memory device, a magnetic memory device, or any suitable combination of the above. In this disclosure, the computer-readable storage medium may be any tangible medium that contains or stores a program that can be used by or in combination with an instruction execution system, apparatus, or device. Meanwhile, in this disclosure, the computer-readable signal medium may include a data signal, propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals may take various forms, including, but not limited to, electromagnetic signals, optical signals, or any suitable combination of the above. A computer-readable signal medium may also be any computer-readable medium, other than a computer-readable storage medium, that can transmit, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. Program code contained in a computer-readable medium may be transmitted over any suitable medium, including, but not limited to, wire, optical cable, RF (radio frequency), etc., or any suitable combination of the above.

[0063] In some embodiments, clients and servers may communicate using any network protocol now known or hereafter developed, such as HyperText Transfer Protocol (HTTP), and may be connected to one another via any form or medium of digital data communication (e.g., a communications network). Examples of communications networks include local area networks ("LANs"), wide area networks ("WANs"), extranets (e.g., the Internet), end-to-end networks (e.g., ad-hoc end-to-end networks), and other networks now known or hereafter developed.

[0064] The computer-readable medium may be included in the electronic device, or may exist separately from the electronic device.

[0065] The computer-readable medium described above includes one or more programs that, when executed by the electronic device, cause the electronic device to perform the method of the present disclosure described above.

[0066] Computer program code for carrying out the operations of the present disclosure may be written in one or more programming languages, or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, C++, etc., as well as conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may run entirely on the user computer, partially on the user computer, as a separate software package, partially on the user computer and partially on a remote computer, or entirely on a remote computer or server. When a remote computer is involved, it may be connected to the user computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., connected via the Internet using an Internet Service Provider).

[0067] The flowcharts and block diagrams in the figures illustrate the architecture, functions, and operations that can be implemented according to systems, methods, and computer program products in various embodiments of the present disclosure. In this regard, each block in the flowcharts or block diagrams may represent a module, program segment, or portion of code, including one or more executable instructions for implementing a given logical function. It should also be noted that in some alternate implementations, the functions noted in the blocks may occur in a different order than that noted in the figures. For example, two blocks shown in succession may actually be executed substantially in parallel or may be executed in the reverse order depending on the functionality involved. It should also be noted that each block in the block diagrams and / or flowcharts, and combinations of blocks in the block diagrams and / or flowcharts, may be implemented in a dedicated hardware-based system that performs a given function or operation, or in a combination of dedicated hardware and computer instructions.

[0068] The units described in the embodiments of the present disclosure may be implemented in a software manner or in a hardware manner, and the names of the units may not necessarily be used to limit the units themselves.

[0069] The functions described herein above may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), complex programmable logic devices (CPLDs), etc.

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

[0071] According to one or more embodiments of the present disclosure, a method for processing table data is provided, comprising: in response to a first preset user operation on a first cell in an online document, displaying at least one update record of the first cell; and in response to a second preset user operation on a first update record of the at least one update record, obtaining entity update content corresponding to the first update record, wherein the entity update content of the first update record includes rich elements including at least one of a picture, a document, a hyperlink, and a function module.

[0072] According to one or more embodiments of the present disclosure, the step of obtaining entity update content corresponding to the first update record includes a step of generating clip content supporting cell pasting based on stored data corresponding to the rich element and associated text or hyperlinks of the rich element.

[0073] According to one or more embodiments of the present disclosure, the step of generating clip content supporting cell pasting based on storage data corresponding to the rich element and associated text or hyperlink of the rich element includes, if the rich element is a document, generating clip content supporting cell pasting based on storage data corresponding to the rich element and associated text of the rich element, or, if the rich element is one of a picture, a hyperlink, or a functional module, generating clip content supporting cell pasting based on storage data corresponding to the rich element and hyperlink of the rich element.

[0074] According to one or more embodiments of the present disclosure, the related text is used as a pasted text representation of the rich element, and the hyperlink is used to refer to the text content of the rich element.

[0075] According to one or more embodiments of the present disclosure, the associated text includes a name of the rich element.

[0076] According to one or more embodiments of the present disclosure, the step of displaying at least one update record of the first cell includes a step of displaying a thumbnail image of a picture if the update content in the at least one update record includes a picture.

[0077] According to one or more embodiments of the present disclosure, the method further includes a step of displaying a content preview interface of the rich element in response to a third preset operation on a first update record of the at least one update record.

[0078] According to one or more embodiments of the present disclosure, the method further includes, after obtaining entity update content corresponding to the first update record, updating the content of a target cell in the online document to the entity update content in response to a fourth preset operation of the user.

[0079] According to one or more embodiments of the present disclosure, the step of generating clip content supporting cell pasting based on stored data corresponding to the rich element and the associated text or hyperlink of the rich element includes the steps of: storing the stored data in a label attribute of a cell label for data extraction when pasting clip content; and embedding the associated text in the cell label so that the associated text is used as a text representation of the rich element after pasting.

[0080] According to one or more embodiments of the present disclosure, the step of generating clip content supporting cell pasting based on stored data corresponding to the rich element and associated text or hyperlink of the rich element includes the steps of: storing the stored data in a label attribute of a cell label for data extraction when pasting the clip content; embedding a label defining a hyperlink in the cell label; and writing a hyperlink corresponding to the rich element in an address attribute specifying a hyperlink destination of the label defining the hyperlink. According to one or more embodiments of the present disclosure, an apparatus for processing table data is provided, including: a display unit configured to display at least one update record of a first cell in an online document in response to a first preset user operation on the first cell; and an acquisition unit configured to acquire entity update content corresponding to the first update record in response to a second preset user operation on a first update record of the at least one update record, wherein the entity update content of the first update record includes a rich element including at least one of a picture, a document, a hyperlink, and a function module. According to one or more embodiments of the present disclosure, a non-transitory computer storage medium is provided having stored thereon program code that, when executed by a computing device, causes the computing device to perform a method for processing table data provided by one or more embodiments of the present disclosure.

[0081] The above description merely describes preferred embodiments and applied technical principles of the present disclosure. Those skilled in the art should understand that the scope of the present disclosure is not limited to the technical solution consisting of a specific combination of the above technical features, but also encompasses other technical solutions consisting of any combination of the above technical features or their equivalent features without departing from the idea of ​​the above disclosure. For example, a technical solution formed by mutually replacing the above features with technical features having similar functions disclosed in the present disclosure (but not limited to).

[0082] Also, although operations are depicted in a particular order, this should not be understood to require that these operations be performed in the particular order shown, or in any sequential order. In certain environments, multitasking and parallel processing may be advantageous. Similarly, although the above discussion includes several specific implementation details, these should not be construed as limiting the scope of the present disclosure. Some features described in the context of separate embodiments may also be implemented in combination in a single embodiment. Conversely, various features described in the context of a single embodiment may also be implemented in multiple embodiments separately or in any suitable subcombination.

[0083] Although the present subject matter has been described using language specific to structural features and / or method logic operations, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or operations described above. Rather, the specific features and operations described above are merely example forms of implementing the claims.

Claims

1. 1. A method for processing table data, the method comprising: displaying at least one update record for a first cell in an online document in response to a first preset user operation on the first cell; In response to a second preset user operation on a first update record of the at least one update record, obtaining entity update content corresponding to the first update record; the entity update content of the first update record includes a rich element including at least one of a picture, a document, a hyperlink, and a function module; method.

2. The step of obtaining entity update content corresponding to the first update record includes: generating clip content supporting cell pasting based on stored data corresponding to the rich element and related text or hyperlinks of the rich element; The method of claim 1.

3. The step of generating clip content supporting cell pasting based on stored data corresponding to the rich element and related text or hyperlinks of the rich element includes: If the rich element is a document, generating clip content that supports cell pasting based on stored data corresponding to the rich element and associated text of the rich element; or When the rich element is any one of a picture, a hyperlink, and a function module, generating clip content that supports cell pasting based on stored data corresponding to the rich element and the hyperlink of the rich element; The method of claim 2.

4. The related text is used as a pasted text representation of the rich element, and the hyperlink is used to refer to the text content of the rich element. The method of claim 2.

5. the associated text includes the name of the rich element; The method of claim 2.

6. The step of displaying at least one update record of the first cell includes: If the update content in the at least one update record includes a picture, displaying a thumbnail image of the picture. The method of claim 1.

7. and displaying a content preview interface of the rich element in response to a third preset operation on a first update record of the at least one update record. The method of claim 1.

8. and further comprising: after obtaining the entity update content corresponding to the first update record, updating a content of a target cell in the online document to the entity update content corresponding to the first update record in response to a fourth preset operation of a user. The method of claim 1.

9. The step of generating clip content supporting cell pasting based on stored data corresponding to the rich element and related text or hyperlinks of the rich element includes: storing the stored data in a label attribute of a cell label for data extraction when pasting clip content; and embedding the associated text in the cell label so that the associated text is used as a pasted text representation of the rich element. The method of claim 2.

10. The step of generating clip content supporting cell pasting based on stored data corresponding to the rich element and related text or hyperlinks of the rich element includes: storing the stored data in a label attribute of a cell label for data extraction when pasting clip content; Embedding a label defining a hyperlink in the cell label, and writing a hyperlink corresponding to the rich element in an address attribute specifying a hyperlink destination of the label defining the hyperlink, The method of claim 2.

11. An apparatus for processing table data, the apparatus comprising: a display unit adapted to display at least one update record of a first cell in an online document in response to a first preset user operation on the first cell; an acquisition unit used to acquire entity update content corresponding to a first update record of the at least one update record in response to a second preset user operation on the first update record; the entity update content of the first update record includes a rich element including at least one of a picture, a document, a hyperlink, and a function module; Device.

12. An electronic device, the electronic device comprising: at least one memory and at least one processor; The memory is adapted to store program code, and the processor is adapted to call the program code stored in the memory to cause the electronic device to perform the method according to any one of claims 1 to 10. electronic equipment.

13. a program code stored thereon which, when executed by a computing device, causes said computing device to carry out the method of any one of claims 1 to 10; Non-transitory computer storage media.

Images