save as excel problem

[Former Member]

Post Author: Marco Nardelli

CA Forum: Deployment

hi everyone

I'using BO 6.5.1 and I try to export different BO reports (about 200 rows) to excel 2000 SR-1.

But when I try to open the xls file it doesn't work.

I reduced the number of rows exported from BO and excel works fine.

At the end I reduced the BO report to the first 4 rows, because when I included the fifth row I got the problem.

So I thought I found the critical row - it can have a strange character

or something like that in one of its columns, I thought...

But if I export to xls a report with only this fifth rows it always works fine.

In this sense I found many critical rows

anyone can give me an explanation for this apparently strange behaviour?

thanks to everyone

ciao

marco

[Former Member]

Post Author: Patrick Walter

CA Forum: Deployment

BO has problems with the square brackets [ or ].

If your columns or data contain square brackets, the Excel export fails.

[Former Member]

Post Author: sreenivas

CA Forum: Deployment

Hi

you better to go macro's because it works fine.

you can script and export your mentioned path.

sreenivas