advisr-io / excel4node

Node module to allow for easy Excel file creation
MIT License
126 stars 20 forks source link

Right border not shown in merged cells #100

Open pferioli opened 1 month ago

pferioli commented 1 month ago

Describe the bug The right border of merged cells is not drawn

To Reproduce

worksheet.cell(1, 1, 1, 2, true).string("SEMANA").style({
                    alignment: {
                        wrapText: false,
                        horizontal: 'center',
                        vertical: 'center'
                    },
                    fill: {
                        type: 'pattern',
                        patternType: 'solid',
                        bgColor: "#ff0000",
                        fgColor: "#ff0000",
                    },
                    font: {
                        color: 'black',
                        size: 11,
                    },
                    border: { // §18.8.4 border (Border)
                        left: {
                            style: "thin",
                            color: "#000000"
                        },
                        right: {
                            style: "thin",
                            color: "#000000"
                        },
                        top: {
                            style: "thin",
                            color: "#000000"
                        },
                        bottom: {
                            style: "thin",
                            color: "#000000"
                        },
                        outline: true
                    },
                });

Expected behavior The cell should have the 4 borders in thin black

Environment (please complete the following information):

Additional context After setting the style to have the four sides of the cell with a border the right one is not present. I Included one example but in the image can see this happens in all merged cells

image