Sign In  Sign Up Live-Chat

Exception "System.ArgumentException: Not a legal OleAut date." occuring when trying to save workbook in AsposePDF format.

Last post 06-25-2008, 10:50 AM by bhaag. 5 replies.
Sort Posts: Previous Next
  •  06-18-2008, 10:02 AM 131910

    Exception "System.ArgumentException: Not a legal OleAut date." occuring when trying to save workbook in AsposePDF format.

    Attachment: Present (inaccessible)
    Hi,

    I am trying to convert an XLS file to PDF, but am unable to save the file in AsposePDF format. I am using the following code:

    Workbook wb = new Workbook();
    wb.Open("Book1.xls");
    wb.Save("temp.xml", FileFormatType.AsposePdf);//<-exception is thrown here



    Narrowing the problem
    down, I have found that this is occuring when some cells are encountered which contain a very large negative value, and have a custom date formatting (mmmm yyyy) applied, see (Book1.xls)

    (I am using Aspose.Cells version 4.4.3.1, along with .NET Framework version v2.0.50727)

     
  •  06-18-2008, 12:25 PM 131951 in reply to 131910

    Re: Exception "System.ArgumentException: Not a legal OleAut date." occuring when trying to save workbook in AsposePDF format.

    Hi,

    Thanks for providing us the template file with details.

    We will figure out the issue soon.

    Thank you.


    Amjad Sahi
    Support Developer,
    Aspose Nanjing Team
    Contact Us
     
  •  06-20-2008, 10:01 PM 132382 in reply to 131951

    Re: Exception "System.ArgumentException: Not a legal OleAut date." occuring when trying to save workbook in AsposePDF format.

    Any updates? Will it require a fix?
     
  •  06-21-2008, 12:18 AM 132390 in reply to 132382

    Re: Exception "System.ArgumentException: Not a legal OleAut date." occuring when trying to save workbook in AsposePDF format.

    Hi,

    Since it's week-ends now. We get back to you at the start of next week.

    Thanks for being patient!


    Amjad Sahi
    Support Developer,
    Aspose Nanjing Team
    Contact Us
     
  •  06-24-2008, 2:27 AM 132701 in reply to 132390

    Re: Exception &quot;System.ArgumentException: Not a legal OleAut date.&quot; occuring when trying to save workbook in AsposePDF format.

    Attachment: Present (inaccessible)

    Hi,

    Thanks for your patience.

    Please try this fix.

    It's caused by converting a negative numberic value to a date time value. We have fixed this bug.


    Warren Zhang
    Developer
    Aspose Nanjing Team
    About Us
    Contact Us
     
  •  06-25-2008, 10:50 AM 133031 in reply to 132701

    Re: Exception &quot;System.ArgumentException: Not a legal OleAut date.&quot; occuring when trying to save workbook in AsposePDF format.

    Yes it is working now.

    Thank you for the quick fix.
     
View as RSS news feed in XML