We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Having trouble populating a table with a spread sheet [closed]

asked 2017-12-02 15:23:55 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am trying to build a data base of names and addresses. When I went to use the spread sheet to populate the table I get the message "The connection to the data source "newdb with java update" could not be established" So I downloaded a new version of Java. I understand that Windows 10 and edge do not play well with Java. So I down loaded Java using IE11. Then I down loaded JRE using current update. I restarted the computer. I deleted the old data base and generated a new one. But still get the same message. What Am I doing wrong?

Part 2 I have managed to connect my data base (new label) to my spread sheet (Christmas label.ODS). which is now called SHEET1 in the tables section. I went to generate a new document (avery labels # 8660). I move the spread sheet field names to the label from sheet 1. I then press new document. I see he 4 up labels. However no data is transferred, it only shows me the field names from SHEET1. example <name>,

, <city>, <state>, but no actual data. I am totally confused and I am at a loss as what to do next. I really need help. I would like to thank anyone in advance that can help me with my problem.

Thank you

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-02-08 04:01:14.898039


Jim K gravatar imageJim K ( 2017-12-02 15:40:23 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-12-02 22:25:31 +0200

Ratslinger gravatar image


It sounds like you haven't done a mail merge. The LO Docs (found here) contain a lot of info on creating labels and mail merge.

As a summary, you have started with a spreadsheet with access to the data in a database:

image description

Next you have started to generate labels (Avery 8660) getting to this point:

image description

Then chose New Document:

image description

Here is where I think you are missing the steps to fills the fields with the data. From the menu select Tools->Mail Merge Wizard... This is a simple merge so on the first screen select Next>> button on the next page select Finish button giving you this screen:

image description

If you select Edit Individual Documents you get this screen:

image description

Now you can see the resulting labels. There is obviously more to this as the selections show. Please refer to the documentation for more info. This is just to get you started.

If this answers your question please click on the ✔ (upper left area of answer).

edit flag offensive delete link more


Also there is the Books, guides and more. It is in the upper right column under Resources (main questions page),which among many other things, contains this: Printing Address Labels. Even without following my extended instructions, your labels should work when you selected Print which would bring up the Mail Merge dialog.

Ratslinger gravatar imageRatslinger ( 2017-12-03 01:05:17 +0200 )edit

Thank you , Thank you, Thank you. You not only found the error I was having, and corrected it, the OL link you gave me about labels was really great and very informative. Thank you very much.

gwatrobski gravatar imagegwatrobski ( 2017-12-04 00:43:30 +0200 )edit

If this answers your question please click on the ✔ (upper left area of answer).

Ratslinger gravatar imageRatslinger ( 2017-12-04 00:58:08 +0200 )edit

'Edit individual Document' is the magic information that is -missing- from the LO docs, like: https://help.libreoffice.org/6.3/en-U...

The label-printing process is totally counter-intuitive. Being an experienced consultant, I now spend 3 hours on this. LO needs to streamline that badly.

wusel77 gravatar imagewusel77 ( 2019-09-17 02:10:51 +0200 )edit

Question Tools


Asked: 2017-12-02 15:23:55 +0200

Seen: 1,242 times

Last updated: Dec 02 '17