Adding a point as grouping character in german locale gives output "1,234,56" for 1234.56 (expected output is "1.234,56"). This is because of bug 59638 in Apache POI. Patch for Apache POI submitted.

It seems like Apache POI has a runtime dependency on SparseBitset that does not get included in MEJA dependencies.

It should be possible to read XLS(X) files directly into a GenericWorkbook using a SAX parser. This should greatly reduce memory usage when manipulating large workbooks.

• read support
• write support

Implement a simple command line only CSV to Excel converter in meja-samples

RichText rendering does not apply formatting (like "a single bold word").

• retrieve text with style attributes after editing
• fix painting issues for cell editor
• fill content with text not result of formula
• don't treat every input as text

• add methods for hiding/unhiding rows and columns to interface Sheet
• skip hidden rows/columns when drawing sheet in class SheetView

It looks like vertical alignment only takes into account the first line (or block) of text. So, the first line is displayed centered and the successing lines are displayed below. This only seems to happen with texts containing newline characters, not with justified text that is automatically wrapped and displayed in multiple lines.

• programmatically creating and
• setting CellStyles (currently only the ones present in the workbook can be returned).

• grouping of cells: implemented in Sheet.addMergedRegion()
• ungrouping of cells