How do I bind a form element size and position to a cell?
How do I bind a form element size and position to a cell?
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?
Re: How do I bind a form element size and position to a cell
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.
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.
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.
Re: How do I bind a form element size and position to a cell
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.
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.
Re: How do I bind a form element size and position to a cell
Is there a way for user to select multiple items from the list in Data Validity select box?
Re: How do I bind a form element size and position to a cell
How do you mean this? Do you want select more than one item in same time? It is not possible.Is there a way for user to select multiple items from the list in Data Validity select box?
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.
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.
Re: How do I bind a form element size and position to a cell
Is there an alternative way to allow them to select from a list of 200? Select 1, several or all?
Re: How do I bind a form element size and position to a cell
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?
(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.
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.