Dynamic Text Positioning in Merged Table Cells

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Current techniques for displaying tabular data fail to ensure that text in merged cells remains visible next to corresponding data in other columns or rows when scrolling, leading to visibility issues.

Innovation Solution

Retrieving table parameters such as size of invisible cells, merged cells, display window size, and text size to calculate the position of text in visible merged cells and display it accordingly based on the scroll bar position.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If text in merged cells is aligned at the top or middle of merged cells, then the text alignment is simple and consistent, but the text may not be visible next to corresponding data when scrolling through the window

Engineering Contradiction:
Improvetext alignment simplicityVSAvoidtext visibility
Core Design Contradiction:
Ease of operationVSLoss of information

Solution Approach 1:

The text position in merged cells is made dynamic rather than static. The text automatically adjusts its position within the merged cell based on the scroll bar position and the position of corresponding data in other columns or rows. This ensures the text remains visible next to its corresponding data throughout scrolling operations while maintaining simple alignment logic through automated calculation.

Inventive Principle:
Principle #15Dynamics

2Quantity of substance

If the table size is greater than the display window size, then more data can be displayed, but the text in merged cells becomes invisible when scrolling

Engineering Contradiction:
Improvedata capacityVSAvoidtext visibility
Core Design Contradiction:
Quantity of substanceVSLoss of information

Solution Approach 1:

The system implements feedback by continuously monitoring the scroll bar position and the position of corresponding data in other columns or rows. Based on this feedback, the text position within merged cells is automatically adjusted to ensure visibility. This creates a closed-loop system where text positioning responds to scrolling actions in real-time, maintaining text visibility throughout the entire table regardless of its size relative to the display window.

Inventive Principle:
Principle #23Feedback

3Loss of substance

If merged cells are used to represent common data across multiple cells, then data redundancy is reduced, but text visibility next to corresponding data is compromised

Engineering Contradiction:
Improvedata redundancyVSAvoidtext visibility
Core Design Contradiction:
Loss of substanceVSLoss of information

Solution Approach 1:

The text in merged cells dynamically repositions itself based on the visible position of corresponding data in other columns or rows. This dynamic positioning ensures that the merged cell text remains visible next to its corresponding data throughout scrolling operations, preserving the information association benefit of merged cells while eliminating the visibility problem.

Inventive Principle:
Principle #15Dynamics

Data Source

PatentUS8782510B2Cell content scrolling
Publication Date: 2014.07.15 SAP IRELAND LTD
  • US8782510B2 patent drawing
  • US8782510B2 patent drawing
  • US8782510B2 patent drawing

AI summary

Disclosed are methods and systems for cell content alignment. The methods and systems involve retrieving one or more table parameters, the one or more table parameters including size of currently invisible cells in a display window, size of merged cells, the display window size and text size in the merged cells, calculating a position of a text in a visible portion of merged cells based on the table parameters and displaying the text in the merged cells based on the calculated position of the text.