Only checked PC / WIN-XP

Created attachment 22027 [details]
Files to reproduce problem

Cannot reproduce it. WinXP (SP2), SRC680m76 (OOo 1.9.76). Please check if this 
still happens in a newer milestone.

works for me

@Rainer - any update on this issue?

Bug is back again in 2.0 (1.9.m113) German version WIN XP: [680m113(Build8930)]

Hi Rainer,

checked it with m118 which should be out soon and can't reproduce as I wasn't
able to do so at the first time this Issue was submitted. 

Sorry for no better reply.

Frank

For me it is also reproducible with 2.0 (1.9.m118) English version WIN XP:
[680m118(Build8936)]. I will attach a testket with 1 file I created with an
export from a file opened from WIN-Explorer (with absolute links) and another
one exported from same source file, but this time opened from OOo File Menu
(with relative links).

Created attachment 28012 [details]
Testkit for Additional comments from rainerbielefeld Mon Jul 18 06:16:44

Hi Rainer,

a few questions :

- Is your E: drive on a network share ?
- Have you different settings for saving relative paths for File system Internet
under tools options Load/Save General ?
- There does your Installation set comes from ?

I've tried it with the last three versions including the latest m122 build and
could not reproduce.

Sorry for no better reply.

Frank

Hm, seems that the problem only ireproducible for some very special conditions.

All drives are yuite normal internal drives in my PC, no network drives or
something like that 

Hi Frank, thanks for your effords. Here the problem still is 100% reproducible
with 2.0 (1.9.m113) German version WIN XP: [680m113(Build8930)] and also with I
checked with 1.1.4 (German) WIN XP: [645m52 (Build 8824)].


I tried with 'e:\Rainer\Eigene
Dateien\TEMP\oootestfiles\41686_FromExplorer\testkit\SheetWithHyperlink.sxc' 
and 2.0, opened by doubleclick from saved a .XLS in samd folder, moved folder
'testkit' to F:\temp\ and saw the bug effect: The hyperlink leads absolute to
e:\Rainer\Eigene Dateien\...

That was reproducible for 3 times.

Next test: (same) sourcefile is 
'C:\temp\41686newtest\testkit\SheetWithHyperlink.sxc'
Opened with doubleclick from explorer, save as XLS, move folder 'testkit' to
F:\temp\ again (after I deleted the old testkit there, of course ...), opened my
exported .xls, and - all as it should be, the relative link leads correctly to
F:\...

That also reproducible for 3 times.

It seems that something goes wrong if the source file opened by doubleclick is
not in a normal drive path structure, but in something special like "Eigene
Dateien" (why ever that does not matter for files opened directly from OOo menu
...)?

May be tomorrow I will find the time to do further tests with m104 on a WIN98 PC

Rainer

Can anyone replace "Eigene Dateien" in subject by english name of that folder?

changed title on request

Hi Rainer,

have you checked it on m130 ?

I'm not able to reproduce this behaviour.

Frank

In 680m125 the problem still exists, also in a 680m122/WIN98 version used in our
network. I will try to test soon with m130, but because of the immense backup
procedure necessary because of unfixed issue 52864, I currently do not install
all new 680 versions - too much work, too much risk.

It seems to be a little tricky! I tried my testkit from Mon Jan 31 02:36:00 with
2.0 (1.9.m125) German version WIN XP: [680m125(Build8947)] and was not able to
reproduce the problem. Another fact is that I have this problem every few Days
on my PC with 680m125, when I forget that problem and open a .ods from WIN
Explorer. The exciting question now is, why that happens for several of my
files, but not for others? I will still do several tests within the next days,
but if I can't create a new testkit with new files from 680m125 (or later) to
reproduce this problem, I will close this issue WFM (latest: Oct. 16th).

I am not able to create a testkit with newly created files, I only see this
effect in some older documets. So WFM

.

I checked with “2.0 German version WIN XP: [680m3(Build8968)]†and I have been
able to reproduce the bug with 2.0.

Currently it seems that that problem does not appar using only 2.0, but if you
have 1.1.4 content in your file, the problem happens.

How I reproduced the bug creating testkit 'newtestkit20a.zip'

Preparations:
1. In my "My files" folder I created folder 
   e:\Rainer\Eigene Dateien\TEMP\oootestfiles\NewRel with subfolder 'goal'
2. I opened OOo 2.0 by clicking on the icon in My WIN Task Bar 
  (with a link containing an OOo spreadsheed containing hyperlinks to 
  frequently used OOo files)
3. I opened a new OOo WRITER document 'bingo.odt' and saved it in subfolder
   'goal'
4. I created 'bingo.pdf' from 'bingo.odt' in subfolder 'goal'
5. I opened OOo 1.1.4 from WIN89 - Start - Programs - OOo1.1.4 - Spreadsheet
6. I created 'createdwith114.sxc' containing a hyperlink to 'bingo.pdf'
   saved it in folder 'NewRel' and closed 1.1.4
7. I created a new OOo 2.0 spreadsheet  'createdwith20.ods' saving it in folder
   'NewRel' 
8. I opened 'createdwith114.sxc' from 2.0 Menu "File - Open"
9. Marked cell with hyperlink and copied it to 'createdwith20.ods'
10. I closed all OOo


The test

11. I opened 'createdwith20.ods' from WIN EXPLORER and saved it as 
    'createdwith20.xls' 
12. closed all OOo
13. Copied folder to another harddisk
14. reopened 'createdwith20.ods' and  'createdwith20.xls' (does not matter how)
15. checked hyperlink:
    in 'createdwith20.ods' as expected to 'goal\bingo.pdf'
    (complete path: F:\Dateien\Temp\newtestkit20a\NewRel ...)
    in 'createdwith20.xls' wrong absolute hyperlink to bingo.pdf on the othe
    harddisk
    (complete: e:\Rainer\Eigene Dateien\TEMP\oootestfiles\NewRel\goal\bingo.pdf)

Additional tests after again closing all OOo:

21) I opened OOo 2.0 by clicking on the icon in My WIN Task Bar 
  (with a link containing an OOo spreadsheed containing hyperlinks to 
  frequently used OOo files)
22) Opened from OOo2.0 Menu "Files - Open"
     e:\Rainer\Eigene Dateien\TEMP\oootestfiles\NewRel\createdwith20.ods
    saved as 'createdwith20openedfromopenfile.xls'
23) Opened again 'createdwith20.ods' from OOo2.0 Menu "Files - Recent Files"
    saved as 'createdwith20openedfromrecentfiles.xls'
24) Copied both files to F:\Dateien\Temp\newtestkit20a\NewRel\
25) Checked both "bingo"-hyperlinks, both worked correctly relative 

Pls. check attached testkit.

If this really is resproducible, we have some big problems.

Created attachment 31196 [details]
comments from rainerbielefeld Sat Nov 5 05:14:07 -0800 2005 showing problems for documents with 1.1.4 content

I till see this behaviour in several spreadsheets I created with 1.1.4 (or
older) which are now used with 2.0 in new format .ods.

It's really worrying: currently the effect seems to appear in all spreadsheet,
it does not matter how I insert the hyperlink.

For a further test, I compared the files "createdwith20openedfromopenfile.xls"
and  "createdwith20openedfromexplorer.xls" in a text editor (editpad), and the
difference ist very visible in the content:
- "createdwith20openedfromexplorer.xls": 
   hyperlink 'goal/bingo.pdf'
- "createdwith20openedfromopenfile.xls": 
   hyperlink 'E:\Rainer\Eigene Dateien\TEMP\oootestfiles\NewRel\goal\bingo.pdf'

Reset assigne to the default "issues@openoffice.apache.org".