internal int DirectSaveToSharedStringTable(string Data)
{
int index = 0;
string sHash;
if (SLTool.ToPreserveSpace(Data))
{
sHash = string.Format("<x:t xml:space=\"preserve\">{0}</x:t>", Data);
}
else
{
sHash = string.Format("<x:t>{0}</x:t>", Data);
}
if (dictSharedStringHash.ContainsKey(sHash))
{
index = dictSharedStringHash[sHash];
}
else
{
index = listSharedString.Count;
listSharedString.Add(sHash);
dictSharedStringHash[sHash] = index;
}
return(index);
}
/// <summary>
/// Set the text. If text formatting is needed, use one of the AppendText() functions.
/// </summary>
/// <param name="Text">The text.</param>
public void SetText(string Text)
{
if (Text == null || Text.Length == 0)
{
this.istrReal.Text = null;
}
else
{
this.istrReal.Text = new Text();
this.istrReal.Text.Text = Text;
if (SLTool.ToPreserveSpace(Text))
{
this.istrReal.Text.Space = SpaceProcessingModeValues.Preserve;
}
}
}
internal TotalsRowFormula ToTotalsRowFormula()
{
TotalsRowFormula trf = new TotalsRowFormula();
if (this.Array)
{
trf.Array = this.Array;
}
if (SLTool.ToPreserveSpace(this.Text))
{
trf.Space = SpaceProcessingModeValues.Preserve;
}
trf.Text = this.Text;
return(trf);
}
internal CalculatedColumnFormula ToCalculatedColumnFormula()
{
CalculatedColumnFormula ccf = new CalculatedColumnFormula();
if (this.Array)
{
ccf.Array = this.Array;
}
if (SLTool.ToPreserveSpace(this.Text))
{
ccf.Space = SpaceProcessingModeValues.Preserve;
}
ccf.Text = this.Text;
return(ccf);
}
internal Run ToRun()
{
Run r = new Run();
r.RunProperties = new RunProperties();
if (this.Font.FontName != null)
{
r.RunProperties.Append(new RunFont()
{
Val = this.Font.FontName
});
}
if (this.Font.CharacterSet != null)
{
r.RunProperties.Append(new RunPropertyCharSet()
{
Val = this.Font.CharacterSet.Value
});
}
if (this.Font.FontFamily != null)
{
r.RunProperties.Append(new FontFamily()
{
Val = this.Font.FontFamily.Value
});
}
if (this.Font.Bold != null && this.Font.Bold.Value)
{
r.RunProperties.Append(new Bold());
}
if (this.Font.Italic != null && this.Font.Italic.Value)
{
r.RunProperties.Append(new Italic());
}
if (this.Font.Strike != null && this.Font.Strike.Value)
{
r.RunProperties.Append(new Strike());
}
if (this.Font.Outline != null && this.Font.Outline.Value)
{
r.RunProperties.Append(new Outline());
}
if (this.Font.Shadow != null && this.Font.Shadow.Value)
{
r.RunProperties.Append(new Shadow());
}
if (this.Font.Condense != null && this.Font.Condense.Value)
{
r.RunProperties.Append(new Condense());
}
if (this.Font.Extend != null && this.Font.Extend.Value)
{
r.RunProperties.Append(new Extend());
}
if (this.Font.HasFontColor)
{
r.RunProperties.Append(this.Font.clrFontColor.ToSpreadsheetColor());
}
if (this.Font.FontSize != null)
{
r.RunProperties.Append(new FontSize()
{
Val = this.Font.FontSize.Value
});
}
if (this.Font.HasUnderline)
{
r.RunProperties.Append(new Underline()
{
Val = this.Font.Underline
});
}
if (this.Font.HasVerticalAlignment)
{
r.RunProperties.Append(new VerticalTextAlignment()
{
Val = this.Font.VerticalAlignment
});
}
if (this.Font.HasFontScheme)
{
r.RunProperties.Append(new FontScheme()
{
Val = this.Font.FontScheme
});
}
r.Text = new Text(this.Text);
if (SLTool.ToPreserveSpace(this.Text))
{
r.Text.Space = SpaceProcessingModeValues.Preserve;
}
return(r);
}
/// <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)
{
Run run = new Run();
RunProperties 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;
}
bool bFound = false;
OpenXmlElement oxe = istrReal.FirstChild;
foreach (var child in this.istrReal.ChildElements)
{
if (child is Text || child is Run)
{
oxe = child;
bFound = true;
}
}
if (bFound)
{
istrReal.InsertAfter(run, oxe);
}
else
{
istrReal.PrependChild(run);
}
}