Troubleshooting: Paste error when editing map value rule in Excel
A developer asks:
I was building a map value rule. When I tried to edit in Excel and paste a column of values in, I received a message indicating that the spreadsheet was protected, and I was prompted for the password.
I have 300+ rows that I need to paste. How can I do this?
This is logged as bug B-17107
Update: This issue is resolved in V42SP6.
It is a bad idea to try to unlock the password. Here are some workarounds:
- If you are copying from within the map, you can do a drag/drop (with the ctrl key held down).
- Display the clipboard (Edit Menu/Office Clipboard) and paste from there-- beware that it is possible to copy data past the default row or column from the clipboard (also a bug to be addressed).