https://bugs.documentfoundation.org/show_bug.cgi?id=173473
Bug ID: 173473
Summary: Dates default to numeric values even when combined
with currency and can't be toggled
Product: LibreOffice
Version: 26.2.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Writer should not implicitly treat Date-formatted table cells as ordinary
numeric values in generic arithmetic formulas such as SUM. Although dates may
reasonably be stored internally as serial numbers, adding a date serial to
currency or other ordinary numeric values is rarely meaningful and can silently
produce plausible but incorrect results. Date cells should be excluded from
generic numeric aggregation by default, with an explicit option or conversion
available when a user actually wants the underlying serial value.
Opening a docx file in libreoffice writer tables use existing formulas
(probably from excel) and the column with the date is automatically calculated
with a sum function as a numeric value, there is no way to tell the table to
exclude dates from the calculation. My personal opinion is that performing
mathematical operations with a dates numeric value is largely restricted to
date and date operations and has almost zero use with other number types such
as currency. Therefore the default should be to exclude dates from such
calculations and have a method for toggling for the case where it might be
useful.
--
You are receiving this mail because:
You are the assignee for the bug.
