1541085 - The value of single value components cannot be changed by dragging mouse when cell which it is linked to contains a formula

SAP Knowledge Base Article - Public

1541085 - The value of single value components cannot be changed by dragging mouse when cell which it is linked to contains a formula

Symptom

  • The value of single value components cannot be changed by dragging mouse
  • The cell which the single value component is linked to contains a formula of any type

Environment

  • Xcelsius Enterprise 2008 FP1.2 or above

Reproducing the Issue

  1. Launch Xcelsius Enterprise 2008 (FP1.2 or above).
  2. At the spreadsheet, type 1 into Cell A1 and 2 into Cell A2.
  3. Type "=SUM(A1:A2)" to Cell A3.
  4. Add a Single Value component to Canvas, such as Values component by selecting Category -> Single value -> Value.
  5. At the  General tag of the component's properties, link the Data to the Cell A3.
  6. Open the Properties of the component.
  7. Select Behavior -> Common tag.
  8. The setting of Increment becomes unavailable.
  9. Click Preview button.
  10. The data of the Values component can be changed by dragging mouse.

Cause

This is an expected behavior and by design.

What dictates whether a Single Value component is an input (which permits user interaction) or output, is the cell to which it is linked.

If the cell contains a formula of any type, the component is interpreted as an output. If the cell does not contain a formula, it is represented as an input.

Please refer to the illustration on "Using the Single Value components" of " Xcelsius 2008 User Guide".

Before FP1.2, Value components are able to modify the data in bound cells that contain formulas.

The issue is tracked under ADAPT01129247 and fixed in Xcelsius Enterprise 2008 FP1.2.

Keywords

Formula, sum, excel, change, Gauge, increment , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008