LibreOffice Calc as a calculation engine server or service

[nangyal]

Hi all

I would like to use the LibreOffice Calc as a calculation engine server or service
I have a quite complex calculation in a spreadsheet
and I would like to pass data to the spreadsheet fill up some cells somehow
and get back the results from the calculated cells
and send it back to the website or database

like my customer type in some details and after few secs get back the results on my website

how it is possible?

[erAck]

By connecting against a headless instance of LibreOffice and using the UNO API (in either Python, C++ or Java) to populate cells and obtain results. See the API Documentation and a small Python example.

See also my LibreOffice Scripting link collection for pointers to Python tools and OOo DevGuide.