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,
- before negative values an apostrophe (e.g. '-5) is inserted,
- amounts in that format cannot be used in formulas.
- SAP Gateway
- Fiori Applications
- Microsoft Excel
$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 pageThis 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.