We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Grouping

Thread ID:

Created:

Updated:

Platform:

Replies:

72553 Mar 26,2008 11:15 AM UTC Mar 27,2008 06:24 AM UTC WinForms 1
loading
Tags: XlsIO
Christoph
Asked On March 26, 2008 11:15 AM UTC

Hi,

I'm creating an Excel Sheet that contains personal data like adress private, address business, phone, etc.

Now I want to group by collumns. Therefore I'm using the following code:

sheet.Range[1, 3, 1, 5].Group(ExcelGroupBy.ByColumns);
sheet.Range[1, 6, 1, 8].Group(ExcelGroupBy.ByColumns);
sheet.Range[1, 9, 1, 15].Group(ExcelGroupBy.ByColumns);

I want to have three groupings. But what I get is one single grouping for column 3 to 15.

Can you help me how to add more then one grouping (not cascaded).

BR
Christoph


Administrator [Syncfusion]
Replied On March 27, 2008 06:24 AM UTC

Hi Christoph,

Thanks for considering Syncfusion.

This is normal behavior of MS Excel also. If you set the first Group range to [1, 3, 1, 4] and second group range to [1, 5, 1, 8], the result will be single grouped range. Please refer the below modified code to get three grouped range in single row.

[C#]
//Group by row
sheet.Range[1, 3, 1, 4].Group(ExcelGroupBy.ByColumns );
sheet.Range[1, 6, 1, 8].Group(ExcelGroupBy.ByColumns);
sheet.Range[1, 10, 1, 15].Group( ExcelGroupBy.ByColumns);

Here is the video clip for MS Excel normal behavior

http://websamples.syncfusion.com/samples/XlsIO.Windows/P42551/main.htm


Please let me know if you need any further assistance.

Best Regards,
Bhuvana



CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;