Custom created class as NPOI doesn't implement CELL.

[swathinetdeveloper7]

I am specifically fixing a case where it is used as CELL("col",W2)
The COLUMN function will do that same thing as COLUMN(W2)
But to avoid having to change existing templates, this implementation has been made.
It only handles the "col" and "row" parameters.
Cell.zip

[tonyqus]

Can you fork the repo and create a PR for your change?

[tonyqus]

Cell Function
Column Function

[tonyqus]

Have you changed the following line?

npoi/main/SS/Formula/Eval/FunctionEval.cs

Line 224 in 285c4c2

retval[125] = new NotImplementedFunction("CELL"); // CELL

[tonyqus]

Any update on this issue?

[tonyqus]

Reference
https://github.com/apache/poi/blob/trunk/poi/src/main/java/org/apache/poi/ss/formula/functions/Column.java