openformula

I do not think we should look to support function names in particular, only functionality. I think it should be down to the spreadsheet developers to map their function names to the OF function names. Otherwise you could potentially end up with several aliases to function names, which I think should be avoided.

For example, we may have a True() and a TrueV() where the former evaluates to TRUE but has no numeric value (and is ignored by other formulae) but the latter has the numeric value of 1. Therefore, Excel would map TRUE() to True() and OpenOffice to TrueV().

Therefore, in the example of conversion functions, we would not have a TEXT() function, but the functionality would be provided by CStr() - should that be the chosen name.