We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Cells having both wrap and centre across selection are not getting printed

Hi team,

I am currently using Aspose cells v 8.0.0.0 and found an issue in which any cell with wrap text as well as center across selection, are not getting printed to the output pdf file.

I have included the input excel file and the output pdf file.

Please revert back for any clarification.

Regards.

Hi Nicole,


Thank you for using Aspose products.

We have evaluated your presented scenario while using latest version of Aspose.Cells for .NET 8.0.1.3, and we haven’t found the issue as mentioned in your post. The cell B4 having the wrap text & center across selection is rendering in the resultant PDF file as attached.

C#

var book = new Workbook(myDir + “Input+excel+file.xlsx”);
book.Save(myDir + “output.pdf”, SaveFormat.Pdf);

Please feel free to write back in case you have further questions.

Hi,
The issue still persists with the new dll file. Please find below the piece of code used to convert the excel file to pdf.

MemoryStream ms = new MemoryStream();
wb.SaveToStreamEx(ref ms, f);
Aspose.Cells.Workbook wb1 = new Aspose.Cells.Workbook(ms, new Aspose.Cells.LoadOptions(Aspose.Cells.LoadFormat.Auto));
foreach (Aspose.Cells.Worksheet ws in wb1.Worksheets)
{
ws.AutoFitRows(true);
}
Aspose.Cells.PdfSaveOptions pso = new Aspose.Cells.PdfSaveOptions();
pso.DefaultFont = “Calibri”;
wb1.Save(destinationFile, pso);
ms.CloseEx();

Please revert back for further clarfication.

Regards

Hi Nicole,


Thank you for providing the sample code snippet.

We are able to replicate the problem while using the latest version of Aspose.Cells for .NET 8.0.1.3 and your provided code snippet. We have also noticed the problem is caused by the AutoFitRows statement in the source code, as the text in B4 renders properly in the PDF when this line is commented out.

We have logged the problem in our bug tracking system under ticket Id CELLSNET-42597. Please spare us little time to properly analyze the problem cause, and to provide a fix at earliest (if applicable). In the meanwhile, we will keep you posted with updates in this regard.

Hi,

This is a high production issue. When can we have fix for it.

Hi Nicole,

Thanks for your posting and using Aspose.Cells.

We have checked your issue status from our database and found that it is fixed. Hopefully, we will provide you a fix in this week. Once, it is available for you, we will let you know asap.

Hi,

AutoFitRows was given as a solution for Warp text issue which we had earlier. Please make sure the fix will be for warp text used alone and along with center across selection.

Hi Nicole,

Thanks for your posting and using Aspose.Cells.

Hopefully, the issue related to cell B4 not printing because of AutoFitRows will be fixed in the next version. It will also fix the issue with wrap text alone and along with center across selection.

Hi Nicole,

Thanks for using Aspose.Cells.

Please download and try this fix: Aspose.Cells for .NET (Latest Version) and let us know your feedback.

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


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