https://bugs.freedesktop.org/show_bug.cgi?id=81935
--- Comment #3 from Worik <[email protected]> --- On 31/07/14 15:51, [email protected] wrote: > https://bugs.freedesktop.org/show_bug.cgi?id=81935 > > Jay Philips <[email protected]> changed: > > What |Removed |Added > ---------------------------------------------------------------------------- > Status|UNCONFIRMED |NEEDINFO > CC| |[email protected] > Ever confirmed|0 |1 > > --- Comment #2 from Jay Philips <[email protected]> --- > Hello Worik, > > Thank you for filing the bug. Using the attached CSV, i used SUM() and it did > calculate it fine for me on 4.2.5 on Linux Mint. With the ODS, the column A > has > numbers in the cells but the format of the cells are 'text' and as such, SUM() > doesnt work on those cells. I opened the same ODS in excel 2010 and it also > showed '0'. How would you like to proceed with this bug report. The bug is a difference between addition (=C1+C2+C3) Vs. SUM (=SUM(C1:C3). This is a bug, SUM is the same as repeated addition, unless I am missing something obvious! cheers Worik > -- 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
