With the F1 race suspended owing to rain in Malaysia, I had the chance to play around with some code and can confirm your findings. There is a difference between the xml created using the setRowStyle() method and hiding the row using Excel. The latter actually sets a hidden attribute on the row record whereas the former creates a style in the styles.xml file and links the row record to that. I do wonder - and that is wonder - if the setRowStyle() method creates a record that applies the style to the cells the row contains rather than the row itself; I do not know this and have not tested it but it might be the case. For now, I suggest you take tcole6's suggestion and set the row height to 0; there are two ways to accomplish this, either setRowHeight((short)0) or setZerHeight(true).
-- View this message in context: http://apache-poi.1045710.n5.nabble.com/Trouble-with-hiding-rows-in-Excel-tp5590626p5592989.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
