defaultCellStyle px vs pt inconsistencies

2 posts, 0 answers
  1. Ryan
    Ryan avatar
    14 posts
    Member since:
    Oct 2012

    Posted 09 Jan 2018 Link to this post

    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.
  2. Veselin Tsvetanov
    Veselin Tsvetanov avatar
    1241 posts

    Posted 11 Jan 2018 Link to this post

    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.

    Veselin Tsvetanov
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top