Automatic row height feature

[luca-vercelli]

If I am not wrong, there is no easy way to adjust rows height automatically.
I found a solution on stackoverflow. You have to create a new class AutoRowHeightCommand extends AbstractCommand. What about putting this class inside jxls itself?

Please note that this command only works for POI-based jxls:

@Override
public Size applyAt(CellRef cellRef, Context context) {
    Size size = this.area.applyAt(cellRef, context);

    PoiTransformer transformer = (PoiTransformer) area.getTransformer();
    Row row = transformer.getWorkbook().getSheet(cellRef.getSheetName()).getRow(cellRef.getRow());
    row.setHeight((short) -1);

    return size;
}

If you agree I could prepare a PR.

[SoltauFintel]

Yes, it would be nice if you could submit a PR. With test case and documentation?

[luca-vercelli]

I pushed both code and doc, however I need some help for tests.

https://github.com/luca-vercelli/jxls/blob/def0effd6b394da9bd2689f1ef8c52535e1a2ea9/jxls-poi/src/test/java/org/jxls3/AutoRowHeightTest.java#L33

Height in rows appears not set. According to implementation of XSSFRow::getHeightInPoints, if height is not set the function returns a default value. So I have no idea how to check that height is correct. Any idea? Thank you.