coldfusion - 合并单元格的 CFSpreadsheet 边框

Question

我搜索了一段时间，如果已经有答案，请原谅我。我在使用 CFSpreadsheet 将边框应用于合并的单元格时遇到问题。下面是一些示例代码。

<cfscript>
newSS = SpreadsheetNew('Testing');      //Create Spreadsheet    

SpreadsheetMergeCells(newSS,1,1,1,9);
SpreadsheetAddRow(newSS,'Underline this Header');
SpreadSheetFormatCell(newSS,{bold=true,alignment='center',bottomborder='thin'},1,1);    

Spreadsheetwrite(newSS,expandpath('myTest.xls'),true);  //Write File
</cfscript>

我期望的是顶部单元格一直带有下划线。我得到的是顶部单元格仅通过“A”列加下划线，之后不加下划线。无论如何，这只是CFSpreadsheet的限制吗？

谢谢!

Answer 1

根据POI FAQ's ，即底层库 CF 用于生成电子表格，目前不支持(强调我的):

12. How do I add a border around a merged cell?

Add blank cells around where the cells normally would have been and set the borders individually for each cell. We will probably enhance HSSF in the future to make this process easier.

可能你现在能做的最好的事情就是使用 SpreadsheetFormatCellRange而不是 SpreadSheetFormatCell:

SpreadsheetFormatCellRange ( newSS
                , {bold=true,alignment='center',bottomborder='thin'}
                , 1,1,1,9 );