Bug 143932 - horizontal pitch resolution limit disrupts label spacing in Labels creator, formatting
Summary: horizontal pitch resolution limit disrupts label spacing in Labels creator, f...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Labels-BusinessCards
  Show dependency treegraph
Reported: 2021-08-18 13:23 UTC by be!bob
Modified: 2022-04-02 04:50 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description be!bob 2021-08-18 13:23:37 UTC
I am trying to create a label type for a full sheet of 3/4 inch by 1/2 inch labels of 9 columns and 16 rows. They are on standard letter-sized (8.5 by 11 inch) sheets. The margins and pitches are in 1/8ths and 1/16ths of an inch.
When I put in the correct horizontal pitch, vertical pitch, and margins, the number is rounded to two decimal digits. The rounding error, when multiplied by the number of labels, destroys the alignment to the actual labels when printed. 
I have tried inputting the measurments in the following ways:
0.625" which is converted to 0.63"
15.88mm which is converted to 0.63"
5/8 which is converted to 0.63"
The problem is that this is not just a "display" rounding, where the actual measurement is correct internally. The internal number also seems to be rounded to two decimal digits in inch units. I was hoping that it would also use two decimal digits in millimeters, but no luck. 
This issue makes the label creation unworkable. I have 1/2 by 1/2 and 3/4 by 1/2 labels that require pitches and margins with greater resolution to make them work. 
I can find no work around.
I see that there are other bug reports related to the two decimal digit issue, but not for labels in writer. So, I am adding this to the list since it makes printing to small labels useless. To further justify the need, these are small asset tags that will have sequential numbers and company logo printed. There is a need for the labels to work properly and be used with a database merge. 

Steps to Reproduce:
1. File/New/Labels -> format tab
2. Horizontal Pitch 7/8"
3. Vertical Pitch 5/8"
4. Width 3/4"
5. Height 1/2"
6. Columns 9
7. Rows 16
8. print out set of labels and see that the vertical and horizontal pitches do not match the numbers entered and cannot print properly on label sheet. 

Actual Results:
Labels do not print at correct (entered) pitches. Rounding error causes accumulated error in label placement and printing not within label bounds.

Expected Results:
Printing would be properly positioned on the labels in the positions as entered into the label creation form. 

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 1 Dieter 2021-09-02 10:39:25 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it)

> I see that there are other bug reports related to the two decimal digit
> issue

Could you please add them in See also field? Thank you.
Comment 2 QA Administrators 2022-03-02 03:48:19 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2022-04-02 04:50:05 UTC
Dear be!bob,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team