Export to Excel - Extra Blank Columns

server administration Web Intelligence 6.x Servers
1

Hi, my users are using webi 6.1 and when they export to excel they get an extra blank column at the end of the data. We’ve tried changing the report page layout margins to 0.0. I’m pretty sure the answer is ‘thats how it works’ but would like to know for sure

Thanks

haggama (BOB member since 2005-03-21)

2

Hi,

Export to Excel under 6.1 is not working correctly ! they change the export engine under release 6.5 due to these problems !

To cope with this problem i used a macro to delete unwanted blanks, lines between sections …

Regards

3

Hello,

Export to Excel on 6.5.1 has the same Bug.

Marc

Marc Beyrich :de: (BOB member since 2004-07-21)

4

I still have this problem in BO6.5.1.

When I export my DP to excel, some lines are split up into 2 lines, other’s are not…

Has someone any idea how this can be resolved?

KR

Dubbe :belgium: (BOB member since 2004-12-30)

5

Hi all,

I though you had to cope with the same problem like the one i describ in this topic.

Regards

6

fyi…I had similar issues and I open a case with BO support and here is what they said “there are known issues with Save to Excel from 6.5
and will be talking with one of the Product Group guys and discuss”

I will update the post when i get any reply

thanks
anan

maanan (BOB member since 2003-01-30)

7

Try the following link, it contains the answers to correctly formatting reports that will not cause duplicate/blank/extra columns when exporting to excel. This, of course, is not meant as a GLOBAL fix-all, but may help others in most situations.

http://www.boomerang.businessobjects.com/data10/2878/5353.pdf

Hope this helps!

boojee :us: (BOB member since 2003-09-26)

8

This is just what I was looking for-- except, I’m in 6.1. Is there an equivalent document for that version?

TIA,
Steve

Steve Aultman (BOB member since 2003-07-22)

9

Steve,

Most of the recomdation such as specific sizing … no overlapping, avoiding image…keeping in cells of excel while designing report are indeed excel specific and it is valid since BO 4.x.( in nutcell it will work for all the versions including macro with few exceptions) :idea: :mrgreen: :idea:

BOBurao (BOB member since 2005-09-20)