I am using LO 7.2.5.2 in windows 10 environment. I have created a BASE file using existing CALC file. In CALC file, I have created a macro function to convert amount mentioned in number to word. Its working fine in Calc file. But the converted value is not coming in BASE table. Its showing #VALUE!.
Please let me know how to solve this.
I can’t answer how to make the macro work; but can’t you just use the [NatNum12] format specifier in your Calc file, either as a cell number format, or as a formula using TEXT, and avoid macros at all?
A quick test reveals that results of add-in functions transfer to database connections but not Basic functions.
Quck test: Apache OpenOffice Community Forum - [Calc][oxt] A function for all python string methods - (View topic)
Install oxt, connect a Base document to the sample document.
Thank you very much. It solved my problem of conversion of number to word.