public uint AddFormat(ExcelCellNumberingFormat format)
{
if (format == null)
{
return(0);
}
if (format.Code == null || cache.Contains(format.Id))
{
return(format.Id);
}
if (stylesheet.NumberingFormats == null)
{
var numberingFormats = new NumberingFormats {
Count = new UInt32Value(0u)
};
stylesheet.InsertAt(numberingFormats, 0);
}
stylesheet.NumberingFormats.AppendChild(new NumberingFormat {
FormatCode = new StringValue(format.Code), NumberFormatId = format.Id
});
cache.Add(format.Id);
return(format.Id);
}
private static bool TryExtractStandardNumberingFormat(uint numberingFormat, out ExcelCellNumberingFormat result)
{
result = null;
if (numberingFormat == 2)
{
result = new ExcelCellNumberingFormat("0.00");
return(true);
}
return(false);
}
public uint AddFormat(ExcelCellNumberingFormat format)
{
if (format == null)
{
return(0);
}
var cacheItem = new NumberingFormatCacheItem(format);
if (cache.TryGetValue(cacheItem, out var formatId))
{
return(formatId);
}
if (stylesheet.NumberingFormats == null)
{
var numberingFormats = new NumberingFormats {
Count = new UInt32Value(0u)
};
stylesheet.InsertAt(numberingFormats, 0);
}
formatId = ++stylesheet.NumberingFormats.Count;
stylesheet.NumberingFormats.AppendChild(cacheItem.ToNumberingFormat(formatId));
cache.Add(cacheItem, formatId);
return(formatId);
}
public NumberingFormatCacheItem(ExcelCellNumberingFormat format)
{
FormatCode = format.FormatCode;
}
