PC Review


Reply
Thread Tools Rate Thread

c# programmatically grouping a range of cells

 
 
=?Utf-8?B?bWlsZXpk?=
Guest
Posts: n/a
 
      6th Aug 2007
I am looking to group groups of consecutive rows at the same level, for example
group rows 11-26 and then group 27-42 and the group 43-58, etc

I've been using this to group
range = sheet.Rows[string.Format("{0}:{1}", startRow, endRow), Type.Missing]
as Range;
range.Group(Type.Missing, Type.Missing, Type.Missing, Type.Missing);

problem is, when it's done it's grouped from 11-58 and not in the in

this is what I would like it to look like when I am finished

http://img113.imageshack.us/img113/953/excello0.jpg

any suggestions?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change GROUPING programmatically in reports Dennis Microsoft Access Form Coding 2 4th Jun 2010 08:15 PM
Programmatically control Report Grouping & Sorting via Form Jen S Microsoft Access Form Coding 1 26th Jul 2009 04:06 PM
Programmatically setting Conditional Formatting to a range of cells Andrew Microsoft Excel Programming 7 13th Nov 2007 01:09 PM
Adjust grouping levels programmatically =?Utf-8?B?UGVuZHJhaWc=?= Microsoft Access Reports 2 23rd Oct 2007 08:44 AM
Changing report grouping programmatically =?Utf-8?B?YW1iZXI=?= Microsoft Dot NET 1 14th Oct 2004 08:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:28 PM.