Hi, I am using aspose.cells in order to calculate some workbooks and noticed that the WORKDAY excel formula returns the incorrect result if the cell referenced for the startdate param is an empty cell or zero, when calculating using aspose the formula is calculated as 1 while when calculating in excel the formulas is calculated as 2. i’ve provided a sample file that shows 3 ways to calculate WORKDAY and when calculated using aspose only 1 of the formulas is set to 2 while the others are 1.WORKDAY Issue.zip (6.6 KB)
@ecarrillo
By using sample files for testing, we can reproduce the issue. Found WorkDAY function gets error value when using empty cell or 0.
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNET-54294
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
The issues you have found earlier (filed as CELLSNET-54294) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi