Skip to Content
author's profile photo Former Member
Former Member

Cell formatting when saved as Excel file

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 19, 2008 at 10:50 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2008 at 05:01 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.