portal entry

select a category, or use search below
(searches all categories and all time range)

CF 2018 Spreadsheet Functions

| View in Portal
October 30, 2018 04:35:12 PM GMT
<p>Help with SpreadsheetAddFreezePanes</p>
<p>The post <a rel="nofollow" href="https://coldfusion.adobe.com/2018/10/cf-2018-spreadsheet-functions/">CF 2018 Spreadsheet Functions</a> appeared first on <a rel="nofollow" href="https://coldfusion.adobe.com">ColdFusion</a>.</p>
Labels: CFML Tag/Function, cfspreadsheet, Question, 2018, cfml tag/function, question


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: <blockquote><cfset SpreadsheetFormatColumn( spreadsheetOBJ, { hidden=true }, 1)></blockquote>   Admittedly, this is not ideal since your spreadsheet now starts at column B.
Comment by Paul Mascari
1335 | October 31, 2018 08:47:11 PM GMT
Someone on Stackoverflow might have a work around too.
Comment by James Mohler
1344 | November 01, 2018 03:48:33 PM GMT