Thank you Nikolas for your reply.
No problem, I’ll switch to English. I hope I have the right vocabulary.
You have understood my needs perfectly.
I am therefore attaching a simplified document of what I would like.
This is a table representing mechanical assemblies consisting of several steel bars for the construction of a machining machine.
Prices are adjusted according to the selection of blue boxes. (The aim is to create a document that can be used by future customers to adjust their options to best suit their budgets). The orange box is not an option in itself but becomes mandatory when at least one of the two options just above it is selected.
The price is recalculated based on the various options, but I would like to go further on three main points:
1/ A simple checkbox instead of the blue boxes. Since this is an option, there are only two choices: either ‘with’ or ‘without’.
2/ I would have liked to be able to hide lines depending on whether the option is checked or not (see the two photos) in order to make the document much more readable and easier to navigate. I thought about creating a group, but I can’t automate its ‘grouping’ and ‘ungrouping’ based on the value of a box. So I’d be interested if you have any ideas.
3/ I see that unlike ‘PDF forms’, when you export a document like this, you can no longer choose from the options set in the sheet.
In my case, I would very much like to see the option in the future to export this type of document in a non-editable format, just like PDF forms, and therefore continue to be able to choose these options. (Although this is not possible to my knowledge via other spreadsheets, I think the option could be very welcome for many users).
The document was created directly in OnlyOffice.
Thank you in advance.
I am unable to attach the document, so I am sending it to you via Kdrive: spreadsheet simulation.xlsx
Picture :
