Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BIP report when exported in EXCEL, data from filled cells is moving to blank cells
User_CKBFD
Rank 1 - Community Starter
Few of the columns in Excel have blank cells (no data for those records). So, the column which has the data, it's values are shifting towards the cells which are blank and getting filled in there.
This makes the data inaccurate.
Please note that column I, J and K in Excel are a splited column in RTF(One column splitted into three via RTF)
Please please help!!!!!!!!!
0
Answers
-
0
-
Can you try setting the "Keep values in the column" - True under report properties → formatting → Excel 2007 output and try again?
Thanks.
0
