summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorLionel Elie Mamane <lionel@mamane.lu>2014-08-18 20:38:43 +0200
committerLionel Elie Mamane <lionel@mamane.lu>2014-08-18 20:42:12 +0200
commit5eaa0e76fb59ed7699c12b84a6d9c052fec3c128 (patch)
tree8b9d77aba8d24dd1c0b2821e7c18c82cacec6112
parent5d5c102e36bcc7eac6ae89d44a635e5d9b680e40 (diff)
fdo#82757 call convertStringToNumber and detectNumberFormat with same locale
So that they agree (among others) on date recognition patterns. Change-Id: I964142702b5bb23bca2c62433e52f76dfa4bdacb
-rw-r--r--connectivity/source/commontools/DateConversion.cxx16
1 files changed, 15 insertions, 1 deletions
diff --git a/connectivity/source/commontools/DateConversion.cxx b/connectivity/source/commontools/DateConversion.cxx
index 5371c431e0b6..954e9878413a 100644
--- a/connectivity/source/commontools/DateConversion.cxx
+++ b/connectivity/source/commontools/DateConversion.cxx
@@ -250,7 +250,21 @@ void DBTypeConversion::setValue(const Reference<XColumnUpdate>& xVariant,
try
{
double fValue = xFormatter->convertStringToNumber(nKeyToUse, rString);
- sal_Int32 nRealUsedKey = xFormatter->detectNumberFormat(0, rString);
+ Reference< XNumberFormats > xFormats(xFormatter->getNumberFormatsSupplier()->getNumberFormats());
+ Reference< XNumberFormatTypes > xFormatTypes(xFormats, UNO_QUERY);
+ assert(xFormatTypes.is());
+ sal_Int32 nStandardKey(0);
+ if(xFormatTypes.is())
+ {
+ css::lang::Locale loc;
+ OSL_VERIFY(xFormats->getByKey(nKeyToUse)->getPropertyValue("Locale") >>= loc);
+ nStandardKey = xFormatTypes->getStandardIndex(loc);
+ }
+ // Why use nStandardKey rather than nKeyToUse here? Don't know, but "it was always like that".
+ // Previously had hardcoded 0 instead of nStandardKey, which led to problems with dates
+ // because of differences M/D/Y vs D/M/Y. This at least fixes those problems, but possibly
+ // nKeyToUse is an even better choice than nStandardKey.
+ sal_Int32 nRealUsedKey = xFormatter->detectNumberFormat(nStandardKey, rString);
if (nRealUsedKey != nKeyToUse)
nRealUsedTypeClass = getNumberFormatType(xFormatter, nRealUsedKey) & ~NumberFormat::DEFINED;