Bug 91424 - handling of relative references in OOXML range names
Summary: handling of relative references in OOXML range names
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX Cell-Reference Calc-large-spreadsheets
  Show dependency treegraph
 
Reported: 2015-05-21 08:24 UTC by Markus Mohrhard
Modified: 2022-02-19 16:20 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
old patch attempt (5.63 KB, patch)
2015-05-21 09:25 UTC, Markus Mohrhard
Details
automated import test for it (9.40 KB, patch)
2015-05-21 09:26 UTC, Markus Mohrhard
Details
Example file extracted from the unit test patch (7.55 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-07-14 09:19 UTC, NISZ LibreOffice Team
Details
The example file in Excel and Calc (88.11 KB, image/png)
2021-07-14 09:52 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Markus Mohrhard 2015-05-21 08:24:21 UTC
relative references in range names are not handled correctly as they depend on wrapping references.
Comment 1 Markus Mohrhard 2015-05-21 09:25:50 UTC
Created attachment 115764 [details]
old patch attempt

Was a wrong idea. Just included for completeness.
Comment 2 Markus Mohrhard 2015-05-21 09:26:44 UTC
Created attachment 115765 [details]
automated import test for it

Test is failing even with aforementioned patch.
Comment 3 QA Administrators 2016-09-20 09:42:46 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2019-12-03 14:38:37 UTC Comment hidden (obsolete)
Comment 5 NISZ LibreOffice Team 2021-07-14 09:19:41 UTC
Created attachment 173552 [details]
Example file extracted from the unit test patch
Comment 6 NISZ LibreOffice Team 2021-07-14 09:52:21 UTC
Created attachment 173554 [details]
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.