Under OpenOffice.org 3.2.x the following formula is entered in a blank sheet: ='File.ods'#Sheet1.A1 and stays as writen above. The same formula opened in LibreOffice 3.3.x or 3.4.x gives the folowing syntax: ='file:///c:/Documents and Settings/olivier/My Documents/File.ods'#Sheet1.A1 that is, the relative path is transformed into an absolute path. Either this is a undocumented feature or a bug, because there is no way I can see so far to stop this transformation and it breaks some of my macros.
possibly this is a dup of: Bug #36387 Bug #35188
Not reproducible at all with "LibreOffice 3.4.3 RC2 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:302)]" and others. I created a source.ods and a targetOOo311.ods. The input with a formula due to report will be modified immediately to some "='file:///c:/Docume...." in OOo after Enter. Same with OOo3.2.-dev and OOo 3.4. Also the "='file:///c:/Docume...." only Looks absolute, but is relative. As you see in my targetxxx.ods from sample, everything works identical in LibO and OOo. The DDE link should not work for you, because that one will be absolute "by design". You can try to reproduce my results with attached test kit. @Olivier: Please check your results and leave a comment with your results, a sample document would be fine. Please file Bug reports with status UNCONFIRMED if your are not absolutely sure that you contributed all required background information and that the problem will be reproducible with information you can provide!
Created attachment 51026 [details] sample documents, see Comment 2
Closing Bug due to reporter's inactivity as INVALID. @reporter: Please feel free to reopen this bug if you find out that the problem still exists with the current stable LibreOffice version and if you can contribute requested additional information due to <http://wiki.documentfoundation.org/BugReport> (especially BugReport Details)!
RESOLVED, FIXED or CLOSED bugs cant be KEYWORD NEEDINFO.
Rainer, I've encountered the same issue as Olivier. Namely, I enter a relative path in a spreadsheet and when I press enter it is converted into an absolute one. But I seem to now understand what you're saying -- it's a relative path, but displayed as an absolute one. This is problematic when you are creating long formulas with many references to a external files that are within the same directory, since the full paths make the formula very long and editing of it, error-prone. With the relative path display, the formula can be viewed in a much more compact manner. Is there a reason to really always display them in the absolute format? Note that I do have the relative paths save/restore:general option selected.
For others that run into this bug, it's worth mentioning that external references to XLS files seem to get corrupted when updating the links -- I ended up with references repeating the pathname in the form "file:///home/user/path/home/user/path/file" which leads to a linking error; ODF file formats work just fine
(In reply to comment #6) > it's a relative path, but displayed as an absolute one. Yes, that's my experience > This is problematic [...] the full paths make > the formula very long and editing of it, error-prone. Ah, I see your problem. May be you should discuss that on <http://ask.libreoffice.org/questions/> or a mailin list, and may be a result will be a suggestion for an enhancement, what you can submit in a different bug report.