Description
I receive a small .png image as MQTT payload encoded as base64 string. I want to display that image inside a sheet
Steps to Reproduce
-
receive mqtt payload abse64 encoded png into cell G3
=READ(INBOXDATA(,,"value"),G3,"String",,FALSE)
-
prepend "data:image/png;base64, to it and set it as fillpattern on a rectangle
=DRAW.RECTANGLE("523506426300","Rectangle10","Rectangle9",7078,2699,14155,4763,,FILLPATTERN(CONCAT("data:image/png;base64,",G3)))
-
launch sheet and process messages, tried time based and msg based
Expected behavior:
newly incoming image overwrites current image flawlessly
Actual behavior:
before the old image is overwritten, it is replaced by a white image, regardles sof the set background, or another colored shape behind
Reproduces how often:
continously
Versions
2.2 - even when I launch the update.sh script, thats the version I get
just look at the small videoclip
top image hase a black rectangle behind, bottom one diretly on sheet
https://user-images.githubusercontent.com/28755821/124262422-54a6d700-db32-11eb-9e0d-415937573712.mp4
Description
I receive a small .png image as MQTT payload encoded as base64 string. I want to display that image inside a sheet
Steps to Reproduce
receive mqtt payload abse64 encoded png into cell G3
=READ(INBOXDATA(,,"value"),G3,"String",,FALSE)
prepend "data:image/png;base64, to it and set it as fillpattern on a rectangle
=DRAW.RECTANGLE("523506426300","Rectangle10","Rectangle9",7078,2699,14155,4763,,FILLPATTERN(CONCAT("data:image/png;base64,",G3)))
launch sheet and process messages, tried time based and msg based
Expected behavior:
newly incoming image overwrites current image flawlessly
Actual behavior:
before the old image is overwritten, it is replaced by a white image, regardles sof the set background, or another colored shape behind
Reproduces how often:
continously
Versions
2.2 - even when I launch the update.sh script, thats the version I get
just look at the small videoclip
top image hase a black rectangle behind, bottom one diretly on sheet
https://user-images.githubusercontent.com/28755821/124262422-54a6d700-db32-11eb-9e0d-415937573712.mp4