Page 1 of 1
numuric error when input a number in TM1 websheet
Posted: Tue Mar 03, 2015 3:04 pm
by wang_chris
TM1web reports numuric error when we try to input a number in the cell of websheet, the original value of this cell is 0, but due to the effect of no show of zero in excel setting, the cell seems in blank.
Same input works fine when the cell has a number before input.
How can we fix it?
Regards,
Chris
Re: numuric error when input a number in TM1 websheet
Posted: Tue Mar 03, 2015 5:28 pm
by tomok
I don't know the exact answer to tell you but I do know that the problem lies in the cell formatting you've applied to the cell in Excel. I've encountered this many times. You're just going to have to play with the formatting to get a setting that won't mess up when published in TM1Web.
Re: numuric error when input a number in TM1 websheet
Posted: Tue Mar 03, 2015 5:37 pm
by declanr
In addition to what tomok has said I've also seen this a lot of times but normally with date cells... TM1 Web and Date Formatting can be... "fun".
Never set number cells to show as a blank though; using dashes to represent zeroes has always worked fine for me.
Re: numuric error when input a number in TM1 websheet
Posted: Wed Mar 04, 2015 6:49 am
by wang_chris
Thanks, all.
When I changed the cell type to Accounting in excel, everything looks fine.