Sheet save method(pdf) error

Aspose.Cells Product Family
1
Hi,

We used aspose sheet.save method for 'original.xlsx' document. It converted to pdf.(withaspose.pdf)

we convert this document without aspose,(withoutaspose.pdf) First row remained constant. But we use aspose save method to convert pdf , first row didnt remain constant.

what can we do to solve the problem?

Note:excell version:8.7.1.0 - pdf version: 11.4.0.0
2

Hi Ahmet,


Please try the scenario against the latest version of Aspose.Cells for .NET 8.8.2.3 (attached) as it produces the correct results, that is; the header rows are printed on each and every PDF page.
3

Hi,


we tested this version but it didnt solve our problem.

Our code is:

Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(this.UploadDirectory + fileName);
Aspose.Cells.PdfSaveOptions opts = new Aspose.Cells.PdfSaveOptions();
wb.Save(this.UploadDirectory + fileName.Substring(0, fileName.LastIndexOf(’.’)) + “.pdf”, opts);
4

Hi,

Thanks for your feedback and using the Aspose.Cells for .NET.

We have attached the Visual Studio 2013 sample project. It uses same code as yours. Please run it at your end and see the output pdf generated by it inside the bin\Debug directory and see if the output pdf is fine or not.

5

Hi Shakeel,


This attachment is your project output.
İt is not Fine,
This output and Babar’s output different.
First row is not remain constant

Thanks…
6

Hi Ahmet,


Thank you for writing back.

I have further investigated the matter on my side and I think the problem is some how related to the locale of the machine. Originally, my machine’s locale was set to USA therefore when I converted the provided spreadsheet to PDF against Aspose.Cells for .NET 8.8.2.3, I got the correct result. Upon reviewing your provided PDF, I have noticed that it was generated with the same API version that we have been asking you to use, however, it isn’t correct because row headers are not being repeated on all PDF pages. I have also noticed that you are from Turkey so I repeated the test by changing the locale of my machine to Turkey and got incorrect results (resultant files attached for your reference). At the moment, I am not sure why the problem is locale specific and how can we overcome it therefore I have logged this incident in our bug tracking system under the ticket CELLSNET-44498 for thorough investigation.

Please spare us little time to for proper analysis. In the meanwhile, we will keep you posted with updates in this regard.
7

Hi,

Thanks for using Aspose.Cells.

It is to inform you that we have fixed your issue CELLSNET-44498 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

8

Hi,

Thanks for using Aspose.Cells.

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

9

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

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

We tested this version but it’s not fixed.


Thanks
11

Hi Ahmet,


Could you please share the PDF generated against the latest release of Aspose.Cells for .NET 8.8.3.6? Please also provide the input spreadsheet if you are testing the scenario with some sample which isn’t shared here. We also require environment details where you are testing the scenario. We are currently interested in the OS version & region/locale of your machine.

Attached is the resultant PDF generated against 8.8.3.6 while using the sample spreadsheet shared in your first post.

12

Hi,

Thanks for using Aspose.Cells.

In order to investigate this issue further, please run the following code and let us know its output.

C#
Console.WriteLine(CellsHelper.GetVersion());

CultureInfo cultureInfo = CultureInfo.CurrentCulture;

Console.WriteLine(cultureInfo.Name);

Workbook workbook = new Workbook(path + "Original.xlsx");

Range range = workbook.Worksheets.Names[0].GetRange();

Console.WriteLine(range);