[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 #12 from osnola <alonso at loria.fr> ---
(In reply to Dennis Roczek from comment #11)

> 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!)

Not really, ie. I think that you will never find =STRIPDURATION("1w") in a user
file as this function is mainly there to be used with a cell reference.

So even if it is possible in the filter to replace STRIPDURATION("1w") by 7, it
means to make the filter very heavy (to handle cases that will almost never
appear) and I don't think it is really worth it.

-- 
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/f261f699/attachment-0001.htm>