Bug 40726

Summary: ERR:517 for function "T" referring to other document
Product: LibreOffice Reporter: eric <ericfaure007>
Component: CalcAssignee: Kohei Yoshida <kohei>
Status: RESOLVED FIXED    
Severity: normal CC: LibreOffice
Priority: medium    
Version: 3.3.3 release   
Hardware: All   
OS: All   
Whiteboard: target:3.5
Crash report or crash signature: Regression By:
Attachments: Test kit, see Comment 1

Description eric 2011-09-08 12:43:03 UTC
When opening the file 1.Comportement.xls,
I get err:517 in all the cells referring to 0.Infos Eleves.xls file.
As example here is the formula of a cell getting err:517:
=T('file:///home/eric/Bureau/0.Info Eleves.xls'#$'Info élèves'.$E$11)

I get this error on all the Libreoffice versions.
On the other hand, The formula is working without errors in openoffice 3.3 and Ms office 2003/2007
Comment 1 Rainer Bielefeld Retired 2011-09-08 22:15:02 UTC
[Reproducible] with "LibreOffice 3.4.3 RC2 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:302)]", also with Server installation of Master "LibO-dev 3.5.0 – WIN7 Home Premium (64bit) English UI [(Build ID:  d3d1481-3f8994a-2ba0a9f)]", with "LibreOffice Portable 3.3.3  - WIN7  Home Premium (64bit) German UI [OOO330m19 (Build:301  Tag 3.3.3.1)]".


Steps to reproduce:
0. Download, unzip attached test kit
1. Start LibO
2. Menu 'File -> open - Browse for test files -> click "0.ods", "1.ods" 
   with <Control+Click> -> <Open>
   Both documents open
3. Check "1.ods" Feulle1.A1
   Expected: shows "DEF" from "0.ods"
   Actual: ERR:517   (OOo 3.1.1 shows empty cell, works fine with OOo 3.3)

"T" works fine for reference to other cell within document.

@eric:
May I ask you to read  hints on <http://wiki.documentfoundation.org/BugReport>?
Then please:
  -- concerning your Operating System
 
@Kohei:
Please feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug.
Comment 2 Rainer Bielefeld Retired 2011-09-08 22:17:18 UTC
Created attachment 50993 [details]
Test kit, see Comment 1
Comment 3 eric 2011-09-09 13:07:22 UTC
I can reproduce the problem on ubuntu 11.04 (64bit) gnome, windows XP (32bit), vista (32bit), 7 (64bit)
Comment 4 Kohei Yoshida 2011-09-14 08:57:20 UTC
I'll take a look.
Comment 6 Björn Michaelsen 2011-12-22 05:54:19 UTC
RESOLVED, FIXED or CLOSED bugs cant be KEYWORD NEEDINFO.