[Libreoffice-bugs] [Bug 123513] New: Using 0 to add in Optimal Column Width dialog makes width too narrow

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=123513

            Bug ID: 123513
           Summary: Using 0 to add in Optimal Column Width dialog makes
                    width too narrow
           Product: LibreOffice
           Version: 6.2.1.1 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Created attachment 149339
  --> https://bugs.documentfoundation.org/attachment.cgi?id=149339&action=edit
A sample that shows ### in A2 when default-sized with no added width

If I try to set Optimal Column Width in Calc, and set Add to 0 in the dialog,
some columns may become too narrow (that is, displaying ### in some cells).

1. Create a new spreadsheet (without any templates, as using
File->New->Spreadsheet just after a profile reset). The default cell font is
Liberation Sans 10.
2. Put 1, 2, 3, 4 to A1, B1, C1, D1.
3. Select columns A:D, and Format->Columns->Optimal Width...
4. Put 0 to Add:, and confirm.
=> see that the 4 columns are narrow (0.30 mm), and all 4 numbers displayed OK.
5. Put 11, 12, 13, 14 to A2, B2, C2, D2.
6. Repeat steps 3-4.
=> See that now columns are wider: A is 0.46 mm, others are 0.49 mm; and A2
shows ### instead of 11.

Tested with Version: 6.3.0.0.alpha0+ (x64)
Build ID: 177747c44557489760cc00473daecacd99995427
CPU threads: 12; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

and with Version: 6.2.1.1 (x64)
Build ID: 757c58e8cb70b2982843211a54750fb3cd79acd5
CPU threads: 12; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

Attached is a spreadsheet created as indicated (but the Optimal Width isn't
applied yet), to allow testing this, without possible problems with default
templates or different defaults on different versions/OSes/locales.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190217/3ac03ae0/attachment.html>