SAP Knowledge Base Article - Public

3747805 - Special Characters Cause Error in Downloaded Excel File in "Display Actual Costing Result" App - SAP S/4HANA Cloud Public Edition

Symptom

  • An error occurs when opening an Excel file generated from the "Display Actual Costing Result" app via Custom Export.
  • Error message: "Excel was able to open the file by repairing or removing unreadable content. Repaired Records: XML error in /xl/worksheets/sheet1.xml part. A semicolon (;) was expected. Line X, column XXXX."
  • Error message (variant): "Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Illegal qualified name character."
  • After opening the file, the data appears to be corrupted and no content is visible. 

Environment

SAP S/4HANA Cloud Public Edition

Cause

The ampersand (&) and less-than (<) characters appear unescaped in xl/worksheets/sheet1.xml, resulting in invalid XML and Excel repair on open.

Resolution

  1. Rename the downloaded .xlsx file to .zip (e.g., Materials.xlsx → Materials.zip).
  2. Extract the ZIP to a folder.
  3. Open xl\worksheets\sheet1.xml in a text editor (e.g., Notepad++).
  4. Use Find & Replace (Only replace & and < inside cell data values, not within XML tags.):
    • Replace & → &amp;
    • Replace < → ~&lt; 
  5. Save the file.
  6. Re-compress all contents back into a ZIP, then rename to .xlsx.

Keywords

custom export, process category view, display actual costing result, excel unreadable content, sheet1.xml, a semicolon was expected, illegal qualified name character, invalid xml, escape characters, ampersand, less-than, material description, xlsx corrupted, actual costing, f6073, &, < , KBA , CO-FIO-ACT-2CL , Actual Costing (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions