Its probably a bug. I reckon its about the Ref/Value flavour of the token. Will
have a look as soon as i can. Could u add this to bugzilla so that it doesnt
slip thru the cracks? Thanks.
-
Avik
Quoting [EMAIL PROTECTED]:
> 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]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
