/// <summary> /// News the run text. /// </summary> /// <param name="NewText">The new text.</param> /// <param name="DecorationList">The decoration list.</param> /// <param name="FontName">Name of the font.</param> /// <param name="FontSize">Size of the font.</param> /// <returns></returns> private static DocumentFormat.OpenXml.Spreadsheet.Run NewRunText(string NewText, List <OpenXmlLeafElement> DecorationList, FontName FontName, FontSize FontSize) { DocumentFormat.OpenXml.Spreadsheet.Run run = new DocumentFormat.OpenXml.Spreadsheet.Run(); Text txt = new Text(NewText); txt.SetAttribute(new OpenXmlAttribute("xml:space", null, "preserve")); RunProperties pPr = new RunProperties(); run.Append(pPr); if (DecorationList != null) { foreach (OpenXmlLeafElement Decoration in DecorationList) { pPr.Append(Decoration); } pPr.Append(FontName); pPr.Append(FontSize); } run.Append(txt); return(run); }
private Cell CreateTextCell(int columnIndex, int rowIndex, object cellValue, RunProperties runProperties = null) { Cell cell = new Cell { DataType = CellValues.InlineString, CellReference = GetColumnName(columnIndex) + rowIndex, }; Text text = new Text { Text = cellValue.ToString() }; RunSpreadsheet run = new RunSpreadsheet(); run.Append(text); if (runProperties != null) { run.RunProperties = runProperties; } InlineString inlineString = new InlineString(); inlineString.Append(run); cell.AppendChild(inlineString); return(cell); }
public OpenXmlCompositeElement NewRun(OpenXmlCompositeElement?runProps, string?text, SpaceProcessingModeValues spaceMode, bool initialBr) { var textElement = new S.Text(text); var result = new S.Run(runProps, textElement); if (initialBr) { result.InsertBefore(new S.Break(), textElement); } return(result); }
private static Run GetRun(IXLRichString rt) { var run = new Run(); var runProperties = new RunProperties(); var bold = rt.Bold ? new Bold() : null; var italic = rt.Italic ? new Italic() : null; var underline = rt.Underline != XLFontUnderlineValues.None ? new Underline {Val = rt.Underline.ToOpenXml()} : null; var strike = rt.Strikethrough ? new Strike() : null; var verticalAlignment = new VerticalTextAlignment {Val = rt.VerticalAlignment.ToOpenXml()}; var shadow = rt.Shadow ? new Shadow() : null; var fontSize = new FontSize {Val = rt.FontSize}; var color = GetNewColor(rt.FontColor); var fontName = new RunFont {Val = rt.FontName}; var fontFamilyNumbering = new FontFamily {Val = (Int32)rt.FontFamilyNumbering}; if (bold != null) runProperties.Append(bold); if (italic != null) runProperties.Append(italic); if (strike != null) runProperties.Append(strike); if (shadow != null) runProperties.Append(shadow); if (underline != null) runProperties.Append(underline); runProperties.Append(verticalAlignment); runProperties.Append(fontSize); runProperties.Append(color); runProperties.Append(fontName); runProperties.Append(fontFamilyNumbering); var text = new Text {Text = rt.Text}; if (rt.Text.PreserveSpaces()) text.Space = SpaceProcessingModeValues.Preserve; run.Append(runProperties); run.Append(text); return run; }
/// <summary> /// Append given text with a given font style. /// </summary> /// <param name="Text">The text.</param> /// <param name="TextFont">The font style.</param> public void AppendText(string Text, SLFont TextFont) { var run = new Run(); var runprops = new RunProperties(); if (TextFont.FontName != null) { runprops.Append(new RunFont { Val = TextFont.FontName }); } if (TextFont.CharacterSet != null) { runprops.Append(new RunPropertyCharSet { Val = TextFont.CharacterSet.Value }); } if (TextFont.FontFamily != null) { runprops.Append(new FontFamily { Val = TextFont.FontFamily.Value }); } if (TextFont.Bold != null) { runprops.Append(new Bold { Val = TextFont.Bold.Value }); } if (TextFont.Italic != null) { runprops.Append(new Italic { Val = TextFont.Italic.Value }); } if (TextFont.Strike != null) { runprops.Append(new Strike { Val = TextFont.Strike.Value }); } if (TextFont.Outline != null) { runprops.Append(new Outline { Val = TextFont.Outline.Value }); } if (TextFont.Shadow != null) { runprops.Append(new Shadow { Val = TextFont.Shadow.Value }); } if (TextFont.Condense != null) { runprops.Append(new Condense { Val = TextFont.Condense.Value }); } if (TextFont.Extend != null) { runprops.Append(new Extend { Val = TextFont.Extend.Value }); } if (TextFont.HasFontColor) { runprops.Append(TextFont.clrFontColor.ToSpreadsheetColor()); } if (TextFont.FontSize != null) { runprops.Append(new FontSize { Val = TextFont.FontSize.Value }); } if (TextFont.HasUnderline) { runprops.Append(new Underline { Val = TextFont.Underline }); } if (TextFont.HasVerticalAlignment) { runprops.Append(new VerticalTextAlignment { Val = TextFont.VerticalAlignment }); } if (TextFont.HasFontScheme) { runprops.Append(new FontScheme { Val = TextFont.FontScheme }); } if (runprops.ChildElements.Count > 0) { run.Append(runprops); } run.Text = new Text(); run.Text.Text = Text; if (SLTool.ToPreserveSpace(Text)) { run.Text.Space = SpaceProcessingModeValues.Preserve; } var bFound = false; var oxe = istrReal.FirstChild; foreach (var child in istrReal.ChildElements) { if (child is Text || child is Run) { oxe = child; bFound = true; } } if (bFound) { istrReal.InsertAfter(run, oxe); } else { istrReal.PrependChild(run); } }