https://bugs.freedesktop.org/show_bug.cgi?id=66985
Parameshwara Bhat <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|CLOSED |REOPENED Resolution|NOTABUG |--- --- Comment #18 from Parameshwara Bhat <[email protected]> --- Please see the attachments. In MSO, addition on cells could be performed . Perhaps you are using the sun(cellx:celly) function which as you correctly said, does not work. But I did a simple cellx + celly addition which worked. In MSOffice, the warning menu offers to convert the number formatted as text to number. And that works very well. That is exactly What LO needs to have. If LO can easily convert from text-formatted number to number, what else it does or it does not do will not be very important. In Calligra sheets, version 2.5.4, sum(cellx:celly) does not work as you pointed out. But simple addition can be performed on the cells. Also,when multiple cells are highlighted, on the bottom-LH, the sum of the cell contents is correctly shown. Internally this display may be tied to simple addition, rather than to sum(x:y) function. Why, can't we have LO smarter than Calligra and MSO ? PS : the status of bug seems to have been messed up by me.I have re-opened. -- 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
