CN112989773B - 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
- CN112989773B CN112989773B CN201911283801.2A CN201911283801A CN112989773B CN 112989773 B CN112989773 B CN 112989773B CN 201911283801 A CN201911283801 A CN 201911283801A CN 112989773 B CN112989773 B CN 112989773B
- Authority
- CN
- China
- Prior art keywords
- cell
- determining
- variation
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 33
- 230000008859 change Effects 0.000 claims abstract description 71
- 230000004044 response Effects 0.000 claims abstract description 33
- 230000001360 synchronised effect Effects 0.000 claims abstract description 16
- 238000012544 monitoring process Methods 0.000 claims abstract description 13
- 238000004590 computer program Methods 0.000 claims description 9
- 230000005540 biological transmission Effects 0.000 claims description 7
- 230000003111 delayed effect Effects 0.000 claims description 3
- 230000008569 process Effects 0.000 abstract description 4
- 238000012545 processing Methods 0.000 description 22
- 238000010586 diagram Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 7
- 238000004891 communication Methods 0.000 description 6
- 230000000694 effects Effects 0.000 description 6
- 230000003287 optical effect Effects 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 230000003247 decreasing effect Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 108010001267 Protein Subunits Proteins 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
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 the following steps: determining the original positions of the cells of the form, wherein the data of the original positions are referenced by the document; monitoring the variation of the form to determine whether the variation changes the original position of the cell; repositioning the cells in response to determining that the change changes the original position of the cells; the redetermined positions of the cells are synchronized to the document. The embodiment realizes the data synchronization under the condition of position change, and the whole process is simple and convenient to operate and easy to understand.
Description
Technical Field
Embodiments of the present disclosure relate to the field of computer technology, and in particular, to a method, apparatus, device, and computer readable medium for synchronizing update data.
Background
Word processing and electronic forms are two commonly used software applications. By means of a word processing application we can create a document that is text-dominated. Through electronic forms we can create financial records, bills, budgets, and other digitally dominated documents. In some cases we need to include data for numbers and spreadsheets in word processing applications to extend their functionality. However, in the prior art, if the data of an electronic form is referenced in a word processing document, neither the name nor the location of the electronic form can be changed once the reference relationship is determined. In such a case, therefore, if there are more operations or modifications to the electronic form, it may affect its reference relationship, causing problems such as a reference relationship error, or a data update error.
Disclosure of Invention
The disclosure is in part intended to introduce concepts in a simplified form that are further described below in the detailed description. The disclosure 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 methods, apparatuses, devices, and computer-readable media for synchronizing update data to solve the technical problems mentioned in the background above.
In a first aspect, some embodiments of the present disclosure provide a method for synchronizing update data, comprising: determining the original positions of the cells of the form, wherein the data of the original positions are referenced by the document; monitoring the variation of the form to determine whether the variation changes the original position of the cell; repositioning the cells in response to determining that the change changes the original position of the cells; the redetermined positions of the cells are synchronized 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 position of a cell of a form, wherein data of the original position is referenced by a document; a monitoring module configured to monitor a variation of the form, and determine whether the variation changes an original position of the cell; a redetermining module configured to redetermine the locations of the cells in response to determining that the variation changes the original locations of the cells; and the synchronization module synchronizes 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 the method as in the first aspect.
In a fourth aspect, some embodiments of the present 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 embodiments of the present disclosure has the following advantageous effects: when the format of the form referenced by the document changes, the same referencing relation can be kept by redefining the position of the referenced cell, so that the referencing relation is not influenced by the form change, the correct data synchronous update is achieved, and the operation is simple and easy to understand.
Drawings
The above and other features, advantages, and aspects of embodiments of the present disclosure will become more apparent by reference to the following detailed description when taken in conjunction with the accompanying drawings. The same or similar reference numbers will be used throughout the drawings to refer to the same or like elements. It should be understood that the figures are schematic and that elements and components are not necessarily drawn to scale.
FIG. 1 is a schematic illustration of one application scenario of a method for synchronizing update data according to some embodiments of the present disclosure;
FIG. 2 is a flow chart of some embodiments of a method for synchronizing update data according to the present disclosure;
FIG. 3 is a flow chart of other embodiments of a method for synchronizing update data according to the present disclosure;
FIG. 4 is a schematic diagram of the structure 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 should be understood that the present 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 so that this disclosure will be thorough and complete. It should be understood that the drawings and embodiments of the present disclosure are for illustration purposes only and are not intended to limit the scope of the present disclosure.
It should be noted that, for convenience of description, only the portions related to the present invention are shown in the drawings. Embodiments of the present disclosure and features of embodiments may be combined with each other without conflict.
It should be noted that the terms "first," "second," and the like in this disclosure are merely used to distinguish between different devices, modules, or units and are not used to define an order or interdependence of functions performed by the devices, modules, or units.
It should be noted that references to "one", "a plurality" and "a plurality" in this disclosure are intended to be illustrative rather than limiting, and those of ordinary skill in the art will appreciate that "one or more" is intended to be understood as "one or more" unless the context clearly indicates otherwise.
The names of messages or information interacted between the various devices in the embodiments of the present disclosure are for illustrative purposes only and are not intended to limit the scope of such messages or information.
The present application will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.
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 shown in fig. 1, the word processing document software 103 and the electronic form software 101 can communicate with each other. Wherein the data 104 in the word processing document software 103 (e.g., word software or WPS literal software may be employed) may be, for example, data for how many tens of thousands of elements the annual cash flows in, which references the data of the cells 102 in the electronic form software 101. While the data diagram of cell 102 shows 19652.5, which corresponds to the business cash flow into the novice. Various operations may be performed in the electronic form software 101 (e.g., excel software or WPS form software may be employed), including but not limited to changing the locations of the electronic form cells, altering data and formulas, etc., and the electronic form 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 business cash inflow sub-meter. When the electronic form software 101 is operated, three other lines of business data, namely an investment activity cash inflow meter, an investment activity cash outflow meter, and an investment activity cash net flow meter, are added before B3. Then the position of the cell 102 changes from the original B3 position to the B6 position. After that, the electronic form software 101 may actively notify the word processing document software 103 of the new position B6, where the word processing document software 103 updates its reference position to B6 according to the above-mentioned position change of the cell 102, that is, the data item 104 in the word processing document software 103 references the data of the new position B6 of the cell 102, where the data still corresponds to the item of running activity cash into the sub-unit, and the data still is 19652.5, so that it is ensured that the word processing document software still maintains a correct reference relationship when the referenced cell position changes.
With continued reference to fig. 2, a flow 200 of a method for synchronizing update data is shown, according to some embodiments of the present disclosure. The method for synchronously updating data comprises the following steps:
in step 201, the original position of the cell of the form is determined, wherein the data of the original position is referenced by the document.
In some embodiments, the executing subject (e.g., electronic form software 101 in FIG. 1) may determine the original location of the cell by coordinates. Wherein the cell may be a grid in a form that is the smallest and most basic unit. The form is made up of a plurality of cells. While the original location is the original location of one or more particular cells in the form before the change, the data in the particular cells being referenced 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 a D3 cell is referenced by a word processing document or electronic form or Web file, then the original location of the cell is determined to be D3 in this case.
Step 202, monitoring the variation of the form, and determining whether the variation changes the original position of the cell.
In some embodiments, the executing body may monitor the form change using a monitoring program to determine whether the change will change the original position of the cell. The variation includes, but is not limited to, a variation in the number of rows, a variation in the number of columns, a simultaneous variation in the rows and columns, a variation in the data, a variation in the formula, and the like. As an example, when the execution subject monitors a form change, for example, the form increases the number of lines, and the execution subject needs to determine whether the change of the form changes the original position B3 of the cell 102, the original position B3 of the cell 102.
In response to determining that the change has changed the original position of the cell, the position of the cell is redetermined 203.
In some embodiments, the executing entity may computationally redefine the new location of the cell 102. For example, when the original position of the cell 102 is D3, and when the operation of the form 101 is to be added by two lines, and it is determined that the original D3 position of the cell 102 is changed in this case, the new position of the cell can be redetermined as D5 by calculation.
Step 204, synchronizing the redefined locations of the cells to the document.
In some embodiments, the executing body may synchronize on the fly, and may also delay the synchronization of cell redetermined locations. Synchronization refers to two or more time-varying amounts maintaining a certain relative relationship during the course of the change. The instant synchronization is to immediately achieve the synchronization, and the delay synchronization is to reach the synchronization state after a period of time. The redetermined position is the coordinate position after the cell change.
As an example, the initial position of the cell 102 is D3, and because the position of the cell 102 is changed to D5 or F8, etc. due to the change of the form, the position of the cell 102 referenced by the document is changed to D5 or F8, etc. at the same time, so as to ensure the correctness of the data reference.
Some embodiments of the present disclosure disclose methods for synchronously updating data that can maintain the same referencing relationship by repositioning the referenced cells when the format of the form referenced by the document changes so that its referencing relationship is not affected by the form change, achieving a correct synchronous update of data.
With continued reference to fig. 3, a flow 300 of further embodiments of a method for synchronizing update data according to the present disclosure is shown. The method for synchronously updating data comprises the following steps:
in step 301, the original position of the cell of the form is determined, wherein the data of the original position is referenced by the document.
Step 302, monitoring the form for a change, and determining whether the change is a line change of the form.
In step 303, in response to determining that the variation is a line variation, it is determined whether or not the line number for the line variation is smaller than the line number of the original position of the cell.
Step 304, in response to being less than, determining that the variation changes the original position of the cell.
In response to determining that the change has changed the original position of the cell, the position of the cell is redetermined 305.
Step 306, synchronizing the redetermined positions of the cells to the document.
In some embodiments, the specific implementation of steps 301, 305-306 and the technical effects thereof may refer to the corresponding embodiment of fig. 2, and will not be described herein.
And step 302, monitoring the variation of the form to determine whether the variation is a line variation of the form. In some embodiments, the executing entity (which may be, for example, electronic form software 101 in FIG. 1) may determine whether the form change is a line change in a number of ways. The increase or decrease in the number of lines is determined by, for example, a change in the number of lines.
In step 303, in response to determining that the variation is a line variation, it is determined whether or not the line number for the line variation is smaller than the line number of the original position of the cell.
In some embodiments, the execution body determines, in response to determining that the change is a line change, whether a line number for which the line change is directed is less than a line number of a location of the cell. As an example, if the form is operated on a line, it is determined whether the line number of the line variation is smaller than the line number 3 of the original position D3 of the cell 102, i.e., whether it is before the third line or after the third line.
Step 304, in response to being less than, determining that the variation changes the original position of the cell.
In some embodiments, the executing body changes the original position of the cell in response to the determination that the variance is less than the predetermined variance. By way of example, the line operation of 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 Yu Shanyuan grid origin D3, i.e., the line change occurs before the third line. In this case, the variation in the number of lines changes the original position D3 of the cell 102. If the manipulation of the form occurs on the fourth row, in this case, the change in the number of rows does not change the position of the row where the home position D3 is located.
In some alternative implementations of some embodiments, the monitoring the form for changes, determining whether the changes change the original location of the cell includes: determining whether the change is a column change of the form; in response to determining that the variation is a column variation, determining whether a column number for the column variation is less than a column number at an original location of the cell; in response to determining that the variation is less than the predetermined threshold, determining that the variation changes the original position of the cell.
As an example, the original position of the cell 102 is determined to be D3. When the form is operated, it is first determined whether the operation of the form is a row change or a column change. If the column changes, it is further determined whether the column changes are before or after the column D. If a column number change is determined to be made before the D column, i.e., on the a-C columns, e.g., two columns are added or two columns are deleted, the column number change in this case will change the original D3 position of the cell 102. If the column number is determined to change after the third column, i.e. the column number changes on the F-Z column, the change in column number does not change the position of D3 in this case.
In some alternative implementations of some embodiments, the monitoring the form for changes, determining whether the changes change the original location of the cell includes: determining whether the variation is a simultaneous variation of the rows and columns of the form; in response to determining that the variation is a simultaneous variation of rows and columns, determining whether a row number and a column number for which the row variation and the column variation are directed are smaller than a row number and a column number at an original position of the cell, respectively; in response to determining that the change is less than any of the plurality of cells, determining that the change changes the original position of the cell. For example, the original position of the cell 102 is determined to be D3. When the form is operated, it is first determined whether the operation of the form is a row change or a column change. If the rows and columns change at the same time, it is further determined 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 would change the original D3 position 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 position of the cell 102 is changed only because of the change in the column number. If it is determined that the row variation is before the third row and the column variation is after the D column, the original D3 position of the cell 102 is changed in this case only because of the variation in the number of rows. If the row variation is after the third row and the column variation is after the D column, in this case, the column-row simultaneous variation does not change the original D3 position of the cell 102.
In some alternative implementations of some embodiments, the repositioning of the cell in response to determining that the change changes the original position of the cell includes: determining the number of the line variations; the new position line number of the cell is determined as the line number of the cell is increased or decreased by the line variation number. For example, if the number of forward shifts at the D3 position is 2, then the third row is added or subtracted by 2 to obtain a new row number of 5 columns or 1 column, and a new position of D5 or D1.
In some alternative implementations of some embodiments, the repositioning of the cell in response to determining that the change changes the original position of the cell includes: determining the number of column variations; the number of columns of the new positions of the cells is determined as the number of columns in which the cells are located, and the number of column changes is increased or decreased. For example, if the number of changes in the front of the D3 position is 2, then the new column number is F or a with the addition or subtraction of 2 to the D column, and the new position is F3 or A3.
In some optional implementations of some embodiments, the synchronizing the redetermined locations of the cells to the at least one document includes: traversing each 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; synchronizing the redetermined positions of the cells to the document in response to determining that the document is not closed, and saving the synchronized state for the document; wherein the closed document, in response to being reopened, acquires the redetermined position of the cell, and updates the saved unsynchronized state to a synchronized state.
As an example, the execution body traverses all documents referencing the cell, such as word processing documents, web pages, electronic forms, etc., determines whether all documents are in an operational state, and if the word processing documents are not in an operational state, saves an unsynchronized state for the above-described documents. If the word processing document, web page, or electronic form is in an operational state, the execution body may actively notify the document and send the redetermined location, 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 in the closed state, it will actively take the most recently determined position of the executing body, e.g. electronic form, and update the unsynchronized state to the synchronized state, until the word processing document is in the open state or running state. If the Web system is always in a closed state, when the Web system is opened and in an operating state, the latest result of the executing body, such as an electronic form, can be obtained by refreshing the Web interface, clicking a synchronous update button, or timing polling (for example, every 10 seconds), and the like, and the obtaining process generally transmits the latest information in an encrypted manner through an HTTP protocol. Finally, the Web system updates its own unsynchronized state to a synchronized state.
In some optional implementations of some embodiments, the synchronizing the redetermined locations of the cells to the at least one document includes: setting a single lock, and adopting the single lock to prevent the change of the form during synchronization; setting a delay transmission time threshold and determining delay transmission time, checking the states of all the documents, and synchronizing the redetermined positions of the cells to the document in the unsynchronized state; and if the delayed transmission time is determined to be greater than the threshold value, canceling the single lock.
A single lock is used to lock a shared resource to exclusive the resource. For example, the single lock may prevent further movement of the electronic form in the execution subject synchronizing the redetermined locations of the cells to multiple documents. The executing body may set a delay transmission time threshold, for example, 30 seconds. When the status of all documents is queried, calculation of the delay transmission time is started. If the unsynchronized document is open within 30 seconds, the redetermined position of the cell is synchronized to the unsynchronized document. If the delayed transmission time exceeds 30 seconds and the unsynchronized document has not been opened, the single lock is canceled so that the executing body can further operate the electronic form.
With further reference to fig. 4, as an implementation of the method shown in the above figures, the present disclosure provides some embodiments of an apparatus for synchronizing update data, which apparatus embodiments correspond to those method embodiments shown in fig. 2, and which apparatus is particularly applicable in various electronic devices.
As shown in fig. 4, an apparatus for synchronizing update data of some embodiments includes: a determining module configured to determine an original position of a cell of a form, wherein data of the original position is referenced by a document; a monitoring module configured to monitor a variation of the form, and determine whether the variation changes an original position of the cell; a redetermining module configured to redetermine the locations of the cells in response to determining that the variation changes the original locations of the cells; and the synchronization module synchronizes the redetermined positions of the cells to the document.
Referring now to fig. 5, a schematic diagram of an electronic device 500 suitable for use in implementing some embodiments of the present disclosure is shown. The electronic devices in some embodiments of the present disclosure may include, but are not limited to, mobile terminals such as mobile phones, notebook computers, digital broadcast receivers, PDAs (personal digital assistants), PADs (tablet computers), PMPs (portable multimedia players), car terminals (e.g., car navigation terminals), and the like, as well as stationary terminals such as digital TVs, desktop computers, and the like. The electronic device/terminal device/server illustrated in fig. 5 is merely an example, and should not impose any limitations on the functionality and scope of use of embodiments of the present disclosure.
As shown in fig. 5, the electronic device 500 may include a processing means (e.g., a central processing unit, a graphics processor, etc.) 501, which may perform various appropriate actions and processes according to 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 required 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 via a bus 504. An input/output (I/O) interface 505 is also connected to bus 504.
In general, the following devices may be connected to the I/O interface 505: input devices 504 including, for example, a touch screen, touchpad, keyboard, mouse, camera, microphone, accelerometer, gyroscope, and the like; an output device 507 including, for example, a Liquid Crystal Display (LCD), a speaker, a vibrator, and the like; and communication means 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 shows an electronic device 500 having various means, it is to be understood that not all of the illustrated means are required to be implemented or provided. More or fewer devices may be implemented or provided instead. Each block shown in fig. 5 may represent one device or a plurality of devices as needed.
In particular, according to some embodiments of the present disclosure, the processes described above with reference to flowcharts 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 shown in the flow chart. In such embodiments, the computer program may be downloaded and installed from a network via the communications device 509, or from the storage device 508, or from the ROM 502. The above-described functions defined in the methods of some embodiments of the present disclosure are performed when the computer program is executed by the processing device 501.
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. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any 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 present 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, the computer-readable signal medium may comprise a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. 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, fiber optic cables, RF (radio frequency), and the like, or any suitable combination of the foregoing.
In some implementations, the clients, servers 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"), 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 networks.
The computer readable medium may be embodied by the apparatus for generating user information; or may exist alone without being incorporated 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 positions of the cells of the form, wherein the data of the original positions are referenced by the document; monitoring the variation of the form to determine whether the variation changes the original position of the cell; repositioning the cells in response to determining that the change changes the original position of the cells; the redetermined positions of the cells are synchronized to the document.
Computer program code for carrying out operations for some embodiments of the present disclosure may be written in 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 kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
The flowcharts 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 means of software, or may be implemented by means of hardware. The described units may also be provided in a processor, for example, described as: a processor includes a determination module, a monitoring module, a redetermination module, and a synchronization module. Wherein the names of the units do not constitute a limitation of the units themselves in some cases. For example, the determination module may also be described as "a module that determines the original location of a cell of a form".
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: a Field Programmable Gate Array (FPGA), an Application Specific Integrated Circuit (ASIC), an Application Specific Standard Product (ASSP), a system on a chip (SOC), a Complex Programmable Logic Device (CPLD), and the like.
The foregoing description is only of the preferred embodiments of the present disclosure and description of the principles of the technology being 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 technical features, but encompasses other technical features formed by any combination of the above technical features or their equivalents without departing from the spirit of the invention. Such as the above-described features, are mutually substituted with (but not limited to) the features having similar functions disclosed in the embodiments of the present disclosure.
Claims (6)
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 referenced by at least one document;
monitoring the variation of the form, and determining whether the variation changes the original position of the cell;
repositioning the cell in response to determining that the change has changed the original position of the cell;
synchronizing the redetermined locations of the cells to the at least one document;
wherein said synchronizing said redefined locations of said cells to said at least one document comprises:
setting a single lock, and preventing the form from changing when the redetermined positions of the cells are synchronized to at least one document by using the single lock;
setting a delay sending time threshold value, determining delay sending time, checking the states of all documents, and synchronizing the redetermined positions of the cells to the document in an unsynchronized state;
determining that the delayed transmission time is greater than the threshold, canceling the single lock;
wherein the monitoring of the variation of the form, determining whether the variation changes the original position of the cell, comprises:
determining whether the change is a line change of the form;
in response to determining that the variation is a line variation, determining whether a line number for which the line variation is for is less than a line number of an original location of the cell;
determining that the variation alters the original position of the cell in response to being less than;
determining whether the change is a column change of the form;
in response to determining that the variation is a column variation, determining whether a column number for which the column variation is for is less than a column number of an original location of the cell;
responsive to determining that the variance is less than, determining that the original position of the cell is changed;
determining whether the variation is a simultaneous variation of a row and a column of the 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 which the row variation and the column variation are for, respectively, less than a row number and a column number at an original location of the cell;
in response to determining that the change is less than any of the cells, determining that the change changes the original position of the cell.
2. The method of claim 1, wherein the repositioning the cell in response to determining that the change changed the original position of the cell comprises:
determining a number of row variations;
and determining the line number of the new position of the cell as the line number of the cell to increase or decrease the line variation number.
3. The method of claim 1, wherein the repositioning the cell in response to determining that the change changed the original position of the cell comprises:
determining a number of column variations;
and determining the new position column number of the cell as the column number of the cell to increase or decrease the column change number.
4. The method of claim 1, wherein the synchronizing the redetermined location of the cell 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; synchronizing the redetermined locations of the cells to the document in response to determining that the document is not closed, and saving the synchronized state for the document; wherein the closed document, in response to being reopened, acquires the redetermined position of the cell, and updates the saved unsynchronized state to a synchronized state.
5. 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, causes the one or more processors to implement the method of any of claims 1-4.
6. A computer readable medium having stored thereon a computer program, wherein the program when executed by a processor implements the method of any of claims 1-4.
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 CN112989773A (en) | 2021-06-18 |
| CN112989773B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117094289A (en) * | 2022-05-11 | 2023-11-21 | 北京字跳网络技术有限公司 | Method, device, system, electronic equipment and storage medium for controlling data block |
Citations (7)
| 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 |
| 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 |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9684646B2 (en) * | 2014-08-05 | 2017-06-20 | Apple Inc. | Reference representation and transformation in collaborative documents |
| US11741300B2 (en) * | 2017-11-03 | 2023-08-29 | Dropbox, Inc. | Embedded spreadsheet data implementation and synchronization |
| US10437923B2 (en) * | 2017-11-03 | 2019-10-08 | Dropbox, Inc. | Collaborative spreadsheet embedding and management |
-
2019
- 2019-12-13 CN CN201911283801.2A patent/CN112989773B/en active Active
Patent Citations (7)
| 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 |
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112989773A (en) | 2021-06-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP4033374A1 (en) | Method and device for synchronizing node data | |
| CN109951331B (en) | Method, device and computing cluster for sending information | |
| EP2596425B1 (en) | Membership tracking and data eviction in mobile middleware scenarios | |
| CN109447635B (en) | Information storage method and device for block chain | |
| US12008556B2 (en) | Method and apparatus for executing smart contract | |
| CN113032412B (en) | Data synchronization method, device, electronic equipment and computer readable medium | |
| EP2603867B1 (en) | Sharing data on mobile devices | |
| CN104115142A (en) | Device specific folders for bookmarks synchronization | |
| CN110704000A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN109471647B (en) | Data updating method and device, electronic equipment and readable medium | |
| CN111858381B (en) | Application fault tolerance capability test method, electronic device and medium | |
| CN110990038B (en) | Method, apparatus, electronic device and medium for applying local update | |
| CN112989773B (en) | Method, apparatus, device and computer readable medium for synchronizing update data | |
| CN112084254A (en) | Data synchronization method and system | |
| CN111338827B (en) | Method and device for pasting form data and electronic equipment | |
| CN110750424B (en) | Resource inspection method and device | |
| US10097613B2 (en) | Systems and methods for enhancing performance of resource state polling | |
| CN111596992A (en) | Navigation bar display method and device and electronic equipment | |
| CN111177260A (en) | Database remote copying method and device and electronic equipment | |
| CN111159179A (en) | Table partitioning method, related device and computer readable storage medium | |
| CN110727694A (en) | Data processing method and device, electronic equipment and storage medium | |
| WO2022017458A1 (en) | Data synchronization method and apparatus, electronic device, and medium | |
| CN112817701B (en) | Timer processing method, device, electronic equipment and computer readable medium | |
| CN110851192B (en) | Method and device for responding to degraded switch configuration | |
| CN118069468B (en) | Replication state machine monitoring method, apparatus and computer 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 |