Calc function names saved to file and backward compatibility

Eike Rathke erack at redhat.com
Wed Feb 18 06:31:28 PST 2015


Hi Winfried,

On Wednesday, 2015-02-18 13:08:30 +0100, Winfried Donkers wrote:

> Ok, I suggest the following:
> 
> Calc UI  ODF-old names to be kept  ODF-new names  Excel
> F.DIST   COM.MICROSOFT.F.DIST      FDIST          _xlfn.F.DIST
> FDIST    COM.MICROSOFT.F.DIST.RT   LEGACY.FDIST   _xlfn.F.DIST.RT and FDIST (import only)

Looks good to me. However, we should keep the F.DIST.RT also in the UI
for the case of loading it from OOXML, to prevent user worries or for
users being used to it and resave it to OOXML as it was, and only map it
to LEGACY.FDIST when writing to ODF, so that it will be UI FDIST when
loaded from ODF.

> Excel's FDIST is now obsolete, but still supported by Excel (how long?).

My guess is forever..

> I think the change could be done in one go for UI FDIST and F.DIST.RT, as new files can be read by older versions.
> Only for UI F.DIST a 2 step change will be needed.

I don't think we should change UI names in this case. FDIST is what
users are used to since ages, suddenly naming something else FDIST is
just confusing. Maybe add a hint in scfuncs.src, ala "this is
OpenFormula FDIST" and "this is OpenFormula LEGACY.FDIST".

  Eike

-- 
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GPG key "ID" 0x65632D3A - 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Better use 64-bit 0x6A6CD5B765632D3A here is why: https://evil32.com/
Care about Free Software, support the FSFE https://fsfe.org/support/?erack
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 819 bytes
Desc: not available
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20150218/47b88719/attachment.sig>


More information about the LibreOffice mailing list