Bug 37880 - FILEOPEN .xlsx: defined names are not recognized
Summary: FILEOPEN .xlsx: defined names are not recognized
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.0 release
Hardware: x86 (IA32) All
: medium normal
Assignee: Markus Mohrhard
Whiteboard: target:3.5 target:3.4.2
: 38763 (view as bug list)
Depends on:
Reported: 2011-06-03 08:22 UTC by Marius
Modified: 2012-11-30 05:06 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

test file (11.76 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2011-06-07 18:35 UTC, Marius

Note You need to log in before you can comment on or make changes to this bug.
Description Marius 2011-06-03 08:22:15 UTC
After opening al xlsx file the defined names are not recognized and the references to them  are substituted with "=#NAME?". It's worth to mention that the same file is perfectly recognized by version 3.3.2 .
Comment 1 Markus Mohrhard 2011-06-06 20:44:20 UTC
Can you provide a test document that shows the problem?
Comment 2 Marius 2011-06-07 18:35:54 UTC
Created attachment 47698 [details]
test file

In the ver. 2.0 sheet you can see the bug.
Comment 3 Rainer Bielefeld Retired 2011-06-10 02:58:08 UTC
RC2 is bit by bit identical with release version, so separate items in the version picker are useless. Changes have been discussed with Michael Meeks.
Comment 4 Markus Mohrhard 2011-06-16 10:20:53 UTC
thanks for your test file.

we have a similar bug report for xls: https://bugs.freedesktop.org/show_bug.cgi?id=38204

Let's see if they have point to the same problem.

I have a look at both.
Comment 5 Markus Mohrhard 2011-06-22 10:22:00 UTC
Ok I have a fix and I think I will add it to master in some days.

I think we will add it to 3.4.2 too.
Comment 6 Markus Mohrhard 2011-06-23 06:37:37 UTC
pushed to master, before it will pushed to 3-4 Kohei should have a look at it
Comment 7 Katarina Behrens 2011-06-29 05:08:14 UTC
*** Bug 38763 has been marked as a duplicate of this bug. ***
Comment 8 Kohei Yoshida 2011-07-07 22:44:48 UTC
Pushed to the -3-4 branch as well for 3.4.2.