Ask Your Question

Patt's profile - activity

2016-07-07 23:16:42 +0100 received badge  Popular Question (source)
2015-10-23 14:58:58 +0100 asked a question Relative reference changed to absolute

Why are formulas with relative references to other sheets automatically changed into absolute when closing and reopening Calc files? Same problem in L.O. 422 and 502. Using Fedora 20. Only happens with Excel 1997-2003 format files but not with ODS format. Found similar issue in a closed (qubit) case but couldn't find explanation ("Saving file changes relative to absolute"). Thanks!