Skip to Content

Langauage indepenence in EPM Excel

Feb 22, 2017 at 02:48 PM


avatar image


We have formula's like "EPMMemberProperty(,J5,"LOCKED")" to find out a locked cost center. If cost center does not exist, excel will issue error as "#Error....". If it is a French based PC, it issues error as "#Errer....". We perform certain action based on the message i.e. #Error vs #Errer. We may have other languages too in future and I do not want to code for each language.

How did you guys handled such a requirement i.e. making your formulae language independent.?


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Feb 22, 2017 at 03:25 PM

There is no way to get some standard code instead of language dependent text error message!

The simple workaround:

Language dependent text error message is long - just calculate text lenght using Excel LEN function and if it's greater then 50...

10 |10000 characters needed characters left characters exceeded