Bug 148126 - [FILEOPEN] NUMBERS missing Duration cells
Summary: [FILEOPEN] NUMBERS missing Duration cells
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Format-Filters
  Show dependency tree / graph
 
Reported: 2022-03-22 02:20 UTC by SheetJS
Modified: 2023-05-13 12:54 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description SheetJS 2022-03-22 02:20:37 UTC 
Description:
Cells with type "Duration" are not processed in LibreOffice

Steps to Reproduce:
Download and open https://github.com/SheetJS/test_files/raw/master/numbers/types_61.numbers

Actual Results:
B10 is blank

Expected Results:
B10 has a value (in Numbers 11.2 it is "12w 0d 5h")


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Test file generated in Numbers 6.1
Comment 1 m_a_riosv 2022-03-23 16:08:25 UTC 
Converting it with ZamZar to xls or xlsx the result in B11 is 84.2083 the date number, but without format.
Comment 2 SheetJS 2022-03-23 17:31:09 UTC 
LibreOffice has support for the "W" week number format, but Excel has no equivalent, so it's not entirely surprising that the format is missing.  The value 84.2083 looks like the duration in days (12w = 84d and 5/24 ~ 0.02833).