Saving file changes relative to absolute [closed]

asked 2012-09-18 11:54:11 +0100

anonymous user

Anonymous

updated 2015-11-02 04:04:25 +0100

Alex Kemp gravatar image

I have a simple spreadsheet with relative addresses but when I exit the file and re-enter it the addresses are changed to absolute addresses (ie with $ in front of the address). It doesn't happen when I save the file only when I come out of it and go back in again. How can I stop this from happening?

eg A1+B1 becomes $A1+$B1 which I don't want to happen.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by qubit
close date 2013-04-07 06:57:18.326129

Comments

Am not sure if this helps but there is an option under Options/Load/Save/General/Save to save URL's as relative to filesystem or internet but I don't think that applies to cell references.

ase618 gravatar imagease618 ( 2012-10-05 15:13:36 +0100 )edit

Better to get help, inform about your Operating System and LibreOffice version.

m.a.riosv gravatar imagem.a.riosv ( 2012-12-19 00:57:06 +0100 )edit

"...only when I come out of it and go back in again" What does this mean? Close a file without saving? What is your file format? Can you attach the file to if there is something special in it?

froz gravatar imagefroz ( 2013-03-27 06:59:55 +0100 )edit