Issue 119603 - "Spacing to contents" doesn't work properly
Summary: "Spacing to contents" doesn't work properly
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
"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
Add an attachment (proposed patch, testcase, etc.)

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.

--Dwayne
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
3.select 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->openoffice.org calc->general"
4.re-enter to check the spacing to contents

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