How to remove the cell background color in a MS Excel exported report

Williams

unread,

Dec 15, 2011, 3:29:27 PM12/15/11

to FastReport for [x]Harbour, Alaska Xbase++, Visual FoxPro

Hello Sergey

When I export my report to MS Excel, the cell background color takes a
white color. I see that in MS Excel through the cell format property.
Fortunately I can fix it to NO COLOR
Can I export the report from Fast Report to MS Excel with no color in
the cell background color?

Thanks

WP

Spirin Sergey

unread,

Dec 15, 2011, 5:30:01 PM12/15/11

to FastReport for [x]Harbour, Alaska Xbase++, Visual FoxPro

Hello, Williams,

I'm not a great expert in Excel. However, in order, what version of
the FR and what export are you using?

Generally, in Excel cells can not cross, so what you want to see at
the transparent cell? :)

I did a couple tests, BIFF-export everything correctly. At XLS on my
computer clWhite = clNone, but when FastExport = True they are both
transparent in Excel, but when FastExport=False, both are white.

---
Sergey Spirin.
FastReport for Xbase-family languages,
http://www.spirins.com

Williams

unread,

Dec 17, 2011, 8:49:45 AM12/17/11

to FastReport for [x]Harbour, Alaska Xbase++, Visual FoxPro

Ok Sergey

I have Fast Report 4.11.6 and I was doing export to XML because.
That´s my mistake. Now I do export to XLSExport and wverything goes
right
Right now I don´t remember why I choose XMLExport
So I want to thank you for your help