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.直接将公式设置为cellvalue显然是错误的，导致内容不求值.我想，也许我可以关闭评估响应.解析，但没有真正的成功.我已经看到，我可以编写自己的函数，但老实说，我想使用 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屋！