https://bugs.documentfoundation.org/show_bug.cgi?id=97334
--- Comment #11 from Dennis Roczek <[email protected]> --- (In reply to osnola from comment #10) > (In reply to Dennis Roczek from comment #6) > > well I thought the same original. There are two parts: > > > > * (maybe) libetonyek import filter modifications (at least for > > stripduration) > > Hi, I'm not sure what you mean here. For example, if in a Numbers' file, we > find the following formula: > =stripduration(C2) > what do you propose that the libetonyek import filter does? from my (unfinished work) in the wiki: https://wiki.documentfoundation.org/Functions_comparison_of_LibreOffice_Calc_and_Numbers#cite_ref-STRIPDURATION_20-0 STRIPDURATION is included for compatibility reasons with "other spreadsheet software". If AppleWorks, Excel, or Number '08 files are imported to Numbers '09, Apple includes this command where it is needed and removes it when exporting to Excel. So basically Numbers is working a bit differently and in their own xls(x) export they do modify that part and strip that command. >From Apple's online help: https://help.apple.com/functions/mac/7.0/?lang=en#/ffa5620514 This function may be automatically inserted when a Numbers ’08 document is upgraded, or an Excel or AppleWorks document is imported. It is removed in any copy of the file saved as a Numbers ’08 or Excel document. Examples =STRIPDURATION(“1w”) returns 7, the equivalent of one week in days. =STRIPDURATION(12) returns 12, because 12 is not a duration value. =STRIPDURATION(“abc”) returns “abc”, because “abc” is not a duration value. Does that help? (Man, I'm so lucky that I made that wiki page so well documented!) -- You are receiving this mail because: You are the assignee for the bug.
