[Bug 61472] New: Unable to evaluate dependent cell formula

classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 61472] New: Unable to evaluate dependent cell formula

Bugzilla from bugzilla@apache.org
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: [hidden email]
          Reporter: [hidden email]
  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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61472] Unable to evaluate dependent cell formula

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61472

Amol Gawali <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |Windows 7
           Hardware|PC                          |HP

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61472] Unable to evaluate dependent cell formula

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61472

PJ Fanning <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--- Comment #1 from PJ Fanning <[hidden email]> ---
Could you try POI 3.16 and 3.17-RC1 to see if the issue has been fixed in newer
versions?

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61472] Unable to evaluate dependent cell formula

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61472

--- Comment #2 from PJ Fanning <[hidden email]> ---
If the issue still appears in newer POI versions, would you be able to provide
a spreadsheet file that demonstrates the issue?

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61472] Unable to evaluate dependent cell formula

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61472

--- Comment #3 from Amol Gawali <[hidden email]> ---
Created attachment 35270
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35270&action=edit
Sample spreadsheet

Attached sample spreadsheet for same

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61472] Unable to evaluate dependent cell formula

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61472

--- Comment #4 from Amol Gawali <[hidden email]> ---
Tried with POI 3.16 and 3.17-RC1, but still issue is persist.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61472] Unable to evaluate dependent cell formula

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61472

Amol Gawali <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61472] Unable to evaluate dependent cell formula

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61472

--- Comment #5 from Amol Gawali <[hidden email]> ---
(In reply to PJ Fanning from comment #2)
> If the issue still appears in newer POI versions, would you be able to
> provide a spreadsheet file that demonstrates the issue?

Tried with latest version of POI, but still issue is persist.
Attached sample spreadsheet for same.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61472] Unable to evaluate dependent cell formula

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61472

Amol Gawali <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|3.13-FINAL                  |3.17-FINAL

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 61472] Unable to evaluate dependent cell formula

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=61472

--- Comment #6 from Dominik Stadler <[hidden email]> ---
The problem happens because the first cell is a string-value via TEXT(...), but
the second cell reads it as time for the HOUR() function, which Excel seems to
somehow manage, but Apache POI does not.

You might be able to change the first cell to be only "NOW()" and use
formatting to get the desired format display, while still keeping the
date-value as formula-result.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]