https://bugs.documentfoundation.org/show_bug.cgi?id=159973
--- Comment #1 from Rafael Lima <[email protected]> --- Created attachment 192877 --> https://bugs.documentfoundation.org/attachment.cgi?id=192877&action=edit Sample file for testing I can confirm the weird behavior with queryPrecedents when the range is in a different sheet. I created a sample file with a macro to make it easier to test. Steps to reproduce 1) Open the test file 2) Select cell B7 in Sheet1 and click "Show Precedents" 3) Notice it will show precedents correctly, since they're in the same sheet 4) Click cell A15 from Sheet1 (which contains a formula that uses a range from Sheet2 5) Click the button "Show Precedents" 6) Notice that the returned range for the second parameter is not correct Tested with Version: 7.6.5.2 (X86_64) / LibreOffice Community Build ID: 60(Build:2) CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 4:7.6.5-0ubuntu0.23.10.1 Calc: threaded Also repro with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 52806e4c1e241d12419373cb0ed013356e12c4b8 CPU threads: 16; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
