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.