spreadsheetSetRowHidden

Hides or shows a row without deleting its data.

spreadsheetSetRowHidden(spreadsheet, row, hide) → returns void

Argument Reference

spreadsheet any
Required

The spreadsheet object.

row numeric
Required

Row number (1-based).

hide boolean
Required

true to hide the row, false to show it.
Values:
  • true
  • false

Compatibility

RustCFML:

Not supported on wasm32. The third argument is named hidden (default true). Member forms: setRowHidden(row, hidden), hideRow(row), showRow(row), isRowHidden(row).

Examples
Sample code invoking the spreadsheetSetRowHidden function

Hide row 3 and check its hidden state.

wb = Spreadsheet("xlsx");
spreadsheetSetRowHidden(wb, 3, true);
writeDump(wb.isRowHidden(3));

Expected Result: true

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub