[Libreoffice-bugs] [Bug 148434] LibreOffice Calc Formatting Option for Leading Zeros in Numbers Does Not Format Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=148434 Commit Notification changed: What|Removed |Added Whiteboard||target:7.6.0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148434] LibreOffice Calc Formatting Option for Leading Zeros in Numbers Does Not Format Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=148434 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148434] LibreOffice Calc Formatting Option for Leading Zeros in Numbers Does Not Format Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=148434 Eike Rathke changed: What|Removed |Added Resolution|--- |INVALID Status|UNCONFIRMED |RESOLVED --- Comment #7 from Eike Rathke --- (In reply to Jerry Sussman from comment #3) > 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. No, that never was the case. > 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 7 would appear > as 007. It didn't. This is a misunderstanding of how number formatting works. A format of 00 (two "leading" zeros) tells to fill the display of numbers with 0 to the left for *up to* 2 digits. Hence a one digit number 0 to 9 displays as 00 to 09 and any number with two or more digits gets *no* 0 prefix. The 00 are *placeholders*. See also https://help.libreoffice.org/7.3/en-GB/text/shared/01/05020301.html?DbPAR=SHARED#bm_id3153514 Placeholders Explanation, 0 (Zero): "Displays extra zeros if the number has less places than zeros in the format." -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148434] LibreOffice Calc Formatting Option for Leading Zeros in Numbers Does Not Format Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=148434 Laurent BP changed: What|Removed |Added CC||jumbo4...@yahoo.fr --- Comment #6 from Laurent BP --- Hi Jerry, Could you please attach a sample file? Leading zeros work as I expect on my configuration. Your procedure is not clear how you apply "leading zeros" format. With a sample file it could be clearer. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148434] LibreOffice Calc Formatting Option for Leading Zeros in Numbers Does Not Format Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=148434 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148434] LibreOffice Calc Formatting Option for Leading Zeros in Numbers Does Not Format Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=148434 --- Comment #5 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148434] LibreOffice Calc Formatting Option for Leading Zeros in Numbers Does Not Format Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=148434 --- Comment #4 from Jerry Sussman --- 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 7 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.
[Libreoffice-bugs] [Bug 148434] LibreOffice Calc Formatting Option for Leading Zeros in Numbers Does Not Format Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=148434 --- Comment #3 from Jerry Sussman --- 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 7 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.
[Libreoffice-bugs] [Bug 148434] LibreOffice Calc Formatting Option for Leading Zeros in Numbers Does Not Format Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=148434 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||107575 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=107575 [Bug 107575] [META] Number format bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148434] LibreOffice Calc Formatting Option for Leading Zeros in Numbers Does Not Format Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=148434 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #2 from m.a.riosv --- Please attach a sample file. There are no numbers with leading zeroes not coming from the format. If you see that, then maybe they are numbers in a text format cell, or numbers with a leading single quote like '0123 treated as text not numbers. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 148434] LibreOffice Calc Formatting Option for Leading Zeros in Numbers Does Not Format Correctly
https://bugs.documentfoundation.org/show_bug.cgi?id=148434 --- Comment #1 from Jerry Sussman --- Created attachment 179365 --> https://bugs.documentfoundation.org/attachment.cgi?id=179365=edit Screenshot Help - LibreOffice Calc -- You are receiving this mail because: You are the assignee for the bug.