[Issue 56535] queryPrecedents (XFormulaQuery) on Calc-cells don't recognize cross-table-references

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=56535

Nick Hollon <ni...@everlaw.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |nick@everlaw.com

--- Comment #8 from Nick Hollon <ni...@everlaw.com> ---
I can confirm that this bug still exists.

And I think I have spotted where the cause lies. 

Internally, XFormulaQuery is correctly finding the cell references (with the
proper table id). But it is using a class called ScMarkData to keep track of
the references, and this class is only storing the row and column data, not the
table id.

In main/sc/inc/markdata.hxx, there is a TODO comment in German:

//!    todo:
//!    Es muss auch die Moeglichkeit geben, MarkArrays pro Tabelle zu halten,
//!    damit "alle suchen" ueber mehrere Tabellen wieder funktioniert!

Translation:
"There must also be the possibility to keep MarkArrays per table,
So "search all" over several tables again works!"

So somebody was already aware that this needed to be fixed.

Unfortunately, I don't feel qualified to actually submit a patch, but I hope my
small bit of detective work will be helpful. Thanks!

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are on the CC list for the issue.