https://bugs.documentfoundation.org/show_bug.cgi?id=148434
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|UNCONFIRMED |RESOLVED --- Comment #7 from Eike Rathke <[email protected]> --- (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 000000007 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.
