单元格复制

收藏

在工作表中新增一行，想把上一行单元格中的数据类型、样式、公式等信息复制到新增单元格中，请问该怎么做

iceman · iceman

回复 1楼luozhu1986的帖子

添加行代码：

$(document).ready(function () {
$("#ss").wijspread();
//Create a data table manually.
var sampleTable = [
{"ID":10, "Text":"Text-10", "Check":true},
{"ID":20, "Text":"Text-20", "Check":false},
{"ID":30, "Text":"Text-30", "Check":false},
{"ID":40, "Text":"Text-40", "Check":true},
{"ID":50, "Text":"Text-50", "Check":true}
];
//Bind the data table
$("#ss").wijspread("spread").getActiveSheet().setDataSource(sampleTable);
$("#button1").click(function(){
console.log("The number of all rows in the datasource before addition:" + sampleTable.length);
var activeSheet = $("#ss").wijspread("spread").getActiveSheet();
var row = activeSheet.getRowCount();
//Add rows after the last row
activeSheet.addRows(row, 1);
//Set data.
activeSheet.setValue(row, 0, 100);
activeSheet.setValue(row, 1, "Text-New");
activeSheet.setValue(row, 2, true);
activeSheet.getRow(row).backColor("pink");
//Data table has been updated.
console.log("The number of all rows in the datasource after addition:" + sampleTable.length);
console.log("The value of the Text field in the last row of the datasource: " + sampleTable[sampleTable.length - 1].Text);
});
});

复制代码

iceman · iceman

回复 1楼luozhu1986的帖子

复制格式方法可以参考：

$("#button1").click(function () {
console.log("The number of all rows in the datasource before addition:" + sampleTable.length);
var activeSheet = $("#ss").wijspread("spread").getActiveSheet();
var row = activeSheet.getRowCount();
activeSheet.addRows(row, 1);
activeSheet.setValue(row, 0, 100);
activeSheet.setValue(row, 1, "Text-New");
activeSheet.setValue(row, 2, true);
activeSheet.clipBoardOptions($.wijmo.wijspread.ClipboardPasteOptions.Formatting);
//获取行列数
var columnCount = activeSheet.getColumnCount();
var rowCount = activeSheet.getRowCount();
//清除选择
activeSheet.clearSelection();
//添加选择
activeSheet.addSelection(rowCount - 2, 0, 1, columnCount);
//设置样式
activeSheet.getRow(rowCount - 2).backColor("pink");
//添加公式
activeSheet.getCell(rowCount - 2, 2).formula("=SUM(A1:B1)");
//添加样式
//复制
$.wijmo.wijspread.SpreadActions.copy.call(activeSheet);
// //再次升级
activeSheet.clearSelection();
activeSheet.addSelection(rowCount-1, 0, 1, columnCount);
$.wijmo.wijspread.SpreadActions.paste.call(activeSheet);
activeSheet.repaint();
});

复制代码

如果希望复制公式需要设置以下方法在重新复制：

复制代码

或者您直接把样式设置在 Column 上，在添加行时样式会自动添加，这时只复制公式即可。

		自动登录	找回密码
密码			立即注册

2 个回复