Spreadsheet has changed after closing & reopening


Hoping someone can help me with this one.

I enter this into a cell:

=IF(backTestData[[#This Row],[Entry Date]]="","",IF(backTestData[[#This Row],[Exit Date]]="",“OPEN”,“CLOSED”))

When i close and reopen the document its been changed to this:

=IF($‘Back Testing’.$C4="","",IF($‘Back Testing’.$Q4="",“OPEN”,“CLOSED”))

Technically it still does what i need it to do but i prefer the original format. I can’t figure out if it does this to save space, if so, can i turn it off?

Those table structured references can’t be saved in ODF OpenFormula as they aren’t specified in the standard yet, hence are saved in their A1 address syntax notation equivalent.

Thank you!