Bug 79630

Summary: Other: double path
Product: LibreOffice Reporter: asetbukerov <aset_bukerov>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 4.4.0.0.alpha0+ Master   
Hardware: Other   
OS: Linux (All)   
Whiteboard: BSA
Crash report or crash signature: Regression By:
Attachments: image fix bug

Description asetbukerov 2014-06-04 09:47:29 UTC
Created attachment 100391 [details]
image fix bug

Problem description: 

Steps to reproduce:
1. create link from 1.xls on 2.xls
2. close 1.xls and 2.xls
3. open 1.xls

Current behavior: can not update cell

Expected behavior:figure upgrade

              
Operating System: Ubuntu
Version: 4.4.0.0.alpha0+ Master
Comment 1 m_a_riosv 2014-06-04 16:23:40 UTC
Hi @asetbukerov, thanks for reporting.

This is a duplicate of bug https://bugs.freedesktop.org/show_bug.cgi?id=48463#c17

As workaround you can put the path in a cell and use the INDIRECT() function (or put directly as text in the function) to compose the address properly, in this way nothing is changed when saving the file.

e.g.

B10: ="'file:///Users/me/Users/me/file.ods'#Sheet1."
c10: =INDIRECT(B10&cell("address";A1))

*** This bug has been marked as a duplicate of bug 48463 ***