public void GetFontHeightTinyFontSizeDefaultsToMinimumKnownSize()
{
var defaultedHeight = ExcelFontXml.GetFontHeight("Calibri", 2);
var calibriHeight = ExcelFontXml.GetFontHeight("Calibri", 6);
Assert.AreEqual(calibriHeight, defaultedHeight);
}
public void GetFontHeightHugeFontSizeDefaultsToMaximumKnownSize()
{
var defaultedHeight = ExcelFontXml.GetFontHeight("Calibri", 5000);
var calibriHeight = ExcelFontXml.GetFontHeight("Calibri", 256);
Assert.AreEqual(calibriHeight, defaultedHeight);
}
public void GetFontHeightFakeFontDefaultsToCalibri()
{
var defaultedHeight = ExcelFontXml.GetFontHeight("whatever", 8);
var calibriHeight = ExcelFontXml.GetFontHeight("Calibri", 8);
Assert.AreEqual(calibriHeight, defaultedHeight);
}
private double GetRowHeightFromCellFonts(int row, ExcelWorksheet ws)
{
var dh = ws.DefaultRowHeight;
if (double.IsNaN(dh) || ws.CustomHeight == false)
{
var height = dh;
var cse = new CellsStoreEnumerator <ExcelCoreValue>(_drawings.Worksheet._values, row, 0, row, ExcelPackage.MaxColumns);
var styles = _drawings.Worksheet.Workbook.Styles;
while (cse.Next())
{
var xfs = styles.CellXfs[cse.Value._styleId];
var f = styles.Fonts[xfs.FontId];
var rh = ExcelFontXml.GetFontHeight(f.Name, f.Size) * 0.75;
if (rh > height)
{
height = rh;
}
}
return(height);
}
else
{
return(dh);
}
}
private double GetRowHeightFromCellFonts(int row, ExcelWorksheet ws)
{
var dh = ws.DefaultRowHeight;
if (double.IsNaN(dh) || ws.CustomHeight == false)
{
var height = dh;
// This is a deceptively non-performant enumerator, because iterating across a row in the CellStore is relatively slow: O(lg( (# of columns with values in the worksheet) + (# of cells with a value in the worksheet) )).
var cse = _drawings.Worksheet._values.GetEnumerator(row, 0, row, ExcelPackage.MaxColumns);
var styles = _drawings.Worksheet.Workbook.Styles;
while (cse.MoveNext())
{
var xfs = styles.CellXfs[cse.Value._styleId];
var f = styles.Fonts[xfs.FontId];
var rh = ExcelFontXml.GetFontHeight(f.Name, f.Size) * 0.75;
if (rh > height)
{
height = rh;
}
}
return(height);
}
else
{
return(dh);
}
}
public void GetFontHeightHandlesAtSymbol()
{
var height = ExcelFontXml.GetFontHeight($"@{ExcelFontXmlTest.TestFont}", 8);
Assert.AreEqual(20, height);
}
public void GetFontHeight()
{
var height = ExcelFontXml.GetFontHeight(ExcelFontXmlTest.TestFont, 8);
Assert.AreEqual(20, height);
}
