Math Formulas<\/h5>\n
The highlight of the release is the introduction of math functions<\/a> for defining relationships between values in the Spreadsheet. Starting with 4.0, DHTMLX Spreadsheet includes 25 math formulas and 9 string functions. They are predefined and do not require any coding. The built-in functions correspond with the ones used in Excel and Google Sheets.<\/p>\n Let\u2019s get acquainted with some of the functions available in DHTMLX Spreadsheet. Apart from the commonly used SUM, AVERAGE, COUNT, MIN, and MAX functions, there is a range of more complicated formulas. For example, the POWER function is equivalent to an exponent in math. The SQRT function calculates the positive square root of a number. The SUMSQ function returns the sum of the squares of arguments.<\/p>\n The string functions serve to manipulate text and present information in the desired way. Thus, you can convert lowercase letters to uppercase ones, shorten the text to a specified number of letters, join separate text strings into one string, and much more.<\/p>\n We have prepared a special cheatsheet<\/a> with all the 34 functions available in DHTMLX Spreadsheet to help you choose and apply the necessary formulas for your project.<\/p>\n Another important feature for a truly Excel-like experience is the ability to freeze columns<\/a> on the left side of the Spreadsheet. V4.0 enables you to freeze as many columns as you need using the leftSplit<\/strong> property:<\/p>\n Check the sample ><\/a><\/p>\n As we are dedicated to supporting TypeScript in all DHTMLX components, we have provided built-in type definitions in DHTMLX Spreadsheet 4.0. No more struggling with methods and properties. Type suggestions, autocompletion, and type checking will prevent code errors and speed up your work.<\/p>\n Previously, DHTMLX Spreadsheet offered four default types of formats: number, percent, and currency formats and a common format for unformatted values. In v4.0 we have added the text format<\/a> as the fifth default format type. Check the sample ><\/a><\/p>\n In addition to new functionality, we have worked on the improvement of existing Spreadsheet features. For instance, we have added a new keyboard shortcut “Ctrl+Shift+Left Click” for selecting several scattered data ranges at once. You can check the list of all fixes and updates in the documentation<\/a>.<\/p>\n We do hope that the newly released update will help you accomplish your web development projects and complement your JavaScript toolkit. Feel free to send us your comments via the comment section below.<\/p>\n As always, current clients may find the latest version in their Client’s Area<\/a>.<\/p>\n If you are new to DHTMLX Spreadsheet, we invite you to download and test the latest version 4.0<\/a> free of charge for 30 days.<\/p>\n The autumn season of 2020 is rich in updates of the DHTMLX JavaScript libraries. Here comes the major release of the Spreadsheet component intended for the convenient processing of …<\/p>\n","protected":false},"author":101012,"featured_media":7802,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70,1,38],"tags":[33,34,41,4],"class_list":["post-7778","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-releases","category-uncategorized","category-visible","tag-all-posts","tag-spreadsheet","tag-typescript","tag-dhtmlx-updates"],"_links":{"self":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/7778","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/users\/101012"}],"replies":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/comments?post=7778"}],"version-history":[{"count":29,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/7778\/revisions"}],"predecessor-version":[{"id":12716,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/7778\/revisions\/12716"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/media\/7802"}],"wp:attachment":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/media?parent=7778"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/categories?post=7778"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/tags?post=7778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Math](\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2020\/10\/Spreadsheet.gif\")
<\/p>\n![\"POWER](\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2020\/10\/POWER_Formula.gif\")
<\/p>\n![\"String](\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2020\/10\/String.gif\")
<\/p>\nFrozen Columns<\/h5>\n
\n leftSplit:<\/span>2<\/span>
\n}<\/span>)<\/span>;<\/span><\/div><\/div>\n![\"Freeze](\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2020\/10\/Freeze-columns.gif\")
<\/p>\nTypeScript Support<\/h5>\n
Text Format<\/h5>\n
\n![\"Text](\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2020\/10\/Text-format.png\")
<\/p>\nOther Improvements<\/h5>\n
Related Materials:<\/h5>\n
\n
\n<\/p>\n","protected":false},"excerpt":{"rendered":"