SAP Knowledge Base Article - Public

2957460 - The format of the negative values in the exported Excel from a table in the story is not displayed correctly in SAP Analytics Cloud (SAC)

Symptom

When set the format of the negative values in the table to be displayed with brackets, like -1 displays as (1), then export the table to Excel with option "Including Formatting" checked, notice that the default format of negative values in SAC table is right aligned, but in the exported Excel, it is changed to left aligned.

Environment

  • SAP Analytics Cloud (Enterprise) 2020.8.22

Reproducing the Issue

  1. Create a table in the story, and make sure that there are negative values in the table cell.
  2. Change the format of displaying negative values to brackets, like -1 is displayed as (1).
  3. And by default the values in the table is right aligned.
  4. Export the table to Excel. Check the option "Include Formatting"
  5. Open the exported Excel, notice that the negative values are displayed left aligned. 

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0