[Libreoffice-bugs] [Bug 138046] Formating percentages varies when leading zero is applied to single integer value

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #7 from Ming Hua <ming.v.hua at qq.com> ---
(In reply to Colin from comment #5)
> It doesn't permit a fallback to a layout without "zero padding" whilst
> retaining the original, additional space - in fact I can only re-introduce a
> space between the value and the symbol if I overwrite the cell and start all
> over again.
There is no need to start all over again.  The "Format code" part in the Format
dialog is editable, just add the space back, i.e. 0.00" "% (maybe it's a
non-break space, I'm not sure" when you reformat it to one leading zero.

The issue, as far as I can see, is that Calc is being inconsistent when the
user is using the simple UI options to format the pencentage cells, for
_certain locales_.

(In reply to Colin from comment #6)
> If loCALC had the ability to right format with indent in the same manner as
> EXCEL or a decimal tab alignment format then it would never even have been
> noticed.
I have little experience in MS Excel, but from your description, I don't see
anything not doable in Calc with hand-crafted format codes.  Maybe Excel
provide better pre-defined formats, especially for non-English locales?  That's
definitely an area LibreOffice can improve in, and enchancement requests are
welcome.

> As a member of the development squad, are you aware of any intention to
> facilitate right aligned indents or decimal alignment of CALC cells?
> Would submitting enhancement requests be a more worthy endeavour?
I am merely an (somewhat) advanced user doing QA work on Bugzilla, and not a
developer.  Nor do I have any insights about the intentions of developers
working on this area, sorry.  However, like I said above, well-described
enhancement request, especially with comparison to what MS Excel provides,
should always be welcome.

-- 
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/20201107/51ce07a0/attachment.htm>