SAP Knowledge Base Article - Public

1315587 - The chart crashes when directly using the number data applied with format which is imported from Excel spreadsheets in Japanese Environment

Symptom

The chart crashes when directly using the number data which has format applied from an Excel spreadsheet

Reproducing the Issue

  1. Create an Excel file with number data, and apply Number format (Use 1000 Separator(,)) to number data.
  2. Create a Xcelsius file with Japanese Locale. 
  3. Import the Excel file created in step 1.
  4. Create a Column Chart with the number data.
  5. The Column Chart crashes.
  • Xcelsius Enterprise 2008
  • Japanese Locale

Cause

The issue is identified and tracked under  ADAPT01195597.

Resolution

Workaround:

  1. Import the Excel spreadsheets.
  2. Remove the format applying to the number data.
  3. Use the number data without format to create charts.
  4. Right-click the chart and select Properties from shortcut menus.
  5. In charts' properties window, click Appearance and then click Text tag.
  6. Set Number Format for Veritical (Value) Axis Labels.

Keywords

Xcelsius 2008, X5, Japanese, format, label , KBA , BI-RA-XL , Dashboards and Presentation Design , Bug Filed

Product

SAP BusinessObjects Xcelsius Enterprise 2008