[Libreoffice-bugs] [Bug 91424] handling of relative references in OOXML range names

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=91424

--- Comment #6 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
Created attachment 173554
  --> https://bugs.documentfoundation.org/attachment.cgi?id=173554&action=edit
The example file in Excel and Calc

Still a problem in:

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 213430e0bdac0786b30a76a68b43d35647e93912
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL Jumbo

You need jumbo sheets enabled since the defined names are in that range:

        <definedNames>
                <definedName name="Name1">Sheet1!XFD1</definedName>
                <definedName name="Name2">Sheet1!$A$1</definedName>
                <definedName name="Name3">Sheet1!XFD1048576:B2</definedName>
        </definedNames>

Of these Name2 is an absolute reference and opens correctly.
Name1 and Name3 are relative and the XFD column designations open as a #REF!
error.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210714/ec559478/attachment.htm>