[Libreoffice-bugs] [Bug 105394] Strange error in mean calculation

[bugzilla-daemon]

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

--- Comment #9 from Bruno Pagani  ---
Well, I don’t agree, because if I hadn’t noticed the wrong result in my
original file (thanks to having calculated it before hand), it would have been
accepted as is and that would have had real consequences.

I think a warning should be issued if one of the cells included in the
computation has a value of any kind in it that is not taken into account in the
result.

I’ll let the decision to reopen to you, but without this being fixed it
basically means I should never trust a calc file.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105394] Strange error in mean calculation

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||todven...@suomi24.fi
 Resolution|--- |NOTABUG

--- Comment #8 from Buovjaga  ---
Ok, I guess this can be closed.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105394] Strange error in mean calculation

[bugzilla-daemon]

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

--- Comment #7 from Bruno Pagani  ---
OK, so switching to french format added a ' at cell value beginning, removing
it made it work.

So, is this considered to be an issue with the person who created the document,
with Google or whatever?

Also, maybe the warning I mentioned should then be when they are cells in same
area with different number format.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105394] Strange error in mean calculation

[bugzilla-daemon]

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

--- Comment #6 from gilward.ku...@gmail.com ---
You have to input the value again.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105394] Strange error in mean calculation

[bugzilla-daemon]

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

--- Comment #4 from gilward.ku...@gmail.com ---
The reason is that A2 has the number format language English (USA).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105394] Strange error in mean calculation

[bugzilla-daemon]

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

--- Comment #5 from Bruno Pagani  ---
I tried switching it to French format, with no result.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105394] Strange error in mean calculation

[bugzilla-daemon]

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

--- Comment #3 from Bruno Pagani  ---
Plus I don’t know what it would do if someone else opens it with either Calc —
but you’re going to tell me that — or any other spreadsheets software… Will it
work with the dot or the comma? Both? Neither?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105394] Strange error in mean calculation

[bugzilla-daemon]

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

--- Comment #2 from Bruno Pagani  ---
Small update: changing the comma to a dot in cell A2 fix this. Don’t know why
this cell behave this way, neither why 9.25 and 9,25 aren’t treated both as
numbers.

Still an issue however, because it’s abnormal such things can happen without
being noticed. Maybe there should be at least a warning if a cell in some area
doesn’t have the same numerical format as its surroundings or something like
that.

Thanks for considering this. ;)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105394] Strange error in mean calculation

[bugzilla-daemon]

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

Bruno Pagani  changed:

   What|Removed |Added

 CC||bruno.n.pag...@gmail.com

--- Comment #1 from Bruno Pagani  ---
Created attachment 130501
  --> https://bugs.documentfoundation.org/attachment.cgi?id=130501=edit
Minimal non-working example

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs