How to add selected data to the first empty line
How to add selected data to the first empty line
I would like to copy the button-selected data to the first blank line in the output record area (blue area).
The output continues each time one of the buttons are clicked, adding new line below.
The output records cannot be linked data, but text or number in each cell.
Without using VBA, how can I design this form setting?
Thank you.
OpenOffice 4.1.1 on Windows 7
Re: How to add selected data to the first empty line
Hello
I think you can do what you want easy with a real database. For that reason you have also to understand what you can do with a form. You can use forms in a spreadsheet but I think how you do it now is not good.
I have made a search for you for filterexamples. Maybe this link will help also.
I think make two simple table.
In your doc-form make two data-form:
a) one mainform
b) one subform
Connect the subform and mainform in the way it passed the selected dat from the mainform to the subform.
I think for detail read some tutorials and the help file.
Romke
I think you can do what you want easy with a real database. For that reason you have also to understand what you can do with a form. You can use forms in a spreadsheet but I think how you do it now is not good.
I have made a search for you for filterexamples. Maybe this link will help also.
I think make two simple table.
In your doc-form make two data-form:
a) one mainform
b) one subform
Connect the subform and mainform in the way it passed the selected dat from the mainform to the subform.
I think for detail read some tutorials and the help file.
Romke
LibreOffice 7.1.4.2 on openSUSE Leap 15.2