Sometimes the little things matter when using a distro... especially when it involves completing a simple task that helps one's productivity such as making address labels in bulk. In Debian, I use Glabels for this task, but given that it is a Gnome app, it will not run in Wary Puppy as there are too many missing dependencies....
So, I got to thinking about this and I wondered about using a spreadsheet as a template... whether it would work or not. After spending a couple of evenings on this, I found a way to do this in Gnumeric while using the Avery Mailing Labels #08160 These mailing labels come in Letter Sized sheets with 30 labels per sheet.
In a nutshell, the task involves creating a spreadsheet layout that matches the Mailing Labels Sheet. To do this, one must resize the necessary rows and columns to match the size of each label and take into account the spacing between the labels. To accomplish this, one must convert the dimensions of each row and column from inches or centimeters to pixels.
Briefly here is what I did:
- --determined that my screen display is set at 84 dpi
--set the screen dpi in Gnumeric to the same value --> Preferences
--converted the column widths and row heights from inches to pixels
--adjusted the font size for the address labels in Gnumeric
--set the margins for printing in Page Setup in Gnumeric
--frequently checked the Print Preview and tweaked the values for each row, column and margin in the set up
-- made four or five test prints until I was satisfied with the result
--I placed the finished spreadsheet here: --> /usr/share/gnumeric/1.10.16/templates
Lastly, I want to say that I am not a spreadsheet wizard. There may be some further tweaks or improvements that can be done, and I will welcome helpful advice, input etc. My thoughts are that this project is a bit tedious, but quite do-able, However, if anyone wants more details, more information how to do this, then I will consider writing another post in depth.
Cheers,
Monsie