Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Jun 27, 2017 3:57 am

Hi

I have the following code:

Code: Select all
double RowHeightBefore = Sheet.Range["C22"].RowHeight;
Sheet.Range["C22"].Style.WrapText = true;
Sheet.Range["C22"].Value = "Text which is wider than the cell so needs to be wrapped.";
double RowHeightAfter = Sheet.Range["C22"].RowHeight;


However, RowHeightBefore and RowHeightAfter are still showing as being the same even though the row height has been increased. (I can see it when I open the file in Excel.)
How can I get the new row height after the text wrapping has increased the height?

Are there any other ways to check if setting the value of a cell will cause the text to be wrapped?

Thanks

mongoose
 
Posts: 11
Joined: Wed Jan 13, 2016 5:07 pm

Tue Jun 27, 2017 7:23 am

Dear mongoose,

Thanks for your inquiry.
I have noticed the issue and posted it to our Dev team. Once there is any progress, we will let you know.
Sorry for the inconvenience caused.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Thu Aug 24, 2017 8:52 pm

Hi

Can you let me know if this is something that will be fixed?

Thanks

mongoose
 
Posts: 11
Joined: Wed Jan 13, 2016 5:07 pm

Fri Aug 25, 2017 2:51 am

Dear mongoose,

Thanks for your inquiry.
Sorry that there is still no progress due to its complexity. We will let you know as soon as there is any good news.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS