XLS -> PDF "Not a legal OleAut date."

Aspose.Cells Product Family
1

Hey,


I have the following code to convert xls and xlsx files to PDF:|
Workbook book = new Workbook(this.tempInputFile);

book.Save(this.tempOutputFile, Aspose.Cells.SaveFormat.Pdf);
This seems to work fine for a lot of files however for a certain file it throws an exception saying “Not a legal OleAut date.”.

With the following stack trace (relevant section only):
System.ArgumentException: Not a legal OleAut date.

at System.DateTime.DoubleDateToTicks(Double value)

at System.DateTime.FromOADate(Double d)

at Aspose.Cells.CellsHelper.GetDateTimeFromDouble(Double doubleValue, Boolean date1904)
I’m working on trying to figure what about the excel file seems to be causing the exception to occur, but currently having difficulty narrowing it down. I can’t share the file it’s occurring in but once I can figure out what it is, I’ll update this thread with a file I know to cause it.

I’m hoping you guys might know what this is, as in the forums I recently saw someone else have a similar issue with the Words module. And way further back (2004) it seems this happened to someone who was using Cells, so kind of hoping you guys might already know the cause.

Thanks in advance.
2

Hi,


Thanks for providing us some details.

I am afraid, it is hard to detect the problem cause unless we are able to replicate the said exception using your template file on our end therefore we request you to kindly provide us your template Excel file for thorough investigation.

We also recommend you to kindly try our latest version/fix: Aspose.Cells for .NET v8.4.1.2 if it makes any difference.

Thank you.

3

Hi,


Using google I found a link to a spreadsheet that causes the same issue to occur:

http://www3.wabash.edu/econometrics/EconometricsBook/Chapters/Ch03PivotTables/ExcelFiles/EastNorthCentralFTWorkers.xls

Thanks again.

4

Hi Amin,


The referenced spreadsheet causes the System.ArgumentException: Not a legal OleAut date, at Workbook constructor. We need to investigate the matter to pin point the problem cause therefore we have logged this incident in our bug tracking system under the ticket CELLSNET-43621. As soon as we complete the analysis, we will get back to you with updates in this regard.
5

Perfect. Thank you.

6

Hi Amin,


This is to inform you that we have resolved the issue logged earlier as CELLSNET-43621. We will shortly provide the fix here with our weekly release after performing QA & incorporating other enhancements.
7

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.4.1.3 and let us know your feedback.

8

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
9

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
(2)