[Upstream] 3 column address label mailmerge alignment not calculated correctly

[DrKay]

When a 3 column label sheet is chosen for printing addresses with mailmerge, columns 2 and 3 are aligned further and further to the left. On Avery 5160, the rightmost column (3) is aligned so far to the left that it does not print fully on the label. This has been reported as Debian Bug #678813 and LibreOffice #58700.

ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: libreoffice (not installed)
ProcVersionSignature: Ubuntu 3.2.0-35.55-generic 3.2.34
Uname: Linux 3.2.0-35-generic x86_64
ApportVersion: 2.0.1-0ubuntu15.1
Architecture: amd64
Date: Sun Dec 23 21:59:37 2012
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 11.04 "Natty Narwhal" - Release amd64 (20110427.1)
MarkForUpload: True
SourcePackage: libreoffice
UpgradeStatus: Upgraded to precise on 2012-04-30 (238 days ago)

[Drjameskay (drjameskay)]

Problem description:
When printing with mailmerge on a sheet of labels with 3 columns, the column spacing is not calculated correctly. Column 1 is more or less OK, but columns 2 and 3 are aligned more and more to the left, so that column 3 does not print on the label.
Steps to reproduce:
1. Create a mailmerge with a database of addresses to print on labels.
2. Select Avery Letter Size 5160 labels
3. Print and notice above described behavior.

Current behavior:
As above.
Expected behavior:
I would expect that printing would align the same on labels of all three columns.

Operating System: Ubuntu
Version: 3.5.4 release

[Drjameskay (drjameskay)]

Problem description:
When printing with mailmerge on a sheet of labels with 3 columns, the column spacing is not calculated correctly. Column 1 is more or less OK, but columns 2 and 3 are aligned more and more to the left, so that column 3 does not print on the label.
Steps to reproduce:
1. Create a mailmerge with a database of addresses to print on labels.
2. Select Avery Letter Size 5160 labels
3. Print and notice above described behavior.

Current behavior:
As above.
Expected behavior:
I would expect that printing would align the same on labels of all three columns.

Operating System: Ubuntu
Version: 3.5.4 release

[penalvch (penalvch)]

DrKay, thank you for reporting this and helping make Ubuntu better. Could you please attach your Avery 5160 file, and URL from where you downloaded the original from if applicable?

[DrKay (dr-jameskay)]

I don't know what you mean by Avery 5160 file. Is this stored somewhere on my computer? I used LibreOffice Writer. I clicked File -> New -> Labels, then select Avery Letter Size, then 5160.

I did not download anything.

Thank you.

[penalvch (penalvch)]

DrKay, could you please provide exact, click-for-click instructions on how you built your Avery 5160 label file? So far, we have click File -> New -> Labels -> tab Labels -> drop down Brand Avery Letter Size -> drop down Type 5160. Anything else or did you just immediately click New Document after the above mentioned steps?

[DrKay (dr-jameskay)]

File -> New -> Labels -> tab Labels -> drop down Brand Avery Letter Size -> drop down Type 5160 Address, then selected the database I was using, and the table (I think it was something like 'Table 1'), added the appropriate fields into the label text, then clicked New Document.

[penalvch (penalvch)]

DrKay, could you please attach the resultant document that demonstrates this problem?

[DrKay (dr-jameskay)]

You will probably need to print this on an Avery 5160 sheet to see what happens. Additionally, it seems that no amount of customizing/adjusting under the Format tab can correct this--or at least I couldn't.

[penalvch (penalvch)]

"Mailing labels (30 per sheet, works with Avery 5160, 8160)" downloaded from http://office.microsoft.com/en-us/templates/mailing-labels-30-per-sheet-works-with-avery-5160-8160-TC001183278.aspx .

[penalvch (penalvch)]

DrKay, as a WORKAROUND, when you click the tab Format, if you adjust the "Horizontal pitch", and/or "Left margin" can you get a usable print out?

As well, does the Microsoft provided Avery 5160 compatible document noted in https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1093401/comments/11 provide a WORKAROUND?

[DrKay (dr-jameskay)]

Christopher-

Thank you for your attention to this bug!

For almost 2 hours, I adjusted the settings in the Format tab. I first carefully measured the Avery 5160 labels, then ensured that the proper measurements were entered in the format provided. When this did not work, I attempted to compensate by making adjustments to the settings that would push the 2nd and 3rd columns to the right (the LibreOffice Format tab has a really nice preview feature that shows you what each adjustment is doing as you make the adjustment). Unfortunately, no matter what I did, it could not push the 2nd and 3rd columns over, even though it looked like it should work on the format preview.

I have not tried the Microsoft Avery 5160 template--I didn't know it was available when I was doing my mailing. Also, it has a lengthy Terms of Use that you must agree to to be allowed to use it.

[penalvch (penalvch)]

