poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 47855] New: java.lang.RuntimeException: Shared Formula Conversion: Coding Error
Date Thu, 17 Sep 2009 00:33:21 GMT

           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: dev@poi.apache.org
        ReportedBy: kevinrmckee@hotmail.com
                CC: kevinrmckee@hotmail.com
        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

public static void RecalculateFormulas(String filename) throws
FileNotFoundException, IOException
    {   try{
        FileInputStream fis = new FileInputStream(filename);
        FileOutputStream out = new
        HSSFWorkbook wb = new HSSFWorkbook(fis); //or new
        FormulaEvaluator evaluator =
        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) {
                        catch(Exception e)
        catch(Exception e)

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message