https://bz.apache.org/bugzilla/show_bug.cgi?id=62216

            Bug ID: 62216
           Summary: SXSSFCell.setCellErrorValue turns a formula cell into
                    an error cell, unlike XSSF
           Product: POI
           Version: 3.17-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SXSSF
          Assignee: [email protected]
          Reporter: [email protected]
  Target Milestone: ---

A fix for this seems to be a one-liner. In source

@Override
public void setCellErrorValue(byte value)
{
    ensureType(CellType.ERROR);
    if(_value.getType()==CellType.FORMULA)
        ((ErrorFormulaValue)_value).setPreEvaluatedValue(value);
    else
        ((ErrorValue)_value).setValue(value);
}


ensureType(CellType.ERROR);

is to be replaced by 

ensureTypeOrFormulaType(CellType.ERROR);

-- 
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]

Reply via email to