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

Free Support Forum - aspose.com

Missing filler points while saving to PDF

Hi,

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 ?

Kind regards,
Guido

@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.

sorry, here the missing excel file: 9465xlsx.zip (175.5 KB)

Kind regards,
Guido

@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.

This issue has been logged as

CELLSNET-47366 – Points not rendered to PDF file

@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);

9465_modified_Cell_A14.zip (172.7 KB)

@Nachti,

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.

@Nachti,

Please try our latest version/fix: Aspose.Cells for .NET v20.5.1 (attached)

Your issue should be fixed in it as we tested using the following code:
e.g
Sample code:

Workbook w2 = new Workbook(@"9465.xlsx");

w2.Save(@"9465.pdf", Aspose.Cells.SaveFormat.Pdf);

Let us know your feedback.
Aspose.Cells20.5.1 For .Net2_AuthenticodeSigned.Zip (5.3 MB)
Aspose.Cells20.5.1 For .Net4.0.Zip (5.4 MB)

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 (https://www.nuget.org/packages/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 (https://www.nuget.org/packages/Aspose.Cells/20.6.0).This message was posted using Bugs notification tool by Amjad_Sahi

Hi,

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.

Can you check it ?

Kind regards,

Kind regards,

@Nachti,

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)