使用OnceAbsoluteMergeStrategy合并单元格，最后一个合并策略没生效

[aBlindBoy]

复现代码

 public static void main(String[] args) {
        List<DemoData> objects = new ArrayList<>();
        for (int i = 0; i < 20; i++) {
            DemoData demoData = new DemoData();
            demoData.setClassName(i>= 10 ? "二年级" :"一年级");
            demoData.setAge(i);
            demoData.setName("name" + i);
            objects.add(demoData);
        }
        FillConfig fillConfig =
                FillConfig.builder().forceNewRow(Boolean.TRUE).direction(WriteDirectionEnum.VERTICAL)
                        .build();
        FastExcel.write("D://simpleFill.xlsx")
                .withTemplate("D://template.xlsx")
                .registerWriteHandler(new OnceAbsoluteMergeStrategy(1, 10, 0, 0))
                .registerWriteHandler(new OnceAbsoluteMergeStrategy(11, 20, 0, 0))
                .sheet()
                .doFill(new FillWrapper("e", objects), fillConfig);
    }
    @Data
    public static class DemoData{
        private String className;
        private String name;
        private int age;
    }

模板文件
template.xlsx

导出后的数据
simpleFill.xlsx

[bengbengbalabalabeng]

OnceAbsoluteMergeStrategy is not suitable for Fill (shiftRows logic) scenarios. The strategy itself does not handle conflicts in the merged area after row displacement. Please refer to the JavaDoc description of org.apache.poi.ss.usermodel.Sheet#shiftRows(int, int, int, boolean, boolean):

    /**
     * Shifts rows between startRow and endRow n number of rows.
     * If you use a negative number, it will shift rows up.
     * Code ensures that rows don't wrap around
     *
     * <p>
     * Additionally shifts merged regions that are completely defined in these
     * rows (ie. merged 2 cells on a row to be shifted). All merged regions that are
     * completely overlaid by shifting will be deleted.
     */
    void shiftRows(int startRow, int endRow, int n, boolean copyRowHeight, boolean resetOriginalRowHeight);

---

Solution

Please try the customized SheetWriteHandler interface and override the afterSheetDispose method.
Version: 2.0.1-incubating

public class CustomMergeStrategy implements SheetWriteHandler {
    private final int firstRowIndex;
    private final int lastRowIndex;
    private final int firstColumnIndex;
    private final int lastColumnIndex;

    public CustomMergeStrategy(int firstRowIndex, int lastRowIndex, int firstColumnIndex, int lastColumnIndex) {
        if (firstRowIndex >= 0 && lastRowIndex >= 0 && firstColumnIndex >= 0 && lastColumnIndex >= 0) {
            this.firstRowIndex = firstRowIndex;
            this.lastRowIndex = lastRowIndex;
            this.firstColumnIndex = firstColumnIndex;
            this.lastColumnIndex = lastColumnIndex;
        } else {
            throw new IllegalArgumentException("All parameters must be greater than 0");
        }
    }

    @Override
    public void afterSheetDispose(SheetWriteHandlerContext context) {
        CellRangeAddress cellRangeAddress = new CellRangeAddress(this.firstRowIndex, this.lastRowIndex, this.firstColumnIndex, this.lastColumnIndex);
        context.getWriteSheetHolder().getSheet().addMergedRegionUnsafe(cellRangeAddress);
    }
}

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

[github-actions]

This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.