on 04-06-2016 11:18 AM
Hi all,
Ive got a case on my webi.
There's a column contain row text like :
for example in 1 row :
Col A Col B
Company A | Bicycle | 200
January Company B | Car | 300
Company C | Train | 230
So the column contain wrap text (which already programmed and logically code from database) , example above is in one row, but unfortunately when i export it to excel, sometimes not all row wrapped.
If above example only 3 row text in one row data is ok, the row that not wrapped contain much text like 30row text in one row data.
Example case like this :
Col A Col B
February Company D | Motorcycle | 210Company E | Car | 320Company F | Monorail | 210Company G | Bus | 270
Is there any configuration in cmc for this?
Thanks.
Setiawan Ang
Hello Setiawan,
Please refer to link below for the best practice of using Excel O/P. It has all the options that you may try.
Regards
Niraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It is quite evident that you have tried to take care of wrapping at database level but has it been taken care at Webi level?
The formatting done at Webi level gets transferred to Excel.
Right click on Col B column --> Format Cell --> General tab --> Wrap Text.
Save this report in Webi and then try saving it as an excel and check.
Regards,
Yuvraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.