Skip to Content

Langauage indepenence in EPM Excel

Hi

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

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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...

    Add comment
    10|10000 characters needed characters exceeded