poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 44675] [patch] POI does not distinguish functions with fixed vs variable arguments
Date Fri, 02 May 2008 23:06:14 GMT

Dmitriy Kumshayev <dq@mail.com> changed:

           What    |Removed                     |Added
             Status|RESOLVED                    |REOPENED
         Resolution|FIXED                       |

--- Comment #2 from Dmitriy Kumshayev <dq@mail.com>  2008-05-02 16:06:14 PST ---
setCellFormula("SUM(A1:A2)") produces #VALUE! error in Excel

This started happening since this patch.

HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sh = wb.createSheet("TestSheet");

HSSFRow row1 = sh.createRow(0); 
HSSFCell A1 = row1.createCell((short)0); 

HSSFRow row2 = sh.createRow(1); 
HSSFCell A2 = row2.createCell((short)0); 

HSSFRow row3 = sh.createRow(2); 
HSSFCell A3 = row3.createCell((short)0); 


FuncVarPtg is used to represent SUM function.
FuncVarPtg(String pName, byte pNumOperands) constructor initializes paramClass
with Ptg.CLASS_VALUE while it used to be Ptg.CLASS_REF before this patch.

I am not quite sure about the meaning of this, but when I manually changed it
in debugger to Ptg.CLASS_REF, the problem disappeared.

Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message