<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><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#c7">Comment # 7</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 <span class="vcard"><a class="email" href="mailto:ming.v.hua@qq.com" title="Ming Hua <ming.v.hua@qq.com>"> <span class="fn">Ming Hua</span></a>
</span></b>
<pre>(In reply to Colin from <a href="show_bug.cgi?id=138046#c5">comment #5</a>)
<span class="quote">> 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.</span >
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 <a href="show_bug.cgi?id=138046#c6">comment #6</a>)
<span class="quote">> 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.</span >
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.
<span class="quote">> 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?</span >
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>