merge table

[cc_cc_cc_cc]

How can I tell if the current cell has been merged with other cells

[Andy.Zhou]

Hello,

Thanks for your inquiry.

You can refer to the following code to judge the merged state of a cell and also here is a sample screenshot for your reference.

Code: Select all

        //Get Horizontal merge state
        CellMerge hMerge=cell.getCellFormat().getHorizontalMerge();
        //Get Vertical merge state
        CellMerge vMerge=cell.getCellFormat().getVerticalMerge();
        //judge the merged state of a cell
        switch (hMerge){
            case Start:
                //The first cell of a cell merger
                break;
            case Continue:
                //The middle cell of a cell merger
                break;
            case None:
                //No merge cell
                break;
        }

3CCCF496-0E36-429c-8070-27DFEBDCD015.png

[cc_cc_cc_cc]

Thank you. Your code is working

[Andy.Zhou]

You are welcome!