Issue 119603 - "Spacing to contents" doesn't work properly
Summary: "Spacing to contents" doesn't work properly
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.3
Hardware: PC Windows 7
: P3 Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2012-05-30 22:02 UTC by Dwayne Henderson
Modified: 2012-07-18 01:53 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

"Spacing to contents" set to 1,35mm but shifted by OOo Calc to 1,36mm (7.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-06-14 10:08 UTC, Dwayne Henderson
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Dwayne Henderson 2012-05-30 22:02:31 UTC
If I set "Spacing to contents" in Format Cells => Borders to 1,35mm, exit, and re-enter, OOo (3.3.0) will have changed it to 1,36mm. If I set it to 1,10mm, it will have changed to 1,09mm. 1,50mm, however, will remain unchanged.

This can be troublesome if one wishes to use consistent round-number positioning and sizing on form elements.

Comment 1 Li Feng Wang 2012-06-14 06:28:33 UTC
I try to reproduce on AOO3.4 release version, but can't reproduce.

when I set borders to 1.35mm, It will convert to 4.0pt and have no changed after re-enter.
Comment 2 Dwayne Henderson 2012-06-14 10:05:48 UTC
I'm so sorry - I forgot to mention that I'm applying this "Spacing to contents" through the "Default" style in "Styles and Formatting".

Please try that.
Comment 3 Dwayne Henderson 2012-06-14 10:08:14 UTC
Created attachment 78325 [details]
"Spacing to contents" set to 1,35mm but shifted by OOo Calc to 1,36mm

Set through the "Default" style in "Styles and Formatting".
Comment 4 Du Jing 2012-07-18 01:53:25 UTC
confirmed,I can reproduce in AOO-r1359641

repeat steps:
1.launch oo and new a spreadsheet
2.input some text in one cell as B3 the cell and enable context menu,select "Format cell...->borders" and set "Spacing to contents" as 1.35mm.
note:if the measurement unit is not millimeter,please change by "Tools-> calc->general" to check the spacing to contents

the spacing 1.35mm will change to 1.36mm.but if set 1.50mm,re-enter and it will no change.