Getting dotted grid lines instead of solid lines when I save report in PDF

Aspose.Cells Product Family
1

Hi


I’m using AsposeCells for .NET version 7.0.3.0 and when I save workbook to pdf by setting printgridlines property of pagesetup to true I’m getting grid lines as dotted lines.
Before that when I was using the previous version I was getting gridlines as solid lines.
Can you please tell me how to get solid grid lines in the saved report (pdf) in this version?

Thanks and Regards
Mukundan
2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please download and try the latest version:
Aspose.Cells
for .NET v7.1.0.2


If the problem persists, then please provide us your source xls/xlsx file which you are converting to pdf, we will look into your issue asap.

3
Hi Shakeel Faiz,
Thanks for your prompt response,
I have tried the new dll you have provided and I'm still getting grid lines as dotted lines.
The code snippet I have used to generate pdf is:
Workbook workbook = New Workbook();
PageSetup pageSetup = workbook.Worksheets[0].PageSetup;
pageSetup.PrintGridlines = true;
pageSetup.SetHeader(0,);
pageSetup.SetHeader((1,);
pageSetup.SetHeader(2, );
workbook.Save(, New PdfSaveOptions());
I'm attaching the xls file and also the generated pdf file.

Thanks and Regards
Mukundan
4

Hi,

We print as Ms-Excel print preview.

Please see the output pdf and the screenshot.

5
Hi Shakeel Faiz,
Thanks for your response,
I have tried the same and when I took print using "cute PDF writer" instead of "do PDF v7", i'm getting grid lines as solid.
Please, find the attached pdf generated by me on my end.
Thanks and Regards
Mukundan
6

Hi,

I am afraid, we do not think it is a bug. Because on the machines of other developers, Ms-Excel 2010 is showing dotted lines regardless of printer.

We render the PDF as it is shown by Ms-Excel in a Print Preview. Please check the Print Preview not the actual output.