Bug Hunting Session
Bug 46872 - [FORMATTING] RFE: add field "List entries" to form editor in document for ListBox and ComboBox (like in Basic IDE)
Summary: [FORMATTING] RFE: add field "List entries" to form editor in document for Lis...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Form-Controls
  Show dependency treegraph
 
Reported: 2012-03-02 01:12 UTC by Nicolas Mailhot
Modified: 2017-06-19 21:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.