Page 1 of 1
sheets hiding
Posted: Fri Dec 21, 2007 1:56 pm
by danieli
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
Posted: Tue Jan 01, 2008 9:03 pm
by larsa
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
Posted: Tue Jan 15, 2008 2:33 pm
by danieli
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...