From 5b0c58818bcbe921075052b2dd11000edfade28b Mon Sep 17 00:00:00 2001 From: Eike Rathke Date: Fri, 17 Jul 2015 18:14:27 +0200 Subject: Resolves: tdf#92767 use ISO 8601 for internal date string representation Change-Id: I481bf3295feb64827de2122234a9300d0b8ced40 (cherry picked from commit 3e17ed1fc2845da5a279d21ffa3ea51d637e515e) Reviewed-on: https://gerrit.libreoffice.org/17172 Tested-by: Jenkins Reviewed-by: Michael Meeks Tested-by: Michael Meeks --- sc/source/core/data/column3.cxx | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/sc/source/core/data/column3.cxx b/sc/source/core/data/column3.cxx index 6c9922605a4f..40ec240370ca 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)); -- cgit v1.2.3