[Libreoffice-bugs] [Bug 144253] New: About the functionality of standard filters

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144253

            Bug ID: 144253
           Summary: About the functionality of standard filters
           Product: LibreOffice
           Version: 7.2.0.4 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dongshili at qq.com

Description:
工作表显示两位小数的近似值，筛选器里显示真实值，导致无法筛选
The worksheet shows the approximate value of two decimal places, and the filter
shows the real value, so it cannot be filtered

Steps to Reproduce:
1.Open my attachment and filter for quantity
2.
3.

Actual Results:
当筛选条件是一组非整数的值，单元格内设置保留2位小数，但是在筛选时显示的是一个保留13位小数的真实值，导致无法依据2位小数进行筛选。
When the filter condition is a group of non integer values, 2 decimal places
are reserved in the cell setting, but a real value with 13 decimal places is
displayed during filtering, so it is impossible to filter according to 2
decimal places.

Expected Results:
我认为这是个体验的问题，筛选这个事，从体验和逻辑上来看，就应该是所见即所得，应该采用看得见的相对值，而不是绝对值，因为到底筛选的精度如何，需要筛选人来通过小数位数来控制，在7.0.6和7.1.5版本的测试中，虽然可以筛选，但是筛选器也是绝对值，这个不是很合理。
I think this is a matter of experience. From the perspective of experience and
logic, screening should be what you see is what you get, and the visible
relative value should be used instead of the absolute value, because the
accuracy of screening needs to be controlled by the filter through the decimal
places. In the tests of versions 7.0.6 and 7.1.5, although it can be screened,
the filter is also an absolute value, This is not very reasonable.

For example, in most work and life scenarios, we can keep two digits. Generally
speaking, there is no difference between 95.554 and 95.553 for the data
analysis of non military scientific research. After all rounding, it is 95.55,
and the filter search 95.55 is two. If you use the absolute value to screen,
you can only see one. Of course, you can check the similar ones yourself, But
this is less practical.
举个例子，大多数工作和生活场景下，我们保留2位即可，一般来说，95.554和95.553
对于做非军工科研的数据分析来说，没有区别，所有四舍五入后就是95.55，筛选器搜95.55就是2条，如果用绝对值筛选，那么只能看到一条，当然你自己去挑看起来差不多的都勾上也行，但是这个就比较不实用了。


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.2.0.4 (x64) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210902/8356b024/attachment-0001.htm>