3435573 - SAC - Can't copy/paste from excel to SAC Story from cells with "Accounting" format

• Users encounter an issue while copying/pasting data from Excel files to SAC stories.
• The problem happens specifically when attempting to paste data from cells in Excel that have the "Accounting" format into SAC using the "Paste Overall Values Only" option in stories.

• SAP ANALYTICS CLOUD

1. Create SAC story that contains a table
2. Copy value from Excel to the SAC table

-> Error occur: "Only numeric values can be pasted here. Please ensure that source and target cells are using the same number formatting." 

This behavior works as designed

The problem is the currency sign. Without it, it works if the Excel number format matches the SAC table number format.

The separator in Excel is a comma and in SAC it's a dot. To solve this they need to be the same.

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
  • https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

, KBA , LOD-ANA-PL-DIS , Distribute, Spreading, Assign, Copy & Paste , LOD-ANA-PL , Planning , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-AD , Analytics Designer , Problem

SAP Analytics Cloud 1.0