Bug 44587 - export or import of formulas from xlsx using range names in matrix formulas is broken
Summary: export or import of formulas from xlsx using range names in matrix formulas i...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Master old -3.6
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2012-01-08 15:44 UTC by Markus Mohrhard
Modified: 2020-08-26 14:26 UTC (History)
0 users

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


Attachments
Example file in Calc and saved XLSX from 5.0 and 5.1 in Excel (91.86 KB, image/png)
2020-08-26 14:24 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 2012-01-08 15:44:42 UTC
NamedRange rangeName: ={ 1, 2, 3 | 4, 5 6 }

using ={rangeName} will be either wrongly exported or wrongly imported

See sc/qa/unit/subsequent_filters-test.cxx testRangeName and save the ods version as xlsx and enable the csv test for xlsx again.
Comment 1 ace_dent 2014-01-22 13:44:48 UTC
This may be related to:
Bug 56823 - Saving in MS Office formats loses data range
Comment 2 Joel Madero 2015-05-02 15:42:02 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2016-09-20 09:37:51 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2019-12-03 14:00:00 UTC Comment hidden (obsolete)
Comment 5 NISZ LibreOffice Team 2020-08-26 14:24:32 UTC
Created attachment 164720 [details]
Example file in Calc and saved XLSX from 5.0 and 5.1 in Excel

This seems to have been solved in 5.1 when tested saving core\sc\qa\unit\data\ods\named-ranges-global.ods to XLSX
Comment 6 NISZ LibreOffice Team 2020-08-26 14:26:08 UTC
Bibisect-win32-5.1 shows this got better with:

https://cgit.freedesktop.org/libreoffice/core/commit/?id=beb8e2830dc9e1c771e196fcaf08cdfd6bf3dde3

author	yogesh.bharate001 <yogesh.bharate@synerzip.com>	2015-06-02 16:39:09 +0530
committer	David Tardon <dtardon@redhat.com>	2015-06-12 14:41:54 +0000

tdf#61908:XLSX formula cell range is not exported for MMULT.