Language Selection

English French German Italian Portuguese Spanish

Openoffice.org mailing labels solution

My daughter is getting married this Summer, and she purchased some weird Avery return address labels for invitees to RSVP whether they plan to attend. The labels have an Avery number of 18195. I have no MS-Windows workstations at home, and I couldn't find an Openoffice.org Writer template for this particular label stock. What to do?

The labels are 2/3 inch tall, 1 3/4" wide, 4 across in a row, and 15 rows on an 8 1/2" by 11" (US letter size) sheet. I still can't find a corresponding OOoWriter template. Nothing even close.

I do a Google search, and try glabel. It seems very powerful--alas, after fooling around with it for a few minutes, I'm not able to get very close to what I need for a label format.

Then, I go to Avery's web site, and download Avery's Microsoft Word doc file template for the 19195 labels. I then open it into Openoffice.org 3.0 Writer beta (m-17). The doc file is a table. I type the return address into one cell, copy that address, and quickly paste the address info into the other 59 cells. I try a print-out on a plain piece of paper and then I examine the printed registration match-up with the Avery label stock. No joy, the table rows on the test print-out aren't tall enough.

In Writer, I select the entire table, pull up the row height option, and see that the doc file import had set the row height to .60 inches instead of the needed .67 inches (or possibly, Avery had it incorrect in the original doc file). I change the row height accordingly, print-out another plain paper copy, and check the registration again. Everything lines up. A minute later, and all my labels are perfectly printed.

More in Tux Machines

today's howtos

96Boards SBC showcases Mediatek’s deca-core Helio X20

MediaTek launched the fastest open-spec SBC to date with a 96Boards development board that runs Android on its deca-core Cortex-A53 and -A72 Helio X20 SoC. The “Helio X20 Development Board” is MediaTek’s first 96Boards form-factor single-board computer, and the most powerful open-spec hacker SBC to date. Although we’ve seen some fast 64-bit SoCs among 96Boards SBCs, such as the HiKey, based on an octa-core, Cortex-A53 HiSilicon Kirin 6220, the Helio X20 Development Board offers an even more powerful Helio X20 system-on-chip processor. Read more

Red Hat Financial News

Leftovers: OSS and Sharing

  • New projects, security, and more OpenStack news
  • LibreOffice 5.1.4 Released with Over 130 Fixes
    The first release candidate represented 123 fixes. Some include a fix for a crash in Impress when setting a background image. This occurred with several popular formats in Windows and Linux. Caolán McNamara submitted the patches to fix this in the 5.1 and 5.2 branches. David Tardon fixed a bug where certain presentations hung Impress for extended periods to indefinitely by checking for preconditions earlier. Laurent Balland-Poirier submitted the patches to fix a user-defined cell misinterpretation when using semicolon inside quotes.
  • Open source. Open science. Open Ocean. Oceanography for Everyone and the OpenCTD
    Nearly four years ago, Kersey Sturdivant and I launched a bold, ambitious, and, frankly, naive crowdfunding initiative to build the first low-cost, open-source CTD, a core scientific instrument that measures salinity, temperature, and depth in a water column. It was a dream born from the frustration of declining science funding, the expense of scientific equipment, and the promise of the Maker movement. After thousands of hours spent learning the skills necessary to build these devices, hundreds of conversations with experts, collaborators, and potential users around the world, dozens of iterations (some transformed into full prototypes, others that exist solely as software), and one research cruise on Lake Superior to test the housing and depth and temperature probes, the OpenCTD has arrived.
  • RuuviTag Open-Source Bluetooth Internet Of Things Sensor Beacon Hits Kickstarter (video)
  • Retro gaming on open source 2048 console
    Retro gaming in the open source vein could be on the upswing this season. Creoqode is the London-based technology design company behind 2048, the DIY game console with retro-style video games and visuals that is also supposed to help users learn coding.