CF 2018 Spreadsheet Functions

October 30, 2018
Newbie 2 posts
Followers: 0 people
2

CF 2018 Spreadsheet Functions

Newbie 2 posts
Followers: 0 people
October 30, 2018

I was working with the set of functions for generating a spreadsheet. I can’t seem to find an answer to freezing only the first row. I tried using the following:

SpreadsheetAddFreezePane(spreadsheetOBJ,1,1)

It ends up freezing the top row, which is what I want, but it also freezes the first column, which I don't want.
The documentation says, "Locks or freezes specific rows or columns in the worksheet.", so I assumed it would allow
freezing only the top row. I tried adding 0 to the column parameter, but that produces an error.

Is there a way to do this?
Comments (2)
2018-11-01 15:48:33
2018-11-01 15:48:33

Someone on Stackoverflow might have a work around too.

Like
(1)
2018-10-31 20:47:11
2018-10-31 20:47:11

Although the error when you enter 0 for the column may be by design, you may still want to submit this as a bug to Adobe.  I think we absolutely should be able to freeze only rows.

As a workaround, you could hide the frozen column:

<cfset SpreadsheetFormatColumn(
spreadsheetOBJ, {
hidden=true
}, 1)>

 

Admittedly, this is not ideal since your spreadsheet now starts at column B.

Like
(2)
Add your comment