Hi guys,
how do you mimic an excel line feed (ALT+ENTER) in a websheet cell while typing in text?
OR
if I can't add one directly while typing, has anyone tried an Action Button to add a CHAR(10) into text in a given cell - does it work or does TM1Web hate linefeeds altogether?
Line feeds (ALT+ENTER) in websheet cells?
-
Thirsty Brick
- Posts: 3
- Joined: Wed Jan 21, 2009 9:30 pm
-
lotsaram
- MVP
- Posts: 3652
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Line feeds (ALT+ENTER) in websheet cells?
Hi Thirsty,
Interesting one. I just tested this and could get it to work in Excel but when viewed on the web the line breaks were ignored. I guess this the same scenario you have. There wasn't even a box place holder for non-displayable characters. Looks like TM1 web just ignores non-displayable characters period.
I guess making the cell the max size you think you will need and formatting to wrap is not quite what you need, not sure if you have any other options though ...
Interesting one. I just tested this and could get it to work in Excel but when viewed on the web the line breaks were ignored. I guess this the same scenario you have. There wasn't even a box place holder for non-displayable characters. Looks like TM1 web just ignores non-displayable characters period.
I guess making the cell the max size you think you will need and formatting to wrap is not quite what you need, not sure if you have any other options though ...