spreadsheetSetRepeatingColumns

Sets the print-title columns of the active sheet in a spreadsheet workbook, so the given column range repeats at the start of every printed page. The range is an A1 address such as "A:B" or "$A:$C". Implemented via the _xlnm.Print_Titles defined name. The fluent member form is setRepeatingColumns(columns).

spreadsheetSetRepeatingColumns(spreadsheetObj, range) → returns any

This function requires RustCFML.  Not supported on Lucee, Adobe ColdFusion, etc.
  1. CFDocs
  2. Functions
  3. All CFML Functions
  4. spreadsheetSetRepeatingColumns
  5. RustCFML
  6. 0 Issue
  7. Edit
See Also:   spreadsheetSetRepeatingRows   spreadsheetNew

Argument Reference

spreadsheetObj any
Required

The spreadsheet workbook object.

columns string
Required

A1 address of the column range to repeat on every printed page, e.g. "A:C".

Compatibility

RustCFML:

Not supported on wasm32.

Examples
Sample code invoking the spreadsheetSetRepeatingColumns function

Columns A through B repeat on every printed page.

wb = Spreadsheet("xlsx");
spreadsheetSetRepeatingColumns(wb, "A:B");

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

Fork me on GitHub