https://issues.apache.org/bugzilla/show_bug.cgi?id=47855
Summary: java.lang.RuntimeException: Shared Formula Conversion:
Coding Error
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
Depends on: 47747
+++ This bug was initially created as a clone of Bug #47747 +++
since nobody in the community will respond to my comments in bug 47747, perhaps
a new bug entry will warrant a reply?
Created an attachment (id=24176)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24176)
This zip contains the original and processed spreadsheets.
I have tried version 3.5, 3.6 and 3.7.
When trying to run the following code to go through a spreadsheet and update
the formula values, I get several errors (java.lang.RuntimeException: Shared
Formula Conversion: Coding Error). When I open the newly created spreadsheet,
several cells have #REF issues. I will attach the original and processed
spreadsheets.
public static void RecalculateFormulas(String filename) throws
FileNotFoundException, IOException
{ try{
FileInputStream fis = new FileInputStream(filename);
FileOutputStream out = new
FileOutputStream(filename.replaceAll(".xls","temp.xls"));
HSSFWorkbook wb = new HSSFWorkbook(fis); //or new
XSSFWorkbook("/somepath/test.xls")
FormulaEvaluator evaluator =
wb.getCreationHelper().createFormulaEvaluator();
for(int sheetNum = 0; sheetNum < wb.getNumberOfSheets(); sheetNum++) {
org.apache.poi.ss.usermodel.Sheet sheet = wb.getSheetAt(sheetNum);
for(org.apache.poi.ss.usermodel.Row r : sheet) {
for(org.apache.poi.ss.usermodel.Cell c : r) {
if(c.getCellType() ==
org.apache.poi.ss.usermodel.Cell.CELL_TYPE_FORMULA) {
try{evaluator.evaluateFormulaCell(c);}
catch(Exception e)
{System.out.println(e.toString());}
}
}
}
}
wb.write(out);
out.close();
}
catch(Exception e)
{System.out.println(e.toString());
}
}
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
