Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread Formatting a Grid Cell or Grid Row
Mon, Nov 30 2015 5:32 PMPermanent Link

Richard Harding

Wise Nutrition Coaching

It appears that you can only change the formatting of a grid cell based on the contents of that cell using TGridColumn's OnCellUpdate event.

Is it possible to change the formatting of a grid cell (or a grid row) based on the contents of another grid cell?

Thank you.

Richard Harding
Wed, Dec 2 2015 12:12 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Richard,

<< It appears that you can only change the formatting of a grid cell based on the contents of that cell using TGridColumn's OnCellUpdate event.

Is it possible to change the formatting of a grid cell (or a grid row) based on the contents of another grid cell? >>

Is this a data-bound grid, or an un-bound grid ?

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Dec 2 2015 10:30 PMPermanent Link

Richard Harding

Wise Nutrition Coaching

Hi Tim

<<Is this a data-bound grid, or an un-bound grid ?>>

It is a data-bound grid.
Thank you . . .

Richard Harding
Thu, Dec 3 2015 2:17 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Richard,

<< It is a data-bound grid. >>

I was afraid that you were going to say that.  There are some options in this area, but they aren't particularly ideal and involve using a shadow dataset to grab the data that you want.  So, for now, the answer is no, you can't do that.

Tim Young
Elevate Software
www.elevatesoft.com
Thu, Dec 3 2015 7:05 PMPermanent Link

Richard Harding

Wise Nutrition Coaching

Thanks Tim

Hopefully that means it is somewhere on the list.

Richard
Sun, Dec 6 2015 8:39 PMPermanent Link

Richard Harding

Wise Nutrition Coaching

<<  There are some options in this area, but they aren't particularly ideal and involve using a shadow dataset to grab the data that you want.  So, for now, the answer is no, you can't do that.>>

Hi Tim,

YES - I was able to get it working using a shadow dataset.  It only works for a cell that contains data that can be used as a key to lookup the shadow dataset.

I have a grid containing stock details that is sorted on 2 columns (for example, Stock Group and Stock Item) and wished to bold the row when the Stock Group changed.  That is not possible, but I can bold the data cell where the Stock Group key changes which satisfies the customer so it was a very helpful idea.

Richard
Mon, Dec 7 2015 1:50 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Richard,

<< YES - I was able to get it working using a shadow dataset.  It only works for a cell that contains data that can be used as a key to lookup the shadow dataset. >>

Good, I'm glad you that you were able to get it to work, at least in a minimal fashion.  As you say, the main issue is that there isn't much of a relationship between a grid cell and a dataset row or column.

Tim Young
Elevate Software
www.elevatesoft.com
Image