I have a simple program that does nothing more than Load an XLS file and writes it back out. Row formatting information is lost. I've attached a sample spreadsheet and the code for the sample application. For instance, row 70 in the original file was resized by the user, but when the file is saved back out, the row's size has reverted to the default row size, thus making the text appear truncated.
I discovered this when opening the spreadsheet and asking each row for it's height - they all returned the default row height, which in the original file, isn't the case.
Is there something that I need to do to preserve the original formatting/style information?
Note: (Give the sample app a moment to present the file open dialog)