Getting different values while copy pasting special characters data from Anaplan to Excel.
Data copied from Anaplan is as follows:
Banked T&I % should be fixed/ is missing |
Savings <= UNRISKED please fix |
Data pasted to excel is as follows:
Banked T&I % should be fixed/ is missing |
Savings<= UNRISKED please fix |
This doesn't happen while exporting, only while copy pasting the data.
End users prefer copy pasting as to avoid the small Lag that happens while exporting the data. Is their a solution to this as business uses this frequently?
I do not believe there is a quick fix for this.
But by understanding what you are trying to achieve we may be able to come to a different solution.
Are these error codes? If so you could create a list in Anaplan which would default to required item when you user copies into the cell. This would only work if the error codes/messages are consistent across your organisation.
@dgingrasYes!! actually they are validation errors used for conditional formatting, These Line items are published in dashboard and are not getting copied as is from Anaplan to Excel.