OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: LINEST and LOGEST should have ForceArray parameter types


Hi,

In OpenFormula 1.2 we missed to define LINEST and LOGEST to let their
first two parameters be of type ForceArray, so actually the definitions
should read:

LINEST( ForceArray knownY [ ; [ ForceArray knownX ] [ ; Logical Const = TRUE() [ ; Logical Stats = FALSE() ] ] ] )

LOGEST( ForceArray knownY [ ; [ ForceArray knownX ] [ ; Logical Const = TRUE() [ ; Logical Stats = FALSE() ] ] ] )


This is what Excel and LibreOffice do.

  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

Attachment: signature.asc
Description: PGP signature



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]