https://bugs.documentfoundation.org/show_bug.cgi?id=145183
--- Comment #4 from Michael Warner <[email protected]> --- In the example file I attached, column A is formatted to display 2 decimal places. If you enter in 0 (or any other whole number for that matter) it shows just the whole number in the formula bar (it shows just "0"), and the number with two decimal places in the sheet ("0.00"). If you enter in a number with an actual fractional component, it shows that in both places. For example, on row two I entered 0.01 and that displays both in the formula bar and the sheet. There, the formula in column D works as expected. So, it seems clear that for any whole number, it's not considered to have a decimal point, even though one is shown on the sheet. I can see why this would surprise a person, but I don't know if it should really be considered a bug. -- You are receiving this mail because: You are the assignee for the bug.
