Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE XLSX Export Missing Spaces b/w the Data

Received Response
1
Views
1
Comments
User_QTT7B
User_QTT7B Rank 1 - Community Starter

When I am exporting OBIEE report to XLSX format, the download is missing spaces from the data. eg. actual data is 'ABC    123', exported output comes like 'ABC 123'. Instead of 5 spaces, excel shows me only one space.

However when exporting to .csv format, i get data intact with 5 spaces.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    1638468 wrote:When I am exporting OBIEE report to XLSX format, the download is missing spaces from the data. eg. actual data is 'ABC 123', exported output comes like 'ABC 123'. Instead of 5 spaces, excel shows me only one space. However when exporting to .csv format, i get data intact with 5 spaces.

    1.) "OBIEE report"is a contradiction in terms. It's either

    a) OBIEE analysis

    b) BI Publisher report

    Two different objects. Two different technologies.

    2.) Which version on which OS?

    Please write questions with a minimum of quality: