/**
* 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 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);
}
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;
}
internal Worksheet(Workbook wb, BoundSheetRecord sheet, SortedList <long, Biff> records)
: base(wb)
{
_name = sheet.Name;
int idx = records.IndexOfKey((long)sheet.BofPos);
_hyperlinks = new HyperLinkCollection(wb);
for (int i = idx + 1; i < records.Count; ++i)
{
Biff biff = records.Values[i];
if (biff is HyperLinkRecord)
{
_hyperlinks.Add((HyperLinkRecord)biff);
}
else if (biff is EofRecord)
{
break;
}
}
BofRecord bof = (BofRecord)records.Values[idx++];
Biff seeker = records.Values[idx++];
while (!(seeker is IndexRecord))
{
seeker = records.Values[idx++];
}
IndexRecord index = (IndexRecord)seeker;
_rows = new RowCollection(wb);
foreach (uint indexPos in index.Rows)
{
long dbCellPos = indexPos;
int dbCellIdx = records.IndexOfKey(dbCellPos);
DbCellRecord dbCell = (DbCellRecord)records[dbCellPos];
if (dbCell.RowOffset > 0)
{
long rowPos = dbCellPos - dbCell.RowOffset;
int recIndex = records.IndexOfKey(rowPos);
Debug.Assert(recIndex != -1);
Biff record = records.Values[recIndex++];
while (record is RowRecord)
{
RowRecord row = (RowRecord)record;
Row currentRow = new Row(Workbook, row);
_rows.Add(row.RowNumber, currentRow);
record = records.Values[recIndex++];
}
while (recIndex <= dbCellIdx)
{
if (!(record is CellRecord))
{
record = records.Values[recIndex++];
continue;
}
CellRecord thecell = (CellRecord)record;
Row currentRow = _rows[thecell.Row];
if (thecell is SingleColCellRecord)
{
SingleColCellRecord cell = (SingleColCellRecord)thecell;
object val = cell.Value;
Cell newCell = new Cell(Workbook, val);
if (cell is RowColXfCellRecord)
{
RowColXfCellRecord xfCell = (RowColXfCellRecord)cell;
Style style = Workbook.Styles[xfCell.Xf];
Debug.Assert(style != null);
newCell.Style = style;
}
currentRow.Cells.Add((byte)cell.Col, newCell);
}
else
{
MultipleColCellRecord cells = (MultipleColCellRecord)thecell;
for (ushort i = cells.FirstCol; i <= cells.LastCol; ++i)
{
object val = cells.GetValue(i);
if (val != null)
{
Cell newCell = null;
if (val is RkRec)
{
RkRec rk = (RkRec)val;
newCell = new Cell(Workbook, rk.Value);
Style style = Workbook.Styles[rk.Xf];
Debug.Assert(style != null);
newCell.Style = style;
}
else
{
newCell = new Cell(Workbook, val);
}
currentRow.Cells.Add((byte)i, newCell);
}
}
}
record = records.Values[recIndex++];
}
}
}
}
