CODEWITHSUNDEEP
javaapache-poi
LeO
LeO

Reputation: 5258

POI Excel formula translated?

I am using German Excel 2007 and therefore the English formula are not evaluated automatically. In the German Excel I have no clue, where resp. how to get it working to evaluate English formulas.

So, I thought I am using the German ones, but this only throws a FormulaParsException. Setting the formula directly as cellvalue is obviously wrong, cause the content is not evaluated. I thought, perhaps I can turn off the evaluation resp. parsing, but no real success to it. I have seen, that I can write my own function, but to be honest, I wanna use an already built-in-function of Excel.

Can anybody give me a hint, how to use COUNTIF in German Excel? Resp. how to convince POI to accept ZAEHLENWENN?

Upvotes: 0

Views: 1718

Answers (1)

aran
aran

Reputation: 11880

Take a look at this question.

As stated in the answer, Apache POI doesn't support multiple languages, so you will have to use the English formulas to make it work.

Upvotes: 1

Related Questions