Add custom function to a cell value #2233
LvironeGreisch
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hello everyone,
I've seen it's not possible to get the result of a custom VBA function, but is it possible to add a custom function to a cell value?
If I add it as Cell.Value then when I open the file it's a text, and I need to click on each individually cell to launch its formula and see the result.
If I add it as Cell.FormulaA1 I think CLosedXml try to parse it and fail because it's custom, so when I open the file an error happened and all cells with custom formula are deleted.
Is it a way to add the custom formula without ClosedXml parse it? Or am I forced to use another library to write this formula? If yes, then what library do you suggest me?
Thanks
Beta Was this translation helpful? Give feedback.
All reactions