Pivot Table Module Decouples Data From Spreadsheet Formulas
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Pivot tables implemented using array formula capabilities in spreadsheet applications are prone to errors and lack flexibility in style settings and exception condition handling, making them difficult to manage and display effectively.
Innovation Solution
A method and apparatus that determine whether a cell is within a pivot table region, using a separate pivot table module to store and retrieve data, allowing independent operation from the spreadsheet's formula capabilities, enabling direct data acquisition and rendering without relying on the spreadsheet's formula capabilities, and supporting advanced style settings by merging pivot table and spreadsheet styles.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of manufacture
If pivot tables are implemented using array formula capabilities in spreadsheet applications, then the pivot table function can be executed through existing formula mechanisms, but the system is prone to errors and difficult to support various style settings and exception conditions
Solution Approach 1:
The patent separates the pivot table rendering logic from the spreadsheet formula system by introducing a dedicated pivot table module. This module independently handles pivot table data processing, style settings, and exception conditions, preventing errors from propagating between systems while maintaining implementation simplicity through modular architecture.
Solution Approach 2:
The patent introduces a proxy mode with a dedicated pivot table module that acts as an intermediary between the spreadsheet system and pivot table functionality. This mediator layer handles style settings and exception conditions separately, allowing the pivot table to operate with its own error handling mechanisms while still integrating with the spreadsheet display.
2Device complexity
If pivot tables depend on spreadsheet formula capabilities to render data, then the integration is simple, but the system lacks flexibility in style settings and exception condition determination
Solution Approach 1:
The patent divides the system into independent pivot table module and spreadsheet module, each with dedicated rendering logic. The pivot table module maintains its own style settings and exception handling capabilities without being constrained by spreadsheet formula limitations, achieving both simplicity and flexibility through separation of concerns.
Solution Approach 2:
The patent adds a new dimension to the system architecture by introducing a separate pivot table module that operates parallel to the spreadsheet formula system. This additional layer provides enhanced style settings and exception handling capabilities while maintaining the original spreadsheet functionality, effectively solving the flexibility problem without increasing integration complexity.
3Productivity
If pivot table data is rendered through spreadsheet formula capabilities, then the data flow follows the existing spreadsheet processing pipeline, but this causes memory consumption and flow blocking issues
Solution Approach 1:
The patent separates pivot table data processing from the spreadsheet formula evaluation pipeline by creating an independent rendering path. This dedicated pivot table module processes and renders data directly without consuming spreadsheet formula resources, eliminating memory conflicts and flow blocking while maintaining efficient data processing through specialized handling.
Data Source
AI summary
A method, an apparatus, an electronic device and a storage medium for processing table data include determining whether a first cell of a spreadsheet is located in a pivot table region; if the first cell is located in the pivot table region, determining a value of the first cell based on a pivot table module, which is configured to store information of a pivot table in the spreadsheet; if the first cell does not belong to the pivot table region, determining a value of the first cell based on data stored in the spreadsheet itself. Data of the pivot table is connected to the spreadsheet with a proxy mode. The two independent functions of the pivot table and the spreadsheet are combined, so that data can be directly acquired from the pivot table module and rendered on the spreadsheet without depending on a formula capability of the spreadsheet itself.