TM1 Forum

I'm being driven to distraction by the difference between the Browser and Excel.

In Perspectives Excel, I make an Active Form. It is a thing of beauty. I have the column widths set such that there is plenty of room for the numbers. It looks great in Excel.
But when I view it in the browser, large numbers frequently fill the column width, resulting in a display of ##########.

In Excel, the same number (say 1,000,000) appears to have 30% more column width than necessary. but in the browser the column isn't big enough.

I assume this has something to do with the fonts used by Excel vs the Browser. Is there anything that can be done to make the two delivery mechanisms see eye-to-eye on this?

Your assumption is right Excel and TM1Web give different results. This is because TM1Web has to render the Excel spreadsheet into XML. After this rendering you will see some differences in the web browser.

If you see #### for the large numbers in that case you can leave some extra width in Excel or else you can use a smaller font.

Also make sure you do not have any hidden columns within the Active Form itself as the hidden columns within the AF sometime do result in some differences between excel and web.