Ask Your Question
0

Question: How to make string 'exportable' to Excel

asked 2021-01-27 15:29:51 +0200

-rob- gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2021-01-27 15:44:26 +0200

karolus gravatar image

Avoid evil INDIRECT use for Example:

 =INDEX(Contrib.A:A;16)
edit flag offensive delete link more

Comments

Thank you! I am going to try this.

-rob- gravatar image-rob- ( 2021-01-27 15:57:10 +0200 )edit

Yes, this works. Thanks a lot.

-rob- gravatar image-rob- ( 2021-01-27 16:06:34 +0200 )edit

@-rob-

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.

Ratslinger gravatar imageRatslinger ( 2021-01-27 19:49:49 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-01-27 15:29:51 +0200

Seen: 26 times

Last updated: Jan 27