| Summary: | : link to another file dublicating | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Anton Kolyaev <antontyt> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | 3.4.6 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
The problem doesn't appear anymore, when I test it with Version 4.0.0.0.beta2 (Build ID: 4104d660979c57e1160b5135634f732918460a0) on Ubuntu 12.04 (x86) Please reopen, if it reappears |
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