How to apply conditional formatting Microsoft Excel Spreadsheet to PDF conversion with Aspose.Cells REST API

Aspose.Cells Cloud Product Family
1

Attached is an Excel file (zip) and the resulting PDF file. The conditional formatting that hides the cell borders in Excel is not applied in the PDF.

The method used is
http://api.aspose.com/v1.1/cells/12345-Doforms-Test_5255608.xlsx/saveAs?newfilename=12345-Doforms-Test_5255608.pdf

The options sent are

 <PdfSaveOptions>
<CalculateFormula>true</CalculateFormula>
<EnableHTTPCompression>true</EnableHTTPCompression>
<CreateDirectory>false</CreateDirectory>
<Compliance>None</Compliance>
<desiredPPI>400</desiredPPI>
<jpegQuality>95</jpegQuality>
<OnePagePerSheet>false</OnePagePerSheet>
<SaveFormat>Pdf</SaveFormat>

12345-Doforms-Test_5255608.pdf (42.7 KB)
12345-Doforms-Test_5255608.zip (8.1 KB)

2

@jsali

Thank you for contacting Aspose Support.

We are able to reproduce the issue at our end. We have logged the issue (CELLSCLOUD-10126) in our internal tracking software for our development team to fix this issue. We will update you here as soon as the issue is fixed.

We are sorry for the inconvenience caused.

3

@jsali

We are pleased to inform you that your reported issue has been fixed. Conditional formatting that hides the cell borders in Excel applies to the generated PDF.

Input File: 12345-Doforms-Test_5255608.xlsx.zip (8.6 KB)
Output File: 12345-Doforms-Test_5255608.pdf (42.7 KB)