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.
SAP Knowledge Base Article - Preview