| Summary: | Autofilter result is wrong when cells contain formatted rounded values | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Kevin Suo <suokunlong> |
| Component: | Calc | Assignee: | Balázs Varga (allotropia) <balazs.varga991> |
| Status: | VERIFIED FIXED | ||
| Severity: | normal | CC: | aron.budea, balazs.varga991, gladys7david, ilmari.lauhakangas, miguelangelrv, telesto, xiscofauli |
| Priority: | medium | Keywords: | bibisected, bisected, regression |
| Version: | 7.5.0.3 release | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=158314 https://bugs.documentfoundation.org/show_bug.cgi?id=117276 |
||
| Whiteboard: | target:24.8.0 target:24.2.5 | ||
| Crash report or crash signature: | Regression By: | Balazs Varga | |
| Bug Depends on: | |||
| Bug Blocks: | 103512 | ||
| Attachments: | test doc | ||
|
Description
Kevin Suo
2024-06-07 12:40:29 UTC
HI Kevin , Thank you for reporting the bug. I can confirm that i can reproduce the bug in windows version: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 74185b8edf7f046a3372319da86a1d8ca0024c87 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: CL threaded. Thank you ReproducibleVersion: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 6d39b1a6068bbbd5ca4947f668f989dbfb73342d CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded 0.00 is not available to select. Last working for me on which ones I have installed. Version: 7.5.9.2 (X86_64) / LibreOffice Community Build ID: cdeefe45c17511d326101eed8008ac4092f278a9 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded Bibisected with linux-64-7.5 to 2d1df9f3dccc10f13b8585ad18afce1542ebc4d1 tdf#117276 sc: Show hidden filter elements as inactive elements Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/db153afbac7acc1ae46f78beef4221e9aad07305 tdf#161457 - Fix autofilter result is wrong when cells contain It will be available in 24.8.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. > https://git.libreoffice.org/core/commit/
> db153afbac7acc1ae46f78beef4221e9aad07305
Maybe someone can double check (verify) if its really solved the issue, just to be sure, before backport to any earlier versions, please. :)
Verified in Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 567dbcf68711402736f65f4a0a47ef57549fe50f CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded @Balázs Varga, thanks for fixing this issue!! Balazs Varga committed a patch related to this issue. It has been pushed to "libreoffice-24-2": https://git.libreoffice.org/core/commit/d23246f1a284f4d4f2c10af60e77ce1a424fd599 tdf#161457 - Fix autofilter result is wrong when cells contain It will be available in 24.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. |