BIFF is nill after clear

[zvasku]

Hello,

I'm using excel97 format. If I set excel version on form (in component) to xvExcel97 and I want to start using BIFF, the BIFF is always nil. Also this happens after Clear call. I have to set Version=xvExcel97 at runtime to solve this:

XLS.Clear;
XLS.Version:=xvExcel97; //to create BIFF

Is this by design or is it bug?

Thanks
Zdenek

[larsa]

Hello

It's by design.

[zvasku]

Ok. So Is setting Version at runtime right approach?