aboutsummaryrefslogtreecommitdiffstats
path: root/src
diff options
context:
space:
mode:
authorJosh Micich <josh@apache.org>2008-05-05 18:30:49 +0000
committerJosh Micich <josh@apache.org>2008-05-05 18:30:49 +0000
commitc9b114eac8cf942bcd777b7839477bc7263e9147 (patch)
tree17568fc336bffcee2baf9458bfd4baf447120ccc /src
parent706bbba899173a60d86e6a8c738a2234b85f0f10 (diff)
downloadpoi-c9b114eac8cf942bcd777b7839477bc7263e9147.tar.gz
poi-c9b114eac8cf942bcd777b7839477bc7263e9147.zip
Added test case method javadoc for old bug 44675
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@653551 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'src')
-rw-r--r--src/testcases/org/apache/poi/hssf/model/TestFormulaParser.java8
1 files changed, 8 insertions, 0 deletions
diff --git a/src/testcases/org/apache/poi/hssf/model/TestFormulaParser.java b/src/testcases/org/apache/poi/hssf/model/TestFormulaParser.java
index 9ce862b9b6..2f476c892e 100644
--- a/src/testcases/org/apache/poi/hssf/model/TestFormulaParser.java
+++ b/src/testcases/org/apache/poi/hssf/model/TestFormulaParser.java
@@ -887,6 +887,14 @@ public final class TestFormulaParser extends TestCase {
assertTrue(e.getMessage().startsWith("Too few arguments suppled to operation token"));
}
}
+ /**
+ * Make sure that POI uses the right Func Ptg when encoding formulas. Functions with variable
+ * number of args should get FuncVarPtg, functions with fixed args should get FuncPtg.<p/>
+ *
+ * Prior to the fix for bug 44675 POI would encode FuncVarPtg for all functions. In many cases
+ * Excel tolerates the wrong Ptg and evaluates the formula OK (e.g. SIN), but in some cases
+ * (e.g. COUNTIF) Excel fails to evaluate the formula, giving '#VALUE!' instead.
+ */
public void testFuncPtgSelection() {
HSSFWorkbook book = new HSSFWorkbook();
Ptg[] ptgs;