https://bugs.freedesktop.org/show_bug.cgi?id=75259
Priority: medium
Bug ID: 75259
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FILTER Auto filter on imported database range does not
work on columns of data type text
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: gdna7...@hotmail.com
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.1.1 rc
Component: Spreadsheet
Product: LibreOffice
Steps to reproduce:
* Connect an exiting database.
* Press F4 and drag a query including a field of type text into Cell A1 of a
new spreadsheet file (ods).
* from cell A1 press Ctrl + Shift + End to select the whole range
* Data --> Filter --> Auto Filter
* Select an existing entry from the drop down menu ON A FIELD BEING OF TYPE
TEXT AND INCLUDING NUMBERS. e.g. the string 36000.
Expected behavior:
*Filter applied
Actual behavior
*Nothing is shown (all entries are hidden).
Worth noting:
1.Selecting the whole range and copying it into a new document, the filter is
working as expected.
2. Saving and closing the document --> filter is working. However if you insert
a new query in the document and repeat the above steps, it is not working until
saved, closed and reopened.
3. This is a regression compared to 4.1.5 and prior (I did not install 4.2.0,
since my experience with .0 was seldom good) and the usecase should not be too
seldom for people using base and calc, which is why I classified it as major.
Unfortunately I cannot provide a document, as:
1. As described under "worth noting", it would not show the bug,
2. The documents I experienced this with, are used for work and contain
sensible information.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
