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.
Which LibO version and OS are you using?
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.