Bug 76887 - VIEWING: can't filter on numeric fields in microsoft access databases
Summary: VIEWING: can't filter on numeric fields in microsoft access databases
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Database (show other bugs)
Version: 4.1.5.3 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-04-01 08:06 UTC by pasqual milvaques
Modified: 2015-01-03 17:39 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments
testcase to reproduce the problem (10.65 KB, application/zip)
2014-04-01 08:11 UTC, pasqual milvaques
Details

Description pasqual milvaques 2014-04-01 08:06:34 UTC
Opening a Microsoft Access (mdb) database in LibreOffice base works ok but when trying to apply a filter, in a numeric field in a table, it fails to be applied without showing any error. Filtering in standard text fields works correctly 

Using autofilter in a numeric fiels works ok
Comment 1 pasqual milvaques 2014-04-01 08:11:38 UTC
Created attachment 96699 [details]
testcase to reproduce the problem

To test the problem open the testcase_filter.odb file (in a windows machine, the mdb file must be in the same directory as the odb)

In the UI enter in the sample_table table and try to apply a standard filter to the num_field field (for example num_field >= 500), the filter is not applied and the UI shows no change
Comment 2 Julien Nabet 2014-07-22 12:46:04 UTC
On Win7 and LO 4.2.5, I can reproduce this.
Comment 3 Alex Thurgood 2015-01-03 17:39:16 UTC
Adding self to CC if not already on


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.