Display Rounded Numbers

Hello Handsontable Support Team,

I’m using Handsontable version 14.5.0 in my project, and I have a requirement where I need to store decimal values (e.g., 12.75) in the data source , but I only want to display the rounded value (e.g., 13) in the table view.

The key requirement is that the underlying data should remain unchanged (retain the full decimal), but the cell should visually show only the rounded number for clarity.

Could you please let me know the best way to achieve this in version 14.5.0? Is there a renderer, formatting option, or any configuration that allows this kind of display customization while preserving the original data?

If possible, I’d really appreciate an example or relevant documentation link.

Thank you for your help!

Hi @kenilgolakiya6

You can use the numeric cell type and configure it so the format will meet your requirements. Here’s a guide from our documentation: Numeric cell type - JavaScript Data Grid | Handsontable