Troubleshooting
Problem
Using displayRichWithColourstringOf(res) function does not have correct formatting after exporting to Microsoft Excel
Diagnosing The Problem
On ‘Edit Layout DXL’ window, replace displayRichWithColourstringOf(res) with displayRichWithColour stringOf(res)" \t" and click on OK
- If data contains "onetwo", Microsoft Excel considers it as Text datatype and formats the cell to support ‘strikethrough’, ‘underline’ and ‘Normal font’
- If data contains "01", Microsoft Excel considers it as Number datatype and formats the cell to support only ‘strikethrough’
Resolving The Problem
As a workaround append " \t" at the end of "01", so Microsoft Excel considers it as Text datatype and formats the cell properly with rich text formatting.
[{"Product":{"code":"SSKR2T","label":"IBM Engineering Requirements Management DOORS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General Information","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.4;9.4.0.1;9.4.0.2;9.4.0.3;9.4.0.4;9.4.0.5;9.5;9.5.0.1;9.5.0.2;9.5.0.3;9.5.0.4;9.5.0.5;9.5.1;9.5.1.1;9.5.1.2;9.5.1.3;9.5.1.4;9.5.1.5;9.5.1.6;9.5.2;9.5.2.1;9.5.2.2;9.5.2.3;9.5.2.4;9.5.2.5;9.6;9.6.0.1;9.6.0.2;9.6.0.3;9.6.0.4;9.6.1;9.6.1.1;9.6.1.2;9.6.1.3;9.6.1.4","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
01 May 2020
UID
swg21991681