Page 1 of 1
[PA Express 2.0.6] [TM1Web] websheets: number format corrupted
Posted: Tue Sep 03, 2019 11:35 am
by 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 5413 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.
Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted
Posted: Tue Sep 03, 2019 11:44 am
by tomok
What number format are you using in Excel, General? Make sure you select the proper number format in Excel then republish.
Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted
Posted: Tue Sep 03, 2019 11:57 am
by 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
Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted
Posted: Tue Sep 03, 2019 12:04 pm
by 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!
Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted
Posted: Wed Sep 04, 2019 11:56 am
by orlando
Patrick Gr wrote: ↑Tue Sep 03, 2019 12:04 pm
@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
Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted
Posted: Mon Sep 09, 2019 2:05 pm
by 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"
Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted
Posted: Mon Sep 09, 2019 2:08 pm
by orlando
Patrick Gr wrote: ↑Mon Sep 09, 2019 2:05 pm
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?
Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted
Posted: Fri Sep 13, 2019 1:15 pm
by Patrick Gr
Sorry for the late reply... I've upgraded to 2.0.8 (There is no 2.0.7 in Express)