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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

WrapText deforms my pictures

Thread ID:





77655 Nov 11,2008 01:54 PM UTC Nov 21,2008 12:29 PM UTC ASP.NET Web Forms (Classic) 3
Tags: XlsIO
Martin Constam
Asked On November 11, 2008 01:54 PM UTC

1. I added some traffic light symbols into the sheet:
if (data.Columns[j].ColumnName.Contains("Ampeln."))
IPictureShape pic = sheet.Pictures.AddPicture(row, column, AppGlobal.ImagesDirAbs + "Status" + data.Rows[i][j].ToString() + ".gif",100,100);
pic.Left += (int)Math.Round(sheet.Range[row, column].ColumnWidth * 3);

2. I filled the column Y with a text and set:
sheet.Range["Y" + rowStart.ToString() + ":Y" + rowEnde.ToString()].WrapText = true;

Using WrapText deforms my traffic light symbols (see attachment)

How can I avoid the deforming of the images?

Thanks for your answer.



Geetha M [Syncfusion]
Replied On November 12, 2008 12:35 PM UTC

Hi Martin,

Thank you for the details.

I am able to see the issue in the image. Could you please send us the original file and the image so that we could recreate and find the cause of the issue?

Please let me know if you have any difficulties.


Martin Constam
Replied On November 21, 2008 10:58 AM UTC

HI Geetha,

I have attached a small VS 2008 project that enables you to recreate the issue with the deformed pictures.

Before you run the solution please correct the variable "m_data" in generateExcel.cs. It must point to the data folder in the solution.

Thanks for your help


Geetha M [Syncfusion]
Replied On November 21, 2008 12:29 PM UTC

Hi Martin,

Thank you for the details.

I was able to reproduce the issue in your sample. This occurs as the WrapText is set for Columns Y and AA. This is suspected to be a defect and has been forwarded to our developers for more analysis. Please create a direct trac incident so that we could update you with the status of this issue.

Meanwhile, instead of going for WrapText, could you please consider increasing ColumnWidth as a workaround? The following code snippet illustrates this:

sheet.Columns[24].ColumnWidth = 70;
sheet.Columns[26].ColumnWidth = 90;

You may still need to scroll to view the text, but this would give a better view than no wraptext.

Please let me know if you have any questions.



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