[BUG] line-break in table header generates error in Excel for Mac

[patrick-hertling]

🐛 Bug Report

Using line break characters in the header of a table generates an error when trying to open the generated file on Mac.

Lib version: 4.2.1

Steps To Reproduce

        const workbook = new ExcelJS.Workbook();

        const worksheet = workbook.addWorksheet(title, {
            properties: {
                defaultColWidth: 30,
            },
            pageSetup: {
                paperSize: 9,
                orientation: 'landscape',
            },
        });

        worksheet.addTable({
            name: 'table',
            ref: 'A1',
            headerRow: true,
            style: {
                theme: 'TableStyleLight2',
                showRowStripes: true,
            },
            columns: [
                { name: 'Test\r\nmultiple\r\nlines' },
            ],
            rows: [
                ['Test'],
            ],
        });

        worksheet.getCell('A1').alignment = { wrapText: true };

        await workbook.xlsx.writeFile('test.xlsx');

The expected behaviour:

After the file gets stored, we can open it and see its content.

The actual behaviour:

An error pops up:

[patrick-hertling]

Is only Mac affected by this? Has anybody found this happening in another OS?