Thread by @jpluimers

@applescripter @Felienne @ICER_C Bumped into another Excel feature today that has this: the CELL function which depends on which locale of Office you have installed.

support.microsoft.com/en-us/office/c…

@applescripter @Felienne @ICER_C In Dutch, the English CELL function becomes CEL, but the parameters are not automatically translated because they are strings instead of tokens.

The first example given works fine in Dutch though.

support.microsoft.com/nl-nl/office/c…

@applescripter @Felienne @ICER_C But in German, CELL becomes ZELLE and "type" needs to be altered into "typ".

support.microsoft.com/de-de/office/z…

@applescripter @Felienne @ICER_C Although the `="v"` needs to be replaced too when browsing further down these documentation pages.

Which means that @MicrosoftHelps needs to nudge the @Microsoft @Office team to update the Excel formula usage examples in the above links (and likely for all other languages)

@applescripter @Felienne @ICER_C @MicrosoftHelps @Microsoft @Office The French version needs updating too as though it uses the same strings for "type" and "v" as English, the example mixes double quotes and guillemets for quoting string values and adds spaces after/before the guillemets.

`=SI(CELLULE(« type »;A1)="v »;A1*2;0)`

@applescripter @Felienne @ICER_C @MicrosoftHelps @Microsoft @Office So if another vendor ever considers translating the programming language used in their tools, do not be like Excel (which tokenises only the keywords but not the string parameters), but tokenise everything.

@applescripter @Felienne @ICER_C @MicrosoftHelps @Microsoft @Office Oh @applescripter, just found out the Japanese Excel language seems *not* translated: formula name and parameters are the same as the English version of Excel.

support.microsoft.com/ja-jp/office/c…