SAP Knowledge Base Article - Preview

2425437 - Cell format issue in Excel after exporting from Fiori: Numbers are exported as texts

Symptom

After exporting to an Excel spreadsheet from a Fiori Application the numbers are displayed as texts:

  • decimals are separated with dots (e.g. 100.5) while the separator was a comma in the Fiori Application,
    AND/OR
  • before negative values an apostrophe (e.g. '-5) is inserted,
    AND/OR
  • amounts in that format cannot be used in formulas.


Read more...

Environment

  • SAP Gateway
  • Fiori Applications
  • Microsoft Excel

Product

SAP Gateway all versions

Keywords

$format=xlsx, format, xlsx, excel export, cell format, string, number, decimals, decimals 5, fixed decimals, negative, amount, dot, coma, separator, sign, currency, p_decimals = 5, Should be enough for most scenarios, decimal point, 5 decimals , KBA , OPU-BSE-SDE , SAP Data Enablement , OPU-GW-COR , Framework , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.