I’ve been happily running ASPOSE.CELLS for a number of years (v2.2). One of or reports creates a pivot table and puts conditional formatting on the cells within the pivot table. This has all but running fine for a number of years. The report is not run often so it has only recently been drawn to my attention that the cells the conditional formating are being applied to the wrong cells. The only thing I can tell that has changed is we are viewing the spreadsheets in Excel 2007 which we only changed to about 6 months ago.
I have checked the code and the right CellArea values are being set but when the report is produced the conditional formatting ‘apply to’ cell value when explored in Excel is incorrect and while the same incorrect cells are in the ‘apply to’ cell value there isn’t any obvious connection between what it should be and what it is.
Can anyone shed any light on this? I am running an older version (v2.2) of
cells.net. Has anyone encountered this problem and solved it? Is it something about Excel 2007? Any help will be greatly appreciated.