You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a simple Excel worksheet that has a formula cell with the function SKEW. Screenshot below:
Trying to read in this Excel file will result in an exception using the following code, which is mostly straight from the README.
(defn load-xls
"Load Excel spreadsheet and return a list of lists"
[fname]
(->> (xls/load-workbook fname)
(xls/sheet-seq)
(first)
xls/row-seq
(remove nil?)
(map xls/cell-seq)
(map #(map xls/read-cell %))))
The result is:
((1.0)Error printing return value (NotImplementedFunctionException) at org.apache.poi.ss.formula.functions.NotImplementedFunction/evaluate (NotImplementedFunction.java:40).
SKEW
I believe this should result in the cell to have the keyword value :FUNCTION_NOT_IMPLEMENTED.
The text was updated successfully, but these errors were encountered:
takapai
changed the title
SKEW formula in Excel results in crash instead of :FUNCTION_NOT_IMPLEMENTED
SKEW formula in Excel results in exception instead of :FUNCTION_NOT_IMPLEMENTED
Jul 30, 2020
SKEW is not mentioned in the list of supported functions in Appendix A at the bottom of that page.
There are two possible approaches:
Fix the problem in the POI library. This would be best for everyone including people using POI without Docjure.
Work around the issue in Docjure. Perhaps it would be possible to use the cached value for the formula result from the spreadsheet when we encounter this error.
I encourage you to explore these options if you have the time and motivation.
I have a simple Excel worksheet that has a formula cell with the function SKEW. Screenshot below:
Trying to read in this Excel file will result in an exception using the following code, which is mostly straight from the README.
The result is:
I believe this should result in the cell to have the keyword value :FUNCTION_NOT_IMPLEMENTED.
The text was updated successfully, but these errors were encountered: