poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 58746] Formula: changed sheet name after re-order
Date Thu, 24 Dec 2015 10:55:16 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=58746

--- Comment #1 from Michele <michele.bissoli.83@gmail.com> ---
For everyone who have this problem, I have found a workaround: at start create
all the sheets and only after insert all the data, so without execute a
re-order.

Example:
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet first = workbook.createSheet("first");
HSSFSheet second = workbook.createSheet("second");
HSSFSheet third = workbook.createSheet("third");
first.createRow(0).createCell(0).setCellValue(1);
second.createRow(0).createCell(0).setCellValue(2);
HSSFRow row = third.createRow(0);
row.createCell(0).setCellFormula("first!A1");
row.createCell(1).setCellFormula("second!A1");

This is only a workaround, the problem still exists.

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message