[Libreoffice-bugs] [Bug 143102] Error calculating sum function

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Uwe Auer <uwe at franke-auer.de> ---
(In reply to bruno.dessale from comment #3)
> Yes but when I look at the format of the cells F51 and F52 (right click
> "format cells") I have a number and not a text !
> 
> Thanks

Formatting a cell *after* there is already data within the cell, never changes
the data type. Formatting about representation of data within the same type.
You cannot convert data by changing format.

In other words: Looking at the format of a cell is no means to determine the
data type of a cell's content (That's why the procedure mentions `View -> Value
Highlighting` which is a means to get the data type.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210628/8884d29a/attachment.htm>