IBM Support

Cell formatting extends beyond some cells in TM1 Web

Troubleshooting


Problem

Report formatting in TM1 Web does not reflect the same report format as seen in TM1 Perspectives. In some cases where cells are dynamically merged, formatting expands beyond cells and into the next cell.

Symptom

You will notice that the same report appears differently in TM1 Web and TM1 Perspectives. 
In TM1 Web, observe that there is incorrect formatting in the dynamically merged cells.  Open the same report in TM1 Perspectives, and you will see the correct/expected format with correct formatting.
The following image shows the incorrect cell formatting extending beyond the cell in TM1 Web.
image-20190522085406-1

Cause

The cells in question that cause this reporting inconsistency are dynamically merged. To perform this type of merge, TM1Web expands the cell by as many columns as necessary to accommodate the entire input, in effect increasing the width of the original cell. This causes the style and format of cells, which the "merged" cell overlaps, to be hidden by the styling of the cell.

Environment

Planning Analytics 2.0.6 and Planning Analytics 2.0.7

Resolving The Problem

To overcome this issue, the cells in the text area must be manually merged.
Merging these cells and republishing the workbook resolves this issue.

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"TM1 Web","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.0.6;2.0.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
22 May 2019

UID

ibm10884390