https://bugs.documentfoundation.org/show_bug.cgi?id=106749
Bug ID: 106749
Summary: average and sum defaults in status bar return a wrong
number when the range include a date
Product: LibreOffice
Version: 5.2.5.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
the status bar provides default calculations when selecting a range.
Instead of manually selecting a range, its not weird to select an entire row or
column clicking on the top or left headers and that selects everything. Text is
ignored for this purpose, and dates should be ignored or properly dealt with
too
Steps to Reproduce:
1. add a date cell and number cell or 2 date cells
2. select date field and the other cell
Actual Results:
weird average and sum numbers
Expected Results:
to ignore date fields, or to use a different default when dates are involved,
like days betweed 2 dates, or whatever other useful result you can make up of 2
dates, just like average and sum are good defaults for numbers
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
Firefox/52.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
