jxls

jxls copied to clipboard

Merged cells are split

2

Cells merged in the template are split in the generated output. [template.xls](https://github.com/jxlsteam/jxls/files/12130174/template.xls) [generated-output.xls](https://github.com/jxlsteam/jxls/files/12130172/generated-output.xls) Versions: ``` org.jxls jxls 2.12.0 org.jxls jxls-poi 2.12.0 org.apache.poi poi 5.0.0 org.apache.poi poi-ooxml 5.0.0 ```

ivos

testcase

SoltauFintel

Merge Region is very slow

2

### I found the code below is very slow, and i don't know how to handle it. ```java protected final void findAndRemoveExistingCellRegion(CellRef cellRef) { ///// } ``` ### the xlsx...

jhd147350

Support footer and header in PoiUtil

1

When template copied into new sheet, template's header and footer settings are not transferred. For example, one may want to output page number during print in sheet footer on every...

abishai

### Description A nullpointerexception is thrown when templating. ``` java.lang.NullPointerException at org.apache.poi.hssf.record.CFHeaderBase.serialize(CFHeaderBase.java:144) at org.apache.poi.hssf.record.StandardRecord.serialize(StandardRecord.java:56) at org.apache.poi.hssf.usermodel.HSSFWorkbook$SheetRecordCollector.serialize(HSSFWorkbook.java:1476) at org.apache.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:1523) at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1418) at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:1404) at org.jxls.transform.poi.PoiTransformer.writeButNotCloseStream(PoiTransformer.java:501) at org.jxls.transform.poi.PoiTransformer.write(PoiTransformer.java:482) at org.jxls.util.JxlsHelper.processTemplate(JxlsHelper.java:288) at org.jxls.util.JxlsHelper.processTemplate(JxlsHelper.java:253)...

Blackiris

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

3

The template is  The plots data is ``` [ { "name": "PlotA", "customers": [ { "name": "Customer1", "products": [ { "name": "Product1", "unit_price": 83.5, "van": 987, "net_weight": 341231.8, "volume":...

bingo-chou

cannot read double value if cell is empty

1

I am using jxls `2.14.0` and jxls-reader `2.1.0`, commons-beanutils `1.9.4`, the java code is: ``` XLSReader mainReader = ReaderBuilder.buildFromXML(xmlConfig); mainReader.getConvertUtilsBeanProvider().getConvertUtilsBean().register(new JxlsDateConverter(), java.util.Date.class); ReaderConfig.getInstance().setUseDefaultValuesForPrimitiveTypes(true); XLSReadStatus readStatus = mainReader.read( dataInputStream, beanMap); ```...

takeAction

jx:mergeCells whith jx:each has Bug cell border and last row lost

3

template  data {“departments”:[ {staff: list.size() = 1}, {staff: list.size() = 1}, {staff: list.size() = 4}, {staff: list.size() = 2}, {staff: list.size() = 2}, {staff: list.size() = 2}, ]} result...

yuuunagi

#261 value with cell access

1

SoltauFintel

Excel outline grouping data don't works

3

Hello, I want to use the excel feature Outline (group) data in a worksheet (https://support.microsoft.com/en-gb/office/outline-group-data-in-a-worksheet-08ce98c4-0063-4d42-8ac7-8278c49e9aff) in my Excel JXLS template. In a classic case, I find my different groupings that...

julien95h