[Libreoffice-bugs] [Bug 97334] [Numbers] Add iWorks' Numbers missing functions

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=97334

--- Comment #11 from Dennis Roczek <dennisroczek at libreoffice.org> ---
(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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210916/c63f3275/attachment.htm>