一、单元格用公式CONCATENATE(''),并在此单元格中设置其它属性,勾选“用HTML显示内容”;
注:其中I3(单元格)为引用的图片网络路径。
二、在分页预览中添加加载结束事件,采用jQuery或者js脚本来处理,代码如下:
var myTable = $('.x-table')[2]; // 取得显示数据的table dom
var rowNo= -1;
var tableId = 'tb';
var inputId = 'show';
var selectedColor = "#FDD899"
var rows = myTable.rows;
for (var i = 0; i < rows.length; i++) {
rows[i].onclick = function() {
rowNo=this.rowIndex;
for(var k=0;k
{
myTable.rows[k].bgColor="#FFFFFF";
try {
myTable.rows[k].style.height = 21 + "px";
myTable.rows[k].cells[9].innerHTML = "";
} catch(e) {}
}
this.bgColor = "#FDD899"
var cell9 = this.cells[9];
var myImg = document.createElement("IMG");
myImg.setAttribute("src", this.cells[8].innerHTML);
myImg.setAttribute("border", 0);
cell9.appendChild(myImg);
this.style.height = 140 + "px";
};
}
function keyDown(e)
{
var currKey = 0, e=e||event;
currKey = e.keyCode||e.which||e.charCode;
if (currKey == 38)
{
for(var k=0;k
{
myTable.rows[k].bgColor="#FFFFFF";
try {
myTable.rows[k].style.height = 21 + "px";
myTable.rows[k].cells[9].innerHTML = "";
} catch(e) {}
}
if(rowNo == 0)
{
rowNo++;
}
myTable.rows[--rowNo%myTable.rows.length].bgColor=selectedColor;
myTable.rows[rowNo%myTable.rows.length].style.height = 140 + "px";
var myImg = document.createElement("IMG");
myImg.setAttribute("src", myTable.rows[rowNo%myTable.rows.length].cells[8].innerHTML);
myImg.setAttribute("border", 0);
myTable.rows[rowNo%myTable.rows.length].cells[9].appendChild(myImg);
} else if (currKey == 40)
{
for(var k=0;k
{
myTable.rows[k].bgColor="#FFFFFF";
try {
myTable.rows[k].style.height = 21 + "px";
myTable.rows[k].cells[9].innerHTML = "";
} catch(e) {}
}
myTable.rows[++rowNo%myTable.rows.length].bgColor=selectedColor;
myTable.rows[rowNo%myTable.rows.length].style.height = 140 + "px";
var myImg = document.createElement("IMG");
myImg.setAttribute("id", "myImg");
myImg.setAttribute("src", myTable.rows[rowNo%myTable.rows.length].cells[8].innerHTML);
myImg.setAttribute("border", 0);
myTable.rows[rowNo%myTable.rows.length].cells[9].appendChild(myImg);
}
}
document.onkeydown = keyDown;