https://bugs.documentfoundation.org/show_bug.cgi?id=115431
m.a.riosv <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |regression
Status|UNCONFIRMED |NEW
CC| |[email protected]
| |rg
Version|6.0.0.0.alpha0+ |4.0.6.2 release
Ever confirmed|0 |1
--- Comment #3 from m.a.riosv <[email protected]> ---
At opening the file F11 seems has text, that's why it's not summed, SUM()
doesn't sum text cells, numbers as text are only treated as numbers with a
direct reference to the cell not with a range reference.
After a hard recalc [Shif+Ctrl+F9] works fine, and F11 became a number.
With the option Menu/Tools/Options/LibreOffice calc/Formula/Recalculation on
file load, as 'Excel 2077 and newer' - 'Always recalculate', opens with right
format and sum value.
It doesn't happen with:
Version 3.6.7.2 (Build ID: e183d5b)
Happens with:
Version 4.0.6.2 (Build ID: 2e2573268451a50806fcd60ae2d9fe01dd0ce24)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
