[Libreoffice-bugs] [Bug 117808] cells display numbers as "0%" percent value although the correct percent value is shown in the cell editor

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun May 27 10:40:01 UTC 2018


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

--- Comment #5 from MM <plokklop at vivaldi.net> ---
(In reply to m.a.riosv from comment #3)
> The format code is '0.%', so the dot is dividing the value with 1000 what
> implies low values are showed as '0%'.
> 
> Thousands Separator
> Depending on your language setting, you can use a comma, a period or a blank
> as a thousands separator. You can also use the separator to reduce the size

It's set as 'default - english usa'.
The format code which the cells have in this example file is set as '0,%', but
the other format codes uses the period instead of the comma. '0.0%' and
'0.00%'. These work.
Strangly if you set 100000% (with '0,%'), in the cell it's shown as 100 instead
of 100,000.

-- 
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/20180527/87ebfee5/attachment.html>


More information about the Libreoffice-bugs mailing list