cancel
Showing results for 
Search instead for 
Did you mean: 

Webi report export to excel cells are merging...

Former Member
0 Kudos

Hi All,

-Problem we are facing.. when webi report saved to excel , the cells are getting merged..

-In Webintelligence Preferences checked option setting Easy Data Processing into Excel ,some times it's working fine.

-Some times issue resolve by checking Wrap text and adding blank cells instead of vertical table ect.

- But Any common solution which globally applies to all the Reports.

-Please advise...

Sasi.M

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

If the report contains multiple blocks (header1,block 1, block2 etc.,), then the cell merging on downloading the webi report to excel takes place because of the following reason

If any cell in the report block (say header block) overlaps with a cell in another block then that cells gets merged/split in the Excel sheet.

Former Member
0 Kudos

Hi,

There is no common solution available. You have to make the adjustments individually in all web-i reports, that too using hit & trial.

Regards,

Rohit