Hi,
I'm having some problems using the SUMIF() formula - if I generate a cell
using it and then open the workbook it in Excel 97 (or 2000)
the displayed cell value is #VALUE!. However, if I look at the contents of
the cell, the formula appears to be set correctly, and if I double-click
on the cell, or hit the function button followed by OK, the cell then
recalculates correctly.
I'm using 1.7-dev and JDK 1.3.1 with Excel 97. Code fragment included
below.
Any ideas?
Thanks,
Gary.
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("new sheet");
HSSFRow row;
HSSFCell cell;
row = sheet.createRow((short)0);
// cell A1 = 3000
cell = row.createCell((short)0);
cell.setCellValue(3000);
// cell B1 = 2
cell = row.createCell((short)1);
cell.setCellValue(2);
row = sheet.createRow((short)1);
// cell A2 = 2000
cell = row.createCell((short)0);
cell.setCellValue(2000);
// cell B2 = 1
cell = row.createCell((short)1);
cell.setCellValue(1);
row = sheet.createRow((short)2);
// cell D3 should calculate as 2
cell = row.createCell((short)3);
cell.setCellFormula(" SUMIF ( A1:A2, 3000, B1:B2) ");
This communication is for informational purposes only. It is not intended as
an offer or solicitation for the purchase or sale of any financial instrument
or as an official confirmation of any transaction. All market prices, data
and other information are not warranted as to completeness or accuracy and
are subject to change without notice. Any comments or statements made herein
do not necessarily reflect those of J.P. Morgan Chase & Co., its
subsidiaries and affiliates.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
