https://bugs.documentfoundation.org/show_bug.cgi?id=150782
Bug ID: 150782
Summary: [FILEOPEN] NUMBERS filter misinterpreting DURATION
function
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: d...@sheetjs.com
Description:
The `DURATION` function in Numbers takes 6 arguments and returns a time
duration.
https://support.apple.com/guide/functions/duration-ffa561e8c4/12.1/web/1.0
documentation
The Excel/LibreOffice `DURATION` function is the Macaulay duration. The
Numbers equivalent is `BONDDURATION`
(https://support.apple.com/guide/functions/bondduration-ffa5742353/12.1/web/1.0)
and Numbers automatically translates between Excel's DURATION and the native
BONDDURATION when reading and writing to Excel formats.
LibreOffice is currently retaining the original names. `BONDDURATION` in the
Numbers read codec should be translated to `DURATION` while `DURATION` should
be mapped to something else.
Steps to Reproduce:
Download and open
https://github.com/SheetJS/test_files/blob/master/duration_112/duration_112.numbers
(uses Numbers DURATION) or attachment (uses Numbers BONDDURATION)
Actual Results:
duration_112: A series of Err:502 in the "Value" column and each function is
translated to `DURATION` (preserving Numbers function name)
bondduration: The cell formula uses `bondduration`
Expected Results:
duration_112: DURATION should use something different
bondduration: BONDDURATION should be translated to DURATION
Reproducible: Always
User Profile Reset: Yes
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug.
