Data grouping issue (Column Data not moved)

Posted by: shimwootae on 8 September 2017, 3:19 pm EST

  • Posted 8 September 2017, 3:19 pm EST

    Hello, all.

    I have developed a program with spread studio v.8. but I have one issue using spread data group function.
    The issue is that column is not moved when I move a column to group bar and drag a column from group bar and drop it to first of columns.
    For example,
    1. I have a "DTTbl" datatable which has a 3 columns("AAA","BBB","CCC") and 3 rows with any data.
    2. I have a "Sprd" spread which has each specified column name("SprdCol1","SprdCol2","SprdCol3")
    3. Data bind a "DTTbl" datatable to "Sprd" using Datasource method.
    4. The "Sprd" options are 'Sprd.AllowColumnMove = True' and 'Sprd.ActiveSheet.Allowgroup = True' and 'Sprd.ActiveSheet.GroupBarInfo.Visible = True'
    5. Move the "AAA" column to next of "BBB" column.
    6. Drag the "AAA" column to grouping bar.
    7. Drag the "AAA" column from grouping bar and drop it in front of "BBB" column
    then, the data in "AAA" column located next of "BBB" column, is not moved and only column label is changed.
    so it looks like the data of "AAA" column and "BBB" column are exchanged.

    what is this happening??..

    if anyone knows how to solve this problem, please inform me that to solve this problem.

    Thank you
  • Replied 8 September 2017, 3:19 pm EST


    I was unable to reproduce the problem with the steps you provided. Are there any other properties that are being set? Also in regards to #5, what did you mean by "Move the “AAA” column to next of “BBB” column."? Did you mean that you moved the "AAA" column so that the order of the columns was "BBB"-"AAA"-"CCC"?

  • Replied 8 September 2017, 3:19 pm EST

    Hello, Kevin.
    Thank you for your reply.
    I am writing you a sample source using C#. And there was nothing another options on spread designer mode.
    Also about #5 step mean is 'Drag 'AAA' column and drop it next of "BBB" column. so it will be 'BBB'-'AAA'-'CCC'.

    private void Form1_Load(object sender, EventArgs e)
    DataTable aaa = new DataTable();
    aaa.Rows.Add("111", "222", "333");
    aaa.Rows.Add("111", "222", "333");
    aaa.Rows.Add("111", "222", "333");
    fpSpread1.ActiveSheet.Columns[0].Label = "SprdCol1";
    fpSpread1.ActiveSheet.Columns[1].Label = "SprdCol2";
    fpSpread1.ActiveSheet.Columns[2].Label = "SprdCol3";
    fpSpread1.DataSource = aaa;
    fpSpread1.ActiveSheet.DataAutoHeadings = true;
    fpSpread1.ActiveSheet.DataAutoCellTypes = false;
    fpSpread1.ActiveSheet.DataAutoSizeColumns = false;
    fpSpread1.AllowColumnMove = true;
    fpSpread1.ActiveSheet.AllowGroup = true;
    fpSpread1.ActiveSheet.GroupBarInfo.Visible = true;

    Also, I am writing you action steps with image file. It would help you to understand easier.
    At a last picture in image file, Data of 'Sprdcol1' spread column and 'SprdCol2' spread column are exchanged.
    I think that most important step to occur this issue is specifying spread column name(Step #2).

    I am waiting your reply.

    Thank you

  • Replied 8 September 2017, 3:19 pm EST



    Thank you for the detailed steps and the image.
    I could replicate the issue mentioned by you and hence I am escalating the same to the concerned team (tracking id : 126916).

    I will get back to you as soon I hear anything from them.

  • Replied 8 September 2017, 3:19 pm EST


    Your issue has been fixed with Spread Studio 9. You can download the latest build of Spread which is Spread Studio 9 with build version 9.0.20153.0 from the following link:-

    Hope it helps.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels