https://bugs.freedesktop.org/show_bug.cgi?id=50582
Jean-Baptiste Faure <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution| |NOTABUG CC| |[email protected] --- Comment #1 from Jean-Baptiste Faure <[email protected]> 2012-06-03 04:09:12 PDT --- Working as expected because B1:C20 are not numbers but text: select all > right clic > remove direct formating => each "number" is aligned to the left of the cell and has a quote before the first digit. True numbers are aligned to the right. SUM() function works only with numbers but not + operator. So you have a mean to detect wrong formatted numbers ;-) Best regards. JBF -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
