Revision history [back]

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.  2 retagged qubit 9538 ●19 ●94 ●65 Saving file changes relative to absolute 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.

 3 retagged Alex Kemp 10504 ●14 ●42 ●42 http://etmg.altervista...

Saving file changes relative to absolute

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.