https://issues.apache.org/bugzilla/show_bug.cgi?id=55324
--- Comment #6 from [email protected] --- (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: [email protected] For additional commands, e-mail: [email protected]
