Bug 46872

Summary: [FORMATTING] RFE: add field "List entries" to form editor in document for ListBox and ComboBox (like in Basic IDE)
Product: LibreOffice Reporter: Nicolas Mailhot <nicolas.mailhot>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: sasha.libreoffice
Priority: medium    
Version: 3.5.0 release   
Hardware: Other   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 107742    

Description Nicolas Mailhot 2012-03-02 01:12:57 UTC 
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.
Comment 1 sasha.libreoffice 2012-05-29 08:57:33 UTC 
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
Comment 2 Joel Madero 2012-06-29 15:40:49 UTC 
@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:

http://www.wikihow.com/Create-a-Form-in-a-Spreadsheet

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.
Comment 3 sasha.libreoffice 2012-07-06 03:29:35 UTC 
Instructions:
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.
Comment 4 QA Administrators 2013-05-26 22:31:43 UTC Comment hidden (obsolete)
Comment 5 Nicolas Mailhot 2013-05-30 15:32:21 UTC 
(In reply to comment #3)
> Instructions:
> 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
Comment 6 sasha.libreoffice 2013-05-31 06:26:28 UTC 
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.