I've been using it for a fairly specific use case: Creating web applications from business logic that has already implemented in a spreadsheet. So instead of trying to figure out what the spreadsheet is doing (they can get fairly complex and the flow of calculation can be difficult to follow) I just treat it as a black box. Input some values here and read the resultant values from somewhere else. Integration with flask/django and you have a prototype within a day.
Would you mind sharing the user flow starting from business folks with their calculations in a spreadsheet?
I'm guessing if I write a front-end spreadsheet like interface, grab their input, have LibreOffice process it, then spit it back out into the interface, it would essentially be my very own spreadsheet program on top of LibreOffice?
I'd really love to learn what's the benefit of making that abstraction because I've been on both sides (business and tech).
I don't quite follow your question but I'll give it a shot. Here is a high level version of how I am currently using the tool: A user is presented with a bunch of input variables on a web page that are then set by the user. These variables are sent to the server and the server sets the relevant cells using spreadsheet_server. Resultant values from other cells are retrieved by spreadsheet_server and then sent back to the web page and presented to the user in the form of a graph or table etc.
Pretty much all of the logic to get from input to output is handled in the spreadsheet by LibreOffice.