diff options
| author | Kohei Yoshida <kohei.yoshida@suse.com> | 2011-12-12 14:08:27 -0500 |
|---|---|---|
| committer | Kohei Yoshida <kohei.yoshida@suse.com> | 2011-12-12 14:10:43 -0500 |
| commit | f162980219bb6ab01d099eda57897c5b0a9aa6fe (patch) | |
| tree | a3677cf168d82bb1a6045958f9d0ad0c4ea91129 /sc | |
| parent | 5438fef04f0e1cdc114b645d50bec94cea17c6da (diff) | |
Fix filtering by inequality operators e.g. >5, <=3, etc.
Diffstat (limited to 'sc')
| -rw-r--r-- | sc/source/ui/dbgui/filtdlg.cxx | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/sc/source/ui/dbgui/filtdlg.cxx b/sc/source/ui/dbgui/filtdlg.cxx index 26616ebb2619..2bb76ea98aaa 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(); |