public void TestApplyFont()
{
XSSFRichTextString rt = new XSSFRichTextString();
rt.Append("123");
rt.Append("4567");
rt.Append("89");
Assert.AreEqual("123456789", rt.String);
XSSFFont font1 = new XSSFFont();
font1.IsBold = (true);
rt.ApplyFont(2, 5, font1);
Assert.AreEqual(4, rt.NumFormattingRuns);
Assert.AreEqual(0, rt.GetIndexOfFormattingRun(0));
Assert.AreEqual("12", rt.GetCTRst().GetRArray(0).t);
Assert.AreEqual(2, rt.GetIndexOfFormattingRun(1));
Assert.AreEqual("345", rt.GetCTRst().GetRArray(1).t);
Assert.AreEqual(5, rt.GetIndexOfFormattingRun(2));
Assert.AreEqual(2, rt.GetLengthOfFormattingRun(2));
Assert.AreEqual("67", rt.GetCTRst().GetRArray(2).t);
Assert.AreEqual(7, rt.GetIndexOfFormattingRun(3));
Assert.AreEqual(2, rt.GetLengthOfFormattingRun(3));
Assert.AreEqual("89", rt.GetCTRst().GetRArray(3).t);
}
public void TestApplyFont()
{
XSSFRichTextString rt = new XSSFRichTextString();
rt.Append("123");
rt.Append("4567");
rt.Append("89");
Assert.AreEqual("123456789", rt.String);
XSSFFont font1 = new XSSFFont();
font1.IsBold = (true);
rt.ApplyFont(2, 5, font1);
Assert.AreEqual(4, rt.NumFormattingRuns);
Assert.AreEqual(0, rt.GetIndexOfFormattingRun(0));
Assert.AreEqual("12", rt.GetCTRst().GetRArray(0).t);
Assert.AreEqual(2, rt.GetIndexOfFormattingRun(1));
Assert.AreEqual("345", rt.GetCTRst().GetRArray(1).t);
Assert.AreEqual(5, rt.GetIndexOfFormattingRun(2));
Assert.AreEqual(2, rt.GetLengthOfFormattingRun(2));
Assert.AreEqual("67", rt.GetCTRst().GetRArray(2).t);
Assert.AreEqual(7, rt.GetIndexOfFormattingRun(3));
Assert.AreEqual(2, rt.GetLengthOfFormattingRun(3));
Assert.AreEqual("89", rt.GetCTRst().GetRArray(3).t);
Assert.AreEqual(-1, rt.GetIndexOfFormattingRun(9999));
Assert.AreEqual(-1, rt.GetLengthOfFormattingRun(9999));
Assert.IsNull(rt.GetFontAtIndex(9999));
}
public void TestEmpty()
{
XSSFRichTextString rt = new XSSFRichTextString();
Assert.AreEqual(0, rt.GetIndexOfFormattingRun(9999));
Assert.AreEqual(-1, rt.GetLengthOfFormattingRun(9999));
Assert.IsNull(rt.GetFontAtIndex(9999));
}
public void TestEmpty()
{
XSSFRichTextString rt = new XSSFRichTextString();
Assert.AreEqual(0, rt.GetIndexOfFormattingRun(9999));
Assert.AreEqual(-1, rt.GetLengthOfFormattingRun(9999));
Assert.IsNull(rt.GetFontAtIndex(9999));
}
public void TestBug56511_values()
{
XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("56511.xlsx");
ISheet sheet = wb.GetSheetAt(0);
IRow row = sheet.GetRow(0);
// verify the values to ensure future Changes keep the returned information equal
XSSFRichTextString rt = (XSSFRichTextString)row.GetCell(0).RichStringCellValue;
Assert.AreEqual(0, rt.NumFormattingRuns);
Assert.IsNull(rt.GetFontOfFormattingRun(0));
Assert.AreEqual(-1, rt.GetLengthOfFormattingRun(0));
rt = (XSSFRichTextString)row.GetCell(1).RichStringCellValue;
Assert.AreEqual(0, row.GetCell(1).RichStringCellValue.NumFormattingRuns);
Assert.IsNull(rt.GetFontOfFormattingRun(1));
Assert.AreEqual(-1, rt.GetLengthOfFormattingRun(1));
rt = (XSSFRichTextString)row.GetCell(2).RichStringCellValue;
Assert.AreEqual(2, rt.NumFormattingRuns);
Assert.IsNotNull(rt.GetFontOfFormattingRun(0));
Assert.AreEqual(4, rt.GetLengthOfFormattingRun(0));
Assert.IsNotNull(rt.GetFontOfFormattingRun(1));
Assert.AreEqual(9, rt.GetLengthOfFormattingRun(1));
Assert.IsNull(rt.GetFontOfFormattingRun(2));
rt = (XSSFRichTextString)row.GetCell(3).RichStringCellValue;
Assert.AreEqual(3, rt.NumFormattingRuns);
Assert.IsNull(rt.GetFontOfFormattingRun(0));
Assert.AreEqual(1, rt.GetLengthOfFormattingRun(0));
Assert.IsNotNull(rt.GetFontOfFormattingRun(1));
Assert.AreEqual(3, rt.GetLengthOfFormattingRun(1));
Assert.IsNotNull(rt.GetFontOfFormattingRun(2));
Assert.AreEqual(9, rt.GetLengthOfFormattingRun(2));
}
