Hi everyone,
I recently migrated a Cognos report from Cognos 10 to Cognos 11 and I found an issue with the way Excel handles merged cells in a list.
Each column in the list has two data items, with the second item being in a block. In Cognos 10, if Column 1 is empty, only the value of Column 2 will appear in a single cell when exporting to Excel. But in Cognos 11, even if Column 1 is empty, an extra empty cell will be created and merged with the adjacent column.5
Has anyone else encountered this issue? Do you know how to fix it so that the Excel export works as before?
Thanks in advance!