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,
Hello Kobie,
Were you able to wrap up a sample for us in order to investigate this further?
Thanks.
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.