https://bz.apache.org/bugzilla/show_bug.cgi?id=68985
Bug ID: 68985
Summary: Unable to edit cell type on excel file that was
generated via Apache Poi API (edit)
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: jengl...@xifin.com
Target Milestone: ---
To give a quick synopsis, I'm using Apache POI API to generate an excel file.
After the file is generated, I am unable to apply formulas to the any of the
modified rows. The reason appears to be related to the cell type of the cells,
which cannot be updated after the file has generated. Even if I manually change
the cell type of the cells via the Excel spreadsheet, the changes do not take
effect.
To reproduce, simply run the test below and open the generate excel file. If
you manually add '=SUM(A1:A5)' to any cell to get the sum of the cells, you
will notice that the formula is not calculating correctly.
Any help would be greatly appreciated.
Thank you
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import java.io.FileOutputStream;
public class TestExcelWriter
{
public static void main(String[] args) throws Exception
{
XSSFWorkbook workbook = new XSSFWorkbook();
workbook.setForceFormulaRecalculation(true);
XSSFSheet sheet = workbook.createSheet();
int row = 0;
String[] values = {"1.00", "2.00", "3.00", "4.00", "5.00",};
for (String value : values)
{
XSSFRow newRow = sheet.createRow(row);
XSSFCell newCell = newRow.createCell(0);
newCell.setCellType(CellType.NUMERIC);
newCell.setCellValue(value);
row++;
}
FileOutputStream out = new FileOutputStream("outputFile.xlsx");
workbook.write(out);
out.close();
}
}
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
