diff options
-rw-r--r-- | sc/source/core/data/column3.cxx | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sc/source/core/data/column3.cxx b/sc/source/core/data/column3.cxx index 521ccb389fe2..d5558e5087d6 100644 --- a/sc/source/core/data/column3.cxx +++ b/sc/source/core/data/column3.cxx @@ -2020,6 +2020,10 @@ class FilterEntriesHandler fVal = rtl::math::approxFloor(fVal); mbHasDates = true; bDate = true; + // Convert string representation to ISO 8601 date to eliminate + // locale dependent behaviour later when filtering for dates. + sal_uInt32 nIndex = pFormatter->GetFormatIndex( NF_DATE_DIN_YYYYMMDD); + pFormatter->GetInputLineString( fVal, nIndex, aStr); } // maybe extend ScTypedStrData enum is also an option here mrStrings.push_back(ScTypedStrData(aStr, fVal, ScTypedStrData::Value,bDate)); |