Summary: | [FILEOPEN] NUMBERS filter misinterpreting DURATION function | ||
---|---|---|---|
Product: | Document Liberation Project | Reporter: | SheetJS <dev> |
Component: | libetonyek | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | 79045_79045, miguelangelrv |
Priority: | medium | ||
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108827 | ||
Attachments: | Numbers BONDDURATION example |
Description
SheetJS
2022-09-04 21:47:21 UTC
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. |