internal override void SaveToPxl(TPxlStream PxlStream, TPxlSaveData SaveData)
{
if ((sBOF == null) || (sEOF == null))
{
XlsMessages.ThrowException(XlsErr.ErrSectionNotLoaded);
}
sBOF.SaveToPxl(PxlStream, 0, SaveData);
foreach (TWindow1Record w1 in Window1)
{
if (w1 != null)
{
w1.SaveToPxl(PxlStream, 0, SaveData);
}
}
Fonts.SaveToPxl(PxlStream, 0, SaveData);
Formats.SaveToPxl(PxlStream, 0, SaveData);
CellXF.SaveToPxl(PxlStream, 0, SaveData);
FBoundSheets.SaveToPxl(PxlStream, SaveData);
FNames.SaveToPxl(PxlStream, 0, SaveData); //Should be after FBoundSheets.SaveToStream
sEOF.SaveToPxl(PxlStream, 0, SaveData);
}
internal void SaveToPxl(TPxlStream PxlStream, TPxlSaveData SaveData)
{
if (ActiveRow > FlxConsts.Max_PxlRows)
{
return;
}
if (ActiveCol > FlxConsts.Max_PxlColumns)
{
return;
}
TXlsCellRange Selection = new TXlsCellRange(ActiveRow, ActiveCol, ActiveRow, ActiveCol);
if (SelectedCells != null && SelectedCells.Length > 0)
{
TXlsCellRange Selection2 = SelectedCells[0];
if (Selection2.Left >= 0 && Selection2.Right <= FlxConsts.Max_PxlColumns && Selection2.Left <= Selection2.Right)
{
if (Selection2.Top >= 0 && Selection2.Bottom <= FlxConsts.Max_PxlRows && Selection2.Top <= Selection2.Bottom)
{
Selection = Selection2;
}
}
}
PxlStream.WriteByte((byte)pxl.SELECTION);
PxlStream.Write16((UInt16)Selection.Top);
PxlStream.WriteByte((byte)Selection.Left);
PxlStream.Write16((UInt16)Selection.Bottom);
PxlStream.WriteByte((byte)Selection.Right);
PxlStream.Write16((UInt16)ActiveRow);
PxlStream.WriteByte((byte)ActiveCol);
}
internal void SaveToPxl(TPxlStream PxlStream, TPxlSaveData SaveData)
{
TDefColWidthRecord.SaveToPxl(PxlStream, DefColWidthChars);
//Pxl needs the full 255 columns defined, starting at 0 and ending af 255.
int LastCol = FlxConsts.Max_Columns97_2003 + 1;
int i = 0;
int k = i;
while (i <= LastCol)
{
k = i + 1;
while (k <= LastCol && IsEqual(this[k], this[i]))
{
k++;
}
if (PxlStream != null)
{
SaveOnePxlRecord(i, k - 1, PxlStream, SaveData);
}
i = k;
}
if (k < LastCol && (PxlStream != null))
{
SaveOnePxlRecord(k, FlxConsts.Max_Columns97_2003, PxlStream, SaveData);
}
}
private void SaveOnePxlRecord(int i, int k, TPxlStream PxlStream, TPxlSaveData SaveData)
{
//We need to ensure this[i] is not bigger than Maxcolumns. this[k] can be=Maxcolumns+1.
if (i > FlxConsts.Max_Columns97_2003)
{
return;
}
//really for pxl k should be Maxcolumns only
if (k > FlxConsts.Max_Columns97_2003)
{
k = FlxConsts.Max_Columns97_2003;
}
PxlStream.WriteByte((byte)pxl.COLINFO);
PxlStream.Write16((UInt16)i);
PxlStream.Write16((UInt16)k);
if (this[i] == null)
{
PxlStream.Write16((UInt16)0x900); //width
PxlStream.Write16((UInt16)0); //xf
PxlStream.WriteByte((byte)(0)); //options
}
else
{
PxlStream.Write16((UInt16)this[i].Width);
PxlStream.Write16(SaveData.GetBiff8FromCellXF(this[i].XF));
PxlStream.WriteByte((byte)(this[i].Options & 1));
}
}
internal void SaveToPxl(TPxlStream PxlStream, TPxlSaveData SaveData)
{
for (int i = 0; i < Count; i++)
{
FList[i].SaveToPxl(PxlStream, SaveData);
}
}
internal override void SaveToPxl(TPxlStream PxlStream, int Row, TPxlSaveData SaveData)
{
base.SaveToPxl(PxlStream, Row, SaveData);
if (!PxlRecordIsValid(Row))
{
return;
}
SaveToPxl(PxlStream, Row, Col, XF, AsString, SaveData);
}
internal void SaveToPxl(TPxlStream PxlStream, TPxlSaveData SaveData)
{
TPaneSelection Pane = Panes[3];
if (Pane == null)
{
return;
}
Pane.SaveToPxl(PxlStream, SaveData);
}
internal void SaveToPxl(TPxlStream PxlStream)
{
FixRows(); //Should be before calculating the offset. it is needed because some non-excel generated files might not have all rows.
FixSheetVisible();
TPxlSaveData SaveData = new TPxlSaveData(FGlobals);
FGlobals.SaveToPxl(PxlStream, SaveData);
FSheets.SaveToPxl(PxlStream, SaveData);
}
internal override void SaveToPxl(TPxlStream PxlStream, int Row, TPxlSaveData SaveData)
{
base.SaveToPxl(PxlStream, Row, SaveData);
if (OptionFlags2 != 0x00)
{
return; //Only worksheets.
}
PxlStream.WriteByte((byte)pxl.BOUNDSHEET);
PxlStream.WriteByte(0); //reserved
PxlStream.WriteString8(SheetName);
}
internal override void SaveToPxl(TPxlStream PxlStream, int Row, TPxlSaveData SaveData)
{
base.SaveToPxl(PxlStream, Row, SaveData);
PxlStream.WriteByte((byte)pxl.PANE);
PxlStream.Write16((UInt16)ColSplit);
PxlStream.Write16((UInt16)RowSplit);
PxlStream.Write16((UInt16)FirstVisibleRow);
PxlStream.Write16((UInt16)FirstVisibleCol);
PxlStream.WriteByte((byte)ActivePane);
}
internal override void SaveToPxl(TPxlStream PxlStream, int Row, TPxlSaveData SaveData)
{
base.SaveToPxl(PxlStream, Row, SaveData);
int bType = BOFType;
Debug.Assert(bType == 0x05 || bType == 0x10, "Only streams valid on Pxl are Globals and Worksheets");
PxlStream.WriteByte((byte)pxl.BOF);
PxlStream.Write16(0x010F); //Pxl 2.0
PxlStream.Write16((UInt16)bType);
}
internal override void SaveToPxl(TPxlStream PxlStream, int Row, TPxlSaveData SaveData)
{
base.SaveToPxl(PxlStream, Row, SaveData);
PxlStream.WriteByte((byte)pxl.BOOLERR);
PxlStream.Write16((UInt16)Row);
PxlStream.WriteByte((byte)Col);
PxlStream.Write16(SaveData.GetBiff8FromCellXF(XF));
byte[] b = new byte[2];
b[0] = BoolErr;
b[1] = ErrFlag;
PxlStream.Write(b, 0, 2);
}
internal override void SaveToPxl(TPxlStream PxlStream, int Row, TPxlSaveData SaveData)
{
base.SaveToPxl(PxlStream, Row, SaveData);
if (!PxlRecordIsValid(Row))
{
return;
}
PxlStream.WriteByte((byte)pxl.BLANK);
PxlStream.Write16((UInt16)Row);
PxlStream.WriteByte((byte)Col);
PxlStream.Write16(SaveData.GetBiff8FromCellXF(XF));
}
public virtual void SaveToPxl(TPxlStream PxlStream, int Row, TPxlSaveData SaveData)
{
int aCount = FList.Count;
for (int i = 0; i < aCount; i++)
{
T it = (T)FList[i];
if (it != null)
{
it.SaveToPxl(PxlStream, Row, SaveData);
}
}
}
internal override void SaveToPxl(TPxlStream PxlStream, int Row, TPxlSaveData SaveData)
{
base.SaveToPxl(PxlStream, Row, SaveData);
if (!PxlRecordIsValid(Row))
{
return;
}
PxlStream.WriteByte((byte)pxl.NUMBER);
PxlStream.Write16((UInt16)Row);
PxlStream.WriteByte((byte)Col);
PxlStream.Write16(SaveData.GetBiff8FromCellXF(XF));
PxlStream.Write(BitConverter.GetBytes(NumValue), 0, 8);
}
internal abstract void SaveToPxl(TPxlStream PxlStream, TPxlSaveData SaveData);
internal override void SaveToPxl(TPxlStream PxlStream, int Row, TPxlSaveData SaveData)
{
base.SaveToPxl(PxlStream, Row, SaveData);
PxlStream.WriteByte((byte)pxl.EOF);
}
internal void SaveToPxl(TPxlStream PxlStream, TPxlSaveData SaveData)
{
FBoundSheets.SaveToPxl(PxlStream, 0, SaveData);
}
public override void SaveToPxl(TPxlStream PxlStream, int Row, TPxlSaveData SaveData)
{
base.SaveToPxl(PxlStream, Row, SaveData);
}
internal static void SaveToPxl(TPxlStream PxlStream, int Row, int Col, int XF, string LabelValue, TPxlSaveData SaveData)
{
PxlStream.WriteByte((byte)pxl.LABEL);
PxlStream.Write16((UInt16)Row);
PxlStream.WriteByte((byte)Col);
PxlStream.Write16(SaveData.GetBiff8FromCellXF(XF));
if (LabelValue == null)
{
LabelValue = String.Empty;
}
if (LabelValue.Length > 255)
{
LabelValue = LabelValue.Substring(0, 255);
}
PxlStream.WriteString16(LabelValue);
}