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'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?
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
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