Question: How to make string 'exportable' to Excel

=Contrib.$A16 in ODS is correctly exported to Excel as =Contrib**!**$A16 (note the “!”)

The problem is that in the formula
=INDIRECT(“Contrib.$A”&16) the string is not changed in the export (of course), so this results in an error in Excel

How can I create a formula that both works in LiberOffice and Excel?

Avoid evil INDIRECT use for Example:


Thank you! I am going to try this.

Yes, this works. Thanks a lot.


As you have been helped, please help others to know the question has been answered by clicking on the :heavy_check_mark: in upper left area of answer which satisfied the question.