defaultCellStyle px vs pt inconsistencies

[Ryan]

It doesn't seem to be possible to make the exported Excel spreadsheet look the same as the kendo spreadsheet.  Excel goes by pt whereas the browser goes by px.  So setting "defaultCellStyle": {"fontFamily": "Arial","fontSize": "12"} makes the browser spreadsheet look like I want it, but when exporting to Excel it is interpreting it as 12pt, which is a much larger font than it should be and the values in cells turn to #####.  An Arial 12px in the browser should be equivalent an Arial 9pt in Excel.

I have tried doing like "fontSize": "12pt", but that causes an error in the exported Excel file.

It seems like the best way to handle this would be to allow us to specify "fontSize": "12pt", or add like "fontUnit": "pt" so that the browser css user pt instead of px.  Or a way to specify two different defaultCellStyle fontSizes, one for browser spreadsheet and one for exports. 

See attached picture as example of browser vs export.

[Veselin Tsvetanov]

Hi Ryan,

Thank you for the detailed explanation of the case and for the suggested improvement of the Spreadsheet widget. You are correct, that the Kendo Spreadsheet will always interpret the fontSize in px units.

Therefore, I would recommend you to log your idea on our Feedback portal. Based on the support it receives from the community, we will decide on whether to proceed with its implementation or not.

Regards,
Veselin Tsvetanov
Progress Telerik