https://bugs.freedesktop.org/show_bug.cgi?id=47771
Kim Woodle <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution| |NOTABUG --- Comment #2 from Kim Woodle <[email protected]> 2012-03-26 08:59:04 PDT --- (In reply to comment #1) > Did you use a number format or did you type in $200.00 in the cell? > > You can only use numbers in cells, so if you need a currency please write 200 > into the cell and use the correct number format. This bug can be removed. For the spreadsheet in question, I had cut and pasted data from a Web page. Upon more careful examination, I found that the contents of each cell contained a trailing space. The SUM worked after the trailing spaces were removed. Thanks for your quick Response -- 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
