You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/08/01 10:58:57 UTC
[Bug 55324] formula returning #VALUE
https://issues.apache.org/bugzilla/show_bug.cgi?id=55324
--- Comment #6 from w.deprez@specinov.fr ---
(In reply to Nick Burch from comment #1)
> As detailed in the documentation, and covered in a lot of detail at
> <http://poi.apache.org/spreadsheet/eval.html>, after making changes to
> formulas or the cells they depend on you need to re-evaluate the formulas to
> update the cached value that gets stored with them in the file.
are you sure there is no bug ?
=IF(1=1,MID(A1,4,2),A1) works bad
=IF(1=1,MID("abcdefgh",4,2),A1) works perfectly.
thanks for your answer
--
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