If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Merged cells in Excel

Started by Nail, 23 Sep 2009 06:17:42 PM

Previous topic - Next topic

Nail

We have a report that creates a spreadsheet.  One of the data items in the spreadsheet is a text comment that can have quite a few characters.  Somehow, during the creation of the spreadsheet, these comments don't wordwrap but rather create and fill merged cells.  No grouping or other formatting is done by us that would cause this.  It appears that Cognos is doing it as some kind of default. 

Is this so?  Is there a way to prevent it ?

karthikeya

take a table arrange u r list report in that table now insert a text label within the table..
it will work for sure.

Gopinath

set the White Space property of the field to No Wrap

afzaki7

put you data items into a blocks will prevent merging the rows in Excel

1- unlock the list or the cross tab
2- put a block for each data item then put data item into it

" إِذَا مَاتَ ابْنُ آدَمَ انْقَطَعَ عَمَلُهُ إِلا مِنْ ثَلاثٍ : مِنْ صَدَقَةٍ جَارِيَةٍ ، أَوْ عِلْمٍ يُنْتَفَعُ بِهِ ، أَوْ وَلَدٍ صَالِحٍ يَدْعُو لَهُ "