DIAdem

cancel
Showing results for 
Search instead for 
Did you mean: 

Background and font coloring of individual cells on a REPORT table

I'm at my wits end.  I have scoured through so many posts on here (and throughout the Googleverse) dealing with changing the background color and/or font color of individual cells in a REPORT table.  I have tried all the examples I've found, all the scripts that I have come across, and I have yet to get the results I'm looking for.  DIAdem really makes this task inherently difficult.

 

Below are two examples of what should be simple things I want to accomplish.

Screenshot 2025-01-14 104359.jpg  Screenshot 2025-01-14 104158.jpg

In the left example, if "None" appears in any cell, change the background color.  If "N/A" appears in any cell, change the font color.  In the right example, if a cell has a particular value, change the background color.

 

Again, simple tasks (and I've really tried my best to get this to work in the REPORT tables), but I have had no luck.  I'm using version 2023 Q2, if that helps.

0 Kudos
Message 1 of 2
(106 Views)

Unfortunately, this is a bit tricky in DIAdem. To change properties of individual cells you have to use the OnDrawingCell event. There is an example in DIAdem help under Examples - Creating a Report - Tables - User command (to be honest - I only found it as I knew it should be there 🙂).

Holger Müller

DIAdem experience since 1996
Turn-key applications - Remote and on-site trainings - On-the-job training

| müller+krahmer GmbH | Koenitzer Straße 14, 07338 Kaulsdorf / Germany |
| Phone: +49 36733 / 2328 - 6 | Mobile: +49 160 / 287 7294 |
| Email: mueller@mueller-krahmer.de | Web: www.mueller-krahmer.de |
0 Kudos
Message 2 of 2
(85 Views)