https://bugs.documentfoundation.org/show_bug.cgi?id=114487
Justin L <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |ASSIGNED
CC| |[email protected]
Assignee|[email protected] |[email protected]
|desktop.org |
Ever confirmed|0 |1
--- Comment #4 from Justin L <[email protected]> ---
So just to get the terminology straight (hopefully). It is OK that the scope
is global. That means that you could *reference* the range from any sheet -
which seems perfectly legitimate. However, the range needs to be absolute
instead of relative. Thus HTML_1 should always point to the appropriate sheet,
and not be different depending on which sheet is requesting the named range.
In initial testing, it seems like the range might already might be absolute,
but that theory didn't survive a round-trip. So forcing a sheet name for the
range is necessary. The default is for a range to be absolute, so the only
change to make is setting Flag3D to true so that the "Sheet#" is added to the
range.
void ScHTMLImport::InsertRangeName( ScDocument* pDoc, const OUString& rName,
const ScRange& rRange )
{
ScComplexRefData aRefData;
aRefData.InitRange( rRange );
+ aRefData.Ref1.SetFlag3D(true);
+ aRefData.Ref2.SetFlag3D(true);
https://gerrit.libreoffice.org/54725 tdf#114487
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
