public Row(IStreamReader reader, RecordType id, ushort length)
: base(reader, id, length)
{
// assert that the correct record type is instantiated
Debug.Assert(this.Id == ID);
this.rw = reader.ReadUInt16();
this.colMic = reader.ReadUInt16();
this.colMac = reader.ReadUInt16();
this.miyRw = reader.ReadUInt16();
// read four unused bytes
reader.ReadUInt32();
var tv = new TwipsValue(this.miyRw);
// read 2 byte for some bit operations
ushort buffer = reader.ReadUInt16();
///
/// A - iOutLevel (3 bits): An unsigned integer that specifies the outline level (1) of the row.
/// B - reserved2 (1 bit): MUST be zero, and MUST be ignored.
/// C - fCollapsed (1 bit): A bit that specifies whether
/// D - fDyZero (1 bit): A bit that specifies whether the row is hidden.
/// E - fUnsynced (1 bit): A bit that specifies whether the row height has been manually set.
/// F - fGhostDirty (1 bit): A bit that specifies whether the row has been formatted.
/// reserved3 (1 byte): MUST be 1, and MUST be ignored.
///
this.iOutLevel = buffer & 0x0007;
this.fCollapsed = Utils.BitmaskToBool(buffer, 0x8);
this.fDyZero = Utils.BitmaskToBool(buffer, 0x10);
this.fUnsynced = Utils.BitmaskToBool(buffer, 0x20);
this.fGhostDirty = Utils.BitmaskToBool(buffer, 0x40);
// read 2 byte for some bit operations
buffer = reader.ReadUInt16();
this.ixfe_val = buffer & 0x0FFF;
this.fExAsc = Utils.BitmaskToBool(buffer, 0x1000);
this.fExDes = Utils.BitmaskToBool(buffer, 0x2000);
this.fPhonetic = Utils.BitmaskToBool(buffer, 0x4000);
/// ixfe_val (12 bits): An unsigned integer that specifies a XF record for the row formatting.
///G - fExAsc (1 bit): A bit that specifies whether any cell in the row has a thick top border, or any cell in the row directly above the current row has a thick bottom border. Thick borders are the following enumeration values from BorderStyle: THICK and DOUBLE.
///H - fExDes (1 bit): A bit that specifies whether any cell in the row has a medium or thick bottom border, or any cell in the row directly below the current row has a medium or thick top border. Thick borders are previously specified. Medium borders are the following enumeration values from BorderStyle: MEDIUM, MEDIUMDASHED, MEDIUMDASHDOT, MEDIUMDASHDOTDOT, and SLANTDASHDOT.
///I - fPhonetic (1 bit): A bit that specifies whether the phonetic guide feature is enabled for any cell in this row. J - unused2 (1 bit): Undefined and MUST be ignored.
// assert that the correct number of bytes has been read from the stream
Debug.Assert(this.Offset + this.Length == this.Reader.BaseStream.Position);
}
public void Apply(PictureDescriptor pict)
{
ImagePart imgPart = copyPicture(pict.BlipStoreEntry);
if (imgPart != null)
{
Shape shape = (Shape)pict.ShapeContainer.Children[0];
List <ShapeOptions.OptionEntry> options = pict.ShapeContainer.ExtractOptions();
//v:shapetype
PictureFrameType type = new PictureFrameType();
type.Convert(new VMLShapeTypeMapping(_writer));
//v:shape
_writer.WriteStartElement("v", "shape", OpenXmlNamespaces.VectorML);
_writer.WriteAttributeString("type", "#" + VMLShapeTypeMapping.GenerateTypeId(type));
StringBuilder style = new StringBuilder();
double xScaling = pict.mx / 1000.0;
double yScaling = pict.my / 1000.0;
TwipsValue width = new TwipsValue(pict.dxaGoal * xScaling);
TwipsValue height = new TwipsValue(pict.dyaGoal * yScaling);
string widthString = Convert.ToString(width.ToPoints(), CultureInfo.GetCultureInfo("en-US"));
string heightString = Convert.ToString(height.ToPoints(), CultureInfo.GetCultureInfo("en-US"));
style.Append("width:").Append(widthString).Append("pt;");
style.Append("height:").Append(heightString).Append("pt;");
_writer.WriteAttributeString("style", style.ToString());
_writer.WriteAttributeString("id", pict.ShapeContainer.GetHashCode().ToString());
if (_olePreview)
{
_writer.WriteAttributeString("o", "ole", OpenXmlNamespaces.Office, "");
}
foreach (ShapeOptions.OptionEntry entry in options)
{
switch (entry.pid)
{
//BORDERS
case ShapeOptions.PropertyId.borderBottomColor:
RGBColor bottomColor = new RGBColor((int)entry.op, RGBColor.ByteOrder.RedFirst);
_writer.WriteAttributeString("o", "borderbottomcolor", OpenXmlNamespaces.Office, "#" + bottomColor.SixDigitHexCode);
break;
case ShapeOptions.PropertyId.borderLeftColor:
RGBColor leftColor = new RGBColor((int)entry.op, RGBColor.ByteOrder.RedFirst);
_writer.WriteAttributeString("o", "borderleftcolor", OpenXmlNamespaces.Office, "#" + leftColor.SixDigitHexCode);
break;
case ShapeOptions.PropertyId.borderRightColor:
RGBColor rightColor = new RGBColor((int)entry.op, RGBColor.ByteOrder.RedFirst);
_writer.WriteAttributeString("o", "borderrightcolor", OpenXmlNamespaces.Office, "#" + rightColor.SixDigitHexCode);
break;
case ShapeOptions.PropertyId.borderTopColor:
RGBColor topColor = new RGBColor((int)entry.op, RGBColor.ByteOrder.RedFirst);
_writer.WriteAttributeString("o", "bordertopcolor", OpenXmlNamespaces.Office, "#" + topColor.SixDigitHexCode);
break;
//CROPPING
case ShapeOptions.PropertyId.cropFromBottom:
//cast to signed integer
int cropBottom = (int)entry.op;
appendValueAttribute(_imageData, null, "cropbottom", cropBottom + "f", null);
break;
case ShapeOptions.PropertyId.cropFromLeft:
//cast to signed integer
int cropLeft = (int)entry.op;
appendValueAttribute(_imageData, null, "cropleft", cropLeft + "f", null);
break;
case ShapeOptions.PropertyId.cropFromRight:
//cast to signed integer
int cropRight = (int)entry.op;
appendValueAttribute(_imageData, null, "cropright", cropRight + "f", null);
break;
case ShapeOptions.PropertyId.cropFromTop:
//cast to signed integer
int cropTop = (int)entry.op;
appendValueAttribute(_imageData, null, "croptop", cropTop + "f", null);
break;
}
}
//v:imageData
appendValueAttribute(_imageData, "r", "id", imgPart.RelIdToString, OpenXmlNamespaces.Relationships);
appendValueAttribute(_imageData, "o", "title", "", OpenXmlNamespaces.Office);
_imageData.WriteTo(_writer);
//borders
writePictureBorder("bordertop", pict.brcTop);
writePictureBorder("borderleft", pict.brcLeft);
writePictureBorder("borderbottom", pict.brcBottom);
writePictureBorder("borderright", pict.brcRight);
//close v:shape
_writer.WriteEndElement();
}
}
/// <summary>
/// The overload apply method
/// Creates the Worksheet xml document
/// </summary>
/// <param name="bsd">WorkSheetData</param>
public void Apply(WorkSheetData bsd)
{
_xlsContext.CurrentSheet = bsd;
_writer.WriteStartDocument();
_writer.WriteStartElement("worksheet", OpenXmlNamespaces.SpreadsheetML);
//if (bsd.emtpyWorksheet)
//{
// _writer.WriteStartElement("sheetData");
// _writer.WriteEndElement();
//}
//else
{
// default info
if (bsd.defaultColWidth >= 0 || bsd.defaultRowHeight >= 0)
{
_writer.WriteStartElement("sheetFormatPr");
if (bsd.defaultColWidth >= 0)
{
double colWidht = (double)bsd.defaultColWidth;
_writer.WriteAttributeString("defaultColWidth", Convert.ToString(colWidht, CultureInfo.GetCultureInfo("en-US")));
}
if (bsd.defaultRowHeight >= 0)
{
TwipsValue tv = new TwipsValue(bsd.defaultRowHeight);
_writer.WriteAttributeString("defaultRowHeight", Convert.ToString(tv.ToPoints(), CultureInfo.GetCultureInfo("en-US")));
}
if (bsd.zeroHeight)
{
_writer.WriteAttributeString("zeroHeight", "1");
}
if (bsd.customHeight)
{
_writer.WriteAttributeString("customHeight", "1");
}
if (bsd.thickTop)
{
_writer.WriteAttributeString("thickTop", "1");
}
if (bsd.thickBottom)
{
_writer.WriteAttributeString("thickBottom", "1");
}
_writer.WriteEndElement(); // sheetFormatPr
}
// Col info
if (bsd.colInfoDataTable.Count > 0)
{
_writer.WriteStartElement("cols");
foreach (ColumnInfoData col in bsd.colInfoDataTable)
{
_writer.WriteStartElement("col");
// write min and max
// booth values are 0 based in the binary format and 1 based in the oxml format
// so you have to add 1 to the value!
_writer.WriteAttributeString("min", (col.min + 1).ToString());
_writer.WriteAttributeString("max", (col.max + 1).ToString());
if (col.widht != 0)
{
double colWidht = (double)col.widht / 256;
_writer.WriteAttributeString("width", Convert.ToString(colWidht, CultureInfo.GetCultureInfo("en-US")));
}
if (col.hidden)
{
_writer.WriteAttributeString("hidden", "1");
}
if (col.outlineLevel > 0)
{
_writer.WriteAttributeString("outlineLevel", col.outlineLevel.ToString());
}
if (col.customWidth)
{
_writer.WriteAttributeString("customWidth", "1");
}
if (col.bestFit)
{
_writer.WriteAttributeString("bestFit", "1");
}
if (col.phonetic)
{
_writer.WriteAttributeString("phonetic", "1");
}
if (col.style > 15)
{
_writer.WriteAttributeString("style", Convert.ToString(col.style - this._xlsContext.XlsDoc.WorkBookData.styleData.XFCellStyleDataList.Count, CultureInfo.GetCultureInfo("en-US")));
}
_writer.WriteEndElement(); // col
}
_writer.WriteEndElement();
}
// End col info
_writer.WriteStartElement("sheetData");
// bsd.rowDataTable.Values
foreach (RowData row in bsd.rowDataTable.Values)
{
// write row start tag
// Row
_writer.WriteStartElement("row");
// the rowindex from the binary format is zero based, the ooxml format is one based
_writer.WriteAttributeString("r", (row.Row + 1).ToString());
if (row.height != null)
{
_writer.WriteAttributeString("ht", Convert.ToString(row.height.ToPoints(), CultureInfo.GetCultureInfo("en-US")));
if (row.customHeight)
{
_writer.WriteAttributeString("customHeight", "1");
}
}
if (row.hidden)
{
_writer.WriteAttributeString("hidden", "1");
}
if (row.outlineLevel > 0)
{
_writer.WriteAttributeString("outlineLevel", row.outlineLevel.ToString());
}
if (row.collapsed)
{
_writer.WriteAttributeString("collapsed", "1");
}
if (row.customFormat)
{
_writer.WriteAttributeString("customFormat", "1");
if (row.style > 15)
{
_writer.WriteAttributeString("s", (row.style - this._xlsContext.XlsDoc.WorkBookData.styleData.XFCellStyleDataList.Count).ToString());
}
}
if (row.thickBot)
{
_writer.WriteAttributeString("thickBot", "1");
}
if (row.thickTop)
{
_writer.WriteAttributeString("thickTop", "1");
}
if (row.minSpan + 1 > 0 && row.maxSpan > 0 && row.minSpan + 1 < row.maxSpan)
{
_writer.WriteAttributeString("spans", (row.minSpan + 1).ToString() + ":" + row.maxSpan.ToString());
}
row.Cells.Sort();
foreach (AbstractCellData cell in row.Cells)
{
// Col
_writer.WriteStartElement("c");
_writer.WriteAttributeString("r", ExcelHelperClass.intToABCString((int)cell.Col, (cell.Row + 1).ToString()));
if (cell.TemplateID > 15)
{
_writer.WriteAttributeString("s", (cell.TemplateID - this._xlsContext.XlsDoc.WorkBookData.styleData.XFCellStyleDataList.Count).ToString());
}
if (cell is StringCell)
{
_writer.WriteAttributeString("t", "s");
}
if (cell is FormulaCell)
{
FormulaCell fcell = (FormulaCell)cell;
if (((FormulaCell)cell).calculatedValue is String)
{
_writer.WriteAttributeString("t", "str");
}
else if (((FormulaCell)cell).calculatedValue is double)
{
_writer.WriteAttributeString("t", "n");
}
else if (((FormulaCell)cell).calculatedValue is byte)
{
_writer.WriteAttributeString("t", "b");
}
else if (((FormulaCell)cell).calculatedValue is int)
{
_writer.WriteAttributeString("t", "e");
}
// <f>1</f>
_writer.WriteStartElement("f");
if (!fcell.isSharedFormula)
{
String value = FormulaInfixMapping.mapFormula(fcell.PtgStack, this._xlsContext);
if (fcell.usesArrayRecord)
{
_writer.WriteAttributeString("t", "array");
_writer.WriteAttributeString("ref", ExcelHelperClass.intToABCString((int)cell.Col, (cell.Row + 1).ToString()));
}
if (fcell.alwaysCalculated)
{
_writer.WriteAttributeString("ca", "1");
}
if (value.Equals(""))
{
TraceLogger.Debug("Formula Parse Error in Row {0}\t Column {1}\t", cell.Row.ToString(), cell.Col.ToString());
}
_writer.WriteString(value);
}
/// If this cell is part of a shared formula
///
else
{
SharedFormulaData sfd = bsd.checkFormulaIsInShared(cell.Row, cell.Col);
if (sfd != null)
{
// t="shared"
_writer.WriteAttributeString("t", "shared");
// <f t="shared" ref="C4:C11" si="0">H4+I4-J4</f>
_writer.WriteAttributeString("si", sfd.ID.ToString());
if (sfd.RefCount == 0)
{
/// Write value and reference
_writer.WriteAttributeString("ref", sfd.getOXMLFormatedData());
String value = FormulaInfixMapping.mapFormula(sfd.PtgStack, this._xlsContext, sfd.rwFirst, sfd.colFirst);
_writer.WriteString(value);
sfd.RefCount++;
}
}
else
{
TraceLogger.Debug("Formula Parse Error in Row {0}\t Column {1}\t", cell.Row.ToString(), cell.Col.ToString());
}
}
_writer.WriteEndElement();
/// write down calculated value from a formula
///
_writer.WriteStartElement("v");
if (((FormulaCell)cell).calculatedValue is int)
{
_writer.WriteString(FormulaInfixMapping.getErrorStringfromCode((int)((FormulaCell)cell).calculatedValue));
}
else
{
_writer.WriteString(Convert.ToString(((FormulaCell)cell).calculatedValue, CultureInfo.GetCultureInfo("en-US")));
}
_writer.WriteEndElement();
}
else
{// Data !!!
_writer.WriteElementString("v", cell.getValue());
}
// add a type to the c element if the formula returns following types
_writer.WriteEndElement(); // close cell (c)
}
_writer.WriteEndElement(); // close row
}
// close tags
_writer.WriteEndElement(); // close sheetData
// Add the mergecell part
//
// - <mergeCells count="2">
// <mergeCell ref="B3:C3" />
// <mergeCell ref="E3:F4" />
// </mergeCells>
if (bsd.MERGECELLSData != null)
{
_writer.WriteStartElement("mergeCells");
_writer.WriteAttributeString("count", bsd.MERGECELLSData.cmcs.ToString());
foreach (MergeCellData mcell in bsd.MERGECELLSData.mergeCellDataList)
{
_writer.WriteStartElement("mergeCell");
_writer.WriteAttributeString("ref", mcell.getOXMLFormatedData());
_writer.WriteEndElement();
}
// close mergeCells Tag
_writer.WriteEndElement();
}
// hyperlinks!
if (bsd.HyperLinkList.Count != 0)
{
_writer.WriteStartElement("hyperlinks");
bool writtenParentElement = false;
foreach (HyperlinkData link in bsd.HyperLinkList)
{
// Uri url;
// if (link.absolute)
// {
// if (link.url.StartsWith("http", true, CultureInfo.GetCultureInfo("en-US"))
// || link.url.StartsWith("mailto", true, CultureInfo.GetCultureInfo("en-US")))
// {
// url = new Uri(link.url, UriKind.Absolute);
// }
// else
// {
// link.url = "file:///" + link.url;
// url = new Uri(link.url, UriKind.Absolute);
// }
// }
// else
// {
// url = new Uri(link.url, UriKind.Relative);
// }
// try
// {
// if (System.Uri.IsWellFormedUriString(url.LocalPath.ToString(), System.UriKind.Absolute))
// {
//if (!writtenParentElement)
//{
// writtenParentElement = true;
//}
string refstring;
if (link.colLast == link.colFirst && link.rwLast == link.rwFirst)
{
refstring = ExcelHelperClass.intToABCString((int)link.colLast, (link.rwLast + 1).ToString());
}
else
{
refstring = ExcelHelperClass.intToABCString((int)link.colFirst, (link.rwFirst + 1).ToString()) + ":" + ExcelHelperClass.intToABCString((int)link.colLast, (link.rwLast + 1).ToString());
}
if (link.url != null)
{
ExternalRelationship er = this._xlsContext.SpreadDoc.WorkbookPart.GetWorksheetPart().AddExternalRelationship(OpenXmlRelationshipTypes.HyperLink, link.url.Replace(" ", ""));
_writer.WriteStartElement("hyperlink");
_writer.WriteAttributeString("ref", refstring);
_writer.WriteAttributeString("r", "id", OpenXmlNamespaces.Relationships, er.Id.ToString());
_writer.WriteEndElement();
}
else if (link.location != null)
{
_writer.WriteStartElement("hyperlink");
_writer.WriteAttributeString("ref", refstring);
_writer.WriteAttributeString("location", link.location);
if (link.display != null)
{
_writer.WriteAttributeString("display", link.display);
}
_writer.WriteEndElement();
}
/* }
* }
* catch (Exception ex)
* {
* TraceLogger.DebugInternal(ex.Message.ToString());
* TraceLogger.DebugInternal(ex.StackTrace.ToString());
* }
* }*/
}
_writer.WriteEndElement(); // hyperlinks
if (writtenParentElement)
{
}
}
// worksheet margins !!
if (bsd.leftMargin != null && bsd.topMargin != null &&
bsd.rightMargin != null && bsd.bottomMargin != null &&
bsd.headerMargin != null && bsd.footerMargin != null)
{
_writer.WriteStartElement("pageMargins");
{
_writer.WriteAttributeString("left", Convert.ToString(bsd.leftMargin, CultureInfo.GetCultureInfo("en-US")));
_writer.WriteAttributeString("right", Convert.ToString(bsd.rightMargin, CultureInfo.GetCultureInfo("en-US")));
_writer.WriteAttributeString("top", Convert.ToString(bsd.topMargin, CultureInfo.GetCultureInfo("en-US")));
_writer.WriteAttributeString("bottom", Convert.ToString(bsd.bottomMargin, CultureInfo.GetCultureInfo("en-US")));
_writer.WriteAttributeString("header", Convert.ToString(bsd.headerMargin, CultureInfo.GetCultureInfo("en-US")));
_writer.WriteAttributeString("footer", Convert.ToString(bsd.footerMargin, CultureInfo.GetCultureInfo("en-US")));
}
_writer.WriteEndElement(); // pageMargins
}
// page setup settings
if (bsd.PageSetup != null)
{
_writer.WriteStartElement("pageSetup");
if (!bsd.PageSetup.fNoPls && bsd.PageSetup.iPaperSize > 0 && bsd.PageSetup.iPaperSize < 255)
{
_writer.WriteAttributeString("paperSize", bsd.PageSetup.iPaperSize.ToString());
}
if (bsd.PageSetup.iScale >= 10 && bsd.PageSetup.iScale <= 400)
{
_writer.WriteAttributeString("scale", bsd.PageSetup.iScale.ToString());
}
_writer.WriteAttributeString("firstPageNumber", bsd.PageSetup.iPageStart.ToString());
_writer.WriteAttributeString("fitToWidth", bsd.PageSetup.iFitWidth.ToString());
_writer.WriteAttributeString("fitToHeight", bsd.PageSetup.iFitHeight.ToString());
if (bsd.PageSetup.fLeftToRight)
{
_writer.WriteAttributeString("pageOrder", "overThenDown");
}
if (!bsd.PageSetup.fNoOrient)
{
if (bsd.PageSetup.fPortrait)
{
_writer.WriteAttributeString("orientation", "portrait");
}
else
{
_writer.WriteAttributeString("orientation", "landscape");
}
}
//10 <attribute name="usePrinterDefaults" type="xsd:boolean" use="optional" default="true"/>
if (bsd.PageSetup.fNoColor)
{
_writer.WriteAttributeString("blackAndWhite", "1");
}
if (bsd.PageSetup.fDraft)
{
_writer.WriteAttributeString("draft", "1");
}
if (bsd.PageSetup.fNotes)
{
if (bsd.PageSetup.fEndNotes)
{
_writer.WriteAttributeString("cellComments", "atEnd");
}
else
{
_writer.WriteAttributeString("cellComments", "asDisplayed");
}
}
if (bsd.PageSetup.fUsePage)
{
_writer.WriteAttributeString("useFirstPageNumber", "1");
}
switch (bsd.PageSetup.iErrors)
{
case 0x00: _writer.WriteAttributeString("errors", "displayed"); break;
case 0x01: _writer.WriteAttributeString("errors", "blank"); break;
case 0x02: _writer.WriteAttributeString("errors", "dash"); break;
case 0x03: _writer.WriteAttributeString("errors", "NA"); break;
default: _writer.WriteAttributeString("errors", "displayed"); break;
}
_writer.WriteAttributeString("horizontalDpi", bsd.PageSetup.iRes.ToString());
_writer.WriteAttributeString("verticalDpi", bsd.PageSetup.iVRes.ToString());
if (!bsd.PageSetup.fNoPls)
{
_writer.WriteAttributeString("copies", bsd.PageSetup.iCopies.ToString());
}
_writer.WriteEndElement();
}
// embedded drawings (charts etc)
if (bsd.ObjectsSequence != null)
{
_writer.WriteStartElement(Sml.Sheet.ElDrawing, Sml.Ns);
{
_writer.WriteAttributeString("r", "id", OpenXmlNamespaces.Relationships, this._worksheetPart.DrawingsPart.RelIdToString);
bsd.ObjectsSequence.Convert(new DrawingMapping(this._xlsContext, this._worksheetPart.DrawingsPart, false));
}
_writer.WriteEndElement();
}
}
_writer.WriteEndElement(); // close worksheet
_writer.WriteEndDocument();
// close writer
_writer.Flush();
}