Documentserver: WORKDAY function broken with day-offset greater then 1

Created on 18 May 2018  路  6Comments  路  Source: ONLYOFFICE/DocumentServer

Do you want to request a feature or report a bug?
Bug

What is the current behavior?
When you use the WORKDAY function (Ex. WORKDAY(B3,5,Holidays) with day-offset value greater then 1
function return holiday day and skip day after holiday day.
image

If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem.
WORKDAY_BUG.xlsx

What is the expected behavior?
WORKDAY function should not return holiday day and should return workday after holiday

Did this work in previous versions of DocumentServer?
No

DocumentServer version:
5.1.3

Operating System:
Windows 10 x64 1803

Browser version:
Firefox 61.0b4

Related issues

184 and #194

bug fixed

All 6 comments

Sample correct implementation: http://jsfiddle.net/mposr3mp/

Hello, @jkolo.
Thank you. I can confirm - this is a bug, issue 37779 in our internal issue tracker.

Any progress?

@jkolo hi, currently no, but I remind dev team to have a look, try to include your fix in 5.2.0

@jkolo your changes are in https://github.com/ONLYOFFICE/sdkjs/commit/b035af02ab9ab6ed0ec05ed331782ca0ff7f2113
This will be released as 5.2, thank you

DocumentServer 5.2.0 released
Issue should be fixed

Was this page helpful?
0 / 5 - 0 ratings