<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#c9">Comment # 9</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#c8">comment #8</a>) > Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=167077" name="attach_167077" title="How to manually change the format code">attachment 167077</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=167077&action=edit" title="How to manually change the format code">[details]</a> > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>