Multiple copy paste in a single column in form Table

Discuss the database features
Post Reply
Imagination *-*
Posts: 41
Joined: Tue May 24, 2016 7:45 pm

Multiple copy paste in a single column in form Table

Post by Imagination *-* »

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!
access1.png
access.png
access2.png
LibreOffice 5.1.3.2 on Windows 7 64 bit
lalithr312
Posts: 56
Joined: Mon Jun 22, 2015 12:07 am

Re: Multiple copy paste in a single column in form Table

Post by lalithr312 »

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
OpenOffice 4.1.1 on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Multiple copy paste in a single column in form Table

Post by Villeroy »

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.
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
Post Reply