CN112989773A - Method, apparatus, device and computer readable medium for synchronizing update data - Google Patents
Method, apparatus, device and computer readable medium for synchronizing update data Download PDFInfo
- Publication number
- CN112989773A CN112989773A CN201911283801.2A CN201911283801A CN112989773A CN 112989773 A CN112989773 A CN 112989773A CN 201911283801 A CN201911283801 A CN 201911283801A CN 112989773 A CN112989773 A CN 112989773A
- Authority
- CN
- China
- Prior art keywords
- change
- determining
- cell
- document
- column
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 37
- 230000008859 change Effects 0.000 claims abstract description 109
- 230000004044 response Effects 0.000 claims abstract description 33
- 238000012544 monitoring process Methods 0.000 claims abstract description 14
- 230000001360 synchronised effect Effects 0.000 claims description 12
- 238000004590 computer program Methods 0.000 claims description 9
- 230000003247 decreasing effect Effects 0.000 claims description 3
- 230000003111 delayed effect Effects 0.000 claims description 3
- 230000008569 process Effects 0.000 abstract description 4
- 238000012545 processing Methods 0.000 description 23
- 238000010586 diagram Methods 0.000 description 12
- 239000003795 chemical substances by application Substances 0.000 description 8
- 230000000694 effects Effects 0.000 description 8
- 230000006870 function Effects 0.000 description 8
- 238000004891 communication Methods 0.000 description 6
- 230000003287 optical effect Effects 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 230000007423 decrease Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 230000002441 reversible effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Images
Abstract
Embodiments of the present disclosure disclose a method, apparatus, electronic device, and computer-readable medium for synchronizing update data. One embodiment of the method comprises: determining the original position of a table cell, wherein the data of the original position is referred by a document; monitoring the change of the form and determining whether the change changes the original position of the cell; repositioning said cell in response to determining that said change has changed the original position of said cell; synchronizing the redetermined locations of the cells to the document. The implementation mode realizes data synchronization under the condition of position change, and the whole process is simple and easy to operate and understand.
Description
Technical Field
Embodiments of the present disclosure relate to the field of computer technologies, and in particular, to a method, an apparatus, a device, and a computer-readable medium for synchronizing update data.
Background
Word processing and electronic forms are two commonly used software applications. With a word processing application we can create a text-dominated document. Through the electronic form we can create financial records, bills, budgets, and other digital-oriented documents. But in some cases we need to include numbers and spreadsheet data in word processing applications to extend their functionality. However, in the prior art, if the data of the electronic form is referred to in the word processing document, once the reference relationship is determined, the name and the position of the electronic form cannot be changed. Therefore, in such a case, if there are more operations or modifications on the electronic form, the reference relationship may be affected, and problems such as a reference relationship error or a data update error may be caused.
Disclosure of Invention
This summary is provided to introduce a selection of concepts in a simplified form that are further described below in the detailed description. This summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used to limit the scope of the claimed subject matter.
Some embodiments of the present disclosure propose a method, apparatus, device and computer readable medium for synchronizing update data to solve the technical problems mentioned in the above background.
In a first aspect, some embodiments of the present disclosure provide a method for synchronizing update data, comprising: determining the original position of a table cell, wherein the data of the original position is referred by a document; monitoring the change of the form and determining whether the change changes the original position of the cell; repositioning said cell in response to determining that said change has changed the original position of said cell; synchronizing the redetermined locations of the cells to the document.
In a second aspect, some embodiments of the present disclosure provide an apparatus for synchronizing update data, comprising: a determining module configured to determine an original location of a cell of a form, wherein data of the original location is referenced by a document; a monitoring module configured to monitor a change in the form and determine whether the change changes an original location of the cell; a redetermination module configured to redetermine a location of the cell in response to determining that the change changed an original location of the cell; and a synchronization module for synchronizing the redetermined positions of the cells to the document.
In a third aspect, some embodiments of the present disclosure provide an electronic device, comprising: one or more processors; a storage device having one or more programs stored thereon which, when executed by one or more processors, cause the one or more processors to implement a method as in the first aspect.
In a fourth aspect, some embodiments of the disclosure provide a computer readable medium having a computer program stored thereon, wherein the program when executed by a processor implements a method as in the first aspect.
One of the above-described various embodiments of the present disclosure has the following advantageous effects: when the format of the form referred by the document changes, the same reference relationship can be kept by re-determining the positions of the referred cells, so that the reference relationship is not influenced by the change of the form, correct data synchronous updating is achieved, and the method is simple and convenient to operate and easy to understand.
Drawings
The above and other features, advantages and aspects of various embodiments of the present disclosure will become more apparent by referring to the following detailed description when taken in conjunction with the accompanying drawings. Throughout the drawings, the same or similar reference numbers refer to the same or similar elements. It should be understood that the drawings are schematic and that elements and features are not necessarily drawn to scale.
FIG. 1 is a schematic illustration of one application scenario of a method for synchronizing update data, in accordance with some embodiments of the present disclosure;
FIG. 2 is a flow diagram of some embodiments of a method for synchronizing update data according to the present disclosure;
FIG. 3 is a flow diagram of further embodiments of a method for synchronizing update data according to the present disclosure;
FIG. 4 is a schematic block diagram of some embodiments of an apparatus for synchronizing update data according to the present disclosure;
FIG. 5 is a schematic structural diagram of an electronic device suitable for use in implementing some embodiments of the present disclosure.
Detailed Description
Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure are shown in the drawings, it is to be understood that the disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the disclosure are for illustration purposes only and are not intended to limit the scope of the disclosure.
It should be noted that, for convenience of description, only the portions related to the related invention are shown in the drawings. The embodiments and features of the embodiments in the present disclosure may be combined with each other without conflict.
It should be noted that the terms "first", "second", and the like in the present disclosure are only used for distinguishing different devices, modules or units, and are not used for limiting the order or interdependence relationship of the functions performed by the devices, modules or units.
It is noted that references to "a", "an", and "the" modifications in this disclosure are intended to be illustrative rather than limiting, and that those skilled in the art will recognize that "one or more" may be used unless the context clearly dictates otherwise.
The names of messages or information exchanged between devices in the embodiments of the present disclosure are for illustrative purposes only, and are not intended to limit the scope of the messages or information.
The present application will be described in detail below with reference to the embodiments with reference to the attached drawings.
FIG. 1 is a schematic diagram of one application scenario of a method for synchronizing update data according to some embodiments of the present disclosure.
As the word processing document software 103 and the electronic form software 101 shown in fig. 1, the word processing document software 103 and the electronic form software 101 can communicate with each other. Where data 104 in word processing documentation software 103 (e.g., word software or WPS text software may be employed) may be, for example, how many ten thousand dollars of cash flow in this year, which references data of cells 102 in electronic forms software 101. And shown in the data diagram for cell 102 is 19652.5, which corresponds to the entry of cash into the sub-total for the business activity. Various operations, including but not limited to changing the location of spreadsheet cells, changing data and formulas, etc., may be performed in spreadsheet software 101 (e.g., Excel software or WPS spreadsheet software may be employed), and the spreadsheet software may also record a history of cell location changes.
As an example, the original position of the cell 102 in FIG. 1 is B3, and the data of B3 is: 19652.5 which corresponds to the flow of cash into a sub-total for a business activity. When the e-forms software 101 is operated, three additional lines of business data are added before B3, investment activity cash-in subtotal, investment activity cash-out subtotal, and investment activity cash net flow subtotal. Then the position of the cell 102 has changed from the original B3 position to the B6 position. Then, the spreadsheet software 101 may actively notify the word processing document software 103 of the new location B6, and the word processing document software 103 updates the data with the reference location B6 according to the location change of the cell 102, that is, the data item 104 in the word processing document software 103 references the data of the new location B6 of the cell 102, which still corresponds to the item of cash flow into the subtotal of the business activity, and the data is still 19652.5, so as to ensure that the word processing document software still maintains the correct reference relationship when the referenced cell location changes.
With continued reference to FIG. 2, a flow 200 of a method for synchronizing update data is shown, in accordance with some embodiments of the present disclosure. The method for synchronously updating data comprises the following steps:
In some embodiments, the executing agent (e.g., spreadsheet software 101 in FIG. 1) may determine the original location of the cell by coordinates. Wherein, the cell can be a grid in the form, which is the minimum most basic unit. The form is composed of a plurality of cells. And the original location is the original location of one or more special cells in the form before the change, and the data in the special cells is to be referred to by the document. And documents include, but are not limited to, word processing documents, electronic forms, Web files, and the like. By way of example, when the data of the D3 cell is referenced by a word processing document or an electronic form or Web file, then the original location of the cell is determined to be D3 in this case.
In some embodiments, the execution agent may monitor the change of the form by using a monitoring program to determine whether the change changes the original location of the cell. The variation includes, but is not limited to, variation of row number, variation of column and row simultaneously, variation of data, variation of formula, and the like. As an example, the original location of cell 102 is B3, and when the execution agent monitors a form change, such as a form having an increased number of lines, the execution agent needs to determine whether the change in the form changed the original location B3 of cell 102.
In some embodiments, the executing agent may computationally re-determine the new location of the cell 102. For example, when the original position of the cell 102 is D3, and the operation on the form 101 is increased by two lines, and it is determined that the original D3 position of the cell 102 has changed in this case, the new position of the cell can be re-determined to be D5 by calculation.
In some embodiments, the execution agent may synchronize instantaneously, or may delay the synchronization of the cell re-determined location. Synchronization means that two or more time-varying quantities maintain a certain relative relationship during the variation. The instant synchronization is to realize synchronization immediately, and the delay synchronization is to reach the synchronization state after a period of time. The re-determined location is the coordinate location after the cell change.
As an example, the initial position of the cell 102 is D3, because the position of the cell 102 changes to D5 or F8 and so on due to the change of the form, the position of the cell 102 referenced by the document will change to D5 or F8 and so on at the same time, so as to ensure the correctness of the data reference.
Some embodiments of the present disclosure disclose a method for synchronously updating data, which can maintain the same reference relationship by re-determining the position of the referenced cell when the format of the form referenced by the document changes, so that the reference relationship is not affected by the change of the form, and correct data synchronous update is achieved.
With continued reference to FIG. 3, a flow 300 of further embodiments of methods for synchronizing update data according to the present disclosure is shown. The method for synchronously updating data comprises the following steps:
In response to being less than, it is determined that the change changes the original location of the cell, step 304.
In some embodiments, the specific implementation and technical effects of steps 301 and 305-306 may refer to the embodiment corresponding to fig. 2, and are not described herein again.
Step 302 monitors the form variations to determine if the variations are line variations of the form. In some embodiments, the execution agent (which may be, for example, electronic form software 101 of FIG. 1) may determine whether the change in the form is a line change in a number of ways. The increase or decrease in the number of lines is judged by, for example, a change in the number of lines.
In some embodiments, the execution agent determines whether a line number to which the line change is directed is less than a line number of the location of the cell in response to determining that the change is a line change. As an example, if the operation is to be performed on a line of the form, it is determined whether the line number of the line variation is less than the line number 3 of the original position D3 of the cell 102, i.e., whether it is varied before or after the third line.
In response to being less than, it is determined that the change changes the original location of the cell, step 304.
In some embodiments, the execution subject determines that the change changes the original location of the cell in response to being less than. As an example, the line operation on the form is performed on the first line, and then the line number of the first line is smaller than the line number of the third line of the cell original position D3, i.e., the line change occurs before the third line. In which case the change in the number of rows would change the original location D3 of the cell 102. If the operation on the form occurs in the fourth row, in this case, the variation in the number of rows does not change the position of the line where the original position D3 is located.
In some optional implementations of some embodiments, the monitoring the change of the form to determine whether the change changes the original location of the cell includes: determining whether the change is a column change of the form; in response to determining that the change is a column change, determining whether a column number to which the column change is directed is less than a column number at an original location of the cell; in response to determining less than, determining that the variation changes the original location of the cell.
As an example, the original location of the cell 102 is determined to be D3. When there is an operation on a form, it is first determined whether the operation on the form is a line change or a column change. If the column shift is a column shift, it is determined whether the column shift is before or after the D column. If it is determined that a change in the number of columns is made before column D, i.e., on columns A-C, such as adding two columns or deleting two columns, the change in the number of columns in this case will change the original D3 location of cell 102. If it is determined that the number of columns is shifted after the third column, i.e., there is a shift in the number of columns on columns F-Z, in this case, the shift in the number of columns does not change the position of D3.
In some optional implementations of some embodiments, the monitoring the change of the form to determine whether the change changes the original location of the cell includes: determining whether said change is a simultaneous change in the rows and columns of said form; in response to determining that the variation is a simultaneous row and column variation, determining whether a row number and a column number for the row and column variations are less than a row number and a column number at an original location of the cell, respectively; in response to determining less than any of the plurality of cells, determining that the change changes the original location of the cell. For example, the original location of the cell 102 is determined to be D3. When there is an operation on a form, it is first determined whether the operation on the form is a line change or a column change. If the row and the column are changed simultaneously, the judgment is made whether the row change is before or after the third row and the column change is before or after the D column. If it is determined that the row change is before the third row and the column change is before the D column, the change is to add two rows and delete one column, in which case the change in the number of rows and columns changes the original D3 location of the cell 102. If the row change is after the third row and the column change is before the D column, in this case, the original D3 location of cell 102 would be changed just as the change in the number of columns would be. If it is determined that the row change is before the third row and the column change is after the D column, this is simply because the change in the number of rows would also change the original D3 location of cell 102. If the row change is after the third row and the column change is after the D column, in this case, the simultaneous row and column change does not change the original D3 location of the cell 102.
In some optional implementations of some embodiments, the re-determining the location of the cell in response to determining that the change changed the original location of the cell includes: determining the number of the line variations; and determining the new position line number of the cell as the number of line changes increased or decreased by the line number of the cell. For example, if the number of forward shifts is 2 at the D3 position, then 2 is added or subtracted from the third row to obtain a new row number of 5 columns or 1 column and a new position of D5 or D1.
In some optional implementations of some embodiments, the re-determining the location of the cell in response to determining that the change changed the original location of the cell includes: determining the number of the column variations; determining the number of columns in the new position of the cell as the number of columns in which the cell is located increases or decreases by the number of column variations. For example, if the number of column shifts is 2 at position D3, then column D is used to add or subtract 2 to yield a new column number of columns F or A, and then the new position is F3 or A3.
In some optional implementations of some embodiments, synchronizing the re-determined location of the cell to the at least one document includes: traversing each document of said at least one document, determining whether said document is closed, and in response to determining that said document is closed, saving an unsynchronized state for said document; in response to determining that the document is not closed, synchronizing the re-determined locations of the cells to the document and saving a synchronized state for the document; and the closed document responds to being opened again, acquires the redetermined position of the cell, and updates the saved unsynchronized state into the synchronized state.
As an example, the execution subject traverses all documents that reference the cell, such as word processing documents, Web pages, electronic forms, etc., determines whether all documents are in a running state, and saves an unsynchronized state for the documents if the word processing documents are not in a running state. If the word processing document, Web page or electronic form is in a running state, the execution body may actively notify and send the redetermined location to the above document and save the synchronized state for the word processing document, Web page or electronic form that has been synchronized. If the word processing document is always in the closed state, it will actively acquire the latest determined position of the execution subject, such as an electronic form, and update the unsynchronized state to the synchronized state by the time the word processing document is in the open state or the running state. If the Web system is always in the closed state, when the Web system is opened and in the running state, the latest result of the execution subject, for example, the electronic form, can be obtained by refreshing the Web interface, clicking a synchronous update button, or polling regularly (for example, every 10 seconds), and the obtaining process generally transmits the latest information in an encrypted manner through the HTTP protocol. And finally, the Web system updates the unsynchronized state of the Web system to a synchronized state.
In some optional implementations of some embodiments, synchronizing the re-determined location of the cell to the at least one document includes: setting a single lock, and adopting the single lock to prevent the form from changing during synchronization; setting a delay sending time threshold value and determining delay sending time, checking the states of all documents, and synchronizing the re-determined positions of the cells to the document in the unsynchronized state; and if the delay sending time is determined to be larger than the threshold value, the single lock is cancelled.
The single lock is used to lock the shared resource to monopolize the resource. For example, where the execution subject synchronizes the redetermined locations of the cells to multiple documents, the single lock may prevent further changes in the location of the electronic form. The execution body may set a delayed transmission time threshold, for example 30 seconds. When the state of all documents is queried, calculation of the delayed transmission time is started. If the unsynchronized document is opened within 30 seconds, the newly determined position of the cell is synchronized to the document in the unsynchronized state. If the delay transmission time exceeds 30 seconds and the unsynchronized document has not been opened, the single lock is canceled so that the execution principal can further manipulate the electronic form.
With further reference to fig. 4, as an implementation of the methods shown in the above figures, the present disclosure provides some embodiments of an apparatus for synchronizing update data, which correspond to those shown in fig. 2, and which may be applied in various electronic devices in particular.
As shown in fig. 4, the apparatus for synchronizing update data of some embodiments includes: a determining module configured to determine an original location of a cell of a form, wherein data of the original location is referenced by a document; a monitoring module configured to monitor a change in the form and determine whether the change changes an original location of the cell; a redetermination module configured to redetermine a location of the cell in response to determining that the change changed an original location of the cell; and a synchronization module for synchronizing the redetermined positions of the cells to the document.
Referring now to FIG. 5, a block diagram of an electronic device 500 suitable for use in implementing some embodiments of the present disclosure is shown. The electronic device in some embodiments of the present disclosure may include, but is not limited to, a mobile terminal such as a mobile phone, a notebook computer, a digital broadcast receiver, a PDA (personal digital assistant), a PAD (tablet computer), a PMP (portable multimedia player), a vehicle-mounted terminal (e.g., a car navigation terminal), and the like, and a stationary terminal such as a digital TV, a desktop computer, and the like. The electronic device/terminal device/server shown in fig. 5 is only an example, and should not bring any limitation to the functions and use range of the embodiments of the present disclosure.
As shown in fig. 5, electronic device 500 may include a processing means (e.g., central processing unit, graphics processor, etc.) 501 that may perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)502 or a program loaded from a storage means 508 into a Random Access Memory (RAM) 503. In the RAM503, various programs and data necessary for the operation of the electronic apparatus 500 are also stored. The processing device 501, the ROM 502, and the RAM503 are connected to each other through a bus 504. An input/output (I/O) interface 505 is also connected to bus 504.
Generally, the following devices may be connected to the I/O interface 505: input devices 504 including, for example, a touch screen, touch pad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, etc.; output devices 507 including, for example, a Liquid Crystal Display (LCD), speakers, vibrators, and the like; and a communication device 509. The communication means 509 may allow the electronic device 500 to communicate with other devices wirelessly or by wire to exchange data. While fig. 5 illustrates an electronic device 500 having various means, it is to be understood that not all illustrated means are required to be implemented or provided. More or fewer devices may alternatively be implemented or provided. Each block shown in fig. 5 may represent one device or may represent multiple devices as desired.
In particular, according to some embodiments of the present disclosure, the processes described above with reference to the flow diagrams may be implemented as computer software programs. For example, some embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In some such embodiments, the computer program may be downloaded and installed from a network via the communication means 509, or installed from the storage means 508, or installed from the ROM 502. The computer program, when executed by the processing device 501, performs the above-described functions defined in the methods of some embodiments of the present disclosure.
It should be noted that the computer readable medium of some embodiments of the present disclosure may be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. 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 diskette, 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 disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In some embodiments of the disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In some embodiments of the present disclosure, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, optical cables, RF (radio frequency), etc., or any suitable combination of the foregoing.
In some embodiments, the clients, servers may communicate using any currently known or future developed network Protocol, such as HTTP (HyperText Transfer Protocol), and may interconnect with any form or medium of digital data communication (e.g., a communications network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the Internet (e.g., the Internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed network.
The computer readable medium may be embodied by the apparatus for generating user information; or may exist separately without being assembled into the electronic device. The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: determining the original position of a table cell, wherein the data of the original position is referred by a document; monitoring the change of the form and determining whether the change changes the original position of the cell; repositioning said cell in response to determining that said change has changed the original position of said cell; synchronizing the redetermined locations of the cells to the document.
Computer program code for carrying out operations for embodiments of the present disclosure may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of 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 the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in some embodiments of the present disclosure may be implemented by software, and may also be implemented by hardware. The described units may also be provided in a processor, and may be described as: a processor includes a determination module, a monitoring module, a re-determination module, and a synchronization module. Wherein the names of the elements do not in some way constitute a limitation on the elements themselves. For example, the determination module may also be described as a "module that determines the original locations of the cells of the form".
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 a chip (SOCs), Complex Programmable Logic Devices (CPLDs), and the like.
The foregoing description is only exemplary of the preferred embodiments of the disclosure and is illustrative of the principles of the technology employed. It will be appreciated by those skilled in the art that the scope of the invention in the embodiments of the present disclosure is not limited to the specific combination of the above-mentioned features, but also encompasses other embodiments in which any combination of the above-mentioned features or their equivalents is made without departing from the inventive concept as defined above. For example, the above features and (but not limited to) technical features with similar functions disclosed in the embodiments of the present disclosure are mutually replaced to form the technical solution.
Claims (10)
1. A method for synchronizing update data, comprising:
determining an original position of a cell of a form, wherein data of the original position is referred to by at least one document;
monitoring the change of the form and determining whether the change changes the original position of the cell;
in response to determining that the change changed the original location of the cell, re-determining the location of the cell;
synchronizing the re-determined locations of the cells to the at least one document.
2. The method of claim 1, wherein the monitoring the form for a change to determine whether the change changes an original location of the cell comprises:
determining whether the change is a line change of the form;
in response to determining that the change is a line change, determining whether a line number for the line change is less than a line number of an original location of the cell;
in response to being less than, determining that the change changes the original location of the cell.
3. The method of claim 1, wherein the monitoring the form for a change to determine whether the change changes an original location of the cell comprises:
determining whether the change is a column change of the form;
in response to determining that the change is a column change, determining whether a column number to which the column change is directed is less than a column number of an original location of the cell;
in response to determining less than, determining that the change changes the original location of the cell.
4. The method of claim 1, wherein the monitoring the form for a change to determine whether the change changes an original location of the cell comprises:
determining whether the change is a simultaneous change in rows and columns of the form;
in response to determining that the variation is a row and column simultaneous variation, determining whether a row number and a column number for the row and column variations, respectively, are less than a row number and a column number at an original location of the cell;
in response to determining less than any of the plurality of cells, determining that the change changes the original location of the cell.
5. The method of any of claims 1-4, wherein said re-determining the location of the cell in response to determining that the change changed the original location of the cell comprises:
determining a number of the line variations;
and determining the number of rows of the new positions of the cells as the number of rows of the cells, which is increased or decreased by the row variation.
6. The method of any of claims 1-4, wherein said re-determining the location of the cell in response to determining that the change changed the original location of the cell comprises:
determining a number of the column variations;
determining the new position column number of the unit cell as the number of the column changes increased or decreased by the number of the column changes of the unit cell.
7. The method of any of claims 1-6, wherein said synchronizing the re-determined locations of the cells to the at least one document comprises:
traversing each document of the at least one document, determining whether the document is closed, and in response to determining that the document is closed, saving an unsynchronized state for the document; in response to determining that the document is not closed, synchronizing the re-determined locations of the cells to the document and saving a synchronized state for the document; wherein the closed document, in response to being reopened, obtains the redetermined location of the cell and updates the saved unsynchronized state to the synchronized state.
8. The method of claim 7, wherein said synchronizing the re-determined locations of the cells to the at least one document further comprises:
setting a single lock, and adopting the single lock to prevent the form from changing during synchronization;
setting a delay sending time threshold value and determining delay sending time, checking the states of all documents, and synchronizing the re-determined positions of the cells to the document in the unsynchronized state;
and if the delayed sending time is determined to be larger than the threshold value, canceling the single lock.
9. An electronic device, comprising:
one or more processors;
a storage device having one or more programs stored thereon,
when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-8.
10. A computer-readable medium, on which a computer program is stored, wherein the program, when executed by a processor, implements the method of any one of claims 1-8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911283801.2A CN112989773B (en) | 2019-12-13 | 2019-12-13 | Method, apparatus, device and computer readable medium for synchronizing update data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911283801.2A CN112989773B (en) | 2019-12-13 | 2019-12-13 | Method, apparatus, device and computer readable medium for synchronizing update data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112989773A true CN112989773A (en) | 2021-06-18 |
| CN112989773B CN112989773B (en) | 2024-02-20 |
Family
ID=76341730
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911283801.2A Active CN112989773B (en) | 2019-12-13 | 2019-12-13 | Method, apparatus, device and computer readable medium for synchronizing update data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112989773B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023217074A1 (en) * | 2022-05-11 | 2023-11-16 | 北京字跳网络技术有限公司 | Data block control method, apparatus and system, electronic device, and storage medium |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6411959B1 (en) * | 1999-09-29 | 2002-06-25 | International Business Machines Corporation | Apparatus and method for dynamically updating a computer-implemented table and associated objects |
| CN1961294A (en) * | 2003-08-21 | 2007-05-09 | 微软公司 | Systems and methods for providing relational and hierarchical synchronization services for units of information manageable by a hardware/software interface system |
| US20160041963A1 (en) * | 2014-08-05 | 2016-02-11 | Apple Inc. | Reference representation and transformation in collaborative documents |
| CN105593848A (en) * | 2013-06-14 | 2016-05-18 | 微软技术许可有限责任公司 | Updates to shared electronic documents in collaborative environments |
| CN106462671A (en) * | 2014-06-30 | 2017-02-22 | 惠普发展公司，有限责任合伙企业 | Composite document referenced resources |
| CN109597896A (en) * | 2018-10-19 | 2019-04-09 | 上海星佑网络科技有限公司 | Information quoting method and device |
| US20190138587A1 (en) * | 2017-11-03 | 2019-05-09 | Dropbox, Inc. | Collaborative Spreadsheet Embedding and Management |
| US20190138588A1 (en) * | 2017-11-03 | 2019-05-09 | Dropbox, Inc. | Embedded spreadsheet data implementation and synchronization |
| CN109829144A (en) * | 2018-12-28 | 2019-05-31 | 陈德芹 | A kind of across table reference method and device of online table |
| CN110020328A (en) * | 2019-04-16 | 2019-07-16 | 北京字节跳动网络技术有限公司 | Data processing method, device, electronic equipment and the storage medium of online table |
-
2019
- 2019-12-13 CN CN201911283801.2A patent/CN112989773B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6411959B1 (en) * | 1999-09-29 | 2002-06-25 | International Business Machines Corporation | Apparatus and method for dynamically updating a computer-implemented table and associated objects |
| CN1961294A (en) * | 2003-08-21 | 2007-05-09 | 微软公司 | Systems and methods for providing relational and hierarchical synchronization services for units of information manageable by a hardware/software interface system |
| CN105593848A (en) * | 2013-06-14 | 2016-05-18 | 微软技术许可有限责任公司 | Updates to shared electronic documents in collaborative environments |
| CN106462671A (en) * | 2014-06-30 | 2017-02-22 | 惠普发展公司，有限责任合伙企业 | Composite document referenced resources |
| US20160041963A1 (en) * | 2014-08-05 | 2016-02-11 | Apple Inc. | Reference representation and transformation in collaborative documents |
| US20190138587A1 (en) * | 2017-11-03 | 2019-05-09 | Dropbox, Inc. | Collaborative Spreadsheet Embedding and Management |
| US20190138588A1 (en) * | 2017-11-03 | 2019-05-09 | Dropbox, Inc. | Embedded spreadsheet data implementation and synchronization |
| CN109597896A (en) * | 2018-10-19 | 2019-04-09 | 上海星佑网络科技有限公司 | Information quoting method and device |
| CN109829144A (en) * | 2018-12-28 | 2019-05-31 | 陈德芹 | A kind of across table reference method and device of online table |
| CN110020328A (en) * | 2019-04-16 | 2019-07-16 | 北京字节跳动网络技术有限公司 | Data processing method, device, electronic equipment and the storage medium of online table |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023217074A1 (en) * | 2022-05-11 | 2023-11-16 | 北京字跳网络技术有限公司 | Data block control method, apparatus and system, electronic device, and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112989773B (en) | 2024-02-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20220253458A1 (en) | Method and device for synchronizing node data | |
| US20230350872A1 (en) | Updating method of citation document, apparatus, electronic device and storage medium | |
| CN104115142A (en) | Device specific folders for bookmarks synchronization | |
| CN113032412B (en) | Data synchronization method, device, electronic equipment and computer readable medium | |
| CN110795443A (en) | Method, device, equipment and computer readable medium for data synchronization | |
| CN113934958A (en) | Page loading method and device, electronic equipment and computer readable medium | |
| CN112347111A (en) | Data updating method and device | |
| CN111309747A (en) | Data synchronization method, system and device | |
| CN111163336A (en) | Video resource pushing method and device, electronic equipment and computer readable medium | |
| CN111596992B (en) | Navigation bar display method and device and electronic equipment | |
| CN111752939A (en) | Data processing method, device, computer system and medium for multiple systems | |
| CN112989773A (en) | Method, apparatus, device and computer readable medium for synchronizing update data | |
| CN113722326A (en) | Data processing method and device, electronic equipment and medium | |
| CN111464254B (en) | Clock synchronization method and device and electronic equipment | |
| CN111597107A (en) | Information output method and device and electronic equipment | |
| CN115357361A (en) | Task processing method, device, equipment and medium | |
| WO2022017458A1 (en) | Data synchronization method and apparatus, electronic device, and medium | |
| CN112507676B (en) | Method and device for generating energy report, electronic equipment and computer readable medium | |
| CN111338827B (en) | Method and device for pasting form data and electronic equipment | |
| CN110941683B (en) | Method, device, medium and electronic equipment for acquiring object attribute information in space | |
| CN112688793B (en) | Data packet obtaining method and device and electronic equipment | |
| CN112148417A (en) | Page adjusting method and device, electronic equipment and computer readable medium | |
| US11232172B2 (en) | Collaborative web application and data system | |
| CN112464039A (en) | Data display method and device of tree structure, electronic equipment and medium | |
| CN113032046A (en) | Method, device and equipment for repairing so file and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |