[Libreoffice-bugs] [Bug 112918] New: Allow python functions to be called from cell formulas

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112918

            Bug ID: 112918
           Summary: Allow python functions to be called from cell formulas
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: sdk
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: quazgar at posteo.de

Description:
Currently, scripts can be written in Python, but using python functions in LO
Calc formulas requires quite some overhead, as described here:

https://stackoverflow.com/questions/7591656/how-can-i-call-a-python-macro-in-a-cell-formula-in-openoffice-org-calc

It would be a lot easier for users to implement their own functions, if such
functionality would be provided by LibreOffice itself.

Actual Results:  


Expected Results:



Reproducible: Always

User Profile Reset: 

Additional Info:
Idea:

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:

import uno
@uno.CalcFunction
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171005/0fd7b1cd/attachment.html>