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@lists.freedesktop.org Reporter: dongsh...@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.