[PA Express 2.0.6] [TM1Web] websheets: number format corrupted

[Patrick Gr]

Hello Community
I have moved my model from TM1 10.2.2 to PA Express 2.0.6. I noticed that data on websheets doesn’t display properly in web browser (Chrome and IE) as shown in the pictures. The number format has changed in terms of decimals.

Illustration.png (56.62 KiB) Viewed 4576 times

What would be the cause? How to fix it?
About hundreds of web sheets are concerned. Is there a specific configuration that I’m missing?
Thank you again for your time and help.

[tomok]

What number format are you using in Excel, General? Make sure you select the proper number format in Excel then republish.

[orlando]

Hi Patrick,

that's a problem of PA 2.06, if you don't use english as first language in your browser - we had the same issue until we moved to 2.07

https://www-01.ibm.com/support/docview. ... wg27049229
PH05317 SINCE 2.0.6 LOCALIZED NUMBER FORMATTING IN WEBSHEETS IS BROKEN

I've heard that there is a hot fix available (if you can't move to 2.07) - you should ask IBM for it.

Best regards
orlando

[Patrick Gr]

@tomok: When verifying in Excel, the cells are set to number format with 0 decimals. The display in Excel is good. I replublished to web and still same issue.
@Orland: there is no 2.0.7 version on Express. I will check with IBM if there is a specific Fix Pack for that.

Thank you all!

[orlando]

@Orland: there is no 2.0.7 version on Express. I will check with IBM if there is a specific Fix Pack for that.

Let us know what IBM said

[Patrick Gr]

From IBM:
"PH05317 SINCE 2.0.6 LOCALIZED NUMBER FORMATTING IN WEBSHEETS IS BROKEN
This is fixed in 2.0.7
Please upgrade"

[orlando]

From IBM:
"PH05317 SINCE 2.0.6 LOCALIZED NUMBER FORMATTING IN WEBSHEETS IS BROKEN
This is fixed in 2.0.7
Please upgrade"

so, there is a PA Express Version 2.07 - or can u use the normal install files?

[Patrick Gr]

Sorry for the late reply... I've upgraded to 2.0.8 (There is no 2.0.7 in Express)