The calculation engine was improved with more than 130 new functions, including financial, date & time, math & trig, statistical, lookup & reference, text, logical, information and engineering functions. The functions of Analysis ToolPak Add-In will be fully supported.
The appearance and the formatting of a document can be changed by using a theme. With the help of EasyXLS the user will be able to create, edit and set a theme to an xlsx or xlsb document. The formatting includes a color scheme, a font scheme and an effect scheme, that offers a modern look for the Excel document.