You can use client-side scripting in Spread to get the value of the active cell. The following code gets the cell value of the active cell on the client side.

<script language="javascript">
  function getactval() {
  var ret FpSpread1.GetValue(FpSpread1.ActiveRow, FpSpread1.ActiveCol);
  }
</script>

For details, refer to GetValue.

You can use client-side scripting in Spread to get the value of a hidden cell. The following code gets the cell value of a hidden cell on the client side.

<script language="javascript">
  function gethidval() {
  var ret = FpSpread1.GetHiddenValue(row,columnName);
  }
</script>

In this code, the row parameter is the index of the row (number) and the columnName parameter is the name of the column (string). Remember, the string for the column name is case sensitive. For details, refer to GetHiddenValue.

Copyright © GrapeCity, inc. All rights reserved.