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"); }