When I export an Excel spreadsheet from the Kendo Grid and then open it with Apple Numbers (the spreadsheet app that ships with Mac OS X), I always get font warnings:
"The font Calibri isn't available on OS X. It was replaced with Trebuchet MS.
"The font Cambria isn't available on OS X. It was replaced with Times New Roman."
I updated my Excel-export code to set the font in each cell to "Times New Roman," and even though I can see that font in all the cells in the spreadsheet, I still get font warnings.
Is there a way to fix this so that my Numbers users don't always have to dismiss a font warning when they open the Kendo-exported XLSX files? Thanks!
9 Answers, 1 is accepted
Please accept my apologies for the delayed response.
I'm still trying to obtain a license for Numbers so I can try this locally.
The online version does not output such warnings, but seems to substitute the font for Times New Roman.
Can you send me samples as they come out of the browser and then after saving the same file through Numbers?
The files are plain XML so we should be able to track down the changes.
Apart from that our standard template contains only a reference to Calibri. There's no mention of Cambria.
So I'm not really sure what the problem might be.
Regards,
T. Tsonev
Telerik
Rank 1
Here is a Dojo example that generates a simple XLSX file that exhibits this problem:
http://dojo.telerik.com/@cglendenin/afIPI
I also created two files: foo-original.xlsx is the output of that Dojo example (with the font warnings), and foo-numbers-export.xlsx is the result of using Apple Numbers' File->Export To->PDF... menu item. Unfortunately, your forum software will not allow me to attach them to this post, presumably because an xlsx file is actually a zip file. [Forum says, "The selected file(s) cannot be attached because it may exceed the maximum attachment size (2 MB) or is from not allowed type (allowed: .jpg, .jpeg, .gif, .png, .zip)."] I'd be happy to give you the files if it were possible.
The sample looks pretty standard, so we should be able to reproduce these with any exported file.
Try zipping the files together in a single archive. That should be allowed on the forums.
Regards,
T. Tsonev
Telerik
Rank 1
Rank 1
Thanks for taking the trouble to upload the files.
The files are significantly different, which is expected.
It's somewhat strange that the exported file contains no references to "Trebuchet MS" or "Times New Roman".
On the other hand, it does contain references to Calibri. It's not really clear where the substitution took place.
Anyway, I'll have to spend some time with the actual app to see what triggers this behavior.
In the meantime I'm sending you a "stock" file straight from Excel 2013. Does that one trigger the message?
Regards,
T. Tsonev
Telerik
Rank 1
I think we can safely assume any Excel file will trip this warning unless you have the fonts installed.
I finally managed to get a license for Numbers, but it doesn't trip the error on my test machine. See screenshot.
On the other hand, we have a bunch of MS products installed there that might have added the fonts as well.
After scouring around the internet I found that Open XML File Format Converter for Mac is the safest bet to get those fonts on your system without installing MS Office.
I hope this helps.
Regards,
T. Tsonev
Telerik
Rank 1
I was hoping to find a way to have all the specified fonts be whatever font is common between the platforms, but I can suggest that people install those MS fonts if that solves the problem. It's strange that even if I set every font setting I can find in the Excel exporter to "Times New Roman," I still get font errors, which makes it seems that there is some hidden field or default value in Excel that is still triggering this font warning. You are correct that I do not currently have MS Office installed on my relatively new development machine, which may be why I see these font errors.
Thank you for the help!