I took a blank spreadsheet, selected Wrap Text for all the cells.
If I type text into the cells I want to wrap it works beautifully....awesome...
If I need to paste text from another document into a cell, not matter how I try and do it, it does not show the last few lines of the text, I have to drag the row taller to see.
Is there a way to paste content into a wrap text cell and it work like typing the content?
Below, the first cell is content I typed in, the second is pasted, the third shows after I drag the cell down to show all the content.
The content I typed is actually bigger than the pasted content, I just can't understand why it will not show the last few lines?
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Requirement
[/TD]
[/TR]
[TR]
[TD]gfsdankglfdsnkmgfldkv sdkvlsdnmklg feskg dmsklf dsjkdlsf eoaw;temlf dskl;fkmsd fgdmsl;gl wsl;fek rewolr;em l;fdsj gmldfk;s gjl;sjt g oew tgjmdls;fgm kl;sgt jrow tgerls;m fgdls; jtgorw jtlr;m flds gldsk; ojew tewl elws gjdfs;p tgjrow rkpe fkmlds; gfdsml gjow gl;sg mls gjorw jgls; mglds; jgolrw jtgors; mfvl,ds gjor gjorw fjoejgrsd;ojtgrowp jgrogfsgjkf
gkrol;gkfmdlogkreogjroe
grjowepgrjeopgjroep
gfjweopgrejogmroekx
grjweoipgrjeiogprej
gjrwiopgrjeopg
gjsaogpfjgfodsjgfodp
grjeaioprhgjreoapgjkoe
grjwioap'gorjeaigojgikfjdaiorgjeriaopgjierpajgorla jfoepwaj feowpaj grajopg rjeoag rjoeap gjropea gjreasgrioepag jopea jgopae gjroea gjrkoea gjrieap ejrgreojap gjroepa gjroepa gjroepa gjrea jgrioea jgkrfspioejg iorpej gorpea jgorpea jegrpe ajogreaj goprea jgopreaj gro jgorepa gjorepagj roepa gjorape jgoreap jgorpeaj groea jgorpaeje rgorepaj goprsa jerop j aoper jgorepa jgorea grjoaepg rjeoap gjroeap gjroea mgklfdsjgorepajoroeaj jgropea gjroea jgoreap
[/TD]
[/TR]
[TR]
[TD]Sing, O goddess, the anger of Achilles son of Peleus, that brought countless ills upon the Achaeans. Many a brave soul did it send hurrying down to Hades, and many a hero did it yield a prey to dogs and vultures, for so were the counsels of Jove fulfilled from the day on which the son of Atreus, king of men, and great Achilles, first fell out with one another. And which of the gods was it that set them on to quarrel? It was the son of Jove and Leto; for he was angry with the king and sent a pestilence upon the host to plague the people, because the son of Atreus had dishonoured Chryses his priest. Now Chryses had come to the ships of the Achaeans to free his daughter, and had brought with him a great ransom: moreover he bore in his hand the sceptre of Apollo wreathed with a suppliant's wreath, and he besought the Achaeans, but most of all the two sons of Atreus, who were their chiefs. "Sons of Atreus," he cried, "and all other Achaeans, may the gods who dwell in Olympus grant you to sack the city of Priam, and to reach your homes in safety; but free my daughter, and accept a ransom for her, in reverence to Apollo, son of Jove." On this the rest of the Achaeans with one voice were for respecting
[/TD]
[/TR]
[TR]
[TD]Sing, O goddess, the anger of Achilles son of Peleus, that brought countless ills upon the Achaeans. Many a brave soul did it send hurrying down to Hades, and many a hero did it yield a prey to dogs and vultures, for so were the counsels of Jove fulfilled from the day on which the son of Atreus, king of men, and great Achilles, first fell out with one another. And which of the gods was it that set them on to quarrel? It was the son of Jove and Leto; for he was angry with the king and sent a pestilence upon the host to plague the people, because the son of Atreus had dishonoured Chryses his priest. Now Chryses had come to the ships of the Achaeans to free his daughter, and had brought with him a great ransom: moreover he bore in his hand the sceptre of Apollo wreathed with a suppliant's wreath, and he besought the Achaeans, but most of all the two sons of Atreus, who were their chiefs. "Sons of Atreus," he cried, "and all other Achaeans, may the gods who dwell in Olympus grant you to sack the city of Priam, and to reach your homes in safety; but free my daughter, and accept a ransom for her, in reverence to Apollo, son of Jove." On this the rest of the Achaeans with one voice were for respecting the priest and taking the ransom that he offered; but not so Agamemnon, who spoke fiercely to him and sent him roughly away. "Old man," said he, "let me not find you tarrying about our ships, nor yet coming hereafter.
[/TD]
[/TR]
</tbody>[/TABLE]
If I type text into the cells I want to wrap it works beautifully....awesome...
If I need to paste text from another document into a cell, not matter how I try and do it, it does not show the last few lines of the text, I have to drag the row taller to see.
Is there a way to paste content into a wrap text cell and it work like typing the content?
Below, the first cell is content I typed in, the second is pasted, the third shows after I drag the cell down to show all the content.
The content I typed is actually bigger than the pasted content, I just can't understand why it will not show the last few lines?
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Requirement
[/TD]
[/TR]
[TR]
[TD]gfsdankglfdsnkmgfldkv sdkvlsdnmklg feskg dmsklf dsjkdlsf eoaw;temlf dskl;fkmsd fgdmsl;gl wsl;fek rewolr;em l;fdsj gmldfk;s gjl;sjt g oew tgjmdls;fgm kl;sgt jrow tgerls;m fgdls; jtgorw jtlr;m flds gldsk; ojew tewl elws gjdfs;p tgjrow rkpe fkmlds; gfdsml gjow gl;sg mls gjorw jgls; mglds; jgolrw jtgors; mfvl,ds gjor gjorw fjoejgrsd;ojtgrowp jgrogfsgjkf
gkrol;gkfmdlogkreogjroe
grjowepgrjeopgjroep
gfjweopgrejogmroekx
grjweoipgrjeiogprej
gjrwiopgrjeopg
gjsaogpfjgfodsjgfodp
grjeaioprhgjreoapgjkoe
grjwioap'gorjeaigojgikfjdaiorgjeriaopgjierpajgorla jfoepwaj feowpaj grajopg rjeoag rjoeap gjropea gjreasgrioepag jopea jgopae gjroea gjrkoea gjrieap ejrgreojap gjroepa gjroepa gjroepa gjrea jgrioea jgkrfspioejg iorpej gorpea jgorpea jegrpe ajogreaj goprea jgopreaj gro jgorepa gjorepagj roepa gjorape jgoreap jgorpeaj groea jgorpaeje rgorepaj goprsa jerop j aoper jgorepa jgorea grjoaepg rjeoap gjroeap gjroea mgklfdsjgorepajoroeaj jgropea gjroea jgoreap
[/TD]
[/TR]
[TR]
[TD]Sing, O goddess, the anger of Achilles son of Peleus, that brought countless ills upon the Achaeans. Many a brave soul did it send hurrying down to Hades, and many a hero did it yield a prey to dogs and vultures, for so were the counsels of Jove fulfilled from the day on which the son of Atreus, king of men, and great Achilles, first fell out with one another. And which of the gods was it that set them on to quarrel? It was the son of Jove and Leto; for he was angry with the king and sent a pestilence upon the host to plague the people, because the son of Atreus had dishonoured Chryses his priest. Now Chryses had come to the ships of the Achaeans to free his daughter, and had brought with him a great ransom: moreover he bore in his hand the sceptre of Apollo wreathed with a suppliant's wreath, and he besought the Achaeans, but most of all the two sons of Atreus, who were their chiefs. "Sons of Atreus," he cried, "and all other Achaeans, may the gods who dwell in Olympus grant you to sack the city of Priam, and to reach your homes in safety; but free my daughter, and accept a ransom for her, in reverence to Apollo, son of Jove." On this the rest of the Achaeans with one voice were for respecting
[/TD]
[/TR]
[TR]
[TD]Sing, O goddess, the anger of Achilles son of Peleus, that brought countless ills upon the Achaeans. Many a brave soul did it send hurrying down to Hades, and many a hero did it yield a prey to dogs and vultures, for so were the counsels of Jove fulfilled from the day on which the son of Atreus, king of men, and great Achilles, first fell out with one another. And which of the gods was it that set them on to quarrel? It was the son of Jove and Leto; for he was angry with the king and sent a pestilence upon the host to plague the people, because the son of Atreus had dishonoured Chryses his priest. Now Chryses had come to the ships of the Achaeans to free his daughter, and had brought with him a great ransom: moreover he bore in his hand the sceptre of Apollo wreathed with a suppliant's wreath, and he besought the Achaeans, but most of all the two sons of Atreus, who were their chiefs. "Sons of Atreus," he cried, "and all other Achaeans, may the gods who dwell in Olympus grant you to sack the city of Priam, and to reach your homes in safety; but free my daughter, and accept a ransom for her, in reverence to Apollo, son of Jove." On this the rest of the Achaeans with one voice were for respecting the priest and taking the ransom that he offered; but not so Agamemnon, who spoke fiercely to him and sent him roughly away. "Old man," said he, "let me not find you tarrying about our ships, nor yet coming hereafter.
[/TD]
[/TR]
</tbody>[/TABLE]
