introduce SvNumberFormatter::GetFormatStringForExcel()

Taking implementation from sc/source/filter/excel/xestyle.cxx
GetNumberFormatCode(), slightly modified to ensure valid conversion and
force en-US locale data. Also don't unnecessarily convert if format is
for system locale and system locale is en-US.

Change-Id: I9223eaa655132b4106a35c94cb0005559d7575b1

1 files changed, 11 insertions, 1 deletions

diff --git a/include/svl/zforlist.hxx b/include/svl/zforlist.hxx
index 159763b451d8..932fd8615907 100644
--- a/include/svl/zforlist.hxx
+++ b/include/svl/zforlist.hxx
@@ -759,9 +759,19 @@ public:
     void    FillKeywordTable( NfKeywordTable& rKeywords, LanguageType eLang );
 
     /** Fill a NfKeywordIndex table with keywords usable in Excel export with
-        GetMappedFormatstring() */
+        GetFormatStringForExcel() or SvNumberformat::GetMappedFormatstring() */
     void    FillKeywordTableForExcel( NfKeywordTable& rKeywords );
 
+    /** Return a format code string suitable for Excel export.
+
+        @param  rTempFormatter
+                SvNumberFormatter to use if a non-en-US format code needs to be
+                converted and put, should not be the same formatter to not
+                pollute the entries of this one here.
+     */
+    OUString GetFormatStringForExcel( sal_uInt32 nKey, const NfKeywordTable& rKeywords,
+            SvNumberFormatter& rTempFormatter ) const;
+
     /** Return a keyword for a language/country and NfKeywordIndex
         for XML import, to generate number format strings. */
     OUString GetKeyword( LanguageType eLnge, sal_uInt16 nIndex );