The sequence of characters “_x000D_” is replaced by a newline after exporting to excel

Hello Solomiia,

Thank you for your prompt response and for confirming the issue. I appreciate your team's effort in working towards a fix and the update regarding the expected timeline.

I'll look forward to hearing back from you regarding any progress or changes.

Thank you once again for your support.

Kind regards,

Alex

Hi Solomiia,

Thank you for following up!

Unfortunately, after updating to v2.9.94 the issue persists on my end. Could you please take another look?

I’m happy to provide more details or screenshots if needed to help troubleshoot further.

Looking forward to your guidance.

Kind regards,

Alex

Hi Solomiia,

I double-checked the issue and found that problem appears when the callbackHandler parameter is used. In my case callbackHandler is used to display url strings as hyperlinks.

this.pivot.flexmonster.exportTo(
      'excel',
      {
        filename: `report`,
        excelSheetName: 'Sheet1',
        destinationType: 'plain'
      },
      (result: any) => {
        let workbook = new ExcelJS.Workbook();
        workbook.xlsx.load(result.data.buffer).then((workbook) => {
          workbook.eachSheet((sheet) => {
            sheet.eachRow((row) => {
              row.eachCell((cell) => {
                let value = cell.value.toString();
                if (this.isValidUrl(value)) {
                  cell.value = { formula: `HYPERLINK("${value}", "${value}")` };
                  cell.style = JSON.parse(JSON.stringify(cell.style)); // workaround for issue 'cell font styling is applied to entire sheet' https://github.com/exceljs/exceljs/issues/879
                  cell.font = { ...cell.font, underline: true, color: { theme: 10 } };
                }
              });
            });
          });

          workbook.xlsx.writeBuffer().then((buffer) => {
            FileSaver.saveAs(new Blob([buffer], { type: 'application/octet-stream' }), 'report.xlsx');
          });
        });
      }
  );

When the data is exported without using the callbackHandler, everything works as expected and the sequence of characters "_x000D_" is not replaced.

this.pivot.flexmonster.exportTo(
      'excel',
      {
        filename: `report`,
        excelSheetName: 'Sheet1'
      }
  );

Could you please help me with solving the issue?

Kind regards,

Alex

Hello Solomiia,

Thank you for your prompt response and the detailed explanation.

I implemented the suggested modification to the callback handler, and it worked perfectly! The issue has been resolved, and the data is now being processed as expected.

Thank you once again for your assistance!

Kind regards,
Alex