-
Close Search
Newbie
2 posts
Help with SpreadsheetAddFreezePanes
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?
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?
You must be logged in to post a comment.
- Most Recent
- Most Relevant
Someone on Stackoverflow might have a work around too.
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.
