[Libreoffice-commits] .: sc/source

[Kohei Yoshida]

 sc/source/ui/dbgui/filtdlg.cxx |    6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

New commits:
commit f162980219bb6ab01d099eda57897c5b0a9aa6fe
Author: Kohei Yoshida <kohei.yoshida at suse.com>
Date:   Mon Dec 12 14:08:27 2011 -0500

    Fix filtering by inequality operators e.g. >5, <=3, etc.

diff --git a/sc/source/ui/dbgui/filtdlg.cxx b/sc/source/ui/dbgui/filtdlg.cxx
index 26616eb..2bb76ea 100644
--- a/sc/source/ui/dbgui/filtdlg.cxx
+++ b/sc/source/ui/dbgui/filtdlg.cxx
@@ -1157,7 +1157,11 @@ IMPL_LINK( ScFilterDlg, ValModifyHdl, ComboBox*, pEd )
             {
                 rItem.maString = aStrVal;
                 rItem.mfVal = 0.0;
-                rItem.meType = ScQueryEntry::ByString;
+
+                sal_uInt32 nIndex;
+                bool bNumber = pDoc->GetFormatTable()->IsNumberFormat(
+                    rItem.maString, nIndex, rItem.mfVal);
+                rItem.meType = bNumber ? ScQueryEntry::ByValue : ScQueryEntry::ByString;
             }
 
             sal_uInt16  nField  = pLbField->GetSelectEntryPos();