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
excel export, cell format , KBA , OPU-BSE-SDE , Gateway SAP Data Enablement , OPU-GW-COR , Gateway 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.