IBM Support

"Unable to paste cell(s) ... Invalid numeric value 'xyz' specified" error when trying to paste cells across different levels in a hierarchy, caused by APAR PH06217

Troubleshooting


Problem

User selects several cells, across 2 (or more) levels in a hierarchy. User presses CTRL-C to copy them into their clipboard.

User selects a different cell, and presses 'CTRL-V' to paste. An error appears.

Symptom

The error will vary slightly depending on the content of your clipboard. For example, if trying to copy this:

image-20181205114818-1

...and then paste into here:

image-20181205114940-2

...would give this error:

image-20181205115106-3

Unable to paste cell(s)
Invalid numeric value 'xyz' specified

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"PAW","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2.0.37","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSKVSF","label":"Planning Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
20 September 2021

UID

ibm10744125