Possible to implement TEXT() and VALUE() functions?

vinci1it2000 / formulas

Excel formulas interpreter in Python.

https://formulas.readthedocs.io/

European Union Public License 1.1

342 stars 75 forks source link

Possible to implement TEXT() and VALUE() functions? #110

Closed viguice closed 8 months ago

viguice commented 1 year ago

I have the following function '=TEXT(VALUE(A1),"00")' where A1 can be a number or a text. The result is always a text using the correct formatting: A1 -> Result 1 -> 01 10 ->10 '5 -> 05 test -> #VALUE!

The value and text functions don't work as I get #NAME? value for this formula. Can you add them?

Thanks a lot,

Cédric

vinci1it2000 commented 8 months ago

I have implemented the TEXT and VALUE functions. They will be included in the next release.