84020999616 TM1 Web 9.1.4 Websheets Don't Honour Line Breaks
Posted: Fri Aug 28, 2009 12:31 am
As submitted. The attempts at adding a line break via the Char() function weren't expected to work, but had to be tried...
How is this problem impacting your business?
Unable to create presentation websheets without breaking content into separate cells. This in turn creates an unnecessary amount of formatting work.
Problem Description
In Excel you can insert a line break in a cell (stored in the cell as a Char(10) character) by pressing [Alt]+[Enter] while in cell edit mode.
If a workbook is stored as an application, the line break will be visible when you open the application in Excel. See the attached file ApplicationSheet.jpg. In a Websheet, the line break is ignored. See the attached file websheet.jpg. We have found this behaviour in 9.1.4, but others have reported it in 9.4 as well. (http://forums.olapforums.com/viewtopic.php?f=3&t=1430)
Could this please be corrected.
Thank you.
How is this problem impacting your business?
Unable to create presentation websheets without breaking content into separate cells. This in turn creates an unnecessary amount of formatting work.
Problem Description
In Excel you can insert a line break in a cell (stored in the cell as a Char(10) character) by pressing [Alt]+[Enter] while in cell edit mode.
If a workbook is stored as an application, the line break will be visible when you open the application in Excel. See the attached file ApplicationSheet.jpg. In a Websheet, the line break is ignored. See the attached file websheet.jpg. We have found this behaviour in 9.1.4, but others have reported it in 9.4 as well. (http://forums.olapforums.com/viewtopic.php?f=3&t=1430)
Could this please be corrected.
Thank you.