Issue 117481 - File references to multiple files are consistently messed up
Summary: File references to multiple files are consistently messed up
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.3
Hardware: PC Windows, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-20 23:49 UTC by terry
Modified: 2013-12-26 14:57 UTC (History)
2 users (show)

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

Attachments
sample spreadsheets (3.95 KB, application/x-zip-compressed)
2013-12-26 14:57 UTC, Edwin Sharp 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description terry 2011-03-20 23:49:50 UTC 
When open office calc opens an .XLS file with multiple file references in one formula, It puts in an extra reference which then returns an error 509.  This is even though the original reference was made in open office and saved in excel format.  Excel will open the same file and be happy!

Example:
Err:509
                                                                                                                                        
=-'file:///D:/1280 Alaska Garden/GL/1280CompGL1210-11.xls'#$CompGL.F230'file:///D:/1280 Alaska Garden/GL/Inv/1280Inv1210F.xls'#$'GC 4th QRT ''10 INVENTORY  '.D9:E9+SUM('file:///D:/1280 Alaska Garden/GL/Inv/1280Inv1210F.xls'#$'GC 4th QRT ''10 INVENTORY  '.D9:E9)

The correct reference is
=-'file:///D:/1280 Alaska Garden/GL/1280CompGL1210-11.xls'#$CompGL.F230+SUM('file:///D:/1280 Alaska Garden/GL/Inv/1280Inv1210F.xls'#$'GC 4th QRT ''10 INVENTORY  '.D9:E9)

In many ways I find Calc much better than Excel, but this is a hindrance as is the macro language.

Thank you!
Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:17:09 UTC 
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 2 Edwin Sharp 2013-12-26 14:47:28 UTC 
#REF! in Calc, #N/A in Excel 2010.

AOO410m1(Build:9750)  -  Rev. 1551017
Rev.1551017
Win 7
Comment 3 Edwin Sharp 2013-12-26 14:57:10 UTC 
Created attachment 82173 [details]
sample spreadsheets

look in file c which contains links to files a and b.