[Libreoffice-bugs] [Bug 123739] Regression - scientific notation now where numbers were shown before - cell padding now requires 1 digit of free space before and after a number, or the cell goes in scientific notation

[bugzilla-daemon at bugs.documentfoundation.org]

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

V Stuart Foote <vstuart.foote at utsa.edu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEEDINFO
                 CC|                            |vstuart.foote at utsa.edu

--- Comment #3 from V Stuart Foote <vstuart.foote at utsa.edu> ---
We're guessing here as we would need your document (anonymize by changing
values to "8" s). But IIUC the autoformatting to Scientific notation for
"General" numbers has not changed.

Font's change from system to build to system build--Arial on OSX is not Arial
on Windows. Also LibreOffices font handling has been changed several times in
the interim. There also have been changes to calc for calculating cell height
and cell width, as well as adjustments to how "Use printer metrics for text
formatting" behaves.

So it would be abnormal to not have some layout changes in the ensuing builds
and versions of your document.

So please do this. Make a copy of the document. Then open the copy and select
the active cells on the sheet, set your font size back to 6pt--and in the
Column label area select one of the grid lines. Open context menu and apply
"Optimal Width".

Are the resulting cell widths more acceptable--and does it fit as you'd prefer?
Also, does selecting another font format things better than Arial? Perhaps a
Monospaced font like Consolas, Liberation Mono, or DejaVu Sans Mono?

-- 
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/20190227/67b4f087/attachment.html>