Bug 127860 - Border units cannot be changed - it's stuck at points
Summary: Border units cannot be changed - it's stuck at points
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-09-29 10:23 UTC by Szasz-Fabian Jozsef
Modified: 2020-04-24 18:35 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Szasz-Fabian Jozsef 2019-09-29 10:23:01 UTC
Description:
The 'points' measurement units means nothing for all users. Except some old print industry guys, points is completely unpractical. It should be the default units, either millimeters or inches, whatever is chosen at the options.

Steps to Reproduce:
1. Select some cells
2. Hit Ctrl-1
3. At the border tab attempt to set the border width to 0.5 mm. Those who don't figure out, to type 0.5 mm will fail even to calculate how many points is 0.5 mm. Moreover, after typing 0.5 mm, the input is changed back to points so it's unable to verify the actual value in millimeters.

Actual Results:
Borders measurement units is stuck at points.

Expected Results:
Display the border units in the chosen units (metric/inches)


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Durgapriyanka 2019-10-04 17:00:35 UTC
Thank you for reporting the bug.

In Version: 6.3.0.0.alpha0+ ,I set the border width to 0.5mm. It does calculate how many points is 0.5mm( also tried various values) and displays it in points.

Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 2 raal 2019-10-08 05:46:28 UTC
Works for me Version: 6.4.0.0.alpha0+
Build ID: 52cda5c5ae426761ccbdb4f20419098eab195303
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 

write for example 2mm and leave text box - calc correctly set 5,67 pt.

please retest with current version of LO. If it still fails for you, add more informations about your system and LO version.
Comment 3 Szasz-Fabian Jozsef 2019-10-09 12:29:17 UTC
(In reply to raal from comment #2)
> write for example 2mm and leave text box - calc correctly set 5,67 pt.
> 
> please retest with current version of LO. If it still fails for you, add
> more informations about your system and LO version.

Back to the original problem:

The 'points' measurement units means nothing for all users. Except some old print industry guys, points is completely unpractical. It should be the default units, either millimeters or inches, whatever is chosen at the options.

LO converts mm to points - it's ok. But next time if I open the dialog and it shows 15,34 points, now how many millimeters is this? This is why points is unpractical. The text box should use practical units, not some cumbersome units.
Comment 4 Buovjaga 2020-04-24 18:35:39 UTC
I don't think this will be changed, see https://bugs.documentfoundation.org/show_bug.cgi?id=72662#c19 for related discussion