https://bugs.freedesktop.org/show_bug.cgi?id=54451
Bug #: 54451
Summary: : link to another file dublicating
Classification: Unclassified
Product: LibreOffice
Version: 3.4.6 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Problem description:
When I create formula in cell like:
=IF($B9=0,0,VLOOKUP($B9,'file:///home/anton/Documents/MRM/Sallery/2012/august
2012/Base.xls'#$UP.$B$3:$L$150,5,FALSE()))
It works as it should do. But if I save document and reopen it I have
automatically rewritten cell contains:
=IF($B9=0,0,VLOOKUP($B9,'file:///home/anton/Documents/MRM/Sallery/2012/august
2012/home/anton/Documents/MRM/Sallery/2012/august
2012/Base.xls'#$UP.$B$3:$L$150,5,FALSE()))
Address 'home/anton/Documents/MRM/Sallery/2012/august 2012/' is duplicated. And
if I save it once more, it will happen again
I've try it with different files, and in different format(*.ods) - the same
result
Steps to reproduce:
1. Create 2 documents (for example 1.ods & 2.ods)
2. Create in 1.ods formula
<code>=IF($B9=0,0,VLOOKUP($B9,'file:///home/my/path/to/directory/2.ods'#$SHEET.$B$3:$L$150,5,FALSE()))</code>
3. Save and close 1.ods
4. Open 1.ods (could be a message)
5. Check cell with formula
Current behavior:
Saved and opened cell with formula contains double address to file
Expected behavior:
Cell have to contain same data as saved
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:15.0) Gecko/20100101
Firefox/15.0
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
