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
Created attachment 27615 [details] An exception was thrown when evaluating Fixed formula in cell A3
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
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?
The FIXED function is available in latest POI, therefore resolving this as FIXED.