Features

JDataGrid Spreadsheet Edition 2.9.0

Freeze Pane

The freeze pane feature in JDataGrid allows you to "freeze" certain areas or panes of

the spreadsheet so that they remain visible at all times when scrolling to the right or down.

Work Sheet

A worksheet is a single page or sheet in an JDataGrid. By default, there are three worksheets per file. Switching between worksheets is done by clicking on the sheet tab at the bottom of the screen.

Excel Formula

JDataGrid includes many formulas, it have the same syntax like Excel formulas, it allow you to perform calculations on data you have entered into the spreadsheet, you can change the data and JDataGrid will automatically recalculate the answer for you..

Common Chart(Pie, Line, Bar)

JDataGrid includes the different chart types, Pie Charts, Bar Charts, Line Charts, these charts are visual representations of worksheet data. makes it easier to understand the data in a worksheet

Common Shape(Cube, Sphere, Pyramid, etc.)

JDataGrid includes the common shapes, such as cube, sphere, pyramid, it allows you create the spreadsheet with these shapes.

Import and Export(xls, pdf, xml, html, csv, txt)

JDataGrid can import and export the standard spreadsheet file format, such as Excel xls file, Excel xml file, comma separated file, you can also export the spreadsheet to Web page, PDF file.

Print and Print Preview

Printing in JDataGrid is easy, JDataGrid allows you control the print area, print preview the page, setup the page margin, page header text and icon, page footer text and icon.

Merge and Split Cell

JDataGrid can merge and split the cell area, it also provide a CellSpanModel, this model can work with a Plain TableModel to provide this functionality.

Undo and Redo

JDataGrid support the feature undo and redo the action, this functionality is implemented by the Swing undo package.

Column and Cell Sorting

JDataGrid provide two different ways to sort the data, the column sorting enable sort the data in the full column, the cell sorting enable sort the data in the specified cell area.

Find and Replace

JDataGrid support finding and replacing the text in the spreadsheet.

Spell Check

JDataGrid provide the spell checking functionality, this feature enable you check the text in the spreadsheet.

Comment and Hyperlink

Adds the comment and hyperlink to the JDataGrid is a nice feature, the JDataGrid also provide the API to add the comment and hyperlink.

Fill Data

JDataGrid allows you drag the fill handle to fill and advance the cell data, the support cell types include number, date, etc.

Cell Attributes(Font, Background, Underline, Cell Border, Format)

JDataGrid allows you change the cell attribtes, change the cell background, font color, cell border, it also allows you change the cell format for different data type, for date cells, you can change the date format, for number cells, you can change the number format.