Prevents the spread control from double-clicking the header to group

Source: Internet
Author: User

Common grouping code is as follows:

// Set the group information FarPoint. web. spread. sheetView sv = this. fpSpread1.ActiveSheetView; // sets whether the header can be grouped by double-clicking. // sv. allowGroup = true; TPD = new GroupDataModel (sv. dataModel); Session ["dataModel"] = TPD; sv. dataModel = TPD; FarPoint. web. spread. sortInfo [] sort = new FarPoint. web. spread. sortInfo [1]; // you can specify the grouping column and sorting method (1st columns are grouped by default, and the number of columns starts from 0). sort [0] = new FarPoint. web. spread. sortInfo (1, true); TPD. group (sort); // hide the bottom of the Group (usually used for aggregate and so on) // FarPoint. web. spread. model. group group = new Group (TPD, (FarPoint. web. spread. model. group. groups [0], 0, false); // GroupFooter groupfooter = new GroupFooter (group); // FpSpread1.Sheets [0]. groupFooterVisible = true; // set ColumnFooter. The formula for GroupFooter column 1st is Sum, which is used to calculate the addition of all cells in column 5th. // this. fpSpread1.ActiveSheetView. columns [0]. aggregationType = FarPoint. web. spread. model. aggregationType. sum;


This article from the "love dead lonely man" blog, please be sure to keep this source http://chcchb.blog.51cto.com/3592607/1251400

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.