JustTrying
New Member
- Joined
- Jun 11, 2010
- Messages
- 10
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 9">****** name="Originator" content="Microsoft Word 9"><link rel="File-List" href="file:///C:/DOCUME%7E1/emachine/LOCALS%7E1/Temp/msoclip1/01/clip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:DoNotOptimizeForBrowser/> </w:WordDocument> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> Can you please tell me how to make word wrap and auto fit row height work in Excel?
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>
I have a form with over a thousand lines that has paragraphs of data along with numbers that must be manipulated. Individual adjustment of lines is not acceptable. Because the user has limited computer skills, the form must be a simple fill in the blanks type. Pre-formatted paragraphs are selected from a larger group based on user input and eventually printed in the final document produced.
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
I have tried changing the font, changing the column width, but can not get word wrap and auto fit to work reliably.
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
The same problem shows up in Excel 97, 2000, 2007, 2010 and has been tried on several different computes from different manufactures and on several different printers also of different manufactures as well as a PDF converter.
An example:
The text is as follows (329 characters)
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
“The Contractor shall take any and all precautions necessary to ensure that fixtures and materials, which are temporarily removed during any phase of construction, are protected from damage, vandalism and/or theft. Damage to property caused by the Contractor shall be repaired or replaced by the Contractor at his/her own expense.”
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
Cell width is 69.82
Font is Arial 11 point
There are no merged cells
Auto-fit is on
Word Wrap is on
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
What prints is:
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
“The Contractor shall take any and all precautions necessary to ensure that fixtures and materials, which are temporarily removed during any phase of construction, are protected from damage, vandalism and/or theft. Damage to property caused by the Contractor shall be repaired or replaced by the Contractor at his/her own”
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
The text “expense.” is lost
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
The print preview also has lost text.(same as the print out)
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
Manual adjustment of the cell shows the complete text. As mentions this is not a solution.
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
Insertion of Alt-Enter can fix it sometimes, but can require more than one. Again this is unreliable. Automatically insertion of Alt-Enter(s) also produces unnecessary extra blank lines, extending the document unacceptably, and confusing the presentation.
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
If the effected paragraphs are copied and pasted into Word using RTF, all characters are there. This is not a solution due to the complexity.
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
This is just one example several appear throughout the document. It is independent of length of the line, some fail with as low as 88 characters, this particular one has 329 characters, while others with over 700 characters work just fine.
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
I have researched this on the web and find I am not alone. I find references to 1026 limit as to what will show in a cell, I have also seen a limit of 255 in some instances but this seems not to be the case. The assumption is that word wrap and auto fit do not work in merged cells, so the form was developed with the largest column width for the sections needing word wrapping and not with merged cells. Macros have been presented that are supposed to take care of the problem, but they also seem to give unreliable results.
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
The document also has sections that will be filled in by the user and may require them to input data of more than 255 characters.
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
Needles to say if the form can not be relied upon to present ALL data input into it, it is worse than useless.
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
Why, after at least 13 years (between 97 and 2010), is it unreasonable to expect word wrap and auto fit to simply work, am I missing something?
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
A solution using Excel 2000 would be optimum as I have little experience with 2007 just yet.
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
If no solution exists, can you suggest another spreadsheet program that will? (OpenOffice, Google, QuickBase, Sphygmic, Lotus, or any others?)
Any help or explanations would be greatly appreciated.
Thanks
<!--[if !supportEmptyParas]--> <!--[endif]--><o></o>
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>I have a form with over a thousand lines that has paragraphs of data along with numbers that must be manipulated. Individual adjustment of lines is not acceptable. Because the user has limited computer skills, the form must be a simple fill in the blanks type. Pre-formatted paragraphs are selected from a larger group based on user input and eventually printed in the final document produced.
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>I have tried changing the font, changing the column width, but can not get word wrap and auto fit to work reliably.
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>The same problem shows up in Excel 97, 2000, 2007, 2010 and has been tried on several different computes from different manufactures and on several different printers also of different manufactures as well as a PDF converter.
An example:
The text is as follows (329 characters)
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>“The Contractor shall take any and all precautions necessary to ensure that fixtures and materials, which are temporarily removed during any phase of construction, are protected from damage, vandalism and/or theft. Damage to property caused by the Contractor shall be repaired or replaced by the Contractor at his/her own expense.”
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>Cell width is 69.82
Font is Arial 11 point
There are no merged cells
Auto-fit is on
Word Wrap is on
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>What prints is:
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>“The Contractor shall take any and all precautions necessary to ensure that fixtures and materials, which are temporarily removed during any phase of construction, are protected from damage, vandalism and/or theft. Damage to property caused by the Contractor shall be repaired or replaced by the Contractor at his/her own”
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>The text “expense.” is lost
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>The print preview also has lost text.(same as the print out)
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>Manual adjustment of the cell shows the complete text. As mentions this is not a solution.
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>Insertion of Alt-Enter can fix it sometimes, but can require more than one. Again this is unreliable. Automatically insertion of Alt-Enter(s) also produces unnecessary extra blank lines, extending the document unacceptably, and confusing the presentation.
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>If the effected paragraphs are copied and pasted into Word using RTF, all characters are there. This is not a solution due to the complexity.
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>This is just one example several appear throughout the document. It is independent of length of the line, some fail with as low as 88 characters, this particular one has 329 characters, while others with over 700 characters work just fine.
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>I have researched this on the web and find I am not alone. I find references to 1026 limit as to what will show in a cell, I have also seen a limit of 255 in some instances but this seems not to be the case. The assumption is that word wrap and auto fit do not work in merged cells, so the form was developed with the largest column width for the sections needing word wrapping and not with merged cells. Macros have been presented that are supposed to take care of the problem, but they also seem to give unreliable results.
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>The document also has sections that will be filled in by the user and may require them to input data of more than 255 characters.
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>Needles to say if the form can not be relied upon to present ALL data input into it, it is worse than useless.
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>Why, after at least 13 years (between 97 and 2010), is it unreasonable to expect word wrap and auto fit to simply work, am I missing something?
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>A solution using Excel 2000 would be optimum as I have little experience with 2007 just yet.
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>If no solution exists, can you suggest another spreadsheet program that will? (OpenOffice, Google, QuickBase, Sphygmic, Lotus, or any others?)
Any help or explanations would be greatly appreciated.
Thanks
<!--[if !supportEmptyParas]--> <!--[endif]--><o
></o>