DrKay, regarding your comments https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1093401/comments/13 :
>"For almost 2 hours, I adjusted the settings in the Format tab. I first carefully measured the Avery 5160 labels, then ensured that the proper measurements were entered in the format provided. When this did not work, I attempted to compensate by making adjustments to the settings that would push the 2nd and 3rd columns to the right (the LibreOffice Format tab has a really nice preview feature that shows you what each adjustment is doing as you make the adjustment). Unfortunately, no matter what I did, it could not push the 2nd and 3rd columns over, even though it looked like it should work on the format preview."

What value(s) for the Horizontal pitch and/or Left margin did you use specifically?

[DrKay (dr-jameskay)]

I tried numerous settings-- everything I could think of, for almost 2 hours.

[Jmadero-dev (jmadero-dev)]

So I'm not going to go out and purchase the labels but from spot checking, they look right.

Attaching a pdf print.

@James - can you print the pdf and see if the labels are aligned? If they aren't I'll just say the bug is confirmed.

[Jmadero-dev (jmadero-dev)]

So I'm not going to go out and purchase the labels but from spot checking, they look right.

Attaching a pdf print.

@James - can you print the pdf and see if the labels are aligned? If they aren't I'll just say the bug is confirmed.

[Jmadero-dev (jmadero-dev)]

Created attachment 80638
PDF Print of Avery Labels - Please print to label and see if they are aligned

[Jmadero-dev (jmadero-dev)]

Created attachment 80638
PDF Print of Avery Labels - Please print to label and see if they are aligned

[Jmadero-dev (jmadero-dev)]

Thank you for reporting this issue! I have been able to confirm the issue on:
Version: 4.2.0.0.alpha0+Build ID: b0a1666f756aa5f5315366eca9d7d02ddd55d2b
Date: Tue May 28 08:51:01 2013 +0300
Platform: Bodhi Linux 2.2 x64

Nevermind -found some labels - indeed confirmed

Marking as:

New
Major - in general I wouldn't say this but it essentially makes the print to labels useless - I would be surprised if it's not a duplicate somewhere
High - default, seems appropriate

ProposedEasyHack

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link:
https://wiki.documentfoundation.org/QA/BugTriage and join us on freenode at #libreoffice-qa

There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org/get-help/mailing-lists/.

Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material

[Jmadero-dev (jmadero-dev)]

Thank you for reporting this issue! I have been able to confirm the issue on:
Version: 4.2.0.0.alpha0+Build ID: b0a1666f756aa5f5315366eca9d7d02ddd55d2b
Date: Tue May 28 08:51:01 2013 +0300
Platform: Bodhi Linux 2.2 x64

Nevermind -found some labels - indeed confirmed

Marking as:

New
Major - in general I wouldn't say this but it essentially makes the print to labels useless - I would be surprised if it's not a duplicate somewhere
High - default, seems appropriate

ProposedEasyHack

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link:
https://wiki.documentfoundation.org/QA/BugTriage and join us on freenode at #libreoffice-qa

There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org/get-help/mailing-lists/.

Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material

[Drjameskay (drjameskay)]

I confirmed as well on Avery 5160 template labels (actually Avery 5960, but they use the same template).

Clever addresses, Joel! :-)

[Drjameskay (drjameskay)]

I confirmed as well on Avery 5160 template labels (actually Avery 5960, but they use the same template).

Clever addresses, Joel! :-)

[Jmadero-dev (jmadero-dev)]

haha I don't get credit for those ;) Found them online just searching "sample data for address labels ;)

[Jmadero-dev (jmadero-dev)]

haha I don't get credit for those ;) Found them online just searching "sample data for address labels ;)

[Qubit (qubit)]

Remove comma from whiteboard.

[Qubit (qubit)]

Remove comma from whiteboard.

[Jmadero-dev (jmadero-dev)]

In order to limit the confusion between ProposedEasyHack and EasyHack and to make queries much easier we are changing ProposedEasyHack to NeedsDevEval.

Thank you and apologies for the noise

[Jmadero-dev (jmadero-dev)]

In order to limit the confusion between ProposedEasyHack and EasyHack and to make queries much easier we are changing ProposedEasyHack to NeedsDevEval.

Thank you and apologies for the noise

[Cno (cno)]

Hi James,

I expect this has been fixed in one of the recent versions.
Can you pls try again?
thanks,
Cor

[Cno (cno)]

Hi James,

I expect this has been fixed in one of the recent versions.
Can you pls try again?
thanks,
Cor

[Iplaw67 (iplaw67)]

Adding self to CC if not already on

[Iplaw67 (iplaw67)]

Adding self to CC if not already on

[julien2412 (serval2412-6)]

No feedback since more than 6 months, put it as WFM.

James: don't hesitate to reopen this tracker if you can reproduce it with a recent LO version (last ones are 4.3.5 and 4.4.0)

[Qubit (qubit)]

Migrating Whiteboard tags to Keywords: (needsDevEval)
[NinjaEdit]

[Björn Michaelsen (bjoern-michaelsen)]

closing as per https://bugs.documentfoundation.org/show_bug.cgi?id=58700#c10