jxls icon indicating copy to clipboard operation
jxls copied to clipboard

When I am utilizing nested loops, an extraneous row is inexplicably created.

Open bingo-chou opened this issue 1 year ago • 3 comments

The template is image The plots data is

[
    {
        "name": "PlotA",
        "customers": [
            {
                "name": "Customer1",
                "products": [
                    {
                        "name": "Product1",
                        "unit_price": 83.5,
                        "van": 987,
                        "net_weight": 341231.8,
                        "volume": 981231.07,
                        "amount": 13213128.11
                    },
                    {
                        "name": "Product2",
                        "unit_price": 83.5,
                        "van": 987,
                        "net_weight": 341231.8,
                        "volume": 981231.07,
                        "amount": 13213128.11
                    }
                ]
            }
        ]
    }
]

The result I am expecting is as follows:

image

But the actual result I get includes an extra seventh row.

image

This is my test project test-jxls.zip

bingo-chou avatar Feb 22 '24 16:02 bingo-chou

Thanks for submitting the zip file. Maybe I'll take a look later.

Looks like we have several problems with jx:mergeCells. Does the additional row also will be created if you omit jx:mergeCells?

I don't use jx:mergeCells. So I don't have much motivation to work on it.

SoltauFintel avatar Feb 22 '24 18:02 SoltauFintel

Thanks for submitting the zip file. Maybe I'll take a look later.

Looks like we have several problems with jx:mergeCells. Does the additional row also will be created if you omit jx:mergeCells?

I don't use jx:mergeCells. So I don't have much motivation to work on it.

Thanks for your reply, but when I remove all jx:mergeCells, extra rows are still created

image

bingo-chou avatar Feb 22 '24 23:02 bingo-chou

Please fork this repo and create a testcase. Create a minimal template from scratch using MS Excel.

gastendonk avatar Feb 29 '24 17:02 gastendonk