Add the method to BandedGridView for Bands similar to the BestFitColumns method in GridView

DevExpress Support Team

created 19 years ago

Comments (1)

Eric Comte Marois 12 years ago

Wow… seven years… guess there's no point expecting it anymore now!

Answers approved by DevExpress Support

DevExpress Support Team

created 12 years ago (modified 12 years ago)

Hi Crono,
The BestFitColumns method does the trick for the BandedGridView. As for the AdvBandedGridView, its layout may be too complex. So, there is no way to calculate the best width of columns in a common scenario.
Updated by Maxim (DevExpress Support)
It is possible to simulate this feature manually for the BandedGridView. Call the BestFit method for all columns related to the current band.
The following code illustrates how to do this:

C#
private void BestFil(GridBand gridBand)  
{  
    gridBand.View.BeginUpdate();  
    foreach (BandedGridColumn column in gridBand.Columns)  
    {  
        column.BestFit();  
    }  
    gridBand.View.EndUpdate();  
}

Visual Basic
Private Sub BestFil(ByVal gridBand As GridBand)  
    gridBand.View.BeginUpdate()  
    For Each column As BandedGridColumn In gridBand.Columns  
        column.BestFit()  
    Next column  
    gridBand.View.EndUpdate()  
End Sub

I hope you find this approach useful.

Show previous comments (6)

Eric Comte Marois 12 years ago

I fully understand that the AdvBandedGridView couldn't support it. I wouldn't expect it to either.
But that can't really be the reason why you won't do it for the BandedGridView?
I'm aware the former is a descendant of the latter but you're still free to shadow the functionnality on it and throw an exception if it's called nonetheless? I know it's not "pretty" but it's sure as hell MUCH better than preventing BandedGridView from evolving?!

Eric Comte Marois 12 years ago

I wouldn't have any problems explaining my users they can't do "best fit" on an AdvBandedGridView. But really, for BandedGridView it's just awkward watching them trying and go "hey, why this isn't working?". It just should.

DevExpress Support Team 12 years ago

Hi Crono,
We've not implemented this method yet and we are not planning to add this method in the near future. We know that there is room for improvement in our controls and we consistently strive to make them better. However, I hope you understand that implementing an ideal control which will meet every customer request is just impossible. Fortunately, XtraGrid allows you to solve this task with ease, by writing only a few lines of code. I have updated our Answer with the corresponding code sample.
Also, I think that throwing an exception when the end-user double clicks the band edge is unacceptable.
Thank you for you understanding.

Eric Comte Marois 12 years ago

Maxim, I agree that there's no such thing as an all-around, do-it-all control that answers every possible user desires. Still, I believe there are many places where you fail to go the extra mile making your components feels natural, and this is one of them.
Users DO expect to be able to resize bands in the same way they do for columns. It doesn't feel right at all being able to do it for columns and not for bands.
It's easy(er) to explain to them that in the case of a more advanced band system (AdvBandedGridView) it cannot be done but as your own code shows there is no reason for this functionnality not being planned for the standard banded grid view.
Besides, your argument on this task being easy to solve "by writing only a few lines of code" is not quite good for a developer who wants to give the end user the ability to autoresize a band himself via double-clicking it's edge, in a similar way than with columns. For this, it would also be necessary to capture the double click event, verify mouse position, get the correct band (left or right?) AND then call your code snippet.
Oh and yeah, unless you override the banded grid or use an extender you'd have to repeat this code for each and every grid you want this feature on. So much for "a few lines of code".
I guess I can still be thankful, as I do happen to use an extender and the idea seems good enough. I'll give it a shot.

DevExpress Support Team 12 years ago

Hi Crono,
I see your point and, of course, I agree with you. I can say that neither our BandedGridView nor AdvBandedGridView override this capability. This method is performed at the GridView level. It traverses through all columns and call their BestFit method. I tested this behavior with both BandedGridView and AdvBandedGridView and this method worked correctly. Probably, it does not work with a particular layout. Would you please send us a project illustrating your layout? We will do our best to provide you with a way to resolve the issue under the current approach.

Victor Rios 3 12 years ago

Hello to collaborate with the solution show here the code that worked for me with a grid with all Advanced bands.
       private void BestFitColumns()
        {
            GridControlDetalleVenta.BeginUpdate();
            foreach (BandedGridView band in GridControlDetalleVenta.Views)
            {
                foreach (GridBand gridBand in band.Bands)
                {
                    gridBand.Columns.View.BestFitColumns();
                }
            }
            GridControlDetalleVenta.EndUpdate();
        }

DevExpress Support Team 12 years ago

Hello,
If I understand you correctly, you wish to have a simular workaround for the AdvBandedGridView instance. As we mentioned before, a layout of the AdvBandedGridView instance may be to complex for such an algorithm.
I suggest that you create a new ticket and send your particular layout for further research. Possibly, we will find a specific solution for your case.

Chris Smith 10 years ago

I cant believe this hasent been implimented yet! Your solution of "Just best fit all the columns within the bands" is not good enough. What if the caption text of the band is longer than the columns? Surely this feature is a must?

DevExpress Support Team 10 years ago

Hello Chris,

Yes, I see that if the caption text of the band is longer than the columns, the BestFitColumns method does not take into account the band width and does not produce the desired result. I created a separate ticket regarding this case on your behalf: T210043: How to use the BestFitColumns method in BandedGridView if the caption text of the band is longer than the columns. Our team will address it as soon as we have any updates.

Created: July 17, 2006 8:51 PM

Modified: February 17, 2015 5:21 PM

Platform: WinForms

Product: XtraGrid Suite

Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

Add the method to BandedGridView for Bands similar to the BestFitColumns method in GridView

Answers approved by DevExpress Support

Recently viewed tickets