POI Excel公式已翻译? [英] POI Excel formula translated?
问题描述
我正在使用德语Excel 2007,因此不会自动评估英语公式.在德语Excel中,我不知道在哪里响应.如何使其能够用于评估英语公式.
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.
所以,我以为我使用的是德语版本,但这只会引发 FormulaParsException
.将公式直接设置为单元格值显然是错误的,因为未评估内容.我想,也许我可以关闭评估响应.解析,但没有真正的成功.我已经看到,我可以编写自己的函数,但是老实说,我想使用已经内置的Excel函数.
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.
有人可以给我一个提示,如何在德语Excel中使用 COUNTIF
吗?分别如何说服POI接受 ZAEHLENWENN
?
Can anybody give me a hint, how to use COUNTIF
in German Excel? Resp. how to convince POI to accept ZAEHLENWENN
?
推荐答案
看看这个如答案中所述,Apache POI不支持多种语言,因此您将不得不使用英语公式来使其工作.
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.
这篇关于POI Excel公式已翻译?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!