I'm used to Excel under Windows, so this came as a bit of an annoyance:
On the Mac I had selected some multiline text from a Mac Mail message. I formatted my destination as Text, Wrap Text. Then I selected the cell and tried to paste (Opt-V). I could see the text in the edit box top right, but, could only see a line of #######'s when I conformed the paste with Enter. This was true even if I greatly increased the cell height.
Next I tried editing the string in the edit box, ensuring no "newlines". No luck. Finally I split the text into lines using Ctrl+Opt+Enter - just like Ctrl-Enter in Windows Excel. Still no luck.
If I type it in manually - everything is hunky dory.
What's wrong? I'd love to know for future reference!![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
On the Mac I had selected some multiline text from a Mac Mail message. I formatted my destination as Text, Wrap Text. Then I selected the cell and tried to paste (Opt-V). I could see the text in the edit box top right, but, could only see a line of #######'s when I conformed the paste with Enter. This was true even if I greatly increased the cell height.
Next I tried editing the string in the edit box, ensuring no "newlines". No luck. Finally I split the text into lines using Ctrl+Opt+Enter - just like Ctrl-Enter in Windows Excel. Still no luck.
If I type it in manually - everything is hunky dory.
What's wrong? I'd love to know for future reference!