|
Les types de fichiers classiques ne pourront plus être utilisés à partir de janvier 2021. Vous pouvez transférer vos fichiers classiques ou télécharger un PDF. En savoir plus

Exporting formulas issue

Demande de démonstration

When I save a spreadsheet into .xlsx format, there are some "@" signs in the formula which gives #VALUE error in Excel. How do I save the file to avoid this issue?

 

Formula on Wdesk:

 

Cell output on Wdesk - error due to formula not supported by Wdesk

 

Formula when in exported Excel file

1

Commentaires

1 commentaire

Date Votes
  • Mike Davis

    Hi Ian!

    Thanks for the question. Happy to help here as best I can.

    To make sure I follow, in the formula within Workiva, you have some @ symbols in the syntax but upon export to XLSX, the formula results in a #VALUE because the @ symbols get stripped?

    I can check further with our engineers if it matters on export but off-hand both the MMULT and TRANSPOSE formulas are not supported in Workiva, but as  you point out, it results in a #NAME exception. 

    Let me know if I've missed the mark or you have any follow-ups for me.

    0

Vous devez vous connecter pour laisser un commentaire.