https://bugs.documentfoundation.org/show_bug.cgi?id=155622
--- Comment #5 from Mike Kaganski <[email protected]> --- The file has *text* in B1, so no bug here: SUM ignores all non-numerical cells. Use View->Value Highlighting to see. However, some issues here. 1. Comment 0 tells: > Give the following numbers in separate lines: > > 7,5 > ... This could result in the seen problem, *if* the first cell (whole row?) was pre-formatted as *text*, in which case, it is perfectly correct that anything you type there later would be treated as text, and not converted to numbers. But the file has B1 (and A1, C1) formatted as Standard. The question is: was the file re-formatted after the entry (and in that case, it is OK that the already present text was kept as text), or was there some *unknown* condition (a real problem?) that the entered data wasn't converted to number? 2. Why doesn't it show an apostrophe ahead of the text in this case, when it's obviously possible to treat it as a number, so the apostrophe is needed? (At least no leading apostrophe here in 7.5.4.1.) -- You are receiving this mail because: You are the assignee for the bug.
