internal static int GetFormatId(string excelFormatCode, ref bool isBuiltIn)
{
if (BuiltInNumberFomrat.ContainsValue(excelFormatCode))
{
foreach (KeyValuePair <int, string> pair in _builtInNumberFomrat)
{
if (pair.Value == excelFormatCode)
{
isBuiltIn = true;
return(pair.Key);
}
}
}
if (BuiltInNumberFomrat2.ContainsKey(excelFormatCode))
{
isBuiltIn = true;
return(_builtInNumberFormat2[excelFormatCode]);
}
if (_customNumberFormat.ContainsKey(excelFormatCode))
{
isBuiltIn = false;
return(_customNumberFormat[excelFormatCode]);
}
int nextAvirableKey = GetNextAvirableKey();
_customNumberFormat.Add(excelFormatCode, nextAvirableKey);
isBuiltIn = false;
return(nextAvirableKey);
}
internal static string GetFormatCode(IExtendedFormat format)
{
if (format.NumberFormat != null)
{
if (BuiltInNumberFomrat.ContainsKey(format.NumberFormat.NumberFormatId) && (BuiltInNumberFomrat[format.NumberFormat.NumberFormatId] != format.NumberFormat.NumberFormatCode))
{
BuiltInNumberFomrat[format.NumberFormat.NumberFormatId] = format.NumberFormat.NumberFormatCode;
return(format.NumberFormat.NumberFormatCode);
}
if (BuiltInNumberFomrat2.ContainsKey(format.NumberFormat.NumberFormatCode) && (BuiltInNumberFomrat2[format.NumberFormat.NumberFormatCode] != format.NumberFormat.NumberFormatId))
{
BuiltInNumberFomrat2[format.NumberFormat.NumberFormatCode] = format.NumberFormat.NumberFormatId;
return(format.NumberFormat.NumberFormatCode);
}
if (!_customNumberFormat.ContainsKey(format.NumberFormat.NumberFormatCode))
{
_customNumberFormat.Add(format.NumberFormat.NumberFormatCode, format.NumberFormat.NumberFormatId);
}
return(format.NumberFormat.NumberFormatCode);
}
if (BuiltInNumberFomrat.ContainsKey(format.NumberFormatIndex))
{
return(BuiltInNumberFomrat[format.NumberFormatIndex]);
}
if (LanguageIndepedentNumberFormat.ContainsKey(format.NumberFormatIndex))
{
return(LanguageIndepedentNumberFormat[format.NumberFormatIndex]);
}
return("General");
}
