|Summary:||Can't evaluate FIXED formula|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
|Attachments:||An exception was thrown when evaluating Fixed formula in cell A3|
Description AnhDuy 2011-09-27 21:42:29 UTC
When I tried to evaluate a cell with FIXED formula, ex: my A3=FIXED(1.123,1), an exception was thrown: Caused by: org.apache.poi.ss.formula.eval.NotImplementedException: FIXED
Comment 1 AnhDuy 2011-09-27 21:45:00 UTC
Created attachment 27615 [details] An exception was thrown when evaluating Fixed formula in cell A3
Comment 2 Nick Burch 2011-09-27 21:54:15 UTC
We're lacking an implementation of the FIXED formula function, which is why you're seeing the error If you could, it'd be great if you could write one. See http://people.apache.org/~yegor/apachecon_us2010/Evaluation_Of_Excel_Formulas_In_POI.pptx for details of how formulas work in Excel files, and how to go about implementing a missing function
Comment 3 AnhDuy 2011-10-11 16:43:39 UTC
I have written code to implement formula FIXED but there is small problem. My code should look like in slide 18 " Walkthrough of an "evaluate()" or an UDF. If it is a first case, I have to write a class which implements Function, then how can I run to check it?
Comment 4 Dominik Stadler 2015-05-31 22:08:46 UTC
The FIXED function is available in latest POI, therefore resolving this as FIXED.