diff options
| -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(); |