https://bugs.documentfoundation.org/show_bug.cgi?id=148126
--- Comment #18 from ady <[email protected]> --- There are several issues when importing from Numbers. Even the epoch date is not the same (but the import seems to be working correctly in that regard). Even if the display value were to be automatically presented in some similar way as in Numbers, I doubt it would automatically be "12w 0d 5h" (i.e. combining the letters). For that, a custom format would be needed, or, alternatively, manually using functions such as N() and TEXT(). The fact that the value presented in the formula bar input window is already presented as time value (i.e. without an integer part) is a positive aspect of the import, as it is already a duration value (rather than presenting it as 5 AM of the date 1900-03-24). -- You are receiving this mail because: You are the assignee for the bug.
