Hi. When I create data ranges with headers and do calculations referring to lines and headers [[#This row];[]] everything works fine until I reopen the document. After making a large table, I discovered the next day that in all my formulas references of the formulas [[#This row];[]] were replaced with regular cell references like .A1. This is observed for a document in ods format, but not xlsx. In xlsx everything is saved as it should be.
Can this be fixed for ods, do I need to change any settings? Thanks.
The OpenDocument Format (ODF) OpenFormula standard doesn’t specify that table formula syntax yet, so it isn’t saved to .ods
The replacement with references continues to work as it should though and new formulas can be entered either in the table formula syntax or copy-pasting the reference replacements.
1 Like