I would be ever so grateful of someone could help me with something.

I have a grid for which i want to provide totals for certain columns.
Being unsure how to do this in the grid itself, I want to put the totals underneath the grid as separate container with controls/widgets. Not sure how this will show, but :

============
= Grid             =
= -- --  --  --  --  =
= -- --  --  --  --  =
============
Totals Container
============

How do I get the grid to stretch to the bottom of the screen BUT stopping above the container set to the bottom of the form? The grid shows the rows, but the container underneath the grid is to show to totals. I just can't work out how to stop the grid stretching beyond the "totals" container to the bottom of the form.

Does that make sense?

On 12/16/2015 3:47 PM, squiffy wrote:
> I would be ever so grateful of someone could help me with something.
> Being unsure how to do this in the grid itself, I want to put the totals underneath the grid as separate container with controls/widgets. Not sure how this will show, but :
>
> ============
> = Grid             =
> = -- --  --  --  --  =
> = -- --  --  --  --  =
> ============
> Totals Container
> ============
>
> How do I get the grid to stretch to the bottom of the screen BUT stopping above the container set to the bottom of the form? The grid shows the rows, but the container underneath the grid is to show to totals. I just can't work out how to stop the grid stretching beyond the "totals" container to the bottom of the form.
> Does that make sense?


Yes it does. I'm not in front of EWB right now but think of totals
container placing itself on bottom first and then grid should just fill
rest of the form.

So something like this (from memory so you might have to experiment a bit ):

For simplicity assume totals container is a panel so make sure it has
layoutorder 0 and then position Bottomleft and Stretch BottomRight and
consumption top.

Then the grid should be position topleft and stretch bottomright

Raul

Hi Raul,
if I do that and set the grid background fill to red, then set the panel background to transparent, the grid seems to go to the bottom right of the form, not stopping at the panel.

ok, it seems to be to do with the "Layout Order" as well. This seems to work but it was complete trial and error rather than reasoned thinking. If anyone could enlighten me I'd be grateful.


Grid -
Layout Order : 1
Consumption: lcBottom
Stretch : bottomRight
Reset : true

BasicPanel -
Layout order : 0
consumption : top
position : bottomleft
stretch : bottomright
reset : false

On 12/16/2015 4:39 PM, squiffy wrote:
> if I do that and set the grid background fill to red, then set the panel background to transparent, the grid seems to go to the bottom right of the form, not stopping at the panel.

That does not sounds right to me - are you sure your Panel LayoutOrder
is 0 and Grid layoutorder is 1 ? (that is important as otherwise grid
would fill the form first).

Another thing to check is that form background is not read red -
transparent panel would show colour of whatever is underneath it.

I won't be able to try this out til i get home but will give it a try
and post back.

Raul

On 12/16/2015 4:50 PM, squiffy wrote:
> ok, it seems to be to do with the "Layout Order" as well. This seems to work but it was complete trial and error rather than reasoned thinking. If anyone could enlighten me I'd be grateful.

Yes - my original posting did specify that panel must be layout order 0
(so it's applied first in layout calculations and take up the bottom of
the form).


> Grid -
> Layout Order : 1
> Consumption: lcBottom
> Stretch : bottomRight
> Reset : true
>
> BasicPanel -
> Layout order : 0
> consumption : top
> position : bottomleft
> stretch : bottomright
> reset : false
>

Looks fine to me - you should not even need the Grid Reset to be true. here

Raul

Raul,

<< Looks fine to me - you should not even need the Grid Reset to be true. here >>

Correct - Reset would be unnecessary.

Also, for all lurkers, always remember these nice shortcuts in the form designer:

Alt-Up/Down Arrows - moves forward and backward among the controls in their *tab* order

Ctrl-Alt-Up/Down Arrows - moves forward and backward among the controls in their *layout* order

These keys, combined with the escape key for backing up into a parent control, allow you to visually navigate the layout/tab order to make sure that everything is set up the way that you want it to be set up.

Tim Young
Elevate Software
www.elevatesoft.com

Apologies Raul, you did indeed specify the layout order.

Thanks for the help, all.

Make sure that the Total Container has a Layout Order of less than the
Grid and set the Layout Container to be placed in the bottom left and
stretch to the right. Then set the grid to be placed Top Left and
stretched to the Bottom Right.

e.g.

Total Container:
=================
Layout Order = 0
Layout Position = lpBottomLeft
Layout Stretch = lsRight

Grid
=======
Layout Order = 1
Layout Position = lpTopLeft
Layout Stretch = lsBottomRight

Chris Holland
[Team Elevate]

On 16/12/2015 20:47, squiffy wrote:
> I would be ever so grateful of someone could help me with something.
>
> I have a grid for which i want to provide totals for certain columns.
> Being unsure how to do this in the grid itself, I want to put the totals underneath the grid as separate container with controls/widgets. Not sure how this will show, but :
>
> ============
> = Grid             =
> = -- --  --  --  --  =
> = -- --  --  --  --  =
> ============
> Totals Container
> ============
>
> How do I get the grid to stretch to the bottom of the screen BUT stopping above the container set to the bottom of the form? The grid shows the rows, but the container underneath the grid is to show to totals. I just can't work out how to stop the grid stretching beyond the "totals" container to the bottom of the form.
>
> Does that make sense?
>

Forgot to set the container consumption to be lcTop

Chris Holland
[Team Elevate]

On 17/12/2015 12:15, Chris Holland wrote:
> Make sure that the Total Container has a Layout Order of less than the
> Grid and set the Layout Container to be placed in the bottom left and
> stretch to the right. Then set the grid to be placed Top Left and
> stretched to the Bottom Right.
>
> e.g.
>
> Total Container:
> =================
> Layout Order = 0
> Layout Position = lpBottomLeft
> Layout Stretch = lsRight
>
> Grid
> =======
> Layout Order = 1
> Layout Position = lpTopLeft
> Layout Stretch = lsBottomRight
>
> Chris Holland
> [Team Elevate]
>
> On 16/12/2015 20:47, squiffy wrote:
>> I would be ever so grateful of someone could help me with something.
>>
>> I have a grid for which i want to provide totals for certain columns.
>> Being unsure how to do this in the grid itself, I want to put the
>> totals underneath the grid as separate container with
>> controls/widgets. Not sure how this will show, but :
>>
>> ============
>> = Grid             =
>> = -- --  --  --  --  =
>> = -- --  --  --  --  =
>> ============
>> Totals Container
>> ============
>>
>> How do I get the grid to stretch to the bottom of the screen BUT
>> stopping above the container set to the bottom of the form? The grid
>> shows the rows, but the container underneath the grid is to show to
>> totals. I just can't work out how to stop the grid stretching beyond
>> the "totals" container to the bottom of the form.
>>
>> Does that make sense?
>>