Created attachment 180095 [details]
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).
The whole SUMIFS result range in sheet "TB" becomes zero!
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: 184.108.40.206.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
# 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: 220.127.116.11.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":
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:
Affected users are encouraged to test the fix and report feedback.