asked 2012-09-18 11:54:11 +0200
Anonymous
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.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-09-18 11:54:11 +0200
Seen: 65 times
Last updated: Dec 18 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
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 ( 2012-10-05 15:13:36 +0200 )editBetter to get help, inform about your Operating System and LibreOffice version.
mariosv ( 2012-12-19 00:57:06 +0200 )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 ( 2013-03-27 06:59:55 +0200 )edit