I have added some conditional formatting to a spreadsheet and it is working perfectly. (I am setting the background color of cells based on the value of the cell.) However, when I save it as pdf, the colors are not right.
Example of the problem: when a value = 0, the cell background should be white, but in the pdf it is light green. Please look at the tab named "% Variance from Forecast".
Note that I added some test data on the xlsx to show the full range of colors that the condition are set to show. These rows are not in the PDF.
Just so you know, when I first ran my code with the 7.3.4.2 Aspose.Cells version, my xlsx files were being saved as 0 bytes. I figured out that when saving to a stream, it leaves the position of the stream at the end. In previous versions, it set the position to 0. When saving to PDF, it positions it to 0.
I changed my code to set the position to 0, and it works, but I thought I would let you know the different save methods are not consistent.