Grouping/Sorting

 

If I missed in the helpfile than please tell me. I spent way to much time before i understood the finer details. Is there a doc/tutorial/sticky that explains the details and intracacies of Value/Format/Caption/SortPriority/GroupCaption?

 

I have a column with Excel cell addresses, e.g. L8 and AX10.  Depending on variable I want to sort by column or row.

Sorting on the raw address gives unacceptable results: At least the caption must be left padded with spaces else AXnnn will sort before Lnnn

 

After my "discovery phase"  I found it's really quite simple:

I set the Value of the Item as a Double: RowNumber+ColNumber/100000# (or swapped depending on my variable)

I set the Caption of the Item (as string) to the cell's Address

I set the GroupCaption as "Column:" & padding & ColLetter (or "Row:" & padding & RowNumber depending on variable)

 

I need the padding for the group as the only sort property is the caption.

 

REQUEST:

For the ReportGroupRow class:

Add a GroupValue Property. (Probably with GroupFormat?)

Remove the GroupRow boolean property: Can this be false for a grouprow?, or is it just the Interface/Implement?

 

For sorting : it would be nice to have an "intuitivesort" flag for strings where characters are followed by numbers.

(or is this implemented for item sorting but not for group sorting?)

 

 

It's been a struggle. Did I miss the obvious explanation in the help file or on the website? I'm normally the first to scream RTFM.

 

 

 

 

 

GroupValue...  it would follow the construct of the RowItem Value,Mask,Caption. Suppose I have 2 rowitems

Value: 9,00026 /  Caption: Z9 / Groupcaption: "000009"

Value: 123456,00256 / Caption: IV123456 / GroupCaption: "123456"

I must set the groupcaptions and rework them in the beforedraw event. Rather a waste of resources  I sometimes need 300.000+ records, so I have to measure performance and memory. 6 char string=16bytes. 1 long=4 bytes....

 

 

 

 

Doesn't solve my Group problem though, does it?

Thanks for the nice example!

 

I had failed to spot the Grouppriority, and I still fail to see the SetMask method I have in SuiteControls and PropertyGrid.

GroupPriority doesnot solve my problem, but it helps. Suppose I want the items grouped in 8 groups of 125 items each. Modify your example to 1000 records, and set the grouppriority to (i - 1) mod 125 + 1

 

Group priority ONLY influences the SORTING of the groups, NOT the grouping itself, and not the Sorting of the items.

 

My reallife example is more complicated but solved. Thanks for the explanation.