var
location =
this
.options.location;
//获取当前控件的位置
var
cr = FR.cellStr2ColumnRow(location);
var
col = cr.col;
//列号
var
ro = cr.row;
//行号
var
t = contentPane.getCellValue(col - 1, ro);
if
(t ==
"居民身份证"
) {
var
value =
this
.getValue();
if
(value.length == 18) {
var
birth = FR.remoteEvaluate(
'=Format(Date(MID('
+ value +
',7,4),MID('
+ value +
',11,2),MID('
+ value +
',13,2)),"yyyy-MM-dd")'
);
//contentPane.setCellValue(col+1,ro,birth);
alert(birth);
}
}
例二:填报定位标志
JS实现填报时对修改过的单元格进行标识-https://help.finereport.com/doc-view-1915.html
var location = this.options.location;
//获取控件的位置
var cr = FR.cellStr2ColumnRow(location);
//单元格列号
var col = cr.col;
//单元格行号
var ro = cr.row;
//设置所在单元格背景色:草绿色
$("tr[tridx="+ro+"]").find("td[col="+col+"]").css("background-color","rgb(153,204,0)");
//设置所在单元格内容:加粗
$("tr[tridx="+ro+"]").find("td[col="+col+"]").css("font-weight","bold");