Trendline and Date format

Aspose.Cells Product Family
1

Hi Guys,

As we are still evaluating the Aspose Excel component I believe to have found some irregularities when it comes to a trend line and date format within test diagrams. I am working with the most current version (16.11.10)

The issues are as follows:

1. Date Format
both charts have a problem with the formatting of a date.
The result in the PDF does not correspond to the Excel file.
The date is displayed in the PDF with a hyphen.
E.g.: Jan 16 becomes Jan-16 in the PDF

2. The Trendline
The Trendline in the second diagram is not render properly in the PDF.
The #NV-error influences the result.
The result in the PDF does not correspond to the Excel file.

Attached you will find my test document and the PDF.

Here is the corresponding code:
//Load and Save paths
var bookPath = @“C:\Users\MBerthold\Documents\TestArea\TrendLine_Test.xlsx”;
var pdfPath = Path.ChangeExtension(bookPath, “.pdf”);

//Load and Save Workbook
var book = new Workbook(bookPath);
book.Save(pdfPath, SaveFormat.Pdf);

//Open PDF-File
Process.Start(pdfPath);

I will keep testing your great components and thank you for your support.

2

Hi,


Thanks for the template file and output PDF file.

1) Well, this is probably due to your locale or region set where you are converting the template file to PDF file format. I have english locale/region (usa) set and use MS Excel (english) to open your file, it does show the DateTime values in the same format as “Jan-16”. I think you may try to specify the region while opening the file or specify it after loading it (before rendering to PDF file format) via Aspose.Cells APIs if it works fine or not. If you still find the issue, kindly do provide your regional/locale details/ settings, we will check it soon.

2) After an initial test, I observed the issue as you mentioned by converting your template Excel file to PDF. I found that the trendline in the second diagram is not rendered properly in the output PDF. I have logged a ticket with an id “CELLSNET-44984” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

Thank you.
3

Hi,

Thank you for your note.

First of all, i use MS Excel in the German Version.
I have no success, when i load the workbook with my country code.
My system is completely set in german.
The PDF results are the same.

Here my Code:
LoadOptions lo = new LoadOptions()
{
LanguageCode = CountryCode.Germany,
Region = CountryCode.Germany,
CultureInfo = new System.Globalization.CultureInfo(“de-DE”),
};

I have expanded my test and also tested other languages.
The following languages are not output correctly:
- Arabic (see test file)
- Nepali (Nepal) (see test file)
- Germany shot (see test file)

Attached I have attached my test document.

Thank you for your support.

4

Hi,


Thanks for providing further details and samples.

While we evaluate your original issue on our end thoroughly, could you test it on a machine with english locale/region and let us know your feedback with details and share screenshots taken in MS Excel for input Vs PDF (output).

Thank you.
5

Hi,

I have again looked at the dates on a English virtual machine installation.
Here the German date works, but the Arabic and Nepali dates still don’t work.
See the files labeled with the name “FormatCodeEnglish”.

In the German version of MS Excel the German date is displayed correctly.
Aspose automatically uses the right culture.
Only in the PDF it is not correct.

I hope I could help you with this and know that international dates are a big issue.

Thank you for your support.

6

Hi,


Thanks for providing further details and samples with screenshots.

We did observe your original issue as you mentioned by converting your template file to PDF. I have specified the region/locale to German but it does not work as expected. I found Date values (short date) in German locale are not rendered fine in Excel to PDF conversion.
e.g
Sample code:

LoadOptions lo = new LoadOptions()
{
LanguageCode = CountryCode.Germany,
Region = CountryCode.Germany,
CultureInfo = new System.Globalization.CultureInfo(“de-DE”),
};
Workbook wb = new Workbook(“e:\test2\TrendLine_Test.xlsx”, lo);


wb.Save(“e:\test2\out1.pdf”);

I have logged a ticket with an id “CELLSNET-44994” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

Thank you.
7

Hi again,


This is to update you that we have resolved the problem logged earlier as CELLSNET-44994. We will shortly share the fix here for your testing.
8

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

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

Hi Martin,


Thank you for writing back. Please note that the latest version of Aspose.Cells for .NET 17.1.0 has resolved the problem logged earlier as CELLSNET-44994 (Issue with Date format in German locale when rendering an Excel file to PDF) whereas the ticket regarding the issue of trend line is CELLSNET-44984, which is currently unresolved.
10

Hi,
sorry, my bad. I have changed the tickets.
I have tested the date function and it is working now.
thank you, good job.

11

Hi Martin,


Thank you for the confirmation. Please feel free to contact us back in case you need our further assistance with Aspose APIs.
12

Hi,

Have you already made progress on the topic of “Trendline”?

Thank you for your support.

13

Hi,


I am afraid, your issue (logged earlier as “CELLSNET-44984”) is not resolved yet. However, I have asked the concerned developer from product team to update on it or share an eta if possible.
Once we receive any news on it, we will let you know here immediately.

Thank you.
14

Hi,


We are pleased to inform you that we did fix your issue and hopefully we could provide you the fix before the end of this week.

Keep in touch.

Thank you.
15

Hi,

thank you for the status and your support.

16

The issues you have found earlier (filed as CELLSNET-44984) have been fixed in Aspose.Cells for .NET 17.3.0.

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