https://issues.apache.org/bugzilla/show_bug.cgi?id=44675
Dmitriy Kumshayev <[EMAIL PROTECTED]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|FIXED |
--- Comment #2 from Dmitriy Kumshayev <[EMAIL PROTECTED]> 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);
A1.setCellValue(1.);
HSSFRow row2 = sh.createRow(1);
HSSFCell A2 = row2.createCell((short)0);
A2.setCellValue(1.);
HSSFRow row3 = sh.createRow(2);
HSSFCell A3 = row3.createCell((short)0);
A3.setCellFormula("SUM(A1:A2)");
--------------------------------------------
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
