Exporting to Excel; Problem with DataTypes

[apexbs]

Hi All;

I am using CR 9.2 and I am exporting one of my report to Excel and having so many problems with formatting. One of the problem is there are few columns which are integer but when those columns are exported to Excel they have small Green Box with information icon on each cell of thoes columns and it says that you have to convert it to number. If I select all cells and click on information icon and select it to Convert to number then it is fixed. How can I prevent it when it is exported.


Thanks.

 

[synapsevampire]

Excel does some assumes data types, which is VERY annoying.
Make sure that the first row in the spreadsheet is the proper data type, that's what Excel assumes that the rest are.

Consider usign the data only export as well.

And make sure that you apply the service packs, they often address exporting concerns:

http://support.businessobjects.com/fix/hot/si75/default.asp

-k