sheets hiding

danieli · Post by **danieli** » Fri Dec 21, 2007 1:56 pm

if you put in hide the first sheet: Xls.Sheet[0].Hidden := hsHidden,
and then open it in Excel, and press "go to first sheet" arrow (the button at bottom on the left using for navigating in the tabsheet) Excel will crash.

Tested with component version 3.01.05, Office 2003

Post by **larsa** » Tue Jan 01, 2008 9:03 pm

Hello

If you set the first sheet as hidden, you must also change all other things that depends on the first sheet, such as visible tab, visible sheet etc.

Lars Arvidsson

danieli · Post by **danieli** » Tue Jan 15, 2008 2:33 pm

Could you please explain in more detail. Which properties are depends of it? I found only one similar to that property - Workbook.SelectedTab. But setting of it does not solve problem.

Also I would like to note that it is not good if setting of one property can destroy file. It means that there is something behind the scene that I have to keep in the mind. Always will have a risk to forget it and make trouble for my end user product. And now should not trust to other properties also...