Summary: | Standard filters involving "greater than" or "smaller than" (>, <, >=, <=) fail and hide everything | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Stéphane Guillou (stragu) <stephane.guillou> |
Component: | Calc | Assignee: | Balázs Varga <varga.balazs3> |
Status: | VERIFIED FIXED | ||
Severity: | major | CC: | libreoffice, miguelangelrv, nemeth, varga.balazs3 |
Priority: | medium | Keywords: | bibisected, bisected, regression |
Version: | 7.2.0.0 alpha1+ | ||
Hardware: | x86-64 (AMD64) | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=140968 https://bugs.documentfoundation.org/show_bug.cgi?id=143950 https://bugs.documentfoundation.org/show_bug.cgi?id=144159 https://bugs.documentfoundation.org/show_bug.cgi?id=144324 https://bugs.documentfoundation.org/show_bug.cgi?id=144253 https://bugs.documentfoundation.org/show_bug.cgi?id=144142 https://bugs.documentfoundation.org/show_bug.cgi?id=144740 https://bugs.documentfoundation.org/show_bug.cgi?id=152082 |
||
Whiteboard: | target:7.3.0 target:7.2.0.0.beta2 target:7.2.2 target:7.4.0 target:7.3.0.0.beta2 target:7.2.5 | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 109326 | ||
Attachments: | example spreadsheet showing the issue, created with LO 7.3 |
Description
Stéphane Guillou (stragu)
2021-06-17 11:51:36 UTC
Created attachment 172968 [details]
example spreadsheet showing the issue, created with LO 7.3
This example spreadsheet has one sheet per common numeric conditional operator: =, <, >, <=, >=, <>.
The issue can be seen in sheets 2, 3, 4 and 5.
It was created with Calc 7.3.0 alpha0+.
This file could probably be used for a test once the regression is fixed?
(Note that opening this file in a version that does not have the regression still displays the wrong filtering.)
Repro Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community Build ID: aa9cb8e14749e7fb7a83b55a2bb095501f731a18 CPU threads: 4; OS: Windows 10.0 Build 21387; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL Bibisected with bibisect-win64-7.2 to: https://git.libreoffice.org/core/+/d5c2584bf36d21580db677b231c57f99f49aa2cb author Balazs Varga <balazs.varga991@gmail.com> Thu Apr 22 10:23:41 2021 +0200 committer László Németh <nemeth@numbertext.org> Tue May 04 10:13:27 2021 +0200 Related: tdf#140968 avoid duplicated filter values Adding CC to: Balazs Varga Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f6b143a57d9bd8f5d7b29febcb4e01ee1eb2ff1d tdf#142910 sc filter: fix "greater than" or "smaller than" etc It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Balazs Varga committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/3069df790cca2917e5aedd87bac1af65f9605d51 tdf#142910 sc filter: fix "greater than" or "smaller than" etc It will be available in 7.2.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Verified as fixed in a build of today's master. Thank you Balazs! :) Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b60b6bfaafa1315e07108dba50f016975b619c59 Resolves: tdf#144740 Fix broken compareByValue() query, tdf#142910 tdf#144253 It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/825a96114a7693335be000b2aa661df88a02e273 Resolves: tdf#144740 Fix broken compareByValue() query, tdf#142910 tdf#144253 It will be available in 7.2.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-2-2": https://git.libreoffice.org/core/commit/dc1642c3225ff4aeada5df749946f406772eb1ff Resolves: tdf#144740 Fix broken compareByValue() query, tdf#142910 tdf#144253 It will be available in 7.2.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Justin Luth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/ac1ea5944a236efef75af7c85d0ffe10d374e7fa new ScTypedStrData: typically missed argument in CTOR, tdf#142910 follow-up It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/77727e6dbcf1a42113ed442d840e941b5ce08bcd new ScTypedStrData: typically missed argument in CTOR, tdf#142910 follow-up It will be available in 7.3.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/20c1ab5d85e3f24d4cdf6ab167ea6ce98e2586b4 new ScTypedStrData: typically missed argument in CTOR, tdf#142910 follow-up It will be available in 7.2.5. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |