LIBRE CALC is automatically adding worksheet references to my formulas, for example:
- I enter the formula =J$2/$H6 and save save the file
- next time I open the workbook, the formula has been changed into =$‘Final’.J$2/$‘Final’.$H5
It means Libre Calc is automatically adding a reference to the worksheet name in which the formula is located.
This is quite annoying because with such worksheet references I cannot use F2 function to see the cells used in the formula.
Is there a way to block such behaviour?