Hello. I can’t copy a some rubrics in the table in LibreOffice Base. I can copy only whole table or only one rubric. How can I repair it? Please help, thanks.
rubric is a column or a group of rows?
.
I often create a special query first, then copy/use the resut of the query.
.
In general databases are not designed as spreadsheets. It is often more used like a programming language (SQL), not for visual programming… But maybe you’d like to check on Access or Filemaker…
If you wan’t to copy more than one row in the same table you will need an autoincremented primary key.
Mark the content (shift + left mouse button).
Draw to new row.
All marked rows will be inserted with a new autonincremented primary key.
You could do the same from one table to another.
Sorry, doesn’t work. I mean that I have column of names, phone numers etc. and with e-mails. I want to mark only these e-mails and copy. I can’t do this.
From where to where do you want to copy e-mails?
Have tested this: Original table with more than one field.
Target table with one field “Mail”, which is also a field in the original table. Primary key has AutoValue here.
Marked all rows of original table.
Moved to target table.
All “Mail” will be copied.
Copying looks for a field with the same name. If you don’t want to copy other columns you could do this by “Hide Column” for the other columns (click on the header → right mouse button → Hide column) or try it by a query.
You speak a very incomprehensible language. Please tell me it step by step. And your question: “From where to where do you want to copy e-mails?” - I want to copy mails from LibreOffice Base to poczta.nazwa.pl (polish mail box). I want to send any message to every my mails.
So you won’t copy anything inside Base. You want to copy 1 column to another program.
- Open the Base file.
- Go to “Queries”
- Start “Create Query in Design View…”
- Chose the table with the field “EMail”.
- Close the dialog for adding queries.
- Doubleclick on the field “EMail”
- Edit → Run Query (F5)
- Open a new Calc document
- Mark all rows by the row header
- Drag now to the Calc document.
- Content of “EMail” will now be copied to Calc together with column header.
- Mark content in Calc and copy the content
- Paste content to your Mail program (works here for Thunderbird …)
You couldn’t copy directly from Base to Writer or Mail Program. Copying a table in Base will need a table structure for paste the content.
I know I don’t write English that well, but I hope this is understandable now.
- Click the toolbar button “Distinct values” to skip duplicate addresses.
- Save the query under some name and close the query design window.
- Copy the query icon.
- Paste into some spreadsheet or text document.
Alternative to the last 2 steps: - Call menu:View>Data Sources (Ctrl+Shift+F4) in Writer or Calc
- Drag the query icon from the data source window’s left pane into the document
And alternative to the first 6 steps:
- Create a new query in SQL view (contrary to design view) and type in
SELECT DISTINCT "Email" FROM "Table_Name"
with the right names in double quotes.
- Test the query by hitting F5.
- Save and close the query.
Nice. Thank you for all! I just copied whole table to LibreOffice Calc and here I can comfortable copy it. Thank you! And Merry Christmas :). I don’t know how about another countries but in Poland Christmas starts tomorrow.