This is a migrated thread and some comments may be shown as answers.

Line height in Excel export

1 Answer 178 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Jean-Luc
Top achievements
Rank 1
Jean-Luc asked on 10 Jul 2017, 09:22 AM

Hi,

We use the Excel export feature of your component.

In the export I have few cells that contains multi-line text.

In the exported file, the line height is set to the default value.

Is it possible to set the line height to some kind of "auto" to fit the content and expand if necessary ?

Best regards

Emmanuel

1 Answer, 1 is accepted

Sort by
0
Stefan
Telerik team
answered on 12 Jul 2017, 06:38 AM
Hello Emmanuel,

The height of the rows can be modified on the excelExport event of the Grid by setting the height property of the row to the desired value:

http://docs.telerik.com/kendo-ui/api/javascript/ui/grid#events-excelExport

http://docs.telerik.com/kendo-ui/api/javascript/ooxml/workbook#configuration-sheets.rows.height

http://dojo.telerik.com/otuNe

The width of the columns can also be modified:

http://docs.telerik.com/kendo-ui/framework/excel/column-width#column-width

Regards,
Stefan
Progress Telerik
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Grid
Asked by
Jean-Luc
Top achievements
Rank 1
Answers by
Stefan
Telerik team
Share this question
or