<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Formating percentages varies when leading zero is applied to single integer value" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138046#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Formating percentages varies when leading zero is applied to single integer value" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138046">bug 138046</a> from <a class="email" href="mailto:that.man.colin@gmail.com" title="Colin <that.man.colin@gmail.com>"> Colin</a> <pre>(In reply to Ming Hua from <a href="show_bug.cgi?id=138046#c1">comment #1</a>) > The display of pencentage format (as well as many other formats, most > apparent for time and date) depends on locale. What is the "Language" > setting in your cell format dialog when you change the pencentage format and > leading zeroes? If you didn't change it yourself, I believe the default > language is decided by locale (so sv-SE?). > > In any case, I can't reproduce the space between numbers and the percent > sign %, under either English (en-US) or simplified Chinese (zh-CN) UI (both > are set to zh-CN locale per OS, I believe): > Version: 6.4.7.2 (x64) > Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 > CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; > Locale: zh-CN (zh_CN); UI-Language: en-US > Calc: threaded > > I can, however, see the space between numbers and % (i.e. "17.55 %") if I > set the "Language" setting in cell format to "French (France)". > > So please provide an example document showing the inconsistency (use the > "Add an attachment" link on this page, above the comment text box), and we > can see if it's indeed a bug in LibreOffice or just some locale/language > setting difference on your side. I was really identifying the inconsistency of the "additional" space depending upon whether the integer value has one or more digits. Also, as mentioned, reformatting the cell to only one leading zero (integer digit) doesn't revert the format so the user is now left with an unchangeable undesired format with the % indicator no longer aligned in a tabular fashion - but at least the decimal is aligned if a mono spaced font is utilised ;).</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>