My question makes me feel a bit silly: it works in Excel 2003 but I can't get it to work in Excel 2010.
Let me try to explain the issue with an example. The report list all item ledger entries in rows. One of the fields retrieved from the database is the Item no. If an item may have multiple ledger entries, I want to see the item no. only with the first ledger entry.
A trick I used to apply was Excel Conditional format - Formula: if the value of the cell is equal to the previous cell the format the font color as white. Maybe not so fancy, but very effective.
The problem I have in Excel is that Excel always applies this formula to a fixed Cell (with $ in front of both column and row). Does anyone have an idea how to get rid of the $ in front of the row so that the conditional format follows my Jet replication?
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment Hi Hans,
The way conditional formatting is copied has changed in Excel 2010, which accounts for the behavior you're seeing. In Jet Reports 2010 (which is currently in beta), we have accounted for this change. The "Applies to" range will still be absolute (i.e. $D$4), but the replication will expand the range and copy the conditional formatting as expected. Because of the impact this could have on report performance, this behavior is optional. The option is called "Preserve conditional formatting in Excel 2010 and later", and can be found in the General section of the Application Settings. It is disabled by default.
Best Regards,
Please sign in to leave a comment.