Spreadsheet Helper Object for Cell-Level Change Tracking
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current technologies face challenges in managing and tracking complex spreadsheet applications, particularly in maintaining data integrity and version control across multiple users and decentralized systems, due to limitations in existing Enterprise Document Management systems and lack of integration with Source Code Management systems.
Innovation Solution
The solution involves treating spreadsheets as application building tools by leveraging Source Code Management (SCM) systems to manage spreadsheet content and activity, using an embedded helper object to intercept and redirect native spreadsheet I/O processes, enabling comprehensive versioning and tracking of data values, formulas, and metadata within a spreadsheet grid.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If Enterprise Document Management systems are used to track spreadsheet changes, then basic version control is provided, but accurate cell-level change tracking and data integrity verification are insufficient
Solution Approach 1:
The patent introduces an intermediary component called a 'helper object' that acts as a bridge between the spreadsheet application and the version control system. This helper object intercepts I/O operations and communicates changes to the SCM system, enabling precise cell-level tracking without requiring the spreadsheet application itself to be complex. The intermediary handles the complexity of change detection and transmission, allowing the spreadsheet to remain simple while achieving precise tracking.
2Adaptability or versatility
If spreadsheets are shared across multiple users and decentralized systems, then collaboration is enabled, but data integrity and version control are compromised
Solution Approach 1:
The system implements feedback mechanisms where the helper object continuously monitors spreadsheet I/O operations and communicates changes back to the SCM system. This feedback loop ensures that all user actions are captured and recorded, maintaining data integrity even in decentralized collaboration environments. The SCM system receives real-time feedback about cell changes, formulas, and metadata, allowing it to maintain accurate version control across multiple users and systems.
3Ease of operation
If native spreadsheet I/O processes are used, then application functionality is maintained, but change interception and tracking are not possible
Solution Approach 1:
The helper object is installed and configured in advance within the spreadsheet application to intercept I/O operations before they occur. This preliminary setup allows the system to capture all cell changes, formula modifications, and metadata updates as they happen, preventing any loss of change data. The interception mechanism is pre-positioned to monitor all relevant operations, ensuring complete tracking while maintaining normal spreadsheet functionality.
Data Source
AI summary
An application data tracking, auditing and collaboration system and method are provided. The system and method may be used to track and manage spreadsheets, or similar documents, at the internal or grid level and allow for unlimited linking, consolidation, referrals, and lookups, or integration of any number of spreadsheets across any number of users across any level of security and deployment scenarios.