| Summary: | [Autofilter] [Standard Filter] Dates and ALT-entered values are NOT being filtered. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | folibof |
| Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | mariosv |
| Version: | 4.2.1.1 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
| Attachments: | Spreadsheet with filter samples and repro instructions. | ||
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.
Created attachment 95396 [details] Spreadsheet with filter samples and repro instructions. Hi, I was using the Autofilter function to select rows in a spreadsheet in order to categorize these rows by filling in a "category value" in an empty column. The easiest way is of course to select all the filtered cells at once and, using ALT-enter, quickly fill in the same category value. It appears however, that these ALT-entered values can NOT be selected in subsequent Autofilter actions! I made some more tests in the attached "Autofilter test.ods" file. It appears that there is a problem for date-formatted cells in general but also for text-formatted cells when using ALT-enter. I haven't tested yet in different versions. Best! Frans