I am trying to export a grid with different row heights.
I have AutoSizeRows = true.
On the apps screen the grid looks great. :)
But when I export it I get an error:
rowHeight should be greater or equal than 0 and less or equal than 600.
spreadExporter.CellFormatting += spreadExporter_CellFormatting;
I have a spreadExporter_CellFormatting function and had:
if (e.GridCellInfo.RowInfo.Height > 600)
{
e.GridCellInfo.RowInfo.Height = 600;
};
But it didnt stop the error happening.
Question, how do I check for the Row height value and set it before/during the export?
Thanks
Deasun.
1 Answer, 1 is accepted
Hello Deasun,
Thank you for reporting this.
After testing the described scenario I was able to receive the same exception when there is a row with RowHeight > 600. This is why I have logged it in our Feedback portal by creating a public thread on your behalf. You can track its progress, subscribe for status changes, and add your comments on the following link: feedback item.
I have updated your Telerik Points.
To workaround the issue you can create a custom SpreadExportRenderer and override its SetWorksheetRowHeight method:
class MySpreadExportRenderer : SpreadExportRenderer
{
public override void SetWorksheetRowHeight(int rowIndex, int rowHeight, bool isCustom)
{
if (rowHeight > SpreadsheetDefaultValues.MaxRowHeight)
{
rowHeight = (int)SpreadsheetDefaultValues.MaxRowHeight;
}
base.SetWorksheetRowHeight(rowIndex, rowHeight, isCustom);
}
}
I hope this helps. Do not hesitate to contact me if you have other questions.
Regards,
Nadya
Progress Telerik
Our thoughts here at Progress are with those affected by the outbreak.