84020999616 TM1 Web 9.1.4 Websheets Don't Honour Line Breaks

Post bug reports and the status of reported bugs
Post Reply
User avatar
Alan Kirk
Site Admin
Posts: 5724
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

84020999616 TM1 Web 9.1.4 Websheets Don't Honour Line Breaks

Post by Alan Kirk » 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.
ApplicationSheet.jpg
ApplicationSheet.jpg (55.66 KiB) Viewed 1462 times
In a Websheet, the line break is ignored. See the attached file websheet.jpg.
Websheet2.jpg
Websheet2.jpg (74.29 KiB) Viewed 1462 times
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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

User avatar
Alan Kirk
Site Admin
Posts: 5724
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

Re: 84020999616 TM1 Web 9.1.4 Websheets Don't Honour Line Breaks

Post by Alan Kirk » Fri Aug 28, 2009 4:37 am

Response from IBM Support:
I found the issue you've reported for carriage returns in Excel was reported as a defect in tm1_9.4 tm1 mr1.

I can see that the defect is targeted to be fix in 9.5 which is expected to be out in 3rd quarter of 2009.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

Post Reply