I use following code to save this file 9465.zip (115.1 KB) as pdf:
Workbook w2 = new Workbook("9465.xlsx");
// Apply custom format to fill cell with dots
foreach (Worksheet worksheet in w2.Worksheets)
{
foreach (Aspose.Cells.Cell cell in worksheet.Cells.OfType<Aspose.Cells.Cell>())
{
if (cell.GetDisplayStyle().Custom.Contains("@*."))
{
Aspose.Cells.Style style = cell.GetStyle();
style.IsTextWrapped = true;
cell.SetStyle(style);
string points = string.Empty;
Int32 iterator = 200;
for (int i = 0; i < iterator; i++)
{
points = points + ".";
}
cell.PutValue(cell.StringValue + points);
}
}
}
w2.Save("9465.pdf", Aspose.Cells.SaveFormat.Pdf);
We add our own points because the save to pdf doesn’t accept the format for the Excel filler points.
This workaround works until we have updated to the newest release because now only
the first occurrence of the filler points are recognized correctly.
The others are now apparently ignored. This is a hard regression and even a not expected output.
How can we solve this issue as soon as possible ?
@Nachti,
Thank you for your query.
It seems that you forgot to attach the template file 9465.xlsx as only PDF file is there in the attached zip file. Please share the XLSX file also for our analysis.
@Nachti,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.
@Nachti,
We removed the custom format “@*.” of Cell A14, append lots of dots in it and set text wrapped (see attachment “9465_modified_Cell_A14.xlsx”), you can see only the text “Cost of” is on the first line, the rest of text is on the next line.
The root cause is that the custom format “@*.” is not supported in the output pdf. We will try to fix it.
After the issue is fixed, you will get expected output simply using the following code:
Workbook w2 = new Workbook(@"9465.xlsx");
w2.Save(@"9465.pdf", Aspose.Cells.SaveFormat.Pdf);
This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.
The issues you have found earlier (filed as CELLSNET-47366) have been fixed in Aspose.Cells for .NET v20.6. you may also get the version @ NuGet repos. here (NuGet Gallery | Aspose.Cells 20.6.0).This message was posted using Bugs notification tool by Amjad_Sahi
The issues you have found earlier (filed as CELLSNET-47366) have been fixed in Aspose.Cells for .NET v20.6. you may also get the version @ NuGet repos. here (NuGet Gallery | Aspose.Cells 20.6.0).This message was posted using Bugs notification tool by Amjad_Sahi
sorry but we still face the same issue with Aspose.Cells v. 20.6.0.0
Only the first approach (A13) of the leading points is correct.
All other occurences (A14 - A44) are still ignored.
I did convert your Excel file to PDF file format using the following sample code, it works and the output (attached) is ok to me:
e.g Sample code:
Workbook w2 = new Workbook(@"9465.xlsx");
w2.Save("out1.pdf", Aspose.Cells.SaveFormat.Pdf);
Please find attached the output file and highlight the issue (you may take screenshots to explain the issues) you are talking about, we will check it soon. out1.pdf (88.5 KB)