/* ==================================================================== Licensed to the Apache Software Foundation (ASF) Under one or more contributor license agreements. See the NOTICE file distributed with this work for Additional information regarding copyright ownership. The ASF licenses this file to You Under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed Under the License is distributed on an "AS Is" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations Under the License. ==================================================================== */ namespace HH.WMS.Utils.NPOI.HSSF.Record { using System; using System.Text; using HH.WMS.Utils.NPOI.Util; /** * Title: A sub Record for Extern Sheet * Description: Defines a named range within a workbook. * REFERENCE: * @author Libin Roman (Vista Portal LDT. Developer) * @version 1.0-pre */ public class ExternSheetSubRecord : Record { public const short sid = 0xFFF; // only here for conformance, doesn't really have an sid private short field_1_index_to_supbook; private short field_2_index_to_first_supbook_sheet; private short field_3_index_to_last_supbook_sheet; /** a Constractor for making new sub record */ public ExternSheetSubRecord() { } /** * Constructs a Extern Sheet Sub Record record and Sets its fields appropriately. * * @param in the RecordInputstream to Read the record from */ public ExternSheetSubRecord(RecordInputStream in1) { field_1_index_to_supbook = in1.ReadShort(); field_2_index_to_first_supbook_sheet = in1.ReadShort(); field_3_index_to_last_supbook_sheet = in1.ReadShort(); } /** Sets the Index to the sup book * @param index sup book index */ public void SetIndexToSupBook(short index) { field_1_index_to_supbook = index; } /** Gets the index to sup book * @return sup book index */ public short GetIndexToSupBook() { return field_1_index_to_supbook; } /** Sets the index to first sheet in supbook * @param index index to first sheet */ public void SetIndexToFirstSupBook(short index) { field_2_index_to_first_supbook_sheet = index; } /** Gets the index to first sheet from supbook * @return index to first supbook */ public short GetIndexToFirstSupBook() { return field_2_index_to_first_supbook_sheet; } /** Sets the index to last sheet in supbook * @param index index to last sheet */ public void SetIndexToLastSupBook(short index) { field_3_index_to_last_supbook_sheet = index; } /** Gets the index to last sheet in supbook * @return index to last supbook */ public short GetIndexToLastSupBook() { return field_3_index_to_last_supbook_sheet; } public override String ToString() { StringBuilder buffer = new StringBuilder(); buffer.Append(" supbookindex =").Append(GetIndexToSupBook()).Append('\n'); buffer.Append(" 1stsbindex =").Append(GetIndexToFirstSupBook()).Append('\n'); buffer.Append(" lastsbindex =").Append(GetIndexToLastSupBook()).Append('\n'); return buffer.ToString(); } /** * called by the class that Is responsible for writing this sucker. * Subclasses should implement this so that their data Is passed back in a * byte array. * * @param offset to begin writing at * @param data byte array containing instance data * @return number of bytes written */ public override int Serialize(int offset, byte [] data) { LittleEndian.PutShort(data, 0 + offset, GetIndexToSupBook()); LittleEndian.PutShort(data, 2 + offset, GetIndexToFirstSupBook()); LittleEndian.PutShort(data, 4 + offset, GetIndexToLastSupBook()); return RecordSize; } /** returns the record size */ public override int RecordSize { get { return 6; } } /** * return the non static version of the id for this record. */ public override short Sid { get { return sid; } } } }