Problems with Gridlines showing in Microsoft Excel Print Preview

Aspose.Cells Product Family
1

When AsposeCells.PageSetup.PrintGridlines is set to false sometimes in PrintPreview within Microsoft Excel they are actually shown.

This appears only to happen when the Workbook is saved using Aspose in Xlsb format. Have not noticed the issue when saving in Xlsx format.

2

Hi Mike,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue. Gridlines are shown in MS-Excel Print Preview when workbook is saved in
Xlsb format. When workbook is saved in Xlsx format, these are not shown.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42595.

C#


Workbook workbook = new Workbook();


Worksheet worksheet = workbook.Worksheets[0];


worksheet.Cells[“C10”].PutValue(“Some Data”);


worksheet.PageSetup.PrintGridlines = false;


workbook.Save(“output.xlsb”);

3

Hi Mike,

Thanks for using Aspose.Cells.

Please download and try this fix: Aspose.Cells
for .NET v8.0.1.4 and let us know your feedback.

4

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

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

Thanks Shakeel, tested in 8.0.2 - all good.

Cheers,

Mike

6

Hi Mike,

Thanks for your feedback and using Aspose.Cells.

It is good to know that this issue is now resolved with the latest version and works fine at your end. Let us know if you encounter any other issue, we will be glad to look into it and help you further.