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:
Created attachment 182216 [details] Numbers BONDDURATION example
I can't open the attached file with, it is unrecoverable for msexcel: Microsoft® Excel® para Microsoft 365 MSO (versión 2207 compilación 16.0.15427.20182) de 64 bits The behavior with LO 7.5 it's how described on the report.
Both files are NUMBERS spreadsheets which can be opened with the Apple Numbers or iCloud Numbers ( https://icloud.com/numbers/ ). The desktop app requires a Mac but iCloud Numbers is a web app.
bondduration.numbers: After opening, B2 holds a value 5.02085. After Data-Calculate-Recalculate in changes to #NAME? as the bondduration is an unknown function duration_112.numbers: Acts exactly as described in the original report.