Sheet Visibility not working for xvExcel97 version

[GenasysCarl]

Hi,

When I try to hide sheets on the old XLS format, it is still visible in the workbook when I view it. Visibility only seems to work for XLSX format.

Code: Select all

XLS.Version := xvExcel97;
Sheet := XLS.Add;
Sheet.Visibility := x12vVeryHidden; //I also tried x12vHidden.
XLS.SaveToFile('Test.xls');

Regards,
Carl

[larsa]

Hello

This is fixed in update 6.00.10