https://bugs.freedesktop.org/show_bug.cgi?id=65182
--- Comment #5 from ign_christian <[email protected]> --- > Following some documentation I found, a single-quote in front of a cell > value is a 'force-text' mark. These cells are handled as text. So the SUM() > function just skip those cells, and doesn't count them. Remove the > single-quotes, result in good behavior. I agree, single-quote followed by value should be treated as text. But cell B1,B2,B5,etc treat cell A1,A2,A5 as value. Doing short testing, found that behavior not only applies to multiplication but also applies to addition, subtraction, division. SUM function goes correctly by ignoring cell with single-quote. I think it's a bug. Tested on LO 4.0.4.1 (Win7 32bit) -- 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
