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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.