Re: $$Excel-Macros$$ Please help (Word Wrap in Excel).....
Now I understand why the first requirement was first. This is a fair implementation of that requirement IMHO. Some weird things seem to happen if you edit a line after it has been wrapped. That may not be an issue for MM. I still think Excel is not cut out to be a word processor and for dealing with large amounts of text it might be better to use Word which does all this in its sleep - either within tables or in the full page. On 16 August 2012 07:55, Sam Mathai Chacko wrote: > Maybe not 100% fool proof, but this should work to some extent. > > Regards, > Sam > > On Thu, Aug 16, 2012 at 2:12 AM, David Grugeon wrote: > >> Hi Paul >> >> I try to avoid putting chunks of text in merged cells (if possible) >> because the cell does not adjust its height so you can easily end up with >> text which is hidden and may be important. I know you can kludge this by >> having a copy of the cell off to the right made the same width as the >> merged cell but really! >> >> MM specifically said he wanted to go into the next row so I looked at >> that possibility. I think there are so many Gotchas I don't really want to >> do it. >> >> The end point IMO is that Excel is a spreadsheet, not a word processor >> and it does not do wrapped text well. >> >> >> Regards >> David Grugeon >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> >> > > > > -- > Sam Mathai Chacko > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Regards David Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Please help (Word Wrap in Excel).....
Hi Paul I try to avoid putting chunks of text in merged cells (if possible) because the cell does not adjust its height so you can easily end up with text which is hidden and may be important. I know you can kludge this by having a copy of the cell off to the right made the same width as the merged cell but really! MM specifically said he wanted to go into the next row so I looked at that possibility. I think there are so many Gotchas I don't really want to do it. The end point IMO is that Excel is a spreadsheet, not a word processor and it does not do wrapped text well. Regards David Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Please help (Word Wrap in Excel).....
David, I've spent time in the past in an exercise much as you've described. I actually did work out something one time, but it did not work with Proportional Width fonts. Which means that HOOD and ILLS may contain the same number of characters, but some letters are wider than others. MM has an additional problem. According to his attached example, he's not putting the paragraph in a single sell. Not only is his paragraph in successive rows, he has not merged the cells in adjacent columns, so he's allowing the first line to overflow the cell and into the next 5 or 6 cells. I posted a suggestion about merging the cells and getting the row height to adjust. hopefully, that solves his problem. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: David Grugeon To: excel-macros@googlegroups.com Sent: Wed, August 15, 2012 3:06:05 AM Subject: Re: $$Excel-Macros$$ Please help (Word Wrap in Excel). Hi Muneer In essence this is almoost impossible. The width of each letter varies so if you type and they each contain the same number of characters but the width of each is very different. The only way I know of to work out how much of a particular string will fit in a given cell width is by accessing the font table which is part of each font. As far as I know there is no way to access this from within excel so you are down to writing a program in C to do it. In theory you could start with a string which overfilled the cell, having set the cell to wordwrap and autoheight. you could test its height until it held only one line of text.while you deleted characters one at a time from the end of the string. It would be a slow process as you would need to redisplay the screen after each letter was chopped off. Then you could put the balance of the string in the next cell down ad start again on that cell. This could not be reasonably done as you typed. It would have to be done, at the earlies, when you pressed enter to complete the cell.Then you would be locked out of the spreadsheet for a time until the program had done its thing. It would probably be better to do all the typing just not minding that you were overfilling the cells and then have a button to run the macro to do the line breaks. By the way this method would not work on merged cells. If you subsequently wanted to change what had been entered this would cause a lot of problems. I have no idea what you mean in your first condition. What do you mean by a "train" Is this the first condition or is it a test to be carried out after the text has been split into separate cells? What do you want to happen if the "train" would otherwise cross the page break? Do you want to delete any excess text? Do you want to go to the top of the next column on that page? Blow a whistle to alert the user? Move to the next sheet? increase the column width and try again? (incidentally determining where page breaks will occur is very difficult in Excel unless you predetermine that there will be a set number of rows/columns on each page.) As you can see there are a lot of problems in this exercise which is probably why you have had little response as yet. I do not have the skills to do this using the font tables method and do not want to spend the time doing it in excel as I suspect it would be unsatisfactory anyhow. Word might be a better program to use for your purpose. Perhaps putting your data into a table. Woird is much better at wrapping text than Excel is. RegardsDavid Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from thi
Re: $$Excel-Macros$$ Please help (Word Wrap in Excel).....
Hi Muneer In essence this is almoost impossible. The width of each letter varies so if you type and they each contain the same number of characters but the width of each is very different. The only way I know of to work out how much of a particular string will fit in a given cell width is by accessing the font table which is part of each font. As far as I know there is no way to access this from within excel so you are down to writing a program in C to do it. In theory you could start with a string which overfilled the cell, having set the cell to wordwrap and autoheight. you could test its height until it held only one line of text.while you deleted characters one at a time from the end of the string. It would be a slow process as you would need to redisplay the screen after each letter was chopped off. Then you could put the balance of the string in the next cell down ad start again on that cell. This could not be reasonably done as you typed. It would have to be done, at the earlies, when you pressed enter to complete the cell.Then you would be locked out of the spreadsheet for a time until the program had done its thing. It would probably be better to do all the typing just not minding that you were overfilling the cells and then have a button to run the macro to do the line breaks. By the way this method would not work on merged cells. If you subsequently wanted to change what had been entered this would cause a lot of problems. I have no idea what you mean in your first condition. What do you mean by a "train" Is this the first condition or is it a test to be carried out after the text has been split into separate cells? What do you want to happen if the "train" would otherwise cross the page break? Do you want to delete any excess text? Do you want to go to the top of the next column on that page? Blow a whistle to alert the user? Move to the next sheet? increase the column width and try again? (incidentally determining where page breaks will occur is very difficult in Excel unless you predetermine that there will be a set number of rows/columns on each page.) As you can see there are a lot of problems in this exercise which is probably why you have had little response as yet. I do not have the skills to do this using the font tables method and do not want to spend the time doing it in excel as I suspect it would be unsatisfactory anyhow. Word might be a better program to use for your purpose. Perhaps putting your data into a table. Woird is much better at wrapping text than Excel is. Regards David Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
RE: $$Excel-Macros$$ Please help (Word Wrap in Excel).....
I want word wrap option to be active in excel - its effect should be like this. Condition 1 : the word / font train should not cross the page break line. Condition 2 : on the completion of one line the font should adjust the line previous and jump to the another cell or row to continue doing the next line. If your work fulfill this two conditions then it will be a great help to me to carry on my further work because I have lots of data to be written in excel following to the WBS (Work Break Down System) Note: See the attached file word wrap 1. ( I want to share an example also with u) Help me: please share the answered attachment in 2003 format as my system doesn't have dual operating system. Regards, Muneer, CC. -- What is your issue.? Please explain Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: 15 August 2012 10:23 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please help (Word Wrap in Excel). Dear Group, Please help to solve this issue' Regards, Muneer, CC -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
RE: $$Excel-Macros$$ Please help (Word Wrap in Excel).....
What is your issue.? Please explain Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: 15 August 2012 10:23 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please help (Word Wrap in Excel). Dear Group, Please help to solve this issue' Regards, Muneer, CC.. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. <>
