[Q] Problem with "Implicit intersection operator: @" #1491
Description
I'm creating a simple sheet which includes an Excel array formula: SUM( ROUND( D1:D3, 0 ))
With this code (ExcelJS 4.1.1):
const workbook = new Excel.Workbook();
const worksheet = workbook.addWorksheet( 'test_sheet' );
worksheet.getCell( 'D1:D1' ).value = 1.2;
worksheet.getCell( 'D2:D2' ).value = 2.3;
worksheet.getCell( 'D3:D3' ).value = 5.6;
worksheet.getCell( 'D4:D4' ).value = {
formula: "SUM(ROUND(D1:D3, 0))",
result: 0,
date1904: false,
};
await workbook.xlsx.writeFile( "c:\\temp\\test.xlsx" );
When I open this sheet with Excel (Excel for Microsoft 365 MSO (16.0.13127.20266)) the new "Implicit intersection operator" will be inserted into the formula and breaks it:
Now I have to remove the inserted "@" and the formula works:
Has anybody a solution or workaround for this problem?