- Notifications
You must be signed in to change notification settings - Fork1.9k
Open
Labels
Description
I set custom column width while defining sheet columns. When adding an image using coordinate (50% column to use), the image don't respect my custom width.
Additional explanation:#650 (comment)
Code :
sheet.columns=[{header:'Id',key:'id',width:10},{header:'Name',key:'name',width:32},];varimageId2=workbook.addImage({base64:myBase64Image,extension:'png',});sheet.getColumn(4).width=38;// sheet.addImage(imageId2, 'B2:D6');sheet.addImage(imageId2,{tl:{col:1,row:1},br:{col:1.5,row:4}});sheet.addImage(imageId2,{tl:{col:3,row:1},br:{col:3.5,row:4}});workbook.xlsx.writeBuffer({base64:true}).then(function(xls64){// donevardata=newBlob([xls64],{type:"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});saveAs(data,"output.xlsx");});
Actual result :
Expected result:
