Replies: 1 comment
-
After comparing a functioning file with the one generated by exceljs, I observed some discrepancies in the XML. With this workaround, it now works for me. I will attempt to submit it as a pull request if I have the time. Currently the library doesn't support worksheet.addImage(imageId, {
tl: {
col: 1,
row: row.number - 1,
nativeCol: 1,
nativeColOff: 36000,
nativeRow: row.number - 1,
nativeRowOff: 36000,
},
br: {
col: 1,
row: row.number - 1,
nativeCol: 1,
nativeColOff: 1332000,
nativeRow: row.number - 1,
nativeRowOff: 504000,
},
editAs: "twoCell",
}); Here are the attachment to compare two drawing versions : |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I made a worksheet with an image in each row. When I filter or remove a row, the image of that row remains.
tested on v4.4.0 / v4.3.0
I tried different way of adding images, but none of them worked , my first assumption was maybe since there is no functionally for Place in cell
I suspect that there might be an issue, or I could be approaching it differently.
Any assistance would be greatly appreciated.
this is the result
![Screenshot 2024-01-04 at 16 20 17](https://private-user-images.githubusercontent.com/14098200/294221316-a14b6019-f6cd-4ca2-a271-89f318bc9b21.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTkwNjk1ODEsIm5iZiI6MTcxOTA2OTI4MSwicGF0aCI6Ii8xNDA5ODIwMC8yOTQyMjEzMTYtYTE0YjYwMTktZjZjZC00Y2EyLWEyNzEtODlmMzE4YmM5YjIxLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MjIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjIyVDE1MTQ0MVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTIyODdlNmIwMGJkMGMzODRiMDViZGQ1NDJlNmYyMzBiMzllZjZmZTc0ZTQ3MmJiYTc3NjU1NjAwZTA0YWFjMzgmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.DFNKbAYsa5el1QInjtLq8EPT7gAtEnN1_F3CDCkX67M)
after applying filtering
![Screenshot 2024-01-04 at 16 20 38](https://private-user-images.githubusercontent.com/14098200/294221672-d59bd260-1f98-4cd8-8e1a-231c1dd301c7.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTkwNjk1ODEsIm5iZiI6MTcxOTA2OTI4MSwicGF0aCI6Ii8xNDA5ODIwMC8yOTQyMjE2NzItZDU5YmQyNjAtMWY5OC00Y2Q4LThlMWEtMjMxYzFkZDMwMWM3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MjIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjIyVDE1MTQ0MVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWQwODMzOGRjYWRiODBlMzZkMzBlOTBhZmU0N2FmOTcwODhiOWRmODFjZDlhODZlYjEyNzE3YjQ4NGYzNzIyMWEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.4P2MeLV3WfSL8Fwpn9yUQtrIdnXHXbumNJYAiA_EtXo)
After removing a row
![Screenshot 2024-01-04 at 16 20 51](https://private-user-images.githubusercontent.com/14098200/294221666-4fea8df7-489d-4959-9eaa-f6c319bcc870.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTkwNjk1ODEsIm5iZiI6MTcxOTA2OTI4MSwicGF0aCI6Ii8xNDA5ODIwMC8yOTQyMjE2NjYtNGZlYThkZjctNDg5ZC00OTU5LTllYWEtZjZjMzE5YmNjODcwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MjIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjIyVDE1MTQ0MVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWY1ZWM1ZGZlZmY2MGFhM2E0YzcwYzZkNmZkMTE1YzMzNDdkMzY5MDk1NTNlZjY4NjgwMGQzZjdhODdiMzhmODQmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.hOB5zOSL_OuTx3kGEbnJdiqiilgLBFuTFRw0D3xu9JQ)
Beta Was this translation helpful? Give feedback.
All reactions