WO2024169747A1 - Excel data processing method and apparatus, electronic device, and storage medium - Google Patents

Abstract

Provided are an excel data processing method and apparatus, an electronic device, and a storage medium. The method comprises: in response to a first preset operation of a user for a first cell in an online document, displaying at least one updated record of the first cell; and in response to a second preset operation of the user for a first updated record, obtaining entity updated content comprising a rich element from the first updated record. Therefore, a user may conveniently restore or copy the entity updated content comprising the rich element, and is not limited to only obtaining text content corresponding to the updated record.

Description

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

CROSS-REFERENCE TO RELATED APPLICATIONS

This application claims priority to the Chinese invention patent application with application number 202310159186.4, entitled “Tabular data processing method, device, electronic device and storage medium” and filing date February 15, 2023, and the entire application is incorporated herein by reference.

Technical Field

The present disclosure relates to the field of computer technology, and in particular to a table data processing method, device, electronic device and storage medium.

Background Art

Document collaboration technology enables multiple users to process the same document in real time without the need for users to transfer the document to each other before processing, thereby improving document processing efficiency. In the process of electronic spreadsheet collaboration, when the content of a cell is updated multiple times, users may want to restore or obtain (for example, copy) a certain version of the updated content in some cases.

Summary of the invention

This summary is provided to introduce concepts in a brief form that will be described in detail in the detailed description below. This summary is not intended to identify key features or essential features of the claimed technical solution, nor is it intended to limit the scope of the claimed technical solution.

In a first aspect, according to one or more embodiments of the present disclosure, a table data processing method is provided, comprising:

In response to a first preset operation of a user on a first cell in the online document, displaying at least one update record of the first cell;

In response to a second preset operation of the user on a first update record in the at least one update record, entity update content corresponding to the first update record is obtained; wherein the entity update content of the first update record includes rich elements, and the rich elements include at least one of the following: pictures, documents, hyperlinks, and functional modules.

In a second aspect, according to one or more embodiments of the present disclosure, there is provided a table data processing apparatus, comprising:

A display unit, configured to display at least one update record of a first cell in the online document in response to a first preset operation of the user on the first cell;

An acquisition unit is used to obtain entity update content corresponding to a first update record in the at least one update record in response to a second preset operation of the user on the first update record; wherein the entity update content of the first update record includes rich elements, and the rich elements include at least one of the following: pictures, documents, hyperlinks, and functional modules.

In a third aspect, according to one or more embodiments of the present disclosure, an electronic device is provided, comprising: at least one memory and at least one processor; wherein the memory is used to store program code, and the processor is used to call the program code stored in the memory so that the electronic device executes the table data processing method provided according to one or more embodiments of the present disclosure.

In a fourth aspect, according to one or more embodiments of the present disclosure, a non-transitory computer storage medium is provided, wherein the non-transitory computer storage medium stores a program code, and when the program code is executed by a computer device, the computer device executes the table data processing method provided according to one or more embodiments of the present disclosure.

According to one or more embodiments of the present disclosure, by responding to a first preset operation of a user on a first cell in an online document, displaying at least one update record of the first cell, and responding to a second preset operation of the user on the first update record, obtaining entity update content containing rich elements of the first update record, thereby facilitating the user to accurately and comprehensively restore or copy the entity update content containing the rich elements, without being limited to obtaining only the text content corresponding to the update record.

BRIEF DESCRIPTION OF THE DRAWINGS

The above and other features, advantages and aspects of the embodiments of the present disclosure will become more apparent with reference to the following detailed description in conjunction with the accompanying drawings. Throughout the accompanying drawings, the same or similar reference numerals represent the same or similar elements. It should be understood that the drawings are schematic and the originals and elements are not necessarily drawn to scale.

FIG1 is a flow chart of a table data processing method according to an embodiment of the present disclosure;

FIG2 is an update record interface of a cell provided according to an embodiment of the present disclosure;

FIG3 is a schematic diagram of the structure of a table data processing device provided according to an embodiment of the present disclosure;

FIG. 4 is a schematic diagram of the structure of an electronic device provided according to an embodiment of the present disclosure.

DETAILED DESCRIPTION

Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be construed as being limited to the embodiments described herein, which are instead provided for a more thorough and complete understanding of the present disclosure. It should be understood that The drawings and embodiments of the present disclosure are only for illustrative purposes and are not intended to limit the protection scope of the present disclosure.

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. In addition, the embodiments may include additional steps and/or omit the steps shown. The scope of the present disclosure is not limited in this respect.

As used herein, the term "including" and its variations are open inclusions, i.e., "including but not limited to". The term "based on" means "based at least in part on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one other embodiment"; the term "some embodiments" means "at least some embodiments". The term "responsive to" and related terms refer to a signal or event being affected to a certain extent by another signal or event, but not necessarily completely or directly. If event x occurs "responsive to" event y, x may be directly or indirectly responsive to y. For example, the occurrence of y may ultimately lead to the occurrence of x, but there may be other intermediate events and/or conditions. In other cases, y may not necessarily lead to the occurrence of x, and x may occur even if y has not yet occurred. In addition, the term "responsive to" may also mean "at least partially responsive to".

The term "determine" broadly covers a variety of actions, which may include obtaining, calculating, computing, processing, deriving, investigating, searching (e.g., searching in a table, database, or other data structure), ascertaining, and similar actions, and may also include receiving (e.g., receiving information), accessing (e.g., accessing data in a memory) and similar actions, as well as parsing, selecting, choosing, establishing, and similar actions, etc. The relevant definitions of other terms will be given in the following description. The relevant definitions of other terms will be given in the following description.

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

It is understandable that before using the technical solutions disclosed in the embodiments of the present disclosure, the type, scope of use, and usage scenarios of the personal information involved in the present disclosure should be informed to the user and the user's authorization should be obtained in an appropriate manner in accordance with relevant laws and regulations. For example, in response to receiving an active request from the user, a prompt message is sent to the user to clearly prompt the user that the operation requested to be performed will require obtaining and using the user's personal information, so that the user can autonomously choose whether to provide personal information to the electronic device, application, server, storage medium, or other software or hardware that performs the operation of the technical solution of the present disclosure according to the prompt message.

As an optional but non-limiting implementation, in response to receiving an active request from the user, the prompt information is sent to the user in a manner such as a pop-up window, in which the prompt information can be presented in text form. In addition, the pop-up window can also carry a selection control for the user to choose "agree" or "disagree" to provide personal information to the electronic device.

It is understandable that the above notification and the process of obtaining user authorization are merely illustrative and do not constitute a limitation on the implementation of the present disclosure. Other methods that meet relevant laws and regulations may also be applied to the implementation of the present disclosure.

It should be noted that the concepts such as "first" and "second" mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".

For the purposes of this disclosure, the phrase "A and/or B" means (A), (B), or (A and B).

The names of the messages or information exchanged between multiple devices in the embodiments of the present disclosure are only used for illustrative purposes and are not used to limit the scope of these messages or information.

Referring to FIG. 1 , FIG. 1 shows a flowchart of a table data processing method 100 provided in an embodiment of the present disclosure. The method 100 includes steps S120 to S140 .

Step S120: in response to a first preset operation of a user on a first cell in the online document, displaying at least one update record of the first cell;

Step S140: In response to a second preset operation of the user on a first update record among 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 rich elements, and the rich elements include at least one of the following: pictures, documents, hyperlinks, and functional modules. In some embodiments, the functional module is used to execute a preset function, such as a schedule reminder, a user reminder, a document reminder, and other functional components that provide functions in a table.

In some embodiments, an online document may be a document that can be edited online by users, collaborated by multiple users, and saved in real time in the cloud. It may be displayed through a Hypertext Markup Language (HTML) page, and rely on communication between the client and the server to synchronize user edited content.

In some embodiments, the execution subject of method 100 may be a client, such as an instant messaging (IM) client. The client integrates the function of an online document. Based on the user's click operation, the client calls the browser kernel through the interface provided by the browser to load the page of the online document. Based on the loaded page, the user can create and edit the online document. Of course, the user can share the online document through the client; in other embodiments, the client is integrated with a browser kernel, and the page of the online document is displayed in the client by calling the browser kernel; in other embodiments, the client is an online document client, and the page loading and display of the online document is realized by running the online document client; in other embodiments, there is a small program corresponding to the online document function, and the client downloads and runs The source code of the online document applet implements the loading and display of online document pages.

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 somatosensory control operation, a gesture control operation, an eye movement operation, a touch operation, a voice control instruction, or an operation of an external control device. Exemplarily, after the user selects the first cell, the user can right-click the mouse to call up a preset menu, which can provide a function option of viewing the cell update record for the user to further select. After the user clicks the function option, the update record interface of the cell pops up.

The second preset operation for the first update record is used to obtain the entity update content corresponding to the first update record. In some embodiments, the second preset operation includes but is not limited to a somatosensory control operation, a gesture control operation, an eye movement operation, a touch operation, a voice control instruction, or an operation of an external control device. Exemplarily, the entity update content of the first update record can be obtained in response to the user triggering a preset virtual button corresponding to the first update record.

FIG2 shows an update record interface of a cell provided according to an embodiment of the present disclosure. The update record interface 10 displays the update record of cell B2, which currently displays a total of 4 update records of user A, user B, user C and user D for cell B2 in the form of a list. The display content of each update record includes the user name, update time and specific update content. Referring to FIG2, when the update content includes inserting a document as an attachment in a cell, the name of the document as an attachment (for example, "xx sales data") can be displayed in the corresponding update record; when the update content includes inserting a picture in a cell, a thumbnail of the picture can be displayed in the corresponding update record; when the update content includes inserting a hyperlink in a cell, the name of the hyperlink defined by the user (for example, "xx web page") can be displayed in the corresponding update record.

The update record interface 10 currently displays a copy mark 11. When the user triggers the copy mark 11, the table document "xx sales data" as the entity update content of cell B2 can be obtained, rather than being limited to obtaining only the text title "xx sales data" of the table document as the display form of cell B2.

In some embodiments, multiple update records may be displayed in the update record interface in the form of page turning, but the present disclosure is not limited thereto.

It should be noted that the first cell may be any cell or a preset cell in the online document, and the present disclosure does not limit this.

In addition to filling text content in cells, online electronic spreadsheets can provide rich element insertion functions, such as inserting attachments, pictures, hyperlinks or functional modules in cells. The inventors found through research that relevant online documents cannot provide rich element update record recovery, resulting in the loss of such data after the rich element data of a cell is changed.

In this regard, according to one or more embodiments of the present disclosure, in response to a user's request for a first cell in an online document, A first preset operation is performed to display at least one update record of the first cell, and in response to a second preset operation of the user for the first update record, the entity update content containing rich elements of the first update record is obtained, thereby facilitating the user to restore or copy the entity update content containing rich elements, without being limited to obtaining only the text content corresponding to the update record.

In some embodiments, step S140 includes: acquiring storage data corresponding to the rich element; and generating clipping content supporting cell pasting based on the storage data corresponding to the rich element and the associated text or hyperlink of the rich element.

In some embodiments, the associated text of a rich element includes a name or title of the rich element.

In some embodiments, if the rich element is a document, clipping content supporting cell pasting is generated based on the storage data corresponding to the rich element and the associated text of the rich element; or, if the rich element is any one of a picture, a hyperlink, and a functional module, clipping content supporting cell pasting is generated based on the storage data corresponding to the rich element and the hyperlink of the rich element.

In some embodiments, the stored data corresponding to the rich element can be stored in the label attribute of the cell label for data extraction when pasting the clipped content, and the associated text of the rich element can be embedded in the cell label so that the associated text is used as the text representation of the rich element after pasting.

In some embodiments, the stored data can be stored in the tag attributes of the cell tag for data extraction when pasting the clipped content; the tag defining the hyperlink can be embedded in the cell tag, and the hyperlink corresponding to the rich element can be written into the attribute of the address of the specified hyperlink target of the tag defining the hyperlink.

In some embodiments, the storage data corresponding to the rich element is data of a non-ordinary text data structure; the cell tag is a standard cell tag in an HTML (Hypertext Markup Language) table; and the tag attributes include HTML tag attributes.

