Spreadsheet has changed after closing & reopening

[Bwatts]

Hi,

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?

[erAck]

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.

[Bwatts]

Thank you!