Summary: | Fails to apply AutoFilter or Standard Filter in Mail Merge dialog after it was applied once successfully (Writer+Calc) | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | lal <cardholm2002> |
Component: | LibreOffice | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | VERIFIED FIXED | ||
Severity: | normal | CC: | noelgrandin, stephane.guillou |
Priority: | medium | Keywords: | bibisected, bisected, regression |
Version: | 7.6.0.0 alpha0+ | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=52586 | ||
Whiteboard: | target:24.2.0 target:7.6.4 | ||
Crash report or crash signature: | Regression By: | Noel Grandin | |
Bug Depends on: | |||
Bug Blocks: | 102998, 109326 |
Description
lal
2023-11-05 13:20:41 UTC
Thank you for the report! (In reply to lal from comment #0) > (a) If applying Standard Filter, "field name" drop-down only states "empty" > and nothing else can be selected (all other parts greyed out). > (b) If applying AutoFilter, LO states "Error setting the filter criteria. > The column is not searchable!" Reproduced both (a) and (b), but _only after successfully applying a filter once_. 1. Have ODT linked to ODS as data source 2. Ctrl + P > Yes (to "print a form letter") 3. Apply AutoFilter on the table: works 4. Click "Cancel" 5. Bring the dialog up again: Ctrl + P > Yes. See that the filter is still active. Result: now, filtering fails as described by OP. Close and reopen the file, filter can be used once more. Same with an XLSX data source. Version: 7.6.3.1 (X86_64) / LibreOffice Community Build ID: c4af5b1259bceea6e979e6fe2435dbee7a5a87c2 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: baecfd21797310bb15ab98ca3962445d99e397db CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US No repro in 7.5: Version: 7.5.8.2 (X86_64) / LibreOffice Community Build ID: f718d63693263970429a68f568db6046aaa9df01 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded -> regression. Calc: threaded Bibisected with comment 1 steps and linux-64-7.6 repo to first bad build commit [72f0cb3c4944426945266c1dab48e09e9768c0c0] which points to: commit 66b0bc55854ba13b92b6c39b95f3f2d4ef76bf20 author Noel Grandin Fri Mar 10 10:35:33 2023 +0200 committer Noel Grandin Fri Mar 10 09:50:16 2023 +0000 simplify initialisation in *DatabaseMetaData Reviewed-on: https://gerrit.libreoffice.org/c/core/+/148594 Noel, can you please have a look? Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f23ee916466bd6e0d328a4e541e104445c8ecb0a tdf#158072 Fails to apply AutoFilter in Mail Merge dialog It will be available in 24.2.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. Noel Grandin committed a patch related to this issue. It has been pushed to "libreoffice-7-6": https://git.libreoffice.org/core/commit/8e81f2462962e0e4ff6b4546d5956df61d6f4d74 tdf#158072 Fails to apply AutoFilter in Mail Merge dialog It will be available in 7.6.4. 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. Fix verified in: Version: 24.2.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 619500d6919c227e734b119481a4b334972e0b7b CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Thank you lal and Noel! |