Problems with NETWORKDAYS function in XLS output

Aspose.Cells Product Family
1

Using .Cells 7.1.0, I have an application that generates a spreadsheet that uses the NETWORKDAYS function. If I save to XLSX, everything's fine, but if I save to XLS I get #VALUE! in the cells that reference that function. If I select one of these cells and type F2/Enter, the error is corrected, so it appears the text of the formula itself is fine.

I have attached both an XLS and XLSX, indentically generated except for the save format.

Thanks,

--Howard

2

Hi,


Yes, I think you are right, I have tested your issue by loading opening your provided xlsx and xls file using Aspose.Cells for .NET API (e.g.call CalculateFormula() method or the Workbook and re-save the file(s)). I can see the issue.

I have logged a ticket with an id: CELLSNET-40346. We will look into it soon.

Thank you.
3

Hi,

Please download and try this fix: Aspose.Cells for .NET v7.1.0.5

4

That works, thanks!

--Howard

5

The issues you have found earlier (filed as CELLSNET-40346) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.