[Libreoffice-bugs] [Bug 45286] FILESAVE as .xlsx destroys link to linked contents

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=45286

Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
         AssignedTo|libreoffice-bugs at lists.free |kohei.yoshida at gmail.com
                   |desktop.org                 |
                 CC|                            |LibreOffice at bielefeldundbus
                   |                            |s.de
     Ever Confirmed|0                           |1
            Summary|Wrong format for references |FILESAVE as .xlsx destroys
                   |when saving as .xlsx        |link to linked contents

--- Comment #1 from Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> 2012-01-26 23:03:05 PST ---
[Reproducible] with "LibreOffice 3.5.0 RC2 German UI/Locale [Build-ID:
e371a95-bf68a13-5a1aa2b-d3c1ae9-b938258] on German WIN7 Home Premium (64bit),
.xlsx shows "Err:509" instead of linked contents

I created a test kit containing "linked.xls" with small ocntents and several
other documents linking to that contents.

Test results with documents from attached  test kit created with a.m. Version:

Linked contents shown correctly with LibO in , "withlink.ods",
"withlinkexcel2003.xls"
Problems as described with "withlink2007.xlsx", "withlinkOOX.xlsx", "", "", 

Same Problems with with "LibreOffice Portable 3.3.0  - WIN7  Home Premium
(64bit) German UI [OOO330m19 (Build:6) tag libreoffice-3.3.0.4]" 

Other Problems 
--------------
visible when I moved folder with sample documents to a differend HDD: 
"withlinkexcel2003.xls" shows wrong link when open:
='file:///T:/Users/Public/Documents/LibO/45286 - Wrong format for references
when saving as .xlsx/new/linked.xls'#$Tabelle1.A1
Should be
='file:///T:/new/linked.xls'#$Tabelle1.A1

"withlinkOOX.xlsx"  shows wrong link when open:
=['file:///c:/users/public/documents/libo/45286 - wrong format for references
when saving as .xlsx/new/linked.xls']$Tabelle1.A1
Should be
='file:///T:/new/linked.xls'#$Tabelle1.A1

Unfortunately neither tests with MS EXCEL Viewer nor tests with GNUMERIC
delivered reliable FILEOPEN results, so that the only reliable result of my
tests is "LibO can't open documents created with LibO", all other is beyond my
skills. "Other Problems" might be related to the problem from original report
or not, I can't tell.

@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.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.