https://bugs.freedesktop.org/show_bug.cgi?id=81935
--- Comment #3 from Worik <worik.stan...@gmail.com> --- On 31/07/14 15:51, bugzilla-dae...@freedesktop.org wrote: > https://bugs.freedesktop.org/show_bug.cgi?id=81935 > > Jay Philips <philip...@hotmail.com> changed: > > What |Removed |Added > ---------------------------------------------------------------------------- > Status|UNCONFIRMED |NEEDINFO > CC| |philip...@hotmail.com > Ever confirmed|0 |1 > > --- Comment #2 from Jay Philips <philip...@hotmail.com> --- > 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs