Question: How to make string 'exportable' to Excel

[rob2]

=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?

[karolus]

Avoid evil INDIRECT use for Example:

 =INDEX(Contrib.A:A;16)

[rob2]

Thank you! I am going to try this.

[rob2]

Yes, this works. Thanks a lot.

[Ratslinger]

@rob2

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