internal int AddFormat(string format)
{
if (format == null || format.Length == 0)
{
return(0);
}
if (!m_formatStringMap.TryGetValue(format, out int value))
{
value = m_currentCustomFormatIndex;
BIFF8Format item = new BIFF8Format(format, value);
m_formatStringMap.Add(format, value);
m_formatIntMap.Add(value, m_formats.Count);
m_formats.Add(item);
m_currentCustomFormatIndex++;
}
return(value);
}
private void AddBuiltInFormats()
{
BIFF8Format item = new BIFF8Format("General", 0);
m_formats.Add(item);
m_formatIntMap.Add(item.Index, 0);
m_formatStringMap.Add(item.String, item.Index);
m_formats.Add(new BIFF8Format("0", 1));
m_formats.Add(new BIFF8Format("0.00", 2));
m_formats.Add(new BIFF8Format("#,##0", 3));
m_formats.Add(new BIFF8Format("#,##0.00", 4));
m_formats.Add(new BIFF8Format("\"$\"#,##0_);\\(\"$\"#,##0\\)", 5));
m_formats.Add(new BIFF8Format("\"$\"#,##0_);[Red]\\(\"$\"#,##0\\)", 6));
m_formats.Add(new BIFF8Format("\"$\"#,##0.00_);\\(\"$\"#,##0.00\\)", 7));
m_formats.Add(new BIFF8Format("\"$\"#,##0.00_);[Red]\\(\"$\"#,##0.00\\)", 8));
m_formats.Add(new BIFF8Format("0%", 9));
m_formats.Add(new BIFF8Format("0.00E+00", 11));
m_formats.Add(new BIFF8Format("#?/?", 12));
m_formats.Add(new BIFF8Format("#??/??", 13));
m_formats.Add(new BIFF8Format("M/D/YY", 14));
m_formats.Add(new BIFF8Format("D-MMM-YY", 15));
m_formats.Add(new BIFF8Format("D-MMM", 16));
m_formats.Add(new BIFF8Format("MMM-YY", 17));
m_formats.Add(new BIFF8Format("h:mm AM/PM", 18));
m_formats.Add(new BIFF8Format("h:mm:ss AM/PM", 19));
m_formats.Add(new BIFF8Format("h:mm", 20));
m_formats.Add(new BIFF8Format("h:mm:ss", 21));
m_formats.Add(new BIFF8Format("M/D/YYYY h:mm", 22));
m_formats.Add(new BIFF8Format("(#,##0_);(#,##0)", 37));
m_formats.Add(new BIFF8Format("(#,##0_);[Red](#,##0)", 38));
m_formats.Add(new BIFF8Format("(#,##0.00_);(#,##0.00)", 39));
m_formats.Add(new BIFF8Format("(#,##0.00_);[Red](#,##0.00)", 40));
m_formats.Add(new BIFF8Format("_(* #,##0_);_(* \\(#,##0\\);_(* \"-\"_);_(@_)", 41));
m_formats.Add(new BIFF8Format("_(\"$\"* #,##0_);_(\"$\"* \\(#,##0\\);_(\"$\"* \"-\"_);_(@_)", 42));
m_formats.Add(new BIFF8Format("_(* #,##0.00_);_(* \\(#,##0.00\\);_(* \"-\"??_);_(@_)", 43));
m_formats.Add(new BIFF8Format("_(\"$\"* #,##0.00_);_(\"$\"* \\(#,##0.00\\);_(\"$\"* \"-\"??_);_(@_)", 44));
m_formats.Add(new BIFF8Format("mm:ss", 45));
m_formats.Add(new BIFF8Format("[h]:mm:ss", 46));
m_formats.Add(new BIFF8Format("mm:ss.0", 47));
m_formats.Add(new BIFF8Format("##0.0E+0", 48));
m_formats.Add(new BIFF8Format("@", 49));
}