We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

XlsIO Image Marker, fixed height not width

Thread ID:

Created:

Updated:

Platform:

Replies:

147141 Aug 31,2019 03:27 AM UTC Sep 4,2019 02:11 PM UTC WinForms 3
loading
Tags: XlsIO
John
Asked On August 31, 2019 03:27 AM UTC

I need to set the image %Reports.Image;size:60 will set image width to 60 and height is not fixed, but I need to do opposite, I need to define height not width, it should be calculated itself by ratio. Is there any way to do that ?

Abirami Varadharajan [Syncfusion]
Replied On September 3, 2019 05:33 PM UTC

Hi John, 

Greetings from Syncfusion. 

While applying marker with image using size argument, you need to specify both height and width. When width value is only given, it considers the width value as height’s value. So, we request you to specify the width by using below calculation to achieve your requirement. 
 
Code Example: 
float height = 80; 
float width = (float)(height * height / 100.0); 
worksheet["A4"].Text = "%Reports.Image;size:" + width + "," + height; 
 
Please refer to below documentation to know about the syntax of Image arguments and its purpose in detail. 

 
Regards, 
Abirami 


John
Replied On September 3, 2019 05:52 PM UTC

Hi John, 

Greetings from Syncfusion. 

While applying marker with image using size argument, you need to specify both height and width. When width value is only given, it considers the width value as height’s value. So, we request you to specify the width by using below calculation to achieve your requirement. 
 
Code Example: 
float height = 80; 
float width = (float)(height * height / 100.0); 
worksheet["A4"].Text = "%Reports.Image;size:" + width + "," + height; 
 
Please refer to below documentation to know about the syntax of Image arguments and its purpose in detail. 

 
Regards, 
Abirami 


that defeats the purpose of template marker, first I have to find the cell that has the required image marker, then replace its text for height and width.
Why not just place the image there by code instead of using marker.

You should add the auto ratio feature in future release.

Abirami Varadharajan [Syncfusion]
Replied On September 4, 2019 02:11 PM UTC

Hi John, 
 
We consider your requirement for “Applying marker image with auto ratio” and logged a feature report for the same. We will include the implementation in our upcoming release which will be available by end of September 2019. 
 
You can track the status of the feature through the following feedback. 
 
 
Regards, 
Abirami. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon