Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Range.Group Method - group rows, not columns

Hello,
I use the

Range.Group Method
_______________
When the Range object represents a single cell in a PivotTable field’s
data range, the Group method performs numeric or date-based grouping
in that field.

Namespace: Microsoft.Office.Interop.Excel
______________

after performing the groupment, I noticed that the groupment was in
columns, not in rows, as I expected. how can I group in rows? is there
a option to group rows or columns?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Range.Group Method - group rows, not columns

The code is in C#, i - an

for(int i = upperLine, i < lowerLine, i++)
{
currentCell = worksheet.get_Range(string.Format("A{0}", i),
Missing.Value);
currentCell.Group(Missing.Value, Missing.Value, Missing.Value,
Missing.Value);
}



thanks
On May 7, 2:29 pm, serhio wrote:
Hello,
I use the

Range.Group Method
_______________
When the Range object represents a single cell in a PivotTable field’s
data range, the Group method performs numeric or date-based grouping
in that field.

Namespace: Microsoft.Office.Interop.Excel
______________

after performing the groupment, I noticed that the groupment was in
columns, not in rows, as I expected. how can I group in rows? is there
a option to group rows or columns?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does Range.Group() method crash after 7 calls? serhio[_2_] Excel Programming 1 April 26th 08 11:29 AM
Range.Group() method fails after 7 calls serhio[_2_] Excel Programming 0 April 24th 08 06:39 PM
Group a range - closing the group does not hide the controls.... [email protected] Excel Programming 0 April 21st 07 04:53 AM
TRANSPOSE 'group' of columns to rows tom Excel Discussion (Misc queries) 1 December 14th 06 07:19 AM
to convert columns to rows having mulit independent group columns Quacy Excel Worksheet Functions 1 August 22nd 06 11:20 PM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"