How do I bind a form element size and position to a cell?

Discuss the spreadsheet application
Post Reply
bmmcwhirt
Posts: 15
Joined: Fri Jun 28, 2013 3:56 pm

How do I bind a form element size and position to a cell?

Post by bmmcwhirt »

I want to have a combo box in a cell and it's size and location be bound so it's always in that cell and not floating like is the default, how do I do this?
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How do I bind a form element size and position to a cell

Post by Zizi64 »

A Combo box and other form control elements never located in a cell, but they located on a secondary graphical layer.. You can anchor them to a cell only, and you can align to a cell manually only - by the User Interface features.

But you can write a macro fot the automated aligning...

Or you can use the Data validity function instead of the Form control elements.
Last edited by Zizi64 on Fri Nov 20, 2015 9:35 pm, edited 1 time in total.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
bmmcwhirt
Posts: 15
Joined: Fri Jun 28, 2013 3:56 pm

Re: How do I bind a form element size and position to a cell

Post by bmmcwhirt »

Thank you for the tip on Data Validity, that worked out amazingly well for what I'm working on.

On a side note is there a way to crate a table in form editor and have that add new rows of form elements as needed? That way if I do need to do something like this I can ignore the cell data on the form page and have my population data in another sheet.I know I can do it in Adobe Lifecycle designer, but my goal is to move away from PDF if I can.

Again thanks.
bmmcwhirt
Posts: 15
Joined: Fri Jun 28, 2013 3:56 pm

Re: How do I bind a form element size and position to a cell

Post by bmmcwhirt »

Is there a way for user to select multiple items from the list in Data Validity select box?
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How do I bind a form element size and position to a cell

Post by Zizi64 »

Is there a way for user to select multiple items from the list in Data Validity select box?
How do you mean this? Do you want select more than one item in same time? It is not possible.

But you can create multiple cells with only one (same) data validity list. Just reference all data validity cell to same cell range.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
bmmcwhirt
Posts: 15
Joined: Fri Jun 28, 2013 3:56 pm

Re: How do I bind a form element size and position to a cell

Post by bmmcwhirt »

Is there an alternative way to allow them to select from a list of 200? Select 1, several or all?
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How do I bind a form element size and position to a cell

Post by Zizi64 »

How will located (how fit) more than one selected item in a cell in same time??

(It is not possible.)

What do you want to achieve exactly? How do you want to use the multiple selected data? How you will reference them?
Can you upload your prepared example .ods file here?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply