The problemLet's suppose that we have a column with fixed number of decimal points (in this case 2 decimals):
When you want to export data from answer report to Excel, you do that through link placed at bottom of the page.
Result is classical Excel file. In this case after opening, monitored value looks like:
CauseYou might think that problem is in OBI and it's functionality-but it is not! For proving this here are steps that shows that:
- Open Notepad, and write 1,25000 (1.25000 if different Regional Setting)
- Select that value and copy value in Windows clipboard
- Open new Excel worksheet
- Paste value from clipboard-you get 1,25 (1.25) zeroes are gone
The solutionThe solution was found From HTML to Excel blog post. Translated to OBI syntax, it is performed in a way that you change CSS style of problematic column property:
part which is written under "Use Custom CSS Style" option.
If you run export now, in Excel worksheet, zeroes are saved:
The EndBut when you run the same Excel file on Excel 2003 or 2007 client, you'll notice problems in columns where decimal and integer values are mixed. In such a column integer values on mentioned Excel versions will be shown a date values in format "mon-yy" (i.e. Jan-11).
For that problem I do not have solution in this moment.