Aspose.com » Public Forums for Customers an... » Aspose.Cells Product Family » Problems with NETWORKDAYS function in XLS output

Problems with NETWORKDAYS function in XLS output

Last post 02-13-2012, 3:45 AM by aspose.notifier. 4 replies.
Sort Posts: Previous Next

  •  02-03-2012, 5:06 PM 359264

    Problems with NETWORKDAYS function in XLS output .NET

    Attachment: Present (inaccessible)

    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
     

  •  02-04-2012, 1:21 AM 359277 in reply to 359264

    Re: Problems with NETWORKDAYS function in XLS output

    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. 
    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     

  •  02-07-2012, 3:41 AM 359694 in reply to 359264

    Re: Problems with NETWORKDAYS function in XLS output

    Hi,

    Please download and try this fix: Aspose.Cells for .NET v7.1.0.5
    Many Thanks and Kind Regards,

    Shakeel Faiz
    Support Developer
    Aspose Sialkot Team
    Contact Us
    Aspose - The .NET and Java Component Publisher

    Keep in touch! We're on Twitter and Facebook
     

  •  02-08-2012, 10:39 AM 360122 in reply to 359694

    Re: Problems with NETWORKDAYS function in XLS output

    That works, thanks!

    --Howard

     
     

  •  02-13-2012, 3:45 AM 361005 in reply to 359264

    Re: Problems with NETWORKDAYS function in XLS output

    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.
     
View as RSS news feed in XML

© Aspose 2002-2012. All Rights Reserved.

Live Chat