Bug 51900 - Can't evaluate FIXED formula
Summary: Can't evaluate FIXED formula
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.8-dev
Hardware: PC Linux
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2011-09-27 21:42 UTC by AnhDuy
Modified: 2015-05-31 22:08 UTC (History)
1 user (show)

An exception was thrown when evaluating Fixed formula in cell A3 (10.21 KB, application/zip)
2011-09-27 21:45 UTC, AnhDuy

Note You need to log in before you can comment on or make changes to this bug.
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.