https://bugs.documentfoundation.org/show_bug.cgi?id=164369
Bug ID: 164369
Summary: Percent formatted values appear incorrectly in
Standard Filter dialog
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 109326
Created attachment 198170
--> https://bugs.documentfoundation.org/attachment.cgi?id=198170&action=edit
Screenshot of the Standard Filter dialog
This is related to bug 163395, and reproducible once its patch gets merged. Or
in older versions before 7.1.
When the example file attachment 197013 is opened in Calc and I try to set a
standard filter on the percentage values in column D, the Standard Filter
dialog shows them with many digits and not formatted like in the cells. This
can cause incorrect filtering, as the values may be rounded to 1/2 digits and
filtering for the many digit representation of values may give different
results than expected.
1. Open attachment 197013
2. Data - More Filters - Standard Filter
3. Select the Open Ratio - 23 field name
4. Select <= as Condition
5. Select a value with many digits like "31.578947368421%" - these do not
consider the formatting set in the sheet, similar to the Autofilter
-> the value 31.58 is not <= than the above, so it is not shown.
However, a sane approach would be to list in the Autofilter and Standard Filter
list the formatted values.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=109326
[Bug 109326] [META] Data filter bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
