Re: setting cell formulas

[owenl]

Here is the class where the trouble shows up. I am using the jdk 1.2.2 on a
window 98 system. I am using the jar file  jakarta-poi-1.8.0-dev-
20020919.jar. The workbook.xls file is nearly trivial with numerical
values in cells A1 and B1. (I will attach the .java and .xls file as well)

thanks
    Owen

import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;

public class setFormulaTest
{
    public static void main(String[] args)
        throws IOException
    {
        POIFSFileSystem fs      =
                new POIFSFileSystem(new FileInputStream("workbook.xls"));
        HSSFWorkbook wb = new HSSFWorkbook(fs);
        HSSFSheet sheet = wb.getSheetAt(0);
        HSSFRow row = sheet.getRow(0);
        HSSFCell cell = row.getCell((short)0);

        cell.setCellFormula("B1");

        FileOutputStream fileOut = new FileOutputStream("workbook.xls");
        wb.write(fileOut);
        fileOut.close();

    }
}

setFormulaTest.java
Description: Binary data

workbook.xls
Description: application/msexcel

--
To unsubscribe, e-mail:   <mailto:poi-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>