Let\u2019s delve into the details.<\/p>\n
Extra Manipulations with Rows and Columns<\/h5>\n
DHTMLX Spreadsheet is known for being flexible in terms of the table’s structural organization. Our Spreadsheet already include plenty of operations that can be done to adjust the spreadsheet structure for more effective data right from the UI. In v5.2, we expanded the arsenal of available operations for columns and rows:<\/p>\n
- \n
- Hiding columns and rows<\/a><\/li>\n<\/ul>\n
From now on, any number of columns and rows in a spreadsheet can be hidden via the corresponding option in the cells\u2019 context menu or via the toolbar buttons. Hidden elements will be marked with horizontal and vertical arrows for columns and rows respectively. If needed, a single click on these arrows will make the required elements visible again.
\n![\"hiding](\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2025\/05\/image4-ezgif.com-speed.gif\")
Check the sample ><\/a><\/p>\n- \n
- Freezing columns and rows<\/a><\/li>\n<\/ul>\n
Previously, you could freeze columns and rows via the API only. For v5.2, our team decided not only to rewrite this functionality for developers’ convenience, but also to bring it to the UI side, opening the opportunity to easily freeze or unfreeze any number of rows and columns on the fly. It can be done via the Edit menu, toolbar buttons, and cells\u2019 context menu.
\n![\"freezing](\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2025\/05\/image3-ezgif.com-speed.gif\")
Check the sample ><\/a><\/p>\nIn both samples above, we showed how to hide and freeze columns and rows using the context menu, while other options for performing these operations are fully covered in the user guide<\/a>.<\/p>\n
From a developer\u2019s perspective, performing hide and freeze operations via the API involves using new methods, which are thoroughly described in the developer guide<\/a>.<\/p>\n
With freezing and hiding options at hand, developers and end-users gain greater control over data presentation in the spreadsheet. This contributes to more convenient comparison and analysis of information, which can be vital in data-heavy apps.<\/p>\n
Multiple Border Styling Options<\/h5>\n
Spreadsheets often contain large volumes of data with varying degrees of relevance and importance. Therefore, it is helpful to highlight certain parts of the table to make them more noticeable. It is especially useful in collaborative environments, where this styling novelty can help draw users\u2019 attention to important pieces of data in large tables and keep everyone on the same page. <\/p>\n
The updated DHTMLX Spreadsheet allows making styling adjustments to borders<\/a> of a selected cell or group of cells. With this feature, it becomes easy to visually separate and highlight specific data blocks, improving the readability and informative value of spreadsheets. <\/p>\n
There are plenty of border styling options available via the corresponding toolbar button of the Spreadsheet UI. For instance, you can specify which borders from the selected cell (group of cells) should be modified (all, top, right, etc.) and play around with the color and style settings.
\n![\"new](\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2025\/05\/image6-ezgif.com-speed.gif\")
Check the sample ><\/a><\/p>\nWhether you’re preparing a budget plan, sales report, or even a financial dashboard, this visual enhancement will boost the user experience with tabular data. <\/p>\n
Formula Description<\/h5>\n
Remembering the purpose of all formulas is an overwhelming task even for Excel experts, let alone ordinary users. DHTMLX Spreadsheet 5.2 becomes more user-friendly in this regard by introducing a formula pop-up description<\/a>. This feature provides real-time assistance by displaying descriptions of formulas in a pop-up as users start typing a formula. It will give users hints on the proper usage of any unfamiliar function supported by our Spreadsheet.
\n![\"formula](\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2025\/05\/image5-ezgif.com-speed.gif\")
Check the sample ><\/a><\/p>\nUnder the hood, the pop-up description is implemented with the new formulas<\/strong> locale. Here is a piece of the default locale for formulas in code:<\/p>\n
const<\/span> en =<\/span> {<\/span>
\n AVERAGE:<\/span> [<\/span>
\n [<\/span>
\n "Number1"<\/span>,<\/span>
\n "Required. A number or cell reference that refers to numeric values."<\/span>
\n ]<\/span>,<\/span>
\n [<\/span>
\n "Number2"<\/span>,<\/span>
\n "Optional. A number or cell reference that refers to numeric values."<\/span>
\n ]<\/span>
\n ]<\/span>,<\/span>
\n \/\/ other descriptions for formulas<\/span>
\n}<\/span>;<\/span><\/div><\/div>\nIf needed, it can be replaced with a custom locale via the dhx.i18n.setLocale()<\/strong> method:<\/p>\n
const<\/span> de =<\/span> {<\/span>
\n AVERAGE:<\/span> [<\/span>
\n [<\/span>"Zahl1"<\/span>,<\/span> "Erforderlich. Eine Zahl oder Zellreferenz, die sich auf numerische Werte bezieht."<\/span>]<\/span>,<\/span>
\n [<\/span>"Zahl2"<\/span>,<\/span> "Optional. Eine Zahl oder Zellreferenz, die auf numerische Werte verweist."<\/span>]<\/span>
\n ]<\/span>,<\/span>
\n \/\/ other descriptions for formulas<\/span>
\n}<\/span>;<\/span>
\n
\ndhx.i18n<\/span>.setLocale<\/span>(<\/span>"formulas"<\/span>,<\/span> de)<\/span>;<\/span><\/div><\/div>\nCheck the sample ><\/a><\/p>\n
Find more details in the localization guide<\/a>.<\/p>\n
Indicating File Import Completion<\/h5>\n
And lastly, we want to mention that the new Spreadsheet version ensures more reliable transfer of spreadsheet data between the web app and external files like Excel or CSV with the new AfterDataLoaded<\/a><\/strong> event. It will fire once the spreadsheet is fully imported into the required format and display the message after the operation is completed.<\/p>\n
spreadsheet.events<\/span>.on<\/span>(<\/span>"afterDataLoaded"<\/span>,<\/span> (<\/span>)<\/span> =><\/span> {<\/span>
\n dhx.message<\/span>(<\/span>{<\/span>
\n text:<\/span> "Data successfully loaded into Spreadsheet!"<\/span>,<\/span>
\n }<\/span>)<\/span>;<\/span>
\n}<\/span>)<\/span>;<\/span><\/div><\/div>\n![\"data](\"https:\/\/dhtmlx.com\/blog\/wp-content\/uploads\/2025\/05\/image3.png\")
Check the sample ><\/a><\/p>\nThis event will be great for importing large datasets, signaling when it is safe to start calling methods for searching, filtering, etc.<\/p>\n
That\u2019s all about the new features included in this minor update of DHTMLX Spreadsheet. Check the “What\u2019s New<\/a>” section to make sure you haven\u2019t missed anything. Also, do not forget to take a look at migration notes<\/a> to v5.2.<\/p>\n
If you need to test the new version of our Spreadsheet before adding it to your project, download a free 30-day trial version<\/a>. Current customers can access DHTMLX Spreadsheet 5.2 via their Client\u2019s Area<\/a>.<\/p>\n
Related Materials<\/h5>\n
- \n
- What\u2019s new in v5.2<\/a><\/li>\n
- DHTMLX Spreadsheet documentation<\/a><\/li>\n
- DHTMLX Spreadsheet samples<\/a><\/li>\n
- Free 30-day trial version<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
When developing a web app with a strong focus on data analysis, it’s essential to have a spreadsheet tool that not only covers most of your project\u2019s functional requirements …<\/p>\n","protected":false},"author":101014,"featured_media":13947,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70],"tags":[33,34],"class_list":["post-13946","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-releases","tag-all-posts","tag-spreadsheet"],"_links":{"self":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/13946","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\/101014"}],"replies":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/comments?post=13946"}],"version-history":[{"count":7,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/13946\/revisions"}],"predecessor-version":[{"id":13966,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/13946\/revisions\/13966"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/media\/13947"}],"wp:attachment":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/media?parent=13946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/categories?post=13946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/tags?post=13946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- DHTMLX Spreadsheet documentation<\/a><\/li>\n
- What\u2019s new in v5.2<\/a><\/li>\n
- Freezing columns and rows<\/a><\/li>\n<\/ul>\n