/* ==================================================================== 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 System.Collections; using HH.WMS.Utils.NPOI.Util; using HH.WMS.Utils.NPOI.HSSF.Util; using HH.WMS.Utils.NPOI.SS.Formula; using HH.WMS.Utils.NPOI.SS.Util; /** * DATATABLE (0x0236)

* * TableRecord - The record specifies a data table. * This record Is preceded by a single Formula record that * defines the first cell in the data table, which should * only contain a single Ptg, {@link TblPtg}. * * See p536 of the June 08 binary docs */ public class TableRecord : SharedValueRecordBase { public const short sid = 0x0236; private static BitField alwaysCalc = BitFieldFactory.GetInstance(0x0001); private static BitField calcOnOpen = BitFieldFactory.GetInstance(0x0002); private static BitField rowOrColInpCell = BitFieldFactory.GetInstance(0x0004); private static BitField oneOrTwoVar = BitFieldFactory.GetInstance(0x0008); private static BitField rowDeleted = BitFieldFactory.GetInstance(0x0010); private static BitField colDeleted = BitFieldFactory.GetInstance(0x0020); private int field_5_flags; private int field_6_res; private int field_7_rowInputRow; private int field_8_colInputRow; private int field_9_rowInputCol; private int field_10_colInputCol; public TableRecord(RecordInputStream in1) : base(in1) { field_5_flags = in1.ReadByte(); field_6_res = in1.ReadByte(); field_7_rowInputRow = in1.ReadShort(); field_8_colInputRow = in1.ReadShort(); field_9_rowInputCol = in1.ReadShort(); field_10_colInputCol = in1.ReadShort(); } public TableRecord(CellRangeAddress8Bit range) : base(range) { field_6_res = 0; } public int Flags { get { return field_5_flags; } set { field_5_flags = value; } } public int RowInputRow { get { return field_7_rowInputRow; } set { field_7_rowInputRow = value; } } public int ColInputRow { get { return field_8_colInputRow; } set { field_8_colInputRow = value; } } public int RowInputCol { get { return field_9_rowInputCol; } set { field_9_rowInputCol = value; } } public int ColInputCol { get { return field_10_colInputCol; } set { field_10_colInputCol = value; } } public bool IsAlwaysCalc { get { return alwaysCalc.IsSet(field_5_flags); } set { field_5_flags = alwaysCalc.SetBoolean(field_5_flags, value); } } public bool IsRowOrColInpCell { get { return rowOrColInpCell.IsSet(field_5_flags); } set { field_5_flags = rowOrColInpCell.SetBoolean(field_5_flags, value); } } public bool IsOneNotTwoVar { get { return oneOrTwoVar.IsSet(field_5_flags); } set { field_5_flags = oneOrTwoVar.SetBoolean(field_5_flags, value); } } public bool IsColDeleted { get { return colDeleted.IsSet(field_5_flags); } set { field_5_flags = colDeleted.SetBoolean(field_5_flags, value); } } public bool IsRowDeleted { get { return rowDeleted.IsSet(field_5_flags); } set { field_5_flags = rowDeleted.SetBoolean(field_5_flags, value); } } public override short Sid { get { return sid; } } protected override int ExtraDataSize { get { return 2 // 2 byte fields + 8; // 4 short fields } } protected override void SerializeExtraData(ILittleEndianOutput out1) { out1.WriteByte(field_5_flags); out1.WriteByte(field_6_res); out1.WriteShort(field_7_rowInputRow); out1.WriteShort(field_8_colInputRow); out1.WriteShort(field_9_rowInputCol); out1.WriteShort(field_10_colInputCol); } public override String ToString() { StringBuilder buffer = new StringBuilder(); buffer.Append("[TABLE]\n"); buffer.Append(" .range = ").Append(Range.ToString()).Append("\n"); buffer.Append(" .flags = ").Append(HexDump.ByteToHex(field_5_flags)).Append("\n"); buffer.Append(" .alwaysClc= ").Append(IsAlwaysCalc).Append("\n"); buffer.Append(" .reserved = ").Append(HexDump.IntToHex(field_6_res)).Append("\n"); CellReference crRowInput = cr(field_7_rowInputRow, field_8_colInputRow); CellReference crColInput = cr(field_9_rowInputCol, field_10_colInputCol); buffer.Append(" .rowInput = ").Append(crRowInput.FormatAsString()).Append("\n"); buffer.Append(" .colInput = ").Append(crColInput.FormatAsString()).Append("\n"); buffer.Append("[/TABLE]\n"); return buffer.ToString(); } private static CellReference cr(int rowIx, int colIxAndFlags) { int colIx = colIxAndFlags & 0x00FF; bool IsRowAbs = (colIxAndFlags & 0x8000) == 0; bool IsColAbs = (colIxAndFlags & 0x4000) == 0; return new CellReference(rowIx, colIx, IsRowAbs, IsColAbs); } } }