how to convert Calc spreadsheet into mobile-friendly web application, so that it can be used for calculation online? No need to show all cells and formulas, only two fields are needed: input field (were user enters the number) and result field.
A mobile-friendly web application never ever uses any spreadsheet at all. There are web applications able to edit uploaded spreadsheets, such as https://www.collaboraonline.com/ or Google spreadsheets.
how to format spreadsheet to make it just two fields are visible: input field and result field? (marked bold)
calc-gaz.ods (13.4 KB)
I tried Collaboraonline, but I don’t understand how it can be useful for converting Calc spreadsheet into a web application. It simply doesn’t have these features. The program itself is no different from Microsoft OneDrive Excel for the web. It’s just as useless as OneDrive Excel for the web. All the OneDrive Excel for the web does is insert a sheet (or cells selection) into iframe - ugly, completely obsolete element for page layout.
It’s not the solution at all. What I mean is simple, straightforward way to convert spreadsheet into mobile friendly web application, that uses javascripts to recreate functionality of Excel’s formulas. Nice web interface instead of ugly Calc cells.
TeX had an error message for this kind of things: “Please ask a wizard to …”
.
The simple straightforward way for your web-app is to develop it. If you believe the advertisements, ask any AI, to do it for you. Otherwise start reading about programming web-apps. Converting a “useless” Office suite is not easy, especially, if you have no clue, what you are attempting to do/ask.
.
What you ask for can be done in JavaScript (and I guess even in php).
For example start reading here (quick google search):
Btw, I can’t change background color in individual cells. Looks like bug.
Looks like a new topik, so start a separate thread and tell, what you tried, what system you use (OS, Version of LO, if you have created your own webappp in the last hours I guess you are on your own).
You are the only one asking this currently. So pebcak and “not enough data” on setting us still possible.