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 , Gateway SAP Data Enablement , OPU-GW-COR , Gateway Framework , Problem

About this page

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

Search for additional results

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