[Libreoffice-bugs] [Bug 106749] average and sum defaults in status bar return a wrong number when the range include a date

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=106749

--- Comment #5 from pajaro at gmail.com ---

>> Well, the bug is not about the sum not doing what its supposed to do, but
>> about the status bar not showing a useful default value...

>Dates are internally time since epoch, so sum of dates does not make sense 

As I said, I know the sum of the internal representation of 2 dates is useless.
It should be removed, instead of showing something useless :)

But we could actually show something useful there, like the difference of min
and max dates... which is useful

- ex.1:
2017-04-10
2017-04-02
2017-04-01

Shows 10 days

- ex.2:
10:30
11:41

Shows 1h10'

And theres probably a few other useful calculations you can do with dates

If you want to discard it because is too difficult to implement with the
current way cells works, okay, but at least acknowledge you are understanding
what I mean with all this, because every reply makes me feel Im not making my
point across :)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170417/1e9452a5/attachment.html>