Footer Rows doesn't honor BestFit

 

If I set BestFitMode to honor all column widths, shown or not, this works fine for 'normal' rows, but footer row sizes would not be hored for calculating the column sizes.

 

Do I miss something?

 

Thanks for help

 

 

Thanks for your sample. It works because the first column with the long footer text was visible.

 

But look: If you set the long footer text ''This text is longer...' to the last column and fill the report control. Make the last column small. Adjust the column with of the first column so the last column totally vanishes. Then press your bestfit button, the whole column wasn't resized. Set Column.BestFitMode=xtpBestFitModeAlldata and repeat. The last column honors all 'normal' rows but not the long footer text.

 

So I came to the conclusion: BestFit doesn't honor BestFitMode=xtpBestFitModeAlldata

 

I had called the best fit method to column 3 and it won't work.

 

Your sample simply works because you use DoEvents in the loop. This is an old trick for the same problem with BestFit before .BestFitMode was introduced. But it does not always work. I am shure that for the footer rows the BestFitMode was not taken into account...

 

Thanks again

 

Yes, but if BestFitMode is 0 or not taken into account only the width of visible cells are measured. So your sample works if you have long text in the first, visible column but not in the last, hidden row.

 

Why it works from time to time with DoEvents - no idea. In V11 before BestFitMode was introduced I also used DoEvents AND .Poulate but sometimes it works sometimes not - depends on Windows repainting (sizing, pane sizing, overlaping windows...).

 

But - thanks a lot, I hope Oleg have the time to examine this issue.