Currently, scripts can be written in Python, but using python functions in LO Calc formulas requires quite some overhead, as described here:
It would be a lot easier for users to implement their own functions, if such functionality would be provided by LibreOffice itself.
User Profile Reset:
I imagine it should be possible to simply require developers to add a Python decorator to the functions they want to expose to Calc cell functions, like so:
def my_calculation(a, b):
return sin(a) + cos(b)
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0
I discussed with developers and the consensus was:
"if the reporter implements a function decarator or whatever that can generate the necessary boiler-plate to register an UNO add-in then we'll merge it"
Regarding general development:
I would love to use the Python decorator described above … However
Python functions can be called from cells with the help of a Basic wrapper function as described in:
This is feasible regardless of the Python routine location:
o user module
o LibO shared module
o document-based module
o user or shared extension module
Macro x-language calls are detailed here:
I suggest to close this incident as WONTFIX since a workaround exists.
Ok, let's close