Forums Ultimate UI for ASP.NET Web Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Kobie Burrell
1070
DefaultRowHeight in Excel
posted

Whenever I create a new Worksheet object, I set the DefaultRowHeight property to 15. This seems to work, as long as I don't set the individual height on any rows in the sheet. For example, if I set the Height of a row, like so:

worksheet->Rows[whichRow]->Height = 2460; //Make room for extra stuff

It somehow causes all of the other rows to have a height of 12.75 (255 twips) in the saved Excel sheet. If I comment out that line, the saved Excel sheet has rows with all heights set to 15, which corresponds to my DefaultRowHeight of 300.

How do I get this to work correctly?

thanks,

  • 71886
    Offline posted

    Hello Kobie,

    Were you able to wrap up a sample for us in order to investigate this further?

    Thanks.

  • 49378
    posted

    Hello Kobie,

    I am currently looking into this matter in order to try and reproduce the described issue. Any samples illustrating the behavior directly would be greatly appreciated. I will keep you posted of any available information regarding this matter.