• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • Last Modified:

cf 9.01 spreadsheet -- inserting page break?

Does anyone know how to insert a page break in a "spreadsheet" object created with cold fusion?
0
Javier_Arroyo
Asked:
Javier_Arroyo
1 Solution
 
_agx_Commented:
That's not supported in CF. You'll have to use the POI stuff. Get a reference to the sheet object. Then insert a row or column break, wherever you want


<cfset yourObject = spreadSheetNew()>
....
<cfset theSheet = yourSpreadsheetObject.getWorkBook().getSheet("SomeSheetName")>
<cfset theSheet.setColumnBreak( columnNumber ) >
<cfset theSheet.setRowBreak( rowNumber ) >

Open in new window


You may need to disable the auto page breaks first:

<cfset theSheet.setAutobreaks( false ) >

Open in new window

0
 
Javier_ArroyoAuthor Commented:
This worked perfectly!!
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now