Spread for ASP.NET 7.0 Product Documentation
GetColCount
See Also Support Options
Spread for ASP.NET 7.0 Product Documentation > Client-Side Scripting Reference > Scripting Members > Methods > GetColCount

Glossary Item Box

Gets the number of columns in the displayed page.

Syntax

[JavaScript]

var ret = FpSpread1.GetColCount();

Parameters

None

Return Type

Integer, number of columns

Remarks

This method returns a count of the columns in the displayed spreadsheet on the client. For a count of the rows, refer to GetRowCount.

Example

This is a sample that uses the method to count the columns in order to create a grand total of all the subtotals from each column and put the result in the first column. On the client side, the script that contains the method would look like this:

JavaScript Copy Code
<SCRIPT language=javascript>
   function doCalc() {
     var colcount = FpSpread1.GetColCount();
     var total = 0;
     for (var i=1; i<colcount-1; i++) {
       var subtotal = parseFloat(FpSpread1.GetValue( 10,i ));
       total += subtotal;
     }
     if (!isNaN(total))
       FpSpread1.SetValue(10, 0, total, true);
   }
</SCRIPT>

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.