[Bug 159973] queryPrecedents returns cells as if in same sheet

2024-03-01 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=159973 --- Comment #4 from Patrick Traill --- It may be worth mentioning that the menu function Tools – Detective – Trace Precedents does show (with a diamond) that there are one or more precedents in a different sheet, presumably meaning that

[Bug 159973] queryPrecedents returns cells as if in same sheet

2024-03-01 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=159973 --- Comment #3 from Patrick Traill --- (In reply to Rafael Lima from comment #2) > (In reply to Patrick Traill from comment #0) > > It also seems to me that enumerating the precedent cells only returns the > > first one, but I am not

[Bug 159973] queryPrecedents returns cells as if in same sheet

2024-02-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=159973 Rafael Lima changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED

[Bug 159973] queryPrecedents returns cells as if in same sheet

2024-02-29 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=159973 --- Comment #1 from Rafael Lima --- Created attachment 192877 --> https://bugs.documentfoundation.org/attachment.cgi?id=192877=edit Sample file for testing I can confirm the weird behavior with queryPrecedents when the range is in a