internal void SetSheetVisible(int index, TXlsSheetVisible Value) { //Wrong docs? the byte to hide a sheet is the low, not the high on grbit byte p = this[index].OptionFlags1; p = (byte)(p & (0xFF - 0x3)); //clear the 2 first bits; switch (Value) { case TXlsSheetVisible.Hidden: p = (byte)(p | 0x1); break; case TXlsSheetVisible.VeryHidden: p = (byte)(p | 0x2); break; } this[index].OptionFlags1 = p; }
internal void SetSheetVisible(int SheetIndex, TXlsSheetVisible Value) { FBoundSheets.BoundSheets.SetSheetVisible(SheetIndex, Value); //Window1[0].SetSheetVisible(Value); //NO! It would hid the full workbook! }