Cell formatting when saved as Excel file

[Former Member]

Hello, I am using Business Objects XIr2 (both Webi and Deski) and when I am saving a report as an excel file the cell formatting is not staying the same. In my report, I have the Vertical justification set to Bottom and Word Wrap turned off, but when the report is opened in excel, the vertical justification is set to Center and Word Wrap is turned on. Any ideas on how to force Excel to keep the formatting of the report?

Thanks

Katie

[Former Member]

Hi Katie,

Could you please update the Exact version of Ms Excel and the

Business Objects version with fix packs installed.

Ms Office Excel 2003 SP3 is not supported with any of the Service pack of business Objects.(SP1

SP2 Sp3 as well as SP4). It could give many issues if used.

Regards,

Chaitanya Deshpande

[Former Member]

Hi Katie,

According to the description provided by you I tested the issue in following environments.

1. BOXIR2 SP2 SP3 FP3.6.

2. BOXIR2 SP2 SP3 SP4 FP4.2

I found that issue is replicable on all the above mentioned environments.

Issue is replicable because of the following reason.

1. DAO properties of MS Office by default converts the vertical alignment to centre irrespective of whether you keep it bottom or top in deski.

2. By default MS excel vertical alignment settings is centre that is why it is giving you

centre.

3. However, about the word wrap it was still off when I exported the report to excel.

I used MS office 2003 to test the issue.

Regards,

Sarbhjeet