[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 #9 from Colin <that.man.colin at gmail.com> ---
(In reply to Ming Hua from comment #8)
> Created attachment 167077 [details]
> How to manually change the format code
> 
> Here is a screenshot using your example file to show how to achieve the
> aligned appeareance you want for two leading-zeros.
> 
> Note that for English and other locales that don't use a space between the
> digits and percent sign, no manual editing is needed.  The UI generates the
> correct format code by default.

Firstly, many thanks for your input.

During the course of our discussion I had figured out how to edit the format in
the way you had demonstrated. As you mentioned, Date formats are also readily
editable and I have achieved passable competency in that area which helped.

I think, to summarise, the only idiosyncracy still remaining is that if a
default percentage cell with only one integer digit and a space is amended to
produce 2 leading zeros and then re-amended back to the original 1 leading zero
then the format without a space which is introduced by setting leading zeros to
2 doesn't revert to a format with a space when it is re-edited to 1 leading
Zero.

I still perceive it as trivial and leave it in your hands to decide whether the
report should be classified as not worth fixing, not a bug, or processed as a
very low priority minor cosmetic change.

Going outside the box, perhaps, if the UK distribution didn't have different
space defaults for single and double integer digits on percentages then one
very esoteric sheet wouldn't produce a noticeable anomaly when "flipping" the
format.

How are the formats originally placed in the distribution? I can identify that
they "grow" as a user modifies them but have no idea where/how the underlying
defaults originate.

-- 
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/9a38b489/attachment.htm>