HI,
Two hopefully quite quick questions about the grid:
1) I love the value based appearance stuff, but is there any way of making it apply to a whole row rather than just a single column? Eg, have a red background for the entire row if column 'A' has it's checkbox ticked?
2) We have a couple of grids in different solutions which keep on switching on a sort of split scrolling effect, ie, there are two copies of the grid's column set displayed side by side, and each can be scrolled independently. I know this is a feature, but for the grids in question we've never enabled it, and can't seem to switch it off. I can make the extra region disappear by dragging its associated splitter all the way to the left of the grid, but eventually it will appear again.
Kevin
1) I don't think so because values are a function of the cells, so a row does not really have a concept of a value. What you could do here is handle (for example) the CellChange event and set the associated row's Appearance when the value for the column in question changes.
2) Somewhere in code you must be splitting a ColScrollRegion; you can search for "ColScrollRegions" to find the code that is responsible for this. Another possibility is that you are loading a saved layout that has multiple ColScrollRegions. In either case, you can clear the UltraGrid.DisplayLayout.ColScrollRegions collection to remove the split(s).
Thanks for the reply Brian.
1) I guess the way to make it work would be to place the property on the bands, and make it available only if a UltraCalcManager was on the form. That way it could have a formula condition to trigger it. Currently we do this via an event handler, as you've described, but moving it from code to properties would be a lot cleaner.
2) Thanks for the tip for clearing it - at least that way we can prevent it confusing the users. However, I can't find any reference to scroll regions being split in the code at all. Here's the results of a search for "ScrollRegion" on all the files that make up the form:
Line 395 - Me.grdPreview.DisplayLayout.MaxColScrollRegions = 1Line 396 - Me.grdPreview.DisplayLayout.MaxRowScrollRegions = 1
These occur within the designer file, yet if I run it I end up with two sets of columns. This is with 2008R3, porting either of the apps we've seen this in to a later release isn't currently an option.
Thanks,
Kev
It would be really useful to have this work as described, ie a value based appearance on the band property, or some other way to make it work for a whole row at once. It's a real pain setting a formula condition individually for each column, and it doesn't seem right doing it in code sometimes and as a property other times