Hi guys,
Can the form in OpenOffice Base perform the same functionality as Microsoft Access as shown in below images?
The images shown has other columns but hidden. I would like to multiple copy paste for a single column only.
Appreciate the feedback, thanks!
Multiple copy paste in a single column in form Table
-
- Posts: 41
- Joined: Tue May 24, 2016 7:45 pm
Multiple copy paste in a single column in form Table
LibreOffice 5.1.3.2 on Windows 7 64 bit
-
- Posts: 56
- Joined: Mon Jun 22, 2015 12:07 am
Re: Multiple copy paste in a single column in form Table
There's a way to do this by editing the data first in Calc and then copying to Base.
It has to meet uniqueness and formatting requirements, though.
Please see this comment: https://bz.apache.org/ooo/show_bug.cgi?id=47703#c2
It has to meet uniqueness and formatting requirements, though.
Please see this comment: https://bz.apache.org/ooo/show_bug.cgi?id=47703#c2
OpenOffice 4.1.1 on Windows 10
Re: Multiple copy paste in a single column in form Table
Having a Base table, view, query or form grid in one window and a Writer/Calc document in another window, I can select multiple records and then drag the grey row handles into the document.
Writer shows an import helper which lets me import the selected data as a Writer table, mail merge fields or tab separated text.
Calc dumps the selected records together with a header row into the spreadsheet grid.
P.S. works also with a record selection from the data source window.
Writer shows an import helper which lets me import the selected data as a Writer table, mail merge fields or tab separated text.
Calc dumps the selected records together with a header row into the spreadsheet grid.
P.S. works also with a record selection from the data source window.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice