[Libreoffice-bugs] [Bug 116104] trivial sum() bad value

[bugzilla-daemon at bugs.documentfoundation.org]

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

Kevin Suo <suokunlong at 126.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |suokunlong at 126.com

--- Comment #5 from Kevin Suo <suokunlong at 126.com> ---
When you set the cell alignment to default, you will see that some cells in
column B are aligning left, which means that the values in these cells are
actually text, not numbers.

If you change the formula contents of the cells, for example, change cell B4
from "=47471*1.1" to "=47471*1.2" and hit enter, it becomes numbers and
automatically align right.

So, the point is, how do you generated this document, and how these cells
become text values, rather than number values?

There was a similar bug report recently and was marked as WORKSFORME as it was
found that the cell values are text with a "'" before numbers. Will try to fint
that one.

-- 
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/20180301/435d659f/attachment.html>