Home > Documentation > JDataGrid FAQ

A:  You can input it on the "About" dialog.
     You can also use the following code to register the license code in
     your programming code:
     // the code means the above license data
     LicenseManager.getInstance().addLicenseData(code);

A:  Use the following method in JDataGrid:
     dataGrid.setSelectionBorderPainted(false);

A: You should enable the following client property in JDataGrid:
     dataGrid.setModel(new DefaultColumnSorter(createModel()));
     dataGrid.putClientProperty("JDataGrid.columnSortingEnabled", Boolean.TRUE);
     dataGrid.putClientProperty("JDataGrid.switchUnsortedOrderEnabled", Boolean.TRUE);
     And you should use the default JTableHeader build-in JDataGrid.

A: You should use the default JTableHeader build-in JDataGrid,
     Because the default JTableHeader cannot provide the support for column sorting,
     it have not this feature, such as show a arrow icon, or act as a button pushing.

A: JPrintPreview provides the following methods to enable color print preview:
    JPrintPreview.setColorType(JPrintPreview.COLOR);

A: Please use DefaultDataGridModel.addColumn(null) to add new column in JDataGrid.

A: You can use the "ObjectCellRenderer" in com.zfqjava.swing.cell directly, it has method
     "setDefaultHorizontalAlignment" and "setDefaultVerticalAlignment".

A: You can create "DateCellRenderer" instance, it's ObjectCellRenderer subclass,
     and pass a new SimpleDateFormat("MM/dd/yyyy");

A: The method "JDataGrid.sizeColumnWidthToFit" can size the column to fit it's contents.

A: A: We have add new API in FormulaFactory, you can switch from Excel formula syntax to OpenOffice formula syntax easily, you can try the following API:

     FormulaFactory.setArgumentSeparatorChar(';');

A: The JDataGrid has provide this feature since version 1.8,
     you can invoke the following code:

     dataGrid.setAlternatingRowBackground(Color.gray);
     dataGrid.setAlternatingRowForeground(Color.white);

A: The following code enable the checkbox in JDataGrid table header:

     JDataGrid dataGrid = getDataGrid();
     BooleanCellRenderer renderer = new BooleanCellRenderer();
     renderer.setComponentType(BooleanCellRenderer.CHECK_BOX);
     // gloablly enable the check box renderer
     // dataGrid.getTableHeader().setDefaultRenderer(renderer);
     dataGrid.getColumnModel().getColumn(0).setHeaderRenderer(renderer);

A: This function can be implemented by write a customize TableColumnModel,
     override the method:

           TableColumn firstColumn = new TableColumn(0);
           // override the method in TableColumnModel
           public TableColumn getColumn(int columnIndex) {
                if(columnIndex == 0) {
                      return firstColumn;
                } else {
                       return super.getColumn(columnIndex);
                 }
           }

A: Use the following code:
     dataGrid.setEditingStopBehavior(JDataGrid.COMMIT_OR_EDITING);

A: Use the following code to set a row height to worksheet:
     WorkSheet[] sheets = new WorkSheet[1];
     sheets[0] = new WorkSheet("sheet0", tableModel);

     // add the following code:
     SizeModel rowSizeModel = new DefaultSizeModel("row model",
     tableModel.getRowCount(), 16);
     rowSizeModel.setSize(0, 30);
     sheets[0].setRowSizeModel(rowSizeModel);

     WorkBook book = new WorkBook(sheets);
     ModelIO.writeWorkBook(book, "xls", null, f);