Copy/ Paste issues in TM1 web -  
Posted: Thu May 26, 2011 1:30 pm
Hi,
I have the following issue.
I am copying a number of cells from a regular excel sheet into a TM1 web sheet. There are no formulas on the cells that I am copying the data to.
Now the weird thing is that the copied values get added to it.
So when I copy 'A310' from the excel sheet and paste it in the websheet, what I actually get in the websheet is 'A310 '
Now I found in wikipedia that this is apparently the representation of a non breaking space character.
(http://en.wikipedia.org/wiki/Non-breaking_space)
The effects seem fairly limited as well as as soon as I refresh the websheet the   part disappears. Similarly only the non ' " part is sent to the server (by dbs formulas on another part of the sheet).
So everything actually seems to be working as it should but I will have a hard time explaining this to the end-users.
Therefore: anyone know how to prevent this from happening?
Also: although the excel sheet was made on a french version of excel and on the webserver excel is in french as well as are the regional settings I get some unintended translation to English.
I.e. I have a few formulas on there =SI(condition, 'VRAI', 'FAUX'). If I open the excel sheet in perspectives (even directly on the server) it shows me that as well. If I open it in TM1web though I get 'FALSE' and 'TRUE' as results though. (Although everything else in TM1 web is in french - included the upper toolbar).
This is all on version 9.5.1
Jeroen
I have the following issue.
I am copying a number of cells from a regular excel sheet into a TM1 web sheet. There are no formulas on the cells that I am copying the data to.
Now the weird thing is that the copied values get added to it.
So when I copy 'A310' from the excel sheet and paste it in the websheet, what I actually get in the websheet is 'A310 '
Now I found in wikipedia that this is apparently the representation of a non breaking space character.
(http://en.wikipedia.org/wiki/Non-breaking_space)
The effects seem fairly limited as well as as soon as I refresh the websheet the   part disappears. Similarly only the non ' " part is sent to the server (by dbs formulas on another part of the sheet).
So everything actually seems to be working as it should but I will have a hard time explaining this to the end-users.
Therefore: anyone know how to prevent this from happening?
Also: although the excel sheet was made on a french version of excel and on the webserver excel is in french as well as are the regional settings I get some unintended translation to English.
I.e. I have a few formulas on there =SI(condition, 'VRAI', 'FAUX'). If I open the excel sheet in perspectives (even directly on the server) it shows me that as well. If I open it in TM1web though I get 'FALSE' and 'TRUE' as results though. (Although everything else in TM1 web is in french - included the upper toolbar).
This is all on version 9.5.1
Jeroen