Hi,
I have noticed that when I copy a long string of text (for what I've experienced more than 12 lines) to a single cell, I can't get the autofit row height to work properly. It strech the height of the cell to only the 12th line. So when I copy a huge string of text(20+ lines) and I use autofit row height, it doesn't fit the height properly and I have to strech the height of the row manually.
Also I noticed that when I copy paste text into a cell, the cell format is set to general and if I put the cell format to text, the value of the cell is changed to "##################".
Can someone please explain me what is happening and what I am doing wrong.
I have noticed that when I copy a long string of text (for what I've experienced more than 12 lines) to a single cell, I can't get the autofit row height to work properly. It strech the height of the cell to only the 12th line. So when I copy a huge string of text(20+ lines) and I use autofit row height, it doesn't fit the height properly and I have to strech the height of the row manually.
Also I noticed that when I copy paste text into a cell, the cell format is set to general and if I put the cell format to text, the value of the cell is changed to "##################".
Can someone please explain me what is happening and what I am doing wrong.
