MindFusion.Spreadsheet for Java Swing Features

• Intuitive API - The API uses familiar Workbook and Worksheet objects that help you easily build and organize spreadsheets. Each worksheet consists of Cell instances, which you can access and customize separately. There is programmatic access to all elements in the workbook. The rich event set allows you to respond to actions performed by the user.
• Sheet Features - Cells can be merged or frozen, grouped or sorted. Each group can be outlined. Clipboard operations, copy and paste, are supported together with undo and redo. You can apply auto filling or auto validation on data as well format the data in a variety of formats. Cells can also show hyperlinks.
• Data Functions - The option for conditional data formatting allows you to visually highlight cells whose data meets a given criteria. Custom functions let you define your own way of calculating a cell's value. The spreadsheet control also includes a set ot predefined functions like sum, max, average work.
• Charts - Bar charts, radars, pie, bubble and different line charts. You can customize many of the chart elements, and all colors and fonts. It is easy to bind a cell range to your chart type the library automatically generates the end result.
• Import and Export - Accurately import data from any Microsoft Office Open XML Format, OpenOffice Calc format as well from comma-separated (CSV) files. When your workbook is ready, you save it as XLSX, ODS or PDF files. Images can be exported to bmp, jpeg, gif, tiff and png.
• Styling and Design - The library provides you with methods to customize any element of the spreadsheet. Group cells into ranges and format them as a header with the appropriate background and font options. Add borders of your chosen type to any cell on the sheet. Format and align text, customize colors, brushes and strokes.