Bug 74582 - Calc Named interval looses reference when reference is external
Summary: Calc Named interval looses reference when reference is external
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
Keywords: regression
Depends on:
Reported: 2014-02-05 18:57 UTC by Olivier Hallot
Modified: 2014-10-29 12:25 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Demonstrating Correct Behavior - LibreOffice 4.3 Built 25.02.14 (12.05 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-02-27 03:25 UTC, Joel Madero

Note You need to log in before you can comment on or make changes to this bug.
Description Olivier Hallot 2014-02-05 18:57:09 UTC
Calc looses named reference when the reference is external, on save and reload

Steps to reproduce

1) create a blank sheet, 

2) insert an external reference from another file in cell A1. The formula should be somthing like


3) copy the external reference expression of A1 formula

4) define a named interval with the external reference picked above. Give name os TEST

5) put the named reference in cell A2. Formula should be


6) Save file

7) Open the file again, inspect the named reference in Edit - Names - Manage, look for TEST

The named reference looses its content when it is an external reference.
Comment 1 Olivier Hallot 2014-02-05 19:51:18 UTC
I add that this feature works for LibreOffice 4.1.4

Comment 2 m_a_riosv 2014-02-05 23:32:48 UTC
Hi Olivier,

I can't reproduce the issue with:
Version: Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71
Comment 3 Björn Michaelsen 2014-02-06 01:01:29 UTC
add regression keyword as per comment 1.
Comment 4 Joel Madero 2014-02-26 02:46:24 UTC
I hate to ask but can I get reproducible steps for step 4, what is a named interval? Is it just insert -> Names -> Define?
Comment 5 Olivier Hallot 2014-02-26 08:30:07 UTC
yes. It is a way to give a name to a complex reference, thus improving readability.
Comment 6 Joel Madero 2014-02-27 03:25:34 UTC
Created attachment 94796 [details]
Demonstrating Correct Behavior - LibreOffice 4.3 Built 25.02.14

Can't reproduce:
Ubuntu 13.10
LibreOffive 4.3 master built last night

Attached: Document showing that named interval stores full path name
Comment 7 sophie 2014-04-02 08:05:33 UTC
I could not reproduce with and Ubuntu 13.10 - Sophie
Comment 8 Buovjaga 2014-10-29 12:25:41 UTC
It works for me.

Win 7 64-bit Version:
Build ID: 4586a3f564600f1a0ce15a5cb98868b43bb9351e
TinderBox: Win-x86@42, Branch:master, Time: 2014-10-29_07:28:16