Issue 124459 - links to 1) other sheets 2) other workbooks are changing at either save or open
Summary: links to 1) other sheets 2) other workbooks are changing at either save o...
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 4.0.1
Hardware: PC Windows 7
: P3 Blocker (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2014-03-19 03:02 UTC by Alan Jamieson
Modified: 2017-05-20 09:57 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Alan Jamieson 2014-03-19 03:02:51 UTC
I have a work book with about 10 named ranges
All ranges are workbook wide
5 are for sheets with the current workbook
The original development was in Excel 2007
I wish to use OpenOffice to make use of text display features.

I have:
1) opened the original in Excel and saved as ODS
2) opened the original in OpenOffice and saved as ODS

Either way the links "lose":
a) the name original sheetname and assume the name of the sheet the workbook opens with.
b) that they are fixed to the sheet named when creating the link in Excel

Having opened the workbook in Open Office I have immediately:
   changed the links to refer to the relevant sheet; 
   applied the fix "$" character to the sheet reference; and 
   saved the resultant work.

On opening the newly saved worksheet the situation is the same 
as when first opened after saving from Excel.
Comment 1 Edwin Sharp 2014-03-19 06:50:05 UTC
Please attach workbook.
Comment 2 Edwin Sharp 2014-04-01 11:51:40 UTC
No info from author.