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
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.