In a specific embodiment, the stored data corresponding to the rich element, such as data stored in the form of a SegmentArray array, can be stored in a property of a cell tag (such as a td tag) that can be pasted and extracted (such as a data-sheet-value property) to facilitate data extraction when pasting, and a corresponding tag or text can be embedded in the tag for display in a form for pasting, and finally a Hypertext Markup Language (HTML) string that can be recognized when pasted in a table is generated and written to the clipboard in the form of Hypertext Markup Language. Exemplarily, if the rich element is a document, the file name of the document can be embedded in the td tag, so that the pasted rich element can be displayed in the cell in the form of a file name and when the user clicks the file name displayed in the cell, the content of the document can be obtained and viewed, rather than just displaying the file name in the form of plain text in the copied cell; if the rich element is a picture, a hyperlink or a functional module, a tag that defines a hyperlink (such as an a tag) can be embedded in the cell tag, and the hyperlink corresponding to the rich element can be written in the attribute of the tag that defines the hyperlink that specifies the URL of the hyperlink target (such as the href attribute), so that After pasting, users can directly click on the corresponding cell to view the content of the rich element through the hyperlink.

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

The third preset operation includes, but is not limited to, a somatosensory control operation, a gesture control operation, an eye movement operation, a touch operation, a voice control instruction, or an operation of an external control device. For example, in response to a user triggering the first update record or a representation of a rich element in the first update record (e.g., a title), a content preview interface of the rich element may be displayed. For example, if the rich element is a document, the user may preview the content of the document through the third preset operation.

In some embodiments, method 100 further includes: after obtaining the entity update content corresponding to the first update record, in response to a fourth preset operation of the user, updating the content of the target cell in the online document to the entity update content. The fourth preset operation is used to update the content of the target cell to the acquired entity update content, and the fourth preset operation includes but is not limited to a somatosensory control operation, a gesture control operation, an eye movement operation, a touch operation, a voice control instruction, or an operation of an external control device. The target cell may include the first cell or other cells other than the first cell, and the present disclosure does not limit this. In this embodiment, by updating the content of the target cell in the online document to the entity update content in response to the fourth preset operation of the user, the rich element can be pasted or restored within the cell.

Accordingly, referring to FIG3 , according to an embodiment of the present disclosure, a table data processing device 600 is provided, comprising:

A display unit 601, configured to display at least one update record of a first cell in an online document in response to a first preset operation of the user on the first cell;

The acquisition unit 602 is used to obtain the entity update content corresponding to the first update record in the at least one update record in response to the user's second preset operation on the first update record; wherein the entity update content of the first update record includes rich elements, and the rich elements include at least one of the following: pictures, documents, hyperlinks, and functional modules.

In some embodiments, the acquisition unit is further used to generate clipping content supporting cell pasting based on the stored data corresponding to the rich element and the associated text or hyperlink of the rich element.

In some embodiments, the acquisition unit includes:

A first acquisition subunit is used to generate clipping content supporting cell pasting based on the storage data corresponding to the rich element and the associated text of the rich element if the rich element is a document; or

The second acquisition subunit is used to generate clipping content supporting cell pasting based on the storage data corresponding to the rich element and the hyperlink of the rich element if the rich element is any one of a picture, a hyperlink, and a functional module.

In some embodiments, the associated text is used as a text representation of the rich element after pasting; the hyperlink Used to view the text content of the rich element.

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

In some embodiments, the display unit is configured to display a thumbnail of a picture if the update content in the at least one update record includes a picture.

In some embodiments, the table data processing apparatus further comprises:

The preview unit is used to display a content preview interface of the rich element in response to a third preset operation on a first update record in the at least one update record.

In some embodiments, the table data processing apparatus further comprises:

The cell updating unit is configured to update the content of a target cell in the online document to the entity updated content in response to a fourth preset operation of the user after acquiring the entity updated content corresponding to the first update record.

In some embodiments, the first acquisition subunit is further used to: store the stored data into the label attribute of the cell label for data extraction when pasting the clipped content; embed the associated text into the cell label so that the associated text is used as the text representation after the rich element is pasted.

In some embodiments, the second acquisition subunit is further used to: store the stored data in the label attribute of the cell label for data extraction when pasting the clipped content; embed the label defining the hyperlink into the cell label, and write the hyperlink corresponding to the rich element in the attribute of the address of the specified hyperlink target of the label defining the hyperlink. For the embodiments of the device, since they basically correspond to the method embodiments, the relevant parts can be referred to the partial description of the method embodiments. The device embodiments described above are merely schematic, in which the modules described as separation modules may or may not be separate. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Those of ordinary skill in the art can understand and implement it without creative work.

Accordingly, according to one or more embodiments of the present disclosure, there is provided an electronic device, including:

at least one memory and at least one processor;

The memory is used to store program codes, and the processor is used to call the program codes stored in the memory to enable the electronic device to execute the table data processing method provided according to one or more embodiments of the present disclosure.

Accordingly, according to one or more embodiments of the present disclosure, a non-transitory computer storage medium is provided, which stores program code, and the program code can be executed by a computer device to enable the computer device to perform the table data processing method provided according to one or more embodiments of the present disclosure.

Referring to FIG. 4 below, an electronic device (eg, a terminal device) suitable for implementing an embodiment of the present disclosure is shown. The terminal device in the embodiment of the present disclosure may include but is not limited to mobile terminals such as mobile phones, laptop computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), vehicle-mounted terminals (such as vehicle-mounted navigation terminals), etc., and fixed terminals such as digital TVs, desktop computers, etc. The electronic device shown in FIG4 is only an example and should not bring any limitation to the functions and scope of use of the embodiment of the present disclosure.

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

Typically, the following devices may be connected to the I/O interface 805: input devices 806 including, for example, a touch screen, a touchpad, a keyboard, a mouse, a camera, a microphone, an accelerometer, a gyroscope, etc.; output devices 807 including, for example, a liquid crystal display (LCD), a speaker, a vibrator, etc.; storage devices 808 including, for example, a magnetic tape, a hard disk, etc.; and communication devices 809. The communication device 809 may allow the electronic device 800 to communicate wirelessly or wired with other devices to exchange data. Although FIG. 4 shows an electronic device 800 with various devices, it should be understood that it is not required to implement or have all the devices shown. More or fewer devices may be implemented or have alternatively.

In particular, according to an embodiment of the present disclosure, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program contains program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network through the communication device 809, or installed from the storage device 808, or installed from the ROM 802. When the computer program is executed by the processing device 801, the above-mentioned functions defined in the method of the embodiment of the present disclosure are executed.

It should be noted that the above-mentioned computer-readable medium of the present disclosure may be a computer-readable signal medium or a computer-readable storage medium or any combination of the above two. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination of the above. More specific examples of computer-readable storage media may include, but are not limited to: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In the present disclosure, In the disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that may be used by or in combination with an instruction execution system, device, or device. In the present disclosure, a computer-readable signal medium may include a data signal propagated in a baseband or as part of a carrier wave, which carries a computer-readable program code. Such propagated data signals may take a variety of 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, which may send, propagate, or transmit a program for use by or in combination with an instruction execution system, device, or device. The program code contained on the computer-readable medium may be transmitted using any suitable medium, including but not limited to: wires, optical cables, RF (radio frequency), etc., or any suitable combination of the above.

In some embodiments, the client and server may communicate using any currently known or future developed network protocol such as HTTP (HyperText Transfer Protocol), and may be interconnected with any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), an internet (e.g., the Internet), and a peer-to-peer network (e.g., an ad hoc peer-to-peer network), as well as any currently known or future developed network.

The computer-readable medium may be included in the electronic device, or may exist independently without being installed in the electronic device.

The computer-readable medium carries one or more programs. When the one or more programs are executed by the electronic device, the electronic device executes the method of the present disclosure.

Computer program code for performing 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++, and conventional procedural programming languages, such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer through 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., through the Internet using an Internet service provider).

The flowcharts and block diagrams in the accompanying drawings illustrate the possible architecture, functions and operations of the systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each box in the flowchart or block diagram may represent a module, a program segment, or a portion of code, which includes Contains one or more executable instructions for implementing the specified logical functions. It should also be noted that in some alternative implementations, the functions marked in the boxes may also occur in an order different from that marked in the accompanying drawings. For example, two boxes shown in succession may actually be executed substantially in parallel, and they may sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram and/or flow chart, and the combination of boxes in the block diagram and/or flow chart, may be implemented with a dedicated hardware-based system that performs the specified functions or operations, or may be implemented with a combination of dedicated hardware and computer instructions.

The units involved in the embodiments described in the present disclosure may be implemented by software or hardware, wherein the name of a unit does not, in some cases, constitute a limitation on the unit itself.

The functions described above herein 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 chip (SOCs), complex programmable logic devices (CPLDs), and the like.

In the context of the present disclosure, a machine-readable medium may be a tangible medium that may contain or store a program for use by or in conjunction with an instruction execution system, device, or equipment. 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 equipment, or any suitable combination of the foregoing. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, 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 foregoing.

According to one or more embodiments of the present disclosure, a table data processing method is provided, comprising: in response to a first preset operation of a user on a first cell in an online document, displaying at least one update record of the first cell; in response to a second preset operation of the user on a first update record among 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, and the rich elements include at least one of the following: pictures, documents, hyperlinks, and functional modules.

According to one or more embodiments of the present disclosure, obtaining the entity update content corresponding to the first update record includes: generating clipping content supporting cell pasting based on the stored data corresponding to the rich element and the associated text or hyperlink of the rich element.

According to one or more embodiments of the present disclosure, the storage data corresponding to the rich element and the rich The associated text or hyperlink of the element generates clipping content that supports cell pasting, including: if the rich element is a document, based on the storage data corresponding to the rich element and the associated text of the rich element, the clipping content that supports cell pasting is generated; or, if the rich element is any one of a picture, a hyperlink, and a functional module, based on the storage data corresponding to the rich element and the hyperlink of the rich element, the clipping content that supports cell pasting is generated.

According to one or more embodiments of the present disclosure, the associated text is used as a text representation after the rich element is pasted; and the hyperlink is used to view the text content of the rich element.

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

According to one or more embodiments of the present disclosure, the displaying of 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 of the picture.

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

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

According to one or more embodiments of the present disclosure, the generation of clipping content supporting cell pasting based on the stored data corresponding to the rich element and the associated text or hyperlink of the rich element includes: storing the stored data in the label attribute of the cell label for data extraction when pasting the clipping content; embedding the associated text into the label of the defined cell so that the associated text is used as the text representation after the rich element is pasted.

According to one or more embodiments of the present disclosure, the generation of clipping content supporting cell pasting based on the stored data corresponding to the rich element and the associated text or hyperlink of the rich element includes: storing the stored data in the tag attribute of the cell tag for data extraction when pasting the clipping content; embedding the tag defining the hyperlink into the cell tag, and writing the hyperlink corresponding to the rich element in the attribute of the address of the specified hyperlink target of the tag defining the hyperlink. According to one or more embodiments of the present disclosure, a table data processing device is provided, including: a display unit for displaying at least one update record of a first cell in an online document in response to a first preset operation of a user on the first cell; an acquisition unit for acquiring entity update content corresponding to the first update record in response to a second preset operation of a user on a first update record in the at least one update record; wherein the entity update content of the first update record includes a rich element, and the rich element includes at least one of the following: a picture, a document, a hyperlink, and a functional module. According to one or more embodiments of the present disclosure, a non-transitory computer storage medium is provided, wherein the non-transitory computer storage medium stores a program code, and when the program code is executed by a computer device, the computer device executes one or more of the operations according to the present disclosure. A table data processing method is provided in an embodiment.

The above description is only a preferred embodiment of the present disclosure and an explanation of the technical principles used. Those skilled in the art should understand that the scope of disclosure involved in the present disclosure is not limited to the technical solutions formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above disclosed concept. For example, the above features are replaced with the technical features with similar functions disclosed in the present disclosure (but not limited to) by each other.

In addition, although each operation is described in a specific order, this should not be understood as requiring these operations to be performed in the specific order shown or in a sequential order. Under certain circumstances, multitasking and parallel processing may be advantageous. Similarly, although some specific implementation details are included in the above discussion, these should not be interpreted as limiting the scope of the present disclosure. Some features described in the context of a separate embodiment can also be implemented in a single embodiment in combination. On the contrary, the various features described in the context of a single embodiment can also be implemented in multiple embodiments individually or in any suitable sub-combination mode.

Although the subject matter has been described in language specific to structural features and/or methodological logical actions, it should be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or actions described above. On the contrary, the specific features and actions described above are merely example forms of implementing the claims.

Claims (13)

A table data processing method, characterized by comprising: In response to a first preset operation of a user on a first cell in the online document, displaying at least one update record of the first cell; In response to a second preset operation of the user on a first update record in the at least one update record, entity update content corresponding to the first update record is obtained; wherein the entity update content of the first update record includes rich elements, and the rich elements include at least one of the following: pictures, documents, hyperlinks, and functional modules. The method according to claim 1, characterized in that the obtaining of the entity update content corresponding to the first update record comprises: Based on the stored data corresponding to the rich element and the associated text or hyperlink of the rich element, clipping content supporting cell pasting is generated. The method according to claim 2, characterized in that the step of generating clipping content supporting cell pasting based on the stored data corresponding to the rich element and the associated text or hyperlink of the rich element comprises: If the rich element is a document, generating clipping content supporting cell pasting based on the stored data corresponding to the rich element and the associated text of the rich element; or, If the rich element is any one of a picture, a hyperlink, and a functional module, a clipping content supporting cell pasting is generated based on the storage data corresponding to the rich element and the hyperlink of the rich element. The method according to claim 2 is characterized in that the associated text is used as a text representation after the rich element is pasted; and the hyperlink is used to view the text content of the rich element. The method according to claim 2 is characterized in that the associated text includes the name of the rich element. The method according to claim 1, characterized in that the displaying at least one update record of the first cell comprises: If the update content in the at least one update record includes a picture, a thumbnail of the picture is displayed. The method according to claim 1, characterized in that the method further comprises: In response to a third preset operation on a first update record in the at least one update record, a content preview interface of the rich element is displayed. The method according to claim 1, characterized in that the method according to claim 1, characterized in that the method further comprises: After acquiring the entity update content corresponding to the first update record, in response to a fourth preset operation of the user, the content of the target cell in the online document is updated to the entity update content corresponding to the first update record. The method according to claim 2, characterized in that the step of generating clipping content supporting cell pasting based on the stored data corresponding to the rich element and the associated text or hyperlink of the rich element comprises: Storing the stored data in the label attribute of the cell label for use in data extraction when pasting the clipped content; The associated text is embedded in the cell label, so that the associated text is used as the text representation after the rich element is pasted. The method according to claim 2, characterized in that the step of generating clipping content supporting cell pasting based on the stored data corresponding to the rich element and the associated text or hyperlink of the rich element comprises: Storing the stored data in the label attribute of the cell label for use in data extraction when pasting the clipped content; A tag defining a hyperlink is embedded in the cell tag, and a hyperlink corresponding to the rich element is written into a property of the tag defining the hyperlink that specifies the address of the hyperlink target. A table data processing device, characterized in that it comprises: A display unit, configured to display at least one update record of a first cell in the online document in response to a first preset operation of the user on the first cell; An acquisition unit is used to obtain entity update content corresponding to a first update record in the at least one update record in response to a second preset operation of the user on the first update record; wherein the entity update content of the first update record includes rich elements, and the rich elements include at least one of the following: pictures, documents, hyperlinks, and functional modules. An electronic device, comprising: at least one memory and at least one processor; The memory is used to store program codes, and the processor is used to call the program codes stored in the memory to enable the electronic device to execute the method according to any one of claims 1 to 10. A non-transitory computer storage medium, characterized in that The non-transitory computer storage medium stores a program code, and when the program code is executed by a computer device, the computer device executes the method according to any one of claims 1 to 10.