It is very common for users to want to create forms with simple controls (typically forms where some option can be toggled or not, limited-choices lists, etc)
Unfortunately calc only allows creating complex forms that depend on macros and cell queries, which are way over complex for what 90% of users want to do and trigger macro warnings whenever the spreadsheet is opened
Please make it possible to create simple forms in calc that can be send afterwards for completion to users, and where nothing more complex is expected than seeing what the user selected when he sends the document back.
Thanks for new idea
> Please make it possible to create simple forms in calc that can be send
> afterwards for completion to users, and where nothing more complex is expected
> than seeing what the user selected when he sends the document back.
But this already exist. Just not forget to exit Design Mode for Form Controls
@Sasha, please provide instructions if you tell a user that something already exists
@Nicolas, check out this link and let us know if it's what you're talking about:
The documentation is for OOo but the same steps apply. I'm going to mark as NEEDINFO until you let us know if this is not (or is) what you are looking for.
1. Enable needed toolbar: View->Toolbars->Form controls
2. On this toolbar is button "Design mode On/Off". When we create document with forms, this button should be in pushed state. When we are finished with creating forms, then we should click this button again for switch to user mode of forms.
Create needed form controls in document
3. click button "Design mode On/Off"
4. Save document.
Dear Bug Submitter,
This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.
For more information about our NEEDINFO policy please read the wiki located here:
If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.
Thank you for helping us make LibreOffice even better for everyone!
(In reply to comment #3)
> 1. Enable needed toolbar: View->Toolbars->Form controls
> 2. On this toolbar is button "Design mode On/Off". When we create document
> with forms, this button should be in pushed state. When we are finished with
> creating forms, then we should click this button again for switch to user
> mode of forms.
> Create needed form controls in document
> 3. click button "Design mode On/Off"
> 4. Save document.
As stated in the title, this request is for macro-less controls
What you propose does not work in a document with disabled macros
Thanks for additional information.
As I can understand, when we in Basic IDE and editing ListBox or ComboBox, there in form editor is field "List entries" where we can enter initial enters of list by typing and pressing Shift-Enter. But in document in form editor we have no such field. And impossible to enter initial values.
And we ask to add this "List entries" to form editor in document.