SAP Knowledge Base Article - Public

2479321 - SAPListOfMessages does not return messages when open with Excel in a different language

Symptom

  • Formula SAPListOfMessages was used in an AO workbook and it was saved in an English version Excel.
  • Open the workbook in a German version Excel later, Formula SAPListOfMessages does not return any messages that should be available.

Environment

  • SAP Business Objects Analysis, edition for Microsoft Office

Reproducing the Issue

  1. Enter the formula in a cell in AO Workbook, for example: =SAPListOfMessages("WARNING";TRUE) in an English version Excel.
  2. Save the AO workboook.
  3. Open this AO workbook ina  German version Excel.
  4. Refresh the AO workbook
  5. Formula SAPListOfMessages returns #WERT!

Cause

In the German version Excel, the formula is automatically set to =SAPListOfMessages("WARNING";WAHR)

 

Resolution

To make the formula work in all regions, you can use for example:

=SAPListOfMessages("WARNING";"TRUE")

instead of

=SAPListOfMessages("WARNING";TRUE)

Keywords

Formula, Function, SAPListOfMessages, German, Excel, language, Analysis Office, AO, English , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office all versions