Need a special offer?Find out if your project fits.
+

How to pass the excel style property.

Answered
Karthik asked on July 22, 2019

Hi,
In our application we are using flexmonster.exportTo to generate the excel report. The excel’s generated through flexmonster are broken and getting error while opening the file. I have modified the excel file to zip file for analyzing the styles.xml and found the font format is not as assigned. I have assigned the font as “Open Sans” in .less style sheet, but the style changed to “”Open Sans”” in styles.xml. Removing the extra quotes in styles.xml resolving the problem and able to open the file without error.
Styles.xml:
Incorrect: <font><sz val=”8″/><color rgb=”FF000000″/><name val=””Open Sans””/></font>
should be: <font><sz val=”8″/><color rgb=”FF000000″/><name val=”Open Sans”/></font>
How can we ignore this and what is better way to designate the font?

2 answers

Public
Vera Didenko Vera Didenko Flexmonster July 23, 2019

Hello,
 
Thank you for reaching out to us.
 
We have managed to reproduce the issue on our side.
Our team has noticed that the warning occurs when the showFilters parameter is specified. The warning is not shown when this parameter is not specified. However, in this case the font is not applied.
 
Here is a JSFiddle example for illustration.
 
We will research this problem further and we will inform you about the results on the 12th of August.
 
Please feel free to write to us in case any questions arise.
 
Best Regards,
Vera

Public
Vera Didenko Vera Didenko Flexmonster August 14, 2019

Hello,
 
We are pleased to inform you that the issue with applying grid fonts in the Excel export file was fixed.
 
This is included in the 2.7.12 version of Flexmonster: https://www.flexmonster.com/release-notes/
 
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/
 
Please let us know if everything works fine for you.
 
Best Regards,
Vera

Please login or Register to Submit Answer