Created attachment 180095 [details] test-sumifs.ods In the attached ods file, sheet "pivot" contains the Debit Amount and Credit Amount for each General Ledger account, and sheet "TB" tries to get the Debit/Credit totals in order to generate a Trial Balance, using SUMIFS formula. If one modifies the Debit Amount or Credit Amount of any single cell in sheet "pivot", the Debit/Credit amount in TB will become 0 for the whole column. The test ods document was generated using LibreOffice 7.3. It works OK in 7.3, thus this is a critical regression. Steps to Reproduce: 1. Open the attached test ods file with current master. Observe that in the highlighted range in sheet "TB", the SUMIFS results are correctly shown. 2. Go to sheet "pivot", modify the value in any single cell (e.g. change the value in D5 to 1). Current Result: The whole SUMIFS result range in sheet "TB" becomes zero! Expected Result: SUMIFS result should be correctly calculated. i.e., if I change e.g. pivot.D5 to 1, then in sheet TB the result for account 1405001006 should be 1 and all other accounts should remain unchanged. Version: 7.4.0.0.alpha1+ / LibreOffice Community Build ID: 9391e9fb99a87e71897e29da79eba084682fdaa5 CPU threads: 8; OS: Linux 5.17; UI render: default; VCL: gtk3 Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN Build Platform: Fedora34@X64, Branch:master, bibisect-linux-64-7.4-CN Calc: threaded Fedora 35.
# bad: 2022-05-11 11:48:37 source-hash-e98a22b4e # good: 2022-05-11 11:48:14 source-hash-eaa2b5054 # first bad commit: 2022-05-11 11:48:37 source-hash-e98a22b4e This range contains only one commit thus it is bisected to: author Luboš Luňák 2022-05-06 20:50:32 +0200 committer Luboš Luňák 2022-05-11 11:48:37 +0200 commit e98a22b4e4f9c5a9249e634dd0489d30d9de2bb1 (patch) use ScSortedRangeCache also for generic queries Adding cc to Luboš Luňák, could you please take a look? Thanks.
Confirm with Version: 7.4.0.0.alpha1+ / LibreOffice Community Build ID: 75f7e057039aaa49558e22d18cad651d11589da9 CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Jumbo
Luboš Luňák committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/8f61250bf9804ed54e7d960f1446a40b29d1a122 no ScSortedRangeCache-based query for number-as-string (tdf#149071) 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.