Calc WORKDAY performance with Holidays [closed]

asked 2014-01-14 02:57:48 +0200

Casey gravatar image

updated 2014-01-14 02:58:08 +0200

On my system, using a workday function with holidays is extremely slow. Is this a perforamnce bug or is there some way to improve the calculation speed of this function.

In my situation, I have about 15 dates, and it takes over 30 seconds to recaluclate any change.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-18 14:13:52.106290


Which LibO version and OS are you using?

ROSt52 gravatar imageROSt52 ( 2014-01-14 15:17:59 +0200 )edit

I did a quick test. Cell A1 has a date, A2 adds on 10 days with WORKDAY. Copied A2 down to A1000, then did some figiting to have b1000 add 10 days onto A1000, A999 added 10 days on to A1000, then copied A999 up to B1. Changed the date in A1, and LO takes about 4 seconds to update all 1999 cells. Added some holidays into the mix, and was still ~4 seconds to update the cells.

Rugslug gravatar imageRugslug ( 2014-01-15 04:38:12 +0200 )edit