gnumeric saves incorrect path in reference to cell in another file
Submitted by mb2..@..il.com
The format of a reference to a cell of a spreadsheet in a different file is (according to the on-line documentation) [filename]Sheet!Cell
Suppose I'm working on spreadsheet /home/jake/projects/thisyear/One.gnumeric, and I want to enter the value of the cell, e.g., in spreadsheet Two in the different directory [/home/jake/projects/lastyear/january/weekfour/Two.gnumeric]'Sheet 1'!D35 This can be done on the second or third try in typing in the reference as given above, or by typing [../lastyear/january/weekfour/Two.gnumeric]'Sheet 1'!D35 .
However, when I save spreadsheet One with the reference to the cell in Two and later reopen spreadsheet One, the reference is wrong. It looks like [../../../lastyear/january/weekfour/Two.gnumeric]'Sheet 1'!D35 . That is, the saved relative reference goes too far up the directory hierarchy. So every time I open spreadsheet One, I need to correct the reference by deleting ../../ . The wrong path is shown in the data entry area as soon as I press enter after typing the correct reference, although the value in the cell is displayed correctly until I save, close spreadsheet One, and reopen it.