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

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

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


Subject: OFFICE-3920 VDB startPerio and endPeriod


Hi members,

I have looked at issue 3920 for fractional startPeriod and endPeriod. I get the problem, that Gnumeric, Excel and GoogleDocs[1] calculate different from LibreOffice for the case of fractional and switch at same time. So we need to define first the algorithm before we can improve the wording.

Andreas, Alfred: Can you please explain, how the result on the sheet "with_switch" is calculated?
Written without references it is about the formula
=VDB(20000;500;5;1.75;3.5;2;FALSE()).
LibreOffice calculates result 5035, which is identic to my manually calculation on the same sheet. Others calculate result 4873.33

The results for fractional without switch (last parameter TRUE()) and for integer with switch are identical in all tested applications.

[1] https://docs.google.com/spreadsheets/d/1jNbUijAZbPyFbPOEKtNffQAJ5M8hkyrdqRPbU8mslUY/edit?usp=sharing

Kind regards
Regina

Attachment: Fractions.ods
Description: application/vnd.oasis.opendocument.spreadsheet



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