我这边试了下,是可以设置高度的,
- let commentsText = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10].map(item => {
- return `版本${item}时间:2022-08-08`
- }).join(' \n');
- sheet.bind(spreadNS.Events.SelectionChanging, function (e, info) {
- var sheetTmp = info.sheet;
- var row = sheetTmp.getActiveRowIndex();
- var col = sheetTmp.getActiveColumnIndex();
- var comment = sheetTmp.comments.get(row, col);
- if (comment) {
- setTimeout(function () {
- comment.text(commentsText).height(800); //修改值,设置高度
- }, 100)
- }
- })
复制代码
|