Online Spreadsheet Batch Editing Data Synchronization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
When multiple users edit an online spreadsheet simultaneously, inconsistencies often arise between the content displayed and the users' operations, particularly during batch editing, leading to inefficiencies in data processing and synchronization.
Innovation Solution
A method and apparatus that acquire editing data from multiple cells, construct a message body using target arrays to represent attribute values, and send this data to a server, optimizing data processing by reducing the number of message bodies and improving synchronization efficiency.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If multiple message bodies are sent for each cell editing operation, then data synchronization accuracy is improved, but server processing load and data transmission volume increase
Solution Approach 1:
The patent combines multiple cell editing operations into a single message body for batch transmission to the server. Instead of sending separate messages for each cell edited, the system aggregates all editing operations within a selection area into one consolidated message, reducing the total number of message bodies transmitted and improving server processing efficiency while maintaining data synchronization accuracy.
Solution Approach 2:
The patent segments the message body into a structured format containing an array of cell data, where each cell's editing information is organized as a discrete element within the array. This segmentation allows the server to efficiently parse and process individual cell operations within the batch message, maintaining reliability while improving processing speed.
2Loss of information
If detailed editing data for each cell is transmitted separately, then data completeness is improved, but data transmission volume and network bandwidth consumption increase
Solution Approach 1:
The patent merges editing data from multiple cells into a single message body with a structured array format. This consolidation reduces the overhead of multiple separate transmissions while preserving all necessary editing information for each cell, thereby maintaining data completeness while reducing total transmission volume.
Solution Approach 2:
The patent changes the data structure parameter from individual cell messages to a batch array structure. By organizing cell editing data as elements within a single message array, the system reduces redundant transmission protocols and headers, decreasing overall data transmission volume while maintaining complete editing information.
3Manufacturing precision
If batch editing operations are processed individually, then processing accuracy is improved, but editing efficiency and user experience deteriorate
Solution Approach 1:
The patent performs preliminary actions by collecting and organizing all cell editing operations within the selection area before transmitting to the server. The system prepares the complete batch of editing data in advance as a structured array, ensuring all necessary information is gathered and validated before processing, which maintains accuracy while enabling efficient batch processing that improves editing efficiency.
Data Source
AI summary
The present disclosure provides a method for processing an online spreadsheet, including: acquiring, in response to an editing operation triggered for the online spreadsheet, an editing area corresponding to the editing operation, in which the editing area includes a plurality of cells; acquiring editing data corresponding to the plurality of cells, in which the editing data includes attribute values respectively edited for each cell of the plurality of cells; obtaining a message body according to the editing data; and sending the message body to a server.