/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
The input-ready cell contains a formula.
When pressing delete in the input-ready cell, the formula is deleted but the value remains in the cell.
When pressing delete again, the value is deleted.
Environment
SAP BusinessObjects Analysis, edition for Microsoft Office
Cause
This is not a bug. The tool works as intended.
The first deletion is used to delete the Table Design Formula and the second deletion to delete the value from the planning query.
Resolution
It is possible to disable Table Design Formulas for input-ready cells via setting "ActivateFormulaRecognitionOnExistingCells". See SAP note 2083067 for changing the settings in AO.
Refer to Administrator Guide of AO available in http://help.sap.com/boao for more information about the setting "ActivateFormulaRecognitionOnExistingCells".
See Also
Keywords
input ready, planning, cell, content, delete, remove, not working, plan, excel formula, formulas, input-ready , KBA , BI-RA-AO-XLA , Excel Addin , Problem
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)