Public bug reported:
Binary package hint: gnumeric
The gnumeric status bar includes a total of all selected cells, in the
appropriate format (e.g. a selection of currency formatted cells will be
shown with a currency symbol).
Unfortunately, the standard spreadsheet convention of value is used,
which includes dates being counted as numbers of days since some epoch
or something. If you select two date cells, it shows you a meaningless
total of these numbers as a date (meaningless since it depends on the
value of the epoch). Worse, if you select e.g. several currency cells
which happen to have a date in the middle of them, the value of the
currency cells will be added to the date in some incredibly meaningless
way, and shown as a new date.
This should be fixed by treating date formatted cells as 0, in the same
way strings are, for the purposes of this sum.
** Affects: gnumeric (Ubuntu)
Importance: Untriaged
Status: Unconfirmed
--
Gnumeric status bar: sum of selected cells, with dates
https://launchpad.net/bugs/50662
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
