|
/* ====================================================================
|
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.
|
==================================================================== */
|
|
|
/*
|
* MulRKRecord.java
|
*
|
* Created on November 9, 2001, 4:53 PM
|
*/
|
namespace HH.WMS.Utils.NPOI.HSSF.Record
|
{
|
using HH.WMS.Utils.NPOI.Util;
|
using System;
|
using System.Text;
|
using System.Collections;
|
using System.IO;
|
using HH.WMS.Utils.NPOI.HSSF.Util;
|
|
/**
|
* Used to store multiple RK numbers on a row. 1 MulRk = Multiple Cell values.
|
* HSSF just Converts this into multiple NUMBER records. Read-ONLY SUPPORT!
|
* REFERENCE: PG 330 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
|
* @author Andrew C. Oliver (acoliver at apache dot org)
|
* @version 2.0-pre
|
*/
|
|
public class MulRKRecord : StandardRecord
|
{
|
public const short sid = 0xbd;
|
private int field_1_row;
|
private short field_2_first_col;
|
private RkRec[] field_3_rks;
|
private short field_4_last_col;
|
|
/** Creates new MulRKRecord */
|
|
public MulRKRecord()
|
{
|
}
|
|
/**
|
* Constructs a MulRK record and Sets its fields appropriately.
|
*
|
* @param in the RecordInputstream to Read the record from
|
*/
|
|
public MulRKRecord(RecordInputStream in1)
|
{
|
field_1_row = in1.ReadUShort();
|
field_2_first_col = in1.ReadShort();
|
field_3_rks = RkRec.ParseRKs(in1);
|
field_4_last_col = in1.ReadShort();
|
}
|
|
//public short Row
|
public int Row
|
{
|
get { return field_1_row; }
|
}
|
|
/**
|
* starting column (first cell this holds in the row)
|
* @return first column number
|
*/
|
|
public short FirstColumn
|
{
|
get { return field_2_first_col; }
|
}
|
|
/**
|
* ending column (last cell this holds in the row)
|
* @return first column number
|
*/
|
|
public short LastColumn
|
{
|
get { return field_4_last_col; }
|
}
|
|
/**
|
* Get the number of columns this Contains (last-first +1)
|
* @return number of columns (last - first +1)
|
*/
|
|
public int NumColumns
|
{
|
get { return field_4_last_col - field_2_first_col + 1; }
|
}
|
|
/**
|
* returns the xf index for column (coffset = column - field_2_first_col)
|
* @return the XF index for the column
|
*/
|
|
public short GetXFAt(int coffset)
|
{
|
return field_3_rks[coffset].xf;
|
}
|
|
/**
|
* returns the rk number for column (coffset = column - field_2_first_col)
|
* @return the value (decoded into a double)
|
*/
|
|
public double GetRKNumberAt(int coffset)
|
{
|
return RKUtil.DecodeNumber(field_3_rks[coffset].rk);
|
}
|
|
|
//private ArrayList ParseRKs(RecordInputStream in1)
|
//{
|
// ArrayList retval = new ArrayList();
|
// while ((in1.Remaining - 2) > 0)
|
// {
|
// RkRec rec = new RkRec();
|
|
// rec.xf = in1.ReadShort();
|
// rec.rk = in1.ReadInt();
|
// retval.Add(rec);
|
// }
|
// return retval;
|
//}
|
|
public override String ToString()
|
{
|
StringBuilder buffer = new StringBuilder();
|
|
buffer.Append("[MULRK]\n");
|
buffer.Append(" .row = ").Append(HexDump.ShortToHex(Row)).Append("\n");
|
buffer.Append(" .firstcol= ").Append(StringUtil.ToHexString(FirstColumn)).Append("\n");
|
buffer.Append(" .lastcol = ").Append(StringUtil.ToHexString(LastColumn)).Append("\n");
|
for (int k = 0; k < NumColumns; k++)
|
{
|
buffer.Append(" xf[").Append(k).Append("] = ").Append(StringUtil.ToHexString(GetXFAt(k))).Append("\n");
|
buffer.Append(" rk[").Append(k).Append("] = ").Append(GetRKNumberAt(k)).Append("\n");
|
}
|
buffer.Append("[/MULRK]\n");
|
return buffer.ToString();
|
}
|
|
public override short Sid
|
{
|
get { return sid; }
|
}
|
|
public override void Serialize(ILittleEndianOutput out1)
|
{
|
throw new RecordFormatException("Sorry, you can't serialize MulRK in this release");
|
}
|
protected override int DataSize
|
{
|
get
|
{
|
throw new RecordFormatException("Sorry, you can't serialize MulRK in this release");
|
}
|
}
|
private class RkRec
|
{
|
public const int ENCODED_SIZE = 6;
|
public short xf;
|
public int rk;
|
|
private RkRec(RecordInputStream in1)
|
{
|
xf = in1.ReadShort();
|
rk = in1.ReadInt();
|
}
|
|
public static RkRec[] ParseRKs(RecordInputStream in1)
|
{
|
int nItems = (in1.Remaining - 2) / ENCODED_SIZE;
|
RkRec[] retval = new RkRec[nItems];
|
for (int i = 0; i < nItems; i++)
|
{
|
retval[i] = new RkRec(in1);
|
}
|
return retval;
|
}
|
}
|
}
|
|
|
}
|
