OOXML Spreadsheet Fragmentation for Mobile Rendering
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Electronic documents in XML-based formats, such as OOXML, often exceed the display capabilities of mobile devices, leading to poor rendering or browser crashes due to insufficient CPU power and memory, especially when containing large tables or graphics.
Innovation Solution
A method and system that splits electronic documents into smaller pieces based on predetermined dimensions, storing geometric information to facilitate conversion from OOXML to HTML or SVG formats, allowing for smoother display on devices with limited resources.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If the electronic document is converted to HTML format for web presentation, then the document can be displayed on various devices including mobile devices, but the document may cause browser crashes or hang on mobile devices due to insufficient CPU power and memory
Solution Approach 1:
The patent divides the electronic document into multiple smaller regions or fragments, each representing a portion of the original document. This segmentation allows mobile devices to process and display smaller, more manageable portions individually, reducing the computational burden on the device's CPU and memory while maintaining the ability to present the complete document through coordinated display of all regions.
2Loss of information
If the electronic document contains large tables or graphics, then the document provides comprehensive information and visual quality, but the document exceeds the display capabilities of mobile devices
Solution Approach 1:
The patent segments the document content into multiple regions that can be processed separately. Each region contains a subset of the original document's information, allowing mobile devices to handle smaller data portions while the system collectively preserves all original information across multiple regions. This approach maintains information completeness while adapting to limited device display capabilities.
Solution Approach 2:
The patent introduces a new dimension of organization by dividing the document into multiple regions that can be displayed in a grid or sequential arrangement. This dimensional transformation allows the system to manage large amounts of information by distributing it across multiple smaller display units, effectively converting a single large document into a multi-region structure that fits within mobile device constraints.
3Ease of operation
If the document is split into smaller pieces, then the document can be displayed on devices with limited resources, but the conversion process becomes more complex
Solution Approach 1:
The patent performs preliminary actions by pre-defining region boundaries and organizing document content into structured regions before the actual conversion to HTML. This preliminary organization includes determining the geometric relationships and display order of regions, which simplifies the subsequent conversion process. By preparing the document structure in advance, the system reduces the complexity of the conversion operations that need to be performed on the mobile device.
Data Source
AI summary
A method for converting an electronic document (ED) having a first format includes comparing an original width of the ED with a predetermined width and an original length of the ED with a predetermined length; splitting the ED into pieces in a width direction when the original width is greater than the predetermined width, and splitting the ED into pieces in a length direction when the original length is greater than the predetermined length, wherein each piece has a width and length less than or equal to the predetermined width and length; storing information representing geometric relationships of the pieces; converting the pieces from the first format into a second format; outputting the converted pieces as first output EDs; and outputting a second output ED having the second format, wherein the second output ED incorporates the first output EDs according to the information when displayed by a viewer application.