internal void SaveToXlsx(TOpenXmlWriter DataStream, string DocName, bool IsCache)
{
if (Attributes == null)
{
return;
}
DataStream.WriteStartDocument(DocName, true);
foreach (TXlsxAttribute att in Attributes)
{
if (att.Namespace != "http://www.w3.org/2000/xmlns/")
{
if (att.Name == "cacheId")
{
DataStream.WriteAtt("cacheId", CacheId);
}
else
{
DataStream.WriteAttRaw(att.Namespace, att.Name, att.Value);
}
}
}
if (IsCache)
{
DataStream.WriteAtt("refreshOnLoad", true);
DataStream.WriteAtt("upgradeOnRefresh", true);
}
foreach (TXlsxPivotRecord rec in FRecords)
{
rec.SaveToXlsx(DataStream);
}
DataStream.WriteEndDocument();
}
internal override void SaveToXlsx(TOpenXmlWriter DataStream, int Row, TCellList CellList, bool Dates1904)
{
TxBaseRecord MySelf = new TxBaseRecord(Id, Data);
int MyOfs = 6;
TExcelString XS = new TExcelString(TStrLenLength.is16bits, ref MySelf, ref MyOfs);
DataStream.WriteAtt("t", "inlineStr");
DataStream.WriteStartElement("is");
DataStream.WriteRichText(XS, CellList.Workbook);
DataStream.WriteEndElement();
}
internal override void SaveToXlsx(TOpenXmlWriter DataStream)
{
DataStream.WriteStartElement("location");
DataStream.WriteAttAsRange("ref", Refe, true);
DataStream.WriteAtt("firstHeaderRow", firstHeaderRow);
DataStream.WriteAtt("firstDataRow", firstDataRow);
DataStream.WriteAtt("firstDataCol", firstDataCol);
DataStream.WriteAtt("rowPageCount", rowPageCount, 0);
DataStream.WriteAtt("colPageCount", colPageCount, 0);
DataStream.WriteEndElement();
}
internal override void SaveToXlsx(TOpenXmlWriter DataStream, int Row, TCellList CellList, bool Dates1904)
{
if (ErrFlag == 0)
{
DataStream.WriteAtt("t", "b");
DataStream.WriteElement("v", BoolErr == 1);
}
else
{
DataStream.WriteAtt("t", "e");
DataStream.WriteElement("v", TFormulaMessages.ErrString(ErrCodeToFlxFormulaErrorValue(BoolErr)));
}
}
internal void SaveToXlsx(TOpenXmlWriter DataStream)
{
DataStream.WriteStartElement("rangeSet");
for (int i = 0; i < ix.Length; i++)
{
if (ix[i] >= 0)
{
DataStream.WriteAtt("i" + (i + 1).ToString(CultureInfo.InvariantCulture), ix[i]);
}
}
if (Source != null)
{
Source.SaveAttsToXlsx(DataStream);
}
DataStream.WriteEndElement();
}
internal override void SaveToXlsx(TOpenXmlWriter DataStream)
{
DataStream.WriteStartElement("cacheSource");
DataStream.WriteAtt("type", SourceType);
if (ConnectionId > 0)
{
DataStream.WriteAtt("connectionId", ConnectionId, 0);
}
if (WorksheetSource != null)
{
WorksheetSource.SaveToXlsx(DataStream);
}
if (Consolidation != null)
{
Consolidation.SaveToXlsx(DataStream);
}
DataStream.WriteFutureStorage(FutureStorage);
DataStream.WriteEndElement();
}
internal void SaveToXlsx(TOpenXmlWriter DataStream)
{
DataStream.WriteStartElement("consolidation");
DataStream.WriteAtt("autoPage", AutoPage);
if (!String.IsNullOrEmpty(Pages))
{
DataStream.WriteRaw(Pages);
}
if (RangeSets.Count > 0)
{
DataStream.WriteStartElement("rangeSets");
DataStream.WriteAtt("count", RangeSets.Count);
foreach (TRangeSet r in RangeSets)
{
r.SaveToXlsx(DataStream);
}
DataStream.WriteEndElement();
}
DataStream.WriteEndElement();
}
internal override void SaveToXlsx(TOpenXmlWriter DataStream, int Row, TCellList CellList, bool Dates1904)
{
//nothing, it gets empty
}
internal override void SaveToXlsx(TOpenXmlWriter DataStream, int Row, TCellList CellList, bool Dates1904)
{
DataStream.WriteElement("v", (double)GetValue());
}
internal override void SaveToXlsx(TOpenXmlWriter DataStream, int Row, TCellList CellList, bool Dates1904)
{
FlxMessages.ThrowException(FlxErr.ErrInternal);
}
internal override void SaveToXlsx(TOpenXmlWriter DataStream, int Row, TCellList CellList, bool Dates1904)
{
DataStream.WriteAtt("t", "s");
DataStream.WriteElement("v", PosInTable);
}
internal void SaveAttsToXlsx(TOpenXmlWriter DataStream)
{
DataStream.WriteAttAsRange("ref", Refe, true);
DataStream.WriteAtt("name", Name);
DataStream.WriteAtt("sheet", Sheet);
}
internal void SaveToXlsx(TOpenXmlWriter DataStream)
{
DataStream.WriteStartElement("worksheetSource");
SaveAttsToXlsx(DataStream);
DataStream.WriteEndElement();
}
internal virtual void SaveToXlsx(TOpenXmlWriter DataStream)
{
DataStream.WriteRaw(Xml);
}
