31
Views
10
Comments
Solved
[Advanced Excel] Advanced excel Image positioning
advanced-excel
Service icon
Forge component by Carlos Freitas
Application Type
Reactive

Hello can someone help me how to position this image i want it on Row1 Col. 1 or "A1" but still the image is in wrong position. i also tried the excell_writeImageByName and byIndex it has same results Thank you in advance



 
MVP
Solution

Hi @Glen Gutlay 

The issue should be resolved in the latest version.

Hanno

UserImage.jpg
Glen Gutlay

its working thanks for your help


Hi Glen. 

The action Image_Insert has the parameters MarginTop and MarginLeft, that might help you place the image. 

UserImage.jpg
Glen Gutlay

I tried this margin. but the result is the same

Hi @Glen Gutlay 

1. Resize all the cell row width and height according to your need using excel, store that excel in resources then use that excel and write on it 

2. You can make use of ( image resize util ) component which is available in forge before writing into cell so that it can fit in a cell perfectly 


Thanks 

UserImage.jpg
Glen Gutlay

hello thank you for response. Its not working


Could you post screenshots of what you're trying to achieve and what it's happening? 

UserImage.jpg
Glen Gutlay

 i want the image to put on row 1 col 1 or "A1' but this is the outcome

Screenshot 2023-10-17 073610.png
 
MVP

Hi @Glen Gutlay 

I believe there is a bug with this that someone reported a while back but I haven't had a chance to look into it yet.

As a workaround, without having tested it myself, could you try adding an extra row at the top and column on the left, then insert the image at "A1" (which will actually add the image to "B2"), then delete the extra row and column and your image should be positioned where you are expecting.

Hope this helps.

Hanno

 
MVP
Solution

Hi @Glen Gutlay 

The issue should be resolved in the latest version.

Hanno

UserImage.jpg
Glen Gutlay

its working thanks for your help


Hello, I'm having the same problem, the image is not in the correct position, what should I do?

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.