Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (143).NET Core  (23)Angular  (39)ASP.NET  (47)ASP.NET Core  (53)ASP.NET MVC  (83)Azure  (27)Blazor  (49)DocIO  (18)Essential JS 2  (64)Essential Studio  (159)Flutter  (53)JavaScript  (134)Microsoft  (96)PDF  (48)React  (29)Succinctly series  (118)Syncfusion  (400)TypeScript  (30)Uno Platform  (2)UWP  (4)Vue  (25)Webinar  (14)Windows Forms  (52)WPF  (92)Xamarin  (105)XlsIO  (20)Other CategoriesBarcode  (4)BI  (29)Bold BI  (3)Build conference  (6)Business intelligence  (53)Button  (4)C#  (100)Chart  (40)Cloud  (8)Company  (445)Dashboard  (4)Data Science  (3)Data Validation  (2)DataGrid  (31)Development  (234)Doc  (7)eBook  (89)Enterprise  (22)Entity Framework  (5)Essential Tools  (14)Excel  (14)Extensions  (7)File Manager  (3)Gantt  (6)Gauge  (4)Git  (3)Grid  (24)HTML  (8)Installer  (1)Knockout  (2)LINQPad  (1)Linux  (1)M-Commerce  (1)Metro Studio  (11)Mobile  (140)Mobile MVC  (9)OLAP server  (1)Orubase  (12)Partners  (20)PDF viewer  (15)Performance  (2)PHP  (1)PivotGrid  (4)Predictive Analytics  (6)Report Server  (3)Reporting  (10)Reporting / Back Office  (11)Rich Text Editor  (5)Road Map  (9)Scheduler  (15)SfDataGrid  (7)Silverlight  (21)Sneak Peek  (12)Solution Services  (2)Spreadsheet  (2)SQL  (4)Stock Chart  (1)Surface  (4)Tablets  (5)Theme  (9)Tips and Tricks  (17)UI  (62)Uncategorized  (68)Unix  (2)User interface  (49)Visual State Manager  (1)Visual Studio  (12)Visual Studio Code  (7)Web  (99)What's new  (62)Windows 8  (19)Windows App  (1)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)
Share on twitter
Share on facebook
Share on linkedin
Formatting the Essential JavaScript Spreadsheet–Number Formatting

Formatting the Essential JavaScript Spreadsheet: Number Formatting

Spreadsheet is one of the most popular file formats, used to view, analyze, and calculate data. It is used in calculating tax, goods quantity, total marks in a student report, expenses, and so on.

The Syncfusion JavaScript Spreadsheet is a feature-rich control that supports various formatting options to display a cell or content. Its appearance will help you to view and understand the data. The following are the different types of formatting options available in Syncfusion Spreadsheet:

  • Number formatting
  • Cell formatting
  • Conditional formatting

In this blog, we will look at the number formatting and how to use it in the Syncfusion Essential JavaScript Spreadsheet control with appropriate code. I will cover the other formatting types in my future blogs.

Number formatting

Number formatting is used to present the numerical type of the data in the Spreadsheet cells. It will change the numbers’ look without changing the actual data. This feature will automatically detect the type of data in the cell, thereby reducing our effort. The feature helps the Spreadsheet to look more professional and attractive.

The following table has the list of types and formatting applied to them in our Spreadsheet control.

TypesFormat
General (default)NA
Number0.00
Currency$#, ##0.00
Accounting_($* #,##0.00_);_($* (#,##0.00);_($* “-“??_);_(@_)
ShortDatemm-dd-yyyy
LongDatedddd, mmmm dd, yyyy
Timeh:mm:ss AM/PM
Percentage0.00%
Fraction# ?/?
Scientific0.00E+00
Text@

You can enable or disable the number formatting by using the allowNumberFormatting property.

Where can you find number formats?

You can find the built-in number formats in a drop-down menu in the ribbon’s Home tab. Here, we have provided the active cell type in the preview option. It will be helpful to know the number format before applying the formatting.

Refer to the following screenshot.

Number Formatting drop-down menu in Home Tab

This will give you a better experience, similar to the number formatting feature in MS Excel.

Adding number formatting in Spreadsheet through code

In the Syncfusion JavaScript Spreadsheet control, you can add number formatting by using the numberFormat public method and pass the format type and range as parameters to this method. Also, you can use the format property to set the number format string to a cell object.

The following code example showcases the number formatting.

/**
 * Number formatting sample.
 */
let sheet: SheetModel[] = [{
        name: 'Restaurant Invoice',
        rows: [
          {
                index: 14, cells: [
                    { index: 1, value: 'Subtotal:' },
                    { index: 4, formula: '=SUBTOTAL(9,E4:E14)', format: '$#,##0.00' }
                ]
            },
            {
                cells: [
                    { index: 1, value: 'Discount (8%):' },
                    { index: 4, formula: '=PRODUCT(8,E15)/100', format: '$#,##0.00' }
                ]
            },
            {
                cells: [
                    { index: 1, value: 'Total Amount:' },
                    {
                        index: 4, formula: '=SUM(E15-E16)',
                        format: getFormatFromType('Accounting')
                    }
                ]
            }
        ]
    }];

    // Initialize Spreadsheet component.
    let spreadsheet: Spreadsheet = new Spreadsheet({
        sheets: sheet,
        created: (): void => {
            spreadsheet.numberFormat('$#,##0.00', 'D4:E14');
            spreadsheet.numberFormat('$#,##0.00', 'E15:E17');
        }
    });
    // Render initialized Spreadsheet component.
    spreadsheet.appendTo('#spreadsheet');

You can also use the getFormatFromType method to get the format code from the format type like number, currency, and accounting. So, this will be very useful while preparing the number formatting sample in the JavaScript Spreadsheet.

The following screenshot will show you the number formatting in Spreadsheet.

Output

Conclusion

I hope you now have a better understanding of the number formatting feature in the Syncfusion JavaScript Spreadsheet control. In the upcoming blog, we will discuss the cell formatting feature. What else do you expect from a spreadsheet? Please share your thoughts in the comments section below.

If you’re already a Syncfusion user, you can download the Essential Studio for JavaScript product setup to try out this control. Otherwise, you can download a free 30-day trial.

If you have any questions about these features, please contact us through our support forumDirect-Trac, or feedback portal. We are always happy to assist you!

Tags:

Share this post:

Share on twitter
Share on facebook
Share on linkedin

Leave a comment

Popular Now

Be the first to get updates

Subscribe RSS feed
Scroll To Top