Copy/ Paste issues in TM1 web - &nbsp

[Jeroen Eynikel]

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 &nbsp part disappears. Similarly only the non '&nbsp" 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

[moby91]

What web browser are you using ?
MSIE ?
Or Firefox ?
Does it make a difference if you are using the other web browser ?

[moby91]

This seems to be a known issue logged as APAR PM21809:

PM21809: Extra characters are added into TM1 Web when Copy and Paste from Excel

Error description:
The customer has used TM1 9.5.1
&nbsp is added into the TM1 Web when the content of excel is copied and pasted



The Hotfix 10 for TM1 9.5.1 includes a hotsite addressing the APAR PM21809:

http://www.tm1forum.com/viewtopic.php?f=3&t=3142
9.5.1 Hotfixes

Hotfix 10 for TM1 9.5.1 (aka TM1 9.5.1 HF10), 09-DEC-10 (?)

Applies to: x86 (client, server, web) & x64 (server & web)

PM21809 Extra characters are added into TM1 web when copy and paste from Excel

[Jeroen Eynikel]

This seems to be a known issue logged as APAR PM21809:

Moby Thanks a lot for the info.