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

--- Comment #4 from Jerry Sussman <jsussma...@outlook.com> ---
Greetings, and thank you for the prompt reply.  Perhaps we are having a
communication issue? 

I did not say nor mean to suggest that the Format feature did not produce
"Leading zeros." Rather, what I said and meant to suggest that the feature did
not produce the number of "Leading zeros" selected, but instead produced
leading zeros only if the number of leading zeros selected was greater than the
number of digits to the left of the decimal point in the number within the cell
being formatted.

Previously, if I selected "Number of Leading Zeros" as 1, 2, 3, etc., "Leading
Zeros" (1, 2, 3, etc.) would be placed to the leftmost position of the last
significant digit to the left of the decimal point regardless of the number of
digits in the number within the cell being formatted.  Thus, if the number of
leading zeros selected was "2," 2 zeros would precede each number, whether the
number was "01," 02," "001," "1," "2," "10," "1000," or whatever.  The number
01 would appear as 001, the number 10 would appear as 0010, the number 0001
would appear as 001, the number 000000007 would appear as 007. 

Now, if the number of "Leading zeros" selected is 1, 2, 3, etc., one or more
leading zeros (1, 2, 3, etc..) will only appear if the number of digits to the
left of the decimal point in the number in the cell to be formatted is less
than the number of leading zeros selected. Here are literal examples just taken
in the case of the formatting of numbers to contain "2 Leading zeros."

    Example A: 1 will appear as 01

    Example B: 10 will appear as 10

    Example C: 100 will appear as 100

    Example D: 1000 will appear as 1000

    Example D: 01 will appear as 1

    Example E: 001 will appear as 1

    Example F: 0001 will appear as 1.

How in the world is this not a bug? 

Respectfully, I prefer not to attach another spreadsheet. Moreover, in the
absence of my ability to delete the attachment to my initial report, for the
reasons that follow, I respectfully request that you do so.

The software used to take the screenshot of the LibreOffice Help-About (XFCE-4
Screenshooter) itself contains a bug: I clearly and unequivocally took a
screenshot only of the portion of my display that contained the "LibreOffice
Help-About" with its opaque background. I attached same with the expectation
that the image taken and saved was the image that I took. Instead, The MX-21
XFCE-4 Screenshooter "X-rayed" the LibreOffice Help-About opaque background and
captured a portion of the open spreadsheet that I then was working on. Though I
would have preferred that no spreadsheet information had been captured, I am
grateful that no account numbers or passwords were uploaded. Still, I do not
think that the attachment should be visible to all as it contains information
that was not in the screenshot as taken.

Thanks again...Jerry Sussman

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to