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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from Fabrizio <fabrizio at bzimage.it> ---
(In reply to Kevin Suo from comment #5)
> 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.

Ok, right. I confirm is as you sayd. But I think you also agree that the user
have no evidence of this difference. It seems bad to change 1.1 to 1.2 and then
change it again to 1.1 to have the right value. Something still dont work I
think. How is clear that one is text and others are numbers? It is not.
Moreover how they can be "text" if are a result of forumula corretly computed
(=47471*1.1 = 52218.1 )

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

>From google doc. I loaded attachment 140250 now the original doc that generates
it  from google doc "File->Download as->Opendocument". I can also share with
you  if you want the doc Google, but privately, write me to fabrizio at bzimage
dot it you need google account.

> 
> 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.

yes Bug 115642 seems to me to be the same.

-- 
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/d4692e4b/attachment-0001.html>