<geregam> wrote in message news:204938@10.0.1.98... I am seeing some odd behavior with C1Report's Excel formatting when the text in the fields are large and can grow is set to true. If CanGrow is true and the field is too big (meaning the field must be grown to accommodate the text), when I export to excel, it seems to mess up the offset of the next page, and their ends up being empty cells that correspond to the height of the previous text field. If I set CanGrow to false, the Excel formatting is better, but the cells which contain a lot of text are not sized to see all the text. Basically, I want to be able to export this to excel and have the rows expand to acccommodate the text in the cell. I would expect CanGrow to do this, but it seems to be miscalculating where the cells need to go when CanGrow is set. I've attached a sample Report Definition (based on the nwind access db) and two sample exports, one with the two larger text fields set to CanGrow=True, the other with CanGrow=false. Has anyone run into a similar situation and found a fix? http://helpcentral.componentone.com/cs/forums/p/75274/204938.aspx#204938
The zip file from my initial post contains a sample report definition and the NWind db.
We are using the latest report designer (I believe it's .288)