Symptom
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Formula bar displays more decimal places than its value cell in a crosstab.
Environment
SAP Analysis for Microsoft Office 2.8
Reproducing the Issue
Click on a cell in Analysis for Office crosstab and check the value displayed in the formula bar.
Resolution
The value displayed in the formula bar is the base value of the cell, which comes from the BW backend without formatting. This value cannot be changed in Analysis for Office.
The data cells in the crosstab display the formatted value.
This is standard behavior. No solution is needed.
Keywords
AO, Analysis for Excel, Analysis for Office, A4O, AFO, Digits, Points, Positions, Exact, Precise, Unrounded, Accurate, Specific , KBA , BI-RA-AO-XLA , Excel Addin , How To