search

microsoft / Excel-Labs

MIT License
72 stars 14 forks source link

Problem with Functions Translator #25

Open KDean-Dolphin opened 4 months ago

KDean-Dolphin commented 4 months ago

There doesn't appear to be a GitHub project for this and the support link is broken (it leads to UserVoice), so I'm posting here, hoping it gets to the right people.

The Functions Translator has a problem with the literal #N/A. This function works in English:

=IF(A1<0,#N/A,A1)

However, the translator can't process it, returning:

Failed to parse: #N/A

The same is true for the literal #VALUE! etc.

NWilson commented 2 months ago

Thank you @KDean-Dolphin I have found the email address of someone who worked on the Functions Translator (I have never met that team), and forwarded a link to this issue. I can't guarantee anyone will act on the bug report though.

You may find that Excel Labs is able to do what you need? In the settings panel (top-right menu of Labs), there is the option to switch between your language and English. This enables you to copy-paste formulas into or out of your workbook using either English or your locale. The workflow is a bit klunky if you need to switch locale often, but it will do the job.

KDean-Dolphin commented 2 months ago

Thank you, @NWilson. I'm actually going from English to other languages. The translator is the fastest option for me.