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.
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.
Better to get help, inform about your Operating System and LibreOffice version.
“…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?