public CommonWorkbook()
{
const int maxBuiltInFormats = 163;
for (var i = 0; i < maxBuiltInFormats; i++)
{
var numFmt = BuiltinNumberFormat.GetBuiltinNumberFormat(i);
if (numFmt != null)
{
Formats.Add(i, numFmt);
}
}
}
public NumberFormatString GetNumberFormatString(int numberFormatIndex)
{
if (Formats.TryGetValue(numberFormatIndex, out var numberFormat))
{
return(numberFormat);
}
numberFormat = BuiltinNumberFormat.GetBuiltinNumberFormat(numberFormatIndex);
if (numberFormat != null)
{
return(numberFormat);
}
// Fall back to "General" if the number format index is invalid
return(GeneralNumberFormat);
}