poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 61472] New: Unable to evaluate dependent cell formula
Date Wed, 30 Aug 2017 15:30:07 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=61472

            Bug ID: 61472
           Summary: Unable to evaluate dependent cell formula
           Product: POI
           Version: 3.13-FINAL
          Hardware: PC
            Status: NEW
          Severity: blocker
          Priority: P2
         Component: POI Overall
          Assignee: dev@poi.apache.org
          Reporter: amol.gawali01@gmail.com
  Target Milestone: ---

I am evaluating dependent cell formula using
workbook.getCreationHelper().createFormulaEvaluator().evaluateAll();

but while second formula evaluation, POI returns error 15 for
cell.getErrorCellValue()

Example : 

Cell A2 contains formula =TEXT(NOW(), "hh:mm:ss") and
Cell B2 contains formula
=TEXT(TIME(HOUR(A2),MINUTE(A2)+2,SECOND(A2)+2),"hh:mm:ss")

In POI, first formula evaluate successfully, but while second formula
evaluation it return error cell type.

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