Quick way to fill strings inside a huge table

[elnath78]

I have the template here, to print multiple labels (189) but might need to print more. Each odd cell will have a string, every even cell is a gap so I can print this on sticky labels sheet.

What I need to enter in each odd cell is the coupon code from Google Play to provide my app for free as promotional effort, I then stick each label behing a business card and hand it to selected contacts.

Since one sheet has 189 cells and I may need to print around 500 or even 1.000 codes along the way, is there a simple way to fill one code in each odd cell, the codes are in a csv file, one per line, nothing fancy.

edit: I tried reproducing the grid in calc, since codes are already there I thought it would simplify things up, however I noticed this: I have set cell width/height and font family/size the same both on writer and calc, some text accomodate in writer but not in calc, for some weird reason cals has a base margin inside the cells I cant get rid of, this wraps some codes in 3 lines, this is too much since the first and 3rd row end up with respectively, top and bottom cut.

stampa etichette.odt (9.5 KB)

[PKG]

You really went to a lot of trouble to create the table. The labels are ready to use (File → New → Labels).

[elnath78]

Noted. But once I have the sheet, how do I quickly import the codes into every odd cell or cell in this case?

[elnath78]

Just tried, I noticed it is asking for a database/table/cell so problably “this is the way” what puzzles me is I cannot select all the cells and apply some basic formatting such as font family/size and center the text vertically other than word-wrapping the strings to split them into two lines, how would I do?

[ajlittoz]

The Label feature uses the mail-merge function. It then needs some “database” which can be a CSV text file. Consequently, convert first your table to text with Table>Convert>Table to Text. Remove excess data from the block of text (e.g. your “gap cell” spaces), erase excess paragraph breaks. Eventually add a separator between cell texts. Save as plain text, either .txt or .csv.

You can now process with stabdard label procedure.

[elnath78]

How do I conncet the data source ot the label sheet? I tried pasting one manually, labels are not cells so I cannot center the text vertically, this helps adding a little margin on the top and make sure labels are not being cut in proximity of the text.

[PKG]

sample Codes.pdf (563,8 KB)

[elnath78]

My codes are really long, they split into two lines inside the cells, I need to center the text vertically, but it is not a table and the meny for this is grayed out. I read in another post, that adding a white border will fix this, but I cannot find how to add border to the lables sheet.

[elnath78]

Similar issue is I cannot cpy the formatting to the whole lables, but need to do one by one.

[PKG]

@elnath78

Similar issue is I cannot cpy the formatting to the whole lables, but need to do one by one.

Then you forgot to allow synchronization.

[PKG]

@elnath78

My codes are really long, they split into two lines inside the cells,

For me, the length of the code doesn’t matter
(as long as it does not exceed the label size).

SampleCodes.odt (25,1 KB)

[elnath78]

Won’t this make all the contents the same? I need a different code in each frame. Also when you select a model (not all models are present) how do you know the spacing between frames?

[PKG]

@elnath78

Won’t this make all the contents the same?

I forgot to tell you that the field next record (Insert → field → More Fields [Ctrl+F2]) must be inserted after the database field.

[elnath78]

Wow, works well, but how do you tell if the gap between frames is correct? I don’t have every brand/model so I have to pick a compatible model or design it myself, is this normal or is there a smarter way?

[elnath78]

It is not working, all I get is a print with <Codes> not likely pulling the data, also because it asked me for a table name but never asked for a field name.