Xlsx to pdf - strange conversion of cell borders

Hello,


i am tying to convert some xlsx files to pdf. One issue i have looking at the resulting file is, that the borders around groups of cells look different compared to the original file and to the result i get when using “save-as-pdf” in Excel.

To illustrate my problem i’ve added a simple example file. I have two groups of cells with a background color. In the upper group i’ve just set the background and the black border. In the lower group i’ve tried to work around the issue with the bright lines between the inner cells by defining a border with the same color as the background.

As you can see highlighted in the image-file i get either highlighted lines (when i set no border) or some strange artefacts where the inner border meets the outer border.

The corners of the outer border doesn’t seem to fit, either.

I’ve used Aspose.Cells 8.7.2.2.

I hope you can solve this issue.

Hi,


Thanks for providing us screen shot and template files.

After an initial test, I observed most of your mentioned issues (as highlighted in your attached screenshot) regarding cell borders in the rendered PDF file. However, when I did zoom (e.g 400%) for the MS Excel saved PDF file, when opening it into Acrobat reader, I did see a few issues as per the following screenshot:
http://prntscr.com/arcc31
I simply used your template file to convert to PDF file format.
e.g
Sample code:

Workbook workbook new Workbook(strFilePath);
workbook.Save(outPDFFilePath);

I have logged a ticket with an id “CELLSNET-44371” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

Thank you.

Hi,


By the way, we can’t observe the inner white line issues of the upper group in Adobe Acrobat Reader. How did you find this issue, in which editor you open the PDF file to find the issue(s)?

Thank you.

Hi,


i can see it with either MuPDF (http://mupdf.com/) or Nitro Pro 8 (http://www.nitropdf.com/).

I cannot see the inner white lines using foxit (https://www.foxitsoftware.com/).

All the best,
Uwe

Hi,


Thanks for providing us further details.

Although we follow Adobe (acrobat) standards in most cases when rendering to PDF file format but we might consider to fix this issue (regarding inner white lines) for your mentioned editors. I have logged your concerns into our database against your issue and our concerned member of the product team will evaluate it (if possible) as well.

Thank you.