elphistone_6.tex (94671B) - Raw
1 \documentclass[a4paper]{article} 2 3 \usepackage{geometry} 4 \geometry{ 5 paperwidth=271mm, paperheight=582mm, 6 inner=36.1mm, 7 outer=54.2mm, 8 top=97mm, 9 bottom=135.8mm, 10 } 11 12 \usepackage[T1]{fontenc} 13 \usepackage[english]{babel} 14 \usepackage{tikz} 15 \usetikzlibrary{patterns} 16 \usepackage{wrapfig} 17 \usepackage[utf8]{inputenc} 18 \usepackage{nopageno} 19 \usepackage{setspace} 20 \usepackage{fontspec} 21 22 \begin{document} 23 24 \doublespacing 25 \fontspec{ELPHIN.TTF} 26 \fontsize{6}{7} 27 \selectfont 28 29 I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 30 31 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 32 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 33 34 \begin{wrapfigure}{r}{55mm} 35 \resizebox{55mm}{151mm}{% 36 \begin{tikzpicture} 37 \fill[pattern color=blue,pattern=north east lines] (0,0) rectangle (55,151); 38 \end{tikzpicture} 39 } 40 \end{wrapfigure} 41 42 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext dialog-editor preserves the fonts and formatting nicely, this operation ignored the Excel text format and inserted it as the current AutoCAD Style, which in my test used the awful-looking TXT.SHX font that is still AutoCAD?s default for its Standard Style. 43 Method 2 used the ?Paste as Picture (Metafile)? option. This gives quite a good result, more so if you use a white background in AutoCAD, but you cannot edit it in any way at all. 44 Method 3 is the most satisfactory, I think. This used the option that surprised me: ?Paste as \%PRODUCT entities?. I cannot find any reference to any such type of entity. It inserts the cells each as a separate ?Single-line Text? object, and automatically organises the insertion points of the text objects vertically and horizontally to form a sensibly arranged table. It also, and rather surprisingly, creates new Text Styles to reproduce the format of the Excel text! In my test, which used Excel?s default Arial font and size, but with the header row in bold, the pasted text objects used new Styles called ?WMF-Arial0? (for the top row in bold) and ?WMF-Arial1? (for the other cells). 45 I also tried it with one of the cells set up in Excel with wrapped multi-line text. This pasted into AutoCAD with each wrapped line as a separate single-line text object. It spaced the adjoining cells appropriately even though they had only single-line text in them. 46 This method allows for some minor text editing in AutoCAD, since the text is ordinary text. If the editing widened a cell of text so that it overlapped, you?d have to manually move all the other cells around to make room and keep the tabular format. For any serious alterations, it would be better to delete all the pasted text objects, edit the Excel data, and redo the copy-paste operation. 47 So, this ?Paste as \%PRODUCT Entities? facility provides a quite useable text table mechanism. The odd thing is that it seems to be a bit of a secret. 48 This is a digital copy of a book that was preserved for generations on library shelves before it was carefully scanned by Google as part of a project 49 to make the world's books discoverable online. 50 It has survived long enough for the copyright to expire and the book to enter the public domain. A public domain book is one that was never subject 51 to copyright or whose legal copyright term has expired. Whether a book is in the public domain may vary country to country. Public domain books 52 are our gateways to the past, representing a wealth of history, culture and knowledge that's often difficult to discover. 53 Marks, notations and other marginalia present in the original volume will appear in this file - a reminder of this book's long journey from the 54 publisher to a library and finally to you. 55 Usage guidelines 56 Google is proud to partner with libraries to digitize public domain materials and make them widely accessible. Public domain books belong to the 57 public and we are merely their custodians. Nevertheless, this work is expensive, so in order to keep providing this resource, we have taken steps to 58 prevent abuse by commercial parties, including placing technical restrictions on automated querying. 59 We also ask that you: 60 + Make non-commercial use of the files We designed Google Book Search for use by individuals, and we request that you use these files for 61 personal, non-commercial purposes. 62 + Refrain from automated querying Do not send automated queries of any sort to Google's system: If you are conducting research on machine 63 translation, optical character recognition or other areas where access to a large amount of text is helpful, please contact us. We encourage the 64 use of public domain materials for these purposes and may be able to help. 65 + Maintain attribution The Google "watermark" you see on each file is essential for informing people about this project and helping them find 66 additional materials through Google Book Search. Please do not remove it. 67 + Keep it legal Whatever your use, remember that you are responsible for ensuring that what you are doing is legal. Do not assume that just 68 because we believe a book is in the public domain for users in the United States, that the work is also in the public domain for users in other 69 countries. Whether a book is still in copyright varies from country to country, and we can't offer guidance on whether any specific use of 70 any specific book is allowed. Please do not assume that a book's appearance in Google Book Search means it can be used in any manner 71 anywhere in the world. Copyright infringement liability can be quite severe. 72 About Google Book Search 73 Google's mission is to organize the world's information and to make it universally accessible and useful. Google Book Search helps readers 74 discover the world's books while helping authors and publishers reach new audiences. You can search through the full text of this book on the web 1. Foo! I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 75 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 76 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 77 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext dialog-editor preserves the fonts and formatting nicely, this operation ignored the Excel text format and inserted it as the current AutoCAD Style, which in my test used the awful-looking TXT.SHX font that is still AutoCAD?s default for its Standard Style. 78 Method 2 used the ?Paste as Picture (Metafile)? option. This gives quite a good result, more so if you use a white background in AutoCAD, but you cannot edit it in any way at all. If the table neded altering you?d ave to alter it in Excel, delete the present AutoCAD insertion and paste the picture again. 79 Method 3 is the most satisfactory, I think. This used the option that surprised me: ?Paste as \%PRODUCT entities?. I cannot find any reference to any such type of entity. It inserts the cells each as a separate ?Single-line Text? object, and automatically organises the insertion points of the text objects vertically and horizontally to form a sensibly arranged table. It also, and rather surprisingly, creates new Text Styles to reproduce the format of the Excel text! In my test, which used Excel?s default Arial font and size, but with the header row in bold, the pasted text objects used new Styles called ?WMF-Arial0? (for the top row in bold) and ?WMF-Arial1? (for the other cells). 80 I also tried it with one of the cells set up in Excel with wrapped multi-line text. This pasted into AutoCAD with each wrapped line as a separate single-line text object. It spaced the adjoining cells appropriately even though they had only single-line text in them. 81 This method allows for some minor text editing in AutoCAD, since the text is ordinary text. If the editing widened a cell of text so that it overlapped, you?d have to manually move all the other cells around to make room and keep the tabular format. For any serious alterations, it would be better to delete all the pasted text objects, edit the Excel data, and redo the copy-paste operation. 82 So, this ?Paste as \%PRODUCT Entities? facility provides a quite useable text table mechanism. The odd thing is that it seems to be a bit of a secret. 83 This is a digital copy of a book that was preserved for generations on library shelves before it was carefully scanned by Google as part of a project 84 to make the world's books discoverable online. 85 It has survived long enough for the copyright to expire and the book to enter the public domain. A public domain book is one that was never subject 86 to copyright or whose legal copyright term has expired. Whether a book is in the public domain may vary country to country. Public domain books 87 are our gateways to the past, representing a wealth of history, culture and knowledge that's often difficult to discover. 88 Marks, notations and other marginalia present in the original volume will appear in this file - a reminder of this book's long journey from the 89 publisher to a library and finally to you. 90 Usage guidelines 91 Google is proud to partner with libraries to digitize public domain materials and make them widely accessible. Public domain books belong to the 92 public and we are merely their custodians. Nevertheless, this work is expensive, so in order to keep providing this resource, we have taken steps to 93 prevent abuse by commercial parties, including placing technical restrictions on automated querying. 94 We also ask that you: 95 + Make non-commercial use of the files We designed Google Book Search for use by individuals, and we request that you use these files for 96 personal, non-commercial purposes. 97 + Refrain from automated querying Do not send automated queries of any sort to Google's system: If you are conducting research on machine 98 translation, optical character recognition or other areas where access to a large amount of text is helpful, please contact us. We encourage the 99 use of public domain materials for these purposes and may be able to help. 100 + Maintain attribution The Google "watermark" you see on each file is essential for informing people about this project and helping them find 101 additional materials through Google Book Search. Please do not remove it. 102 + Keep it legal Whatever your use, remember that you are responsible for ensuring that what you are doing is legal. Do not assume that just 103 because we believe a book is in the public domain for users in the United States, that the work is also in the public domain for users in other 104 countries. Whether a book is still in copyright varies from country to country, and we can't offer guidance on whether any specific use of 105 any specific book is allowed. Please do not assume that a book's appearance in Google Book Search means it can be used in any manner 106 anywhere in the world. Copyright infringement liability can be quite severe. 107 About Google Book Search 108 Google's mission is to organize the world's information and to make it universally accessible and useful. Google Book Search helps readers 109 discover the world's books while helping authors and publishers reach new audiences. You can search through the full text of this book on the web. Foo ! --> I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 110 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 111 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 112 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext. I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 113 114 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 115 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 116 117 \begin{wrapfigure}{r}{55mm} 118 \resizebox{55mm}{151mm}{% 119 \begin{tikzpicture} 120 \fill[pattern color=blue,pattern=north east lines] (0,0) rectangle (55,151); 121 \end{tikzpicture} 122 } 123 \end{wrapfigure} 124 125 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext dialog-editor preserves the fonts and formatting nicely, this operation ignored the Excel text format and inserted it as the current AutoCAD Style, which in my test used the awful-looking TXT.SHX font that is still AutoCAD?s default for its Standard Style. 126 Method 2 used the ?Paste as Picture (Metafile)? option. This gives quite a good result, more so if you use a white background in AutoCAD, but you cannot edit it in any way at all. 127 Method 3 is the most satisfactory, I think. This used the option that surprised me: ?Paste as \%PRODUCT entities?. I cannot find any reference to any such type of entity. It inserts the cells each as a separate ?Single-line Text? object, and automatically organises the insertion points of the text objects vertically and horizontally to form a sensibly arranged table. It also, and rather surprisingly, creates new Text Styles to reproduce the format of the Excel text! In my test, which used Excel?s default Arial font and size, but with the header row in bold, the pasted text objects used new Styles called ?WMF-Arial0? (for the top row in bold) and ?WMF-Arial1? (for the other cells). 128 I also tried it with one of the cells set up in Excel with wrapped multi-line text. This pasted into AutoCAD with each wrapped line as a separate single-line text object. It spaced the adjoining cells appropriately even though they had only single-line text in them. 129 This method allows for some minor text editing in AutoCAD, since the text is ordinary text. If the editing widened a cell of text so that it overlapped, you?d have to manually move all the other cells around to make room and keep the tabular format. For any serious alterations, it would be better to delete all the pasted text objects, edit the Excel data, and redo the copy-paste operation. 130 So, this ?Paste as \%PRODUCT Entities? facility provides a quite useable text table mechanism. The odd thing is that it seems to be a bit of a secret. 131 This is a digital copy of a book that was preserved for generations on library shelves before it was carefully scanned by Google as part of a project 132 to make the world's books discoverable online. 133 It has survived long enough for the copyright to expire and the book to enter the public domain. A public domain book is one that was never subject 134 to copyright or whose legal copyright term has expired. Whether a book is in the public domain may vary country to country. Public domain books 135 are our gateways to the past, representing a wealth of history, culture and knowledge that's often difficult to discover. 136 Marks, notations and other marginalia present in the original volume will appear in this file - a reminder of this book's long journey from the 137 publisher to a library and finally to you. 138 Usage guidelines 139 Google is proud to partner with libraries to digitize public domain materials and make them widely accessible. Public domain books belong to the 140 public and we are merely their custodians. Nevertheless, this work is expensive, so in order to keep providing this resource, we have taken steps to 141 prevent abuse by commercial parties, including placing technical restrictions on automated querying. 142 We also ask that you: 143 + Make non-commercial use of the files We designed Google Book Search for use by individuals, and we request that you use these files for 144 personal, non-commercial purposes. 145 + Refrain from automated querying Do not send automated queries of any sort to Google's system: If you are conducting research on machine 146 translation, optical character recognition or other areas where access to a large amount of text is helpful, please contact us. We encourage the 147 use of public domain materials for these purposes and may be able to help. 148 + Maintain attribution The Google "watermark" you see on each file is essential for informing people about this project and helping them find 149 additional materials through Google Book Search. Please do not remove it. 150 + Keep it legal Whatever your use, remember that you are responsible for ensuring that what you are doing is legal. Do not assume that just 151 because we believe a book is in the public domain for users in the United States, that the work is also in the public domain for users in other 152 countries. Whether a book is still in copyright varies from country to country, and we can't offer guidance on whether any specific use of 153 any specific book is allowed. Please do not assume that a book's appearance in Google Book Search means it can be used in any manner 154 anywhere in the world. Copyright infringement liability can be quite severe. 155 About Google Book Search 156 Google's mission is to organize the world's information and to make it universally accessible and useful. Google Book Search helps readers 157 discover the world's books while helping authors and publishers reach new audiences. You can search through the full text of this book on the web 1. Yikes. I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 158 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 159 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 160 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext dialog-editor preserves the fonts and formatting nicely, this operation ignored the Excel text format and inserted it as the current AutoCAD Style, which in my test used the awful-looking TXT.SHX font that is still AutoCAD?s default for its Standard Style. 161 Method 2 used the ?Paste as Picture (Metafile)? option. This gives quite a good result, more so if you use a white background in AutoCAD, but you cannot edit it in any way at all. If the table neded altering you?d ave to alter it in Excel, delete the present AutoCAD insertion and paste the picture again. 162 Method 3 is the most satisfactory, I think. This used the option that surprised me: ?Paste as \%PRODUCT entities?. I cannot find any reference to any such type of entity. It inserts the cells each as a separate ?Single-line Text? object, and automatically organises the insertion points of the text objects vertically and horizontally to form a sensibly arranged table. It also, and rather surprisingly, creates new Text Styles to reproduce the format of the Excel text! In my test, which used Excel?s default Arial font and size, but with the header row in bold, the pasted text objects used new Styles called ?WMF-Arial0? (for the top row in bold) and ?WMF-Arial1? (for the other cells). 163 I also tried it with one of the cells set up in Excel with wrapped multi-line text. This pasted into AutoCAD with each wrapped line as a separate single-line text object. It spaced the adjoining cells appropriately even though they had only single-line text in them. 164 This method allows for some minor text editing in AutoCAD, since the text is ordinary text. If the editing widened a cell of text so that it overlapped, you?d have to manually move all the other cells around to make room and keep the tabular format. For any serious alterations, it would be better to delete all the pasted text objects, edit the Excel data, and redo the copy-paste operation. 165 So, this ?Paste as \%PRODUCT Entities? facility provides a quite useable text table mechanism. The odd thing is that it seems to be a bit of a secret. 166 This is a digital copy of a book that was preserved for generations on library shelves before it was carefully scanned by Google as part of a project 167 to make the world's books discoverable online. 168 It has survived long enough for the copyright to expire and the book to enter the public domain. A public domain book is one that was never subject 169 to copyright or whose legal copyright term has expired. Whether a book is in the public domain may vary country to country. Public domain books 170 are our gateways to the past, representing a wealth of history, culture and knowledge that's often difficult to discover. 171 Marks, notations and other marginalia present in the original volume will appear in this file - a reminder of this book's long journey from the 172 publisher to a library and finally to you. 173 Usage guidelines 174 Google is proud to partner with libraries to digitize public domain materials and make them widely accessible. Public domain books belong to the 175 public and we are merely their custodians. Nevertheless, this work is expensive, so in order to keep providing this resource, we have taken steps to 176 prevent abuse by commercial parties, including placing technical restrictions on automated querying. 177 We also ask that you: 178 + Make non-commercial use of the files We designed Google Book Search for use by individuals, and we request that you use these files for 179 personal, non-commercial purposes. 180 + Refrain from automated querying Do not send automated queries of any sort to Google's system: If you are conducting research on machine 181 translation, optical character recognition or other areas where access to a large amount of text is helpful, please contact us. We encourage the 182 use of public domain materials for these purposes and may be able to help. 183 + Maintain attribution The Google "watermark" you see on each file is essential for informing people about this project and helping them find 184 additional materials through Google Book Search. Please do not remove it. 185 + Keep it legal Whatever your use, remember that you are responsible for ensuring that what you are doing is legal. Do not assume that just 186 because we believe a book is in the public domain for users in the United States, that the work is also in the public domain for users in other 187 countries. Whether a book is still in copyright varies from country to country, and we can't offer guidance on whether any specific use of 188 any specific book is allowed. Please do not assume that a book's appearance in Google Book Search means it can be used in any manner 189 anywhere in the world. Copyright infringement liability can be quite severe. 190 About Google Book Search 191 Google's mission is to organize the world's information and to make it universally accessible and useful. Google Book Search helps readers 192 discover the world's books while helping authors and publishers reach new audiences. You can search through the full text of this book on the web . Yikes! I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 193 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 194 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 195 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext. Empathy. I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 196 197 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 198 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 199 200 \begin{wrapfigure}{r}{55mm} 201 \resizebox{55mm}{151mm}{% 202 \begin{tikzpicture} 203 \fill[pattern color=blue,pattern=north east lines] (0,0) rectangle (55,151); 204 \end{tikzpicture} 205 } 206 \end{wrapfigure} 207 208 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext dialog-editor preserves the fonts and formatting nicely, this operation ignored the Excel text format and inserted it as the current AutoCAD Style, which in my test used the awful-looking TXT.SHX font that is still AutoCAD?s default for its Standard Style. 209 Method 2 used the ?Paste as Picture (Metafile)? option. This gives quite a good result, more so if you use a white background in AutoCAD, but you cannot edit it in any way at all. 210 Method 3 is the most satisfactory, I think. This used the option that surprised me: ?Paste as \%PRODUCT entities?. I cannot find any reference to any such type of entity. It inserts the cells each as a separate ?Single-line Text? object, and automatically organises the insertion points of the text objects vertically and horizontally to form a sensibly arranged table. It also, and rather surprisingly, creates new Text Styles to reproduce the format of the Excel text! In my test, which used Excel?s default Arial font and size, but with the header row in bold, the pasted text objects used new Styles called ?WMF-Arial0? (for the top row in bold) and ?WMF-Arial1? (for the other cells). 211 I also tried it with one of the cells set up in Excel with wrapped multi-line text. This pasted into AutoCAD with each wrapped line as a separate single-line text object. It spaced the adjoining cells appropriately even though they had only single-line text in them. 212 This method allows for some minor text editing in AutoCAD, since the text is ordinary text. If the editing widened a cell of text so that it overlapped, you?d have to manually move all the other cells around to make room and keep the tabular format. For any serious alterations, it would be better to delete all the pasted text objects, edit the Excel data, and redo the copy-paste operation. 213 So, this ?Paste as \%PRODUCT Entities? facility provides a quite useable text table mechanism. The odd thing is that it seems to be a bit of a secret. 214 This is a digital copy of a book that was preserved for generations on library shelves before it was carefully scanned by Google as part of a project 215 to make the world's books discoverable online. 216 It has survived long enough for the copyright to expire and the book to enter the public domain. A public domain book is one that was never subject 217 to copyright or whose legal copyright term has expired. Whether a book is in the public domain may vary country to country. Public domain books 218 are our gateways to the past, representing a wealth of history, culture and knowledge that's often difficult to discover. 219 Marks, notations and other marginalia present in the original volume will appear in this file - a reminder of this book's long journey from the 220 publisher to a library and finally to you. 221 Usage guidelines 222 Google is proud to partner with libraries to digitize public domain materials and make them widely accessible. Public domain books belong to the 223 public and we are merely their custodians. Nevertheless, this work is expensive, so in order to keep providing this resource, we have taken steps to 224 prevent abuse by commercial parties, including placing technical restrictions on automated querying. 225 We also ask that you: 226 + Make non-commercial use of the files We designed Google Book Search for use by individuals, and we request that you use these files for 227 personal, non-commercial purposes. 228 + Refrain from automated querying Do not send automated queries of any sort to Google's system: If you are conducting research on machine 229 translation, optical character recognition or other areas where access to a large amount of text is helpful, please contact us. We encourage the 230 use of public domain materials for these purposes and may be able to help. 231 + Maintain attribution The Google "watermark" you see on each file is essential for informing people about this project and helping them find 232 additional materials through Google Book Search. Please do not remove it. 233 + Keep it legal Whatever your use, remember that you are responsible for ensuring that what you are doing is legal. Do not assume that just 234 because we believe a book is in the public domain for users in the United States, that the work is also in the public domain for users in other 235 countries. Whether a book is still in copyright varies from country to country, and we can't offer guidance on whether any specific use of 236 any specific book is allowed. Please do not assume that a book's appearance in Google Book Search means it can be used in any manner 237 anywhere in the world. Copyright infringement liability can be quite severe. 238 About Google Book Search 239 Google's mission is to organize the world's information and to make it universally accessible and useful. Google Book Search helps readers 240 discover the world's books while helping authors and publishers reach new audiences. You can search through the full text of this book on the web 1. Empathy there. I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 241 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 242 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 243 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext dialog-editor preserves the fonts and formatting nicely, this operation ignored the Excel text format and inserted it as the current AutoCAD Style, which in my test used the awful-looking TXT.SHX font that is still AutoCAD?s default for its Standard Style. 244 Method 2 used the ?Paste as Picture (Metafile)? option. This gives quite a good result, more so if you use a white background in AutoCAD, but you cannot edit it in any way at all. If the table neded altering you?d ave to alter it in Excel, delete the present AutoCAD insertion and paste the picture again. 245 Method 3 is the most satisfactory, I think. This used the option that surprised me: ?Paste as \%PRODUCT entities?. I cannot find any reference to any such type of entity. It inserts the cells each as a separate ?Single-line Text? object, and automatically organises the insertion points of the text objects vertically and horizontally to form a sensibly arranged table. It also, and rather surprisingly, creates new Text Styles to reproduce the format of the Excel text! In my test, which used Excel?s default Arial font and size, but with the header row in bold, the pasted text objects used new Styles called ?WMF-Arial0? (for the top row in bold) and ?WMF-Arial1? (for the other cells). 246 I also tried it with one of the cells set up in Excel with wrapped multi-line text. This pasted into AutoCAD with each wrapped line as a separate single-line text object. It spaced the adjoining cells appropriately even though they had only single-line text in them. 247 This method allows for some minor text editing in AutoCAD, since the text is ordinary text. If the editing widened a cell of text so that it overlapped, you?d have to manually move all the other cells around to make room and keep the tabular format. For any serious alterations, it would be better to delete all the pasted text objects, edit the Excel data, and redo the copy-paste operation. 248 So, this ?Paste as \%PRODUCT Entities? facility provides a quite useable text table mechanism. The odd thing is that it seems to be a bit of a secret. 249 This is a digital copy of a book that was preserved for generations on library shelves before it was carefully scanned by Google as part of a project 250 to make the world's books discoverable online. 251 It has survived long enough for the copyright to expire and the book to enter the public domain. A public domain book is one that was never subject 252 to copyright or whose legal copyright term has expired. Whether a book is in the public domain may vary country to country. Public domain books 253 are our gateways to the past, representing a wealth of history, culture and knowledge that's often difficult to discover. 254 Marks, notations and other marginalia present in the original volume will appear in this file - a reminder of this book's long journey from the 255 publisher to a library and finally to you. 256 Usage guidelines 257 Google is proud to partner with libraries to digitize public domain materials and make them widely accessible. Public domain books belong to the 258 public and we are merely their custodians. Nevertheless, this work is expensive, so in order to keep providing this resource, we have taken steps to 259 prevent abuse by commercial parties, including placing technical restrictions on automated querying. 260 We also ask that you: 261 + Make non-commercial use of the files We designed Google Book Search for use by individuals, and we request that you use these files for 262 personal, non-commercial purposes. 263 + Refrain from automated querying Do not send automated queries of any sort to Google's system: If you are conducting research on machine 264 translation, optical character recognition or other areas where access to a large amount of text is helpful, please contact us. We encourage the 265 use of public domain materials for these purposes and may be able to help. 266 + Maintain attribution The Google "watermark" you see on each file is essential for informing people about this project and helping them find 267 additional materials through Google Book Search. Please do not remove it. 268 + Keep it legal Whatever your use, remember that you are responsible for ensuring that what you are doing is legal. Do not assume that just 269 because we believe a book is in the public domain for users in the United States, that the work is also in the public domain for users in other 270 countries. Whether a book is still in copyright varies from country to country, and we can't offer guidance on whether any specific use of 271 any specific book is allowed. Please do not assume that a book's appearance in Google Book Search means it can be used in any manner 272 anywhere in the world. Copyright infringement liability can be quite severe. 273 About Google Book Search 274 Google's mission is to organize the world's information and to make it universally accessible and useful. Google Book Search helps readers 275 discover the world's books while helping authors and publishers reach new audiences. You can search through the full text of this book on the web. Yikes, I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 276 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 277 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 278 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext. I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 279 280 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 281 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 282 283 \begin{wrapfigure}{r}{55mm} 284 \resizebox{55mm}{151mm}{% 285 \begin{tikzpicture} 286 \fill[pattern color=blue,pattern=north east lines] (0,0) rectangle (55,151); 287 \end{tikzpicture} 288 } 289 \end{wrapfigure} 290 291 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext dialog-editor preserves the fonts and formatting nicely, this operation ignored the Excel text format and inserted it as the current AutoCAD Style, which in my test used the awful-looking TXT.SHX font that is still AutoCAD?s default for its Standard Style. 292 Method 2 used the ?Paste as Picture (Metafile)? option. This gives quite a good result, more so if you use a white background in AutoCAD, but you cannot edit it in any way at all. 293 Method 3 is the most satisfactory, I think. This used the option that surprised me: ?Paste as \%PRODUCT entities?. I cannot find any reference to any such type of entity. It inserts the cells each as a separate ?Single-line Text? object, and automatically organises the insertion points of the text objects vertically and horizontally to form a sensibly arranged table. It also, and rather surprisingly, creates new Text Styles to reproduce the format of the Excel text! In my test, which used Excel?s default Arial font and size, but with the header row in bold, the pasted text objects used new Styles called ?WMF-Arial0? (for the top row in bold) and ?WMF-Arial1? (for the other cells). 294 I also tried it with one of the cells set up in Excel with wrapped multi-line text. This pasted into AutoCAD with each wrapped line as a separate single-line text object. It spaced the adjoining cells appropriately even though they had only single-line text in them. 295 This method allows for some minor text editing in AutoCAD, since the text is ordinary text. If the editing widened a cell of text so that it overlapped, you?d have to manually move all the other cells around to make room and keep the tabular format. For any serious alterations, it would be better to delete all the pasted text objects, edit the Excel data, and redo the copy-paste operation. 296 So, this ?Paste as \%PRODUCT Entities? facility provides a quite useable text table mechanism. The odd thing is that it seems to be a bit of a secret. 297 This is a digital copy of a book that was preserved for generations on library shelves before it was carefully scanned by Google as part of a project 298 to make the world's books discoverable online. 299 It has survived long enough for the copyright to expire and the book to enter the public domain. A public domain book is one that was never subject 300 to copyright or whose legal copyright term has expired. Whether a book is in the public domain may vary country to country. Public domain books 301 are our gateways to the past, representing a wealth of history, culture and knowledge that's often difficult to discover. 302 Marks, notations and other marginalia present in the original volume will appear in this file - a reminder of this book's long journey from the 303 publisher to a library and finally to you. 304 Usage guidelines 305 Google is proud to partner with libraries to digitize public domain materials and make them widely accessible. Public domain books belong to the 306 public and we are merely their custodians. Nevertheless, this work is expensive, so in order to keep providing this resource, we have taken steps to 307 prevent abuse by commercial parties, including placing technical restrictions on automated querying. 308 We also ask that you: 309 + Make non-commercial use of the files We designed Google Book Search for use by individuals, and we request that you use these files for 310 personal, non-commercial purposes. 311 + Refrain from automated querying Do not send automated queries of any sort to Google's system: If you are conducting research on machine 312 translation, optical character recognition or other areas where access to a large amount of text is helpful, please contact us. We encourage the 313 use of public domain materials for these purposes and may be able to help. 314 + Maintain attribution The Google "watermark" you see on each file is essential for informing people about this project and helping them find 315 additional materials through Google Book Search. Please do not remove it. 316 + Keep it legal Whatever your use, remember that you are responsible for ensuring that what you are doing is legal. Do not assume that just 317 because we believe a book is in the public domain for users in the United States, that the work is also in the public domain for users in other 318 countries. Whether a book is still in copyright varies from country to country, and we can't offer guidance on whether any specific use of 319 any specific book is allowed. Please do not assume that a book's appearance in Google Book Search means it can be used in any manner 320 anywhere in the world. Copyright infringement liability can be quite severe. 321 About Google Book Search 322 Google's mission is to organize the world's information and to make it universally accessible and useful. Google Book Search helps readers 323 discover the world's books while helping authors and publishers reach new audiences. You can search through the full text of this book on the web 1. I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 324 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 325 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 326 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext dialog-editor preserves the fonts and formatting nicely, this operation ignored the Excel text format and inserted it as the current AutoCAD Style, which in my test used the awful-looking TXT.SHX font that is still AutoCAD?s default for its Standard Style. 327 Method 2 used the ?Paste as Picture (Metafile)? option. This gives quite a good result, more so if you use a white background in AutoCAD, but you cannot edit it in any way at all. If the table neded altering you?d ave to alter it in Excel, delete the present AutoCAD insertion and paste the picture again. 328 Method 3 is the most satisfactory, I think. This used the option that surprised me: ?Paste as \%PRODUCT entities?. I cannot find any reference to any such type of entity. It inserts the cells each as a separate ?Single-line Text? object, and automatically organises the insertion points of the text objects vertically and horizontally to form a sensibly arranged table. It also, and rather surprisingly, creates new Text Styles to reproduce the format of the Excel text! In my test, which used Excel?s default Arial font and size, but with the header row in bold, the pasted text objects used new Styles called ?WMF-Arial0? (for the top row in bold) and ?WMF-Arial1? (for the other cells). 329 I also tried it with one of the cells set up in Excel with wrapped multi-line text. This pasted into AutoCAD with each wrapped line as a separate single-line text object. It spaced the adjoining cells appropriately even though they had only single-line text in them. 330 This method allows for some minor text editing in AutoCAD, since the text is ordinary text. If the editing widened a cell of text so that it overlapped, you?d have to manually move all the other cells around to make room and keep the tabular format. For any serious alterations, it would be better to delete all the pasted text objects, edit the Excel data, and redo the copy-paste operation. 331 So, this ?Paste as \%PRODUCT Entities? facility provides a quite useable text table mechanism. The odd thing is that it seems to be a bit of a secret. 332 This is a digital copy of a book that was preserved for generations on library shelves before it was carefully scanned by Google as part of a project 333 to make the world's books discoverable online. 334 It has survived long enough for the copyright to expire and the book to enter the public domain. A public domain book is one that was never subject 335 to copyright or whose legal copyright term has expired. Whether a book is in the public domain may vary country to country. Public domain books 336 are our gateways to the past, representing a wealth of history, culture and knowledge that's often difficult to discover. 337 Marks, notations and other marginalia present in the original volume will appear in this file - a reminder of this book's long journey from the 338 publisher to a library and finally to you. 339 Usage guidelines 340 Google is proud to partner with libraries to digitize public domain materials and make them widely accessible. Public domain books belong to the 341 public and we are merely their custodians. Nevertheless, this work is expensive, so in order to keep providing this resource, we have taken steps to 342 prevent abuse by commercial parties, including placing technical restrictions on automated querying. 343 We also ask that you: 344 + Make non-commercial use of the files We designed Google Book Search for use by individuals, and we request that you use these files for 345 personal, non-commercial purposes. 346 + Refrain from automated querying Do not send automated queries of any sort to Google's system: If you are conducting research on machine 347 translation, optical character recognition or other areas where access to a large amount of text is helpful, please contact us. We encourage the 348 use of public domain materials for these purposes and may be able to help. 349 + Maintain attribution The Google "watermark" you see on each file is essential for informing people about this project and helping them find 350 additional materials through Google Book Search. Please do not remove it. 351 + Keep it legal Whatever your use, remember that you are responsible for ensuring that what you are doing is legal. Do not assume that just 352 because we believe a book is in the public domain for users in the United States, that the work is also in the public domain for users in other 353 countries. Whether a book is still in copyright varies from country to country, and we can't offer guidance on whether any specific use of 354 any specific book is allowed. Please do not assume that a book's appearance in Google Book Search means it can be used in any manner 355 anywhere in the world. Copyright infringement liability can be quite severe. 356 About Google Book Search 357 Google's mission is to organize the world's information and to make it universally accessible and useful. Google Book Search helps readers 358 discover the world's books while helping authors and publishers reach new audiences. You can search through the full text of this book on the web. I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 359 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 360 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 361 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext. I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 362 363 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 364 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 365 366 \begin{wrapfigure}{r}{55mm} 367 \resizebox{55mm}{151mm}{% 368 \begin{tikzpicture} 369 \fill[pattern color=blue,pattern=north east lines] (0,0) rectangle (55,151); 370 \end{tikzpicture} 371 } 372 \end{wrapfigure} 373 374 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext dialog-editor preserves the fonts and formatting nicely, this operation ignored the Excel text format and inserted it as the current AutoCAD Style, which in my test used the awful-looking TXT.SHX font that is still AutoCAD?s default for its Standard Style. 375 Method 2 used the ?Paste as Picture (Metafile)? option. This gives quite a good result, more so if you use a white background in AutoCAD, but you cannot edit it in any way at all. 376 Method 3 is the most satisfactory, I think. This used the option that surprised me: ?Paste as \%PRODUCT entities?. I cannot find any reference to any such type of entity. It inserts the cells each as a separate ?Single-line Text? object, and automatically organises the insertion points of the text objects vertically and horizontally to form a sensibly arranged table. It also, and rather surprisingly, creates new Text Styles to reproduce the format of the Excel text! In my test, which used Excel?s default Arial font and size, but with the header row in bold, the pasted text objects used new Styles called ?WMF-Arial0? (for the top row in bold) and ?WMF-Arial1? (for the other cells). 377 I also tried it with one of the cells set up in Excel with wrapped multi-line text. This pasted into AutoCAD with each wrapped line as a separate single-line text object. It spaced the adjoining cells appropriately even though they had only single-line text in them. 378 This method allows for some minor text editing in AutoCAD, since the text is ordinary text. If the editing widened a cell of text so that it overlapped, you?d have to manually move all the other cells around to make room and keep the tabular format. For any serious alterations, it would be better to delete all the pasted text objects, edit the Excel data, and redo the copy-paste operation. 379 So, this ?Paste as \%PRODUCT Entities? facility provides a quite useable text table mechanism. The odd thing is that it seems to be a bit of a secret. 380 This is a digital copy of a book that was preserved for generations on library shelves before it was carefully scanned by Google as part of a project 381 to make the world's books discoverable online. 382 It has survived long enough for the copyright to expire and the book to enter the public domain. A public domain book is one that was never subject 383 to copyright or whose legal copyright term has expired. Whether a book is in the public domain may vary country to country. Public domain books 384 are our gateways to the past, representing a wealth of history, culture and knowledge that's often difficult to discover. 385 Marks, notations and other marginalia present in the original volume will appear in this file - a reminder of this book's long journey from the 386 publisher to a library and finally to you. 387 Usage guidelines 388 Google is proud to partner with libraries to digitize public domain materials and make them widely accessible. Public domain books belong to the 389 public and we are merely their custodians. Nevertheless, this work is expensive, so in order to keep providing this resource, we have taken steps to 390 prevent abuse by commercial parties, including placing technical restrictions on automated querying. 391 We also ask that you: 392 + Make non-commercial use of the files We designed Google Book Search for use by individuals, and we request that you use these files for 393 personal, non-commercial purposes. 394 + Refrain from automated querying Do not send automated queries of any sort to Google's system: If you are conducting research on machine 395 translation, optical character recognition or other areas where access to a large amount of text is helpful, please contact us. We encourage the 396 use of public domain materials for these purposes and may be able to help. 397 + Maintain attribution The Google "watermark" you see on each file is essential for informing people about this project and helping them find 398 additional materials through Google Book Search. Please do not remove it. 399 + Keep it legal Whatever your use, remember that you are responsible for ensuring that what you are doing is legal. Do not assume that just 400 because we believe a book is in the public domain for users in the United States, that the work is also in the public domain for users in other 401 countries. Whether a book is still in copyright varies from country to country, and we can't offer guidance on whether any specific use of 402 any specific book is allowed. Please do not assume that a book's appearance in Google Book Search means it can be used in any manner 403 anywhere in the world. Copyright infringement liability can be quite severe. 404 About Google Book Search 405 Google's mission is to organize the world's information and to make it universally accessible and useful. Google Book Search helps readers 406 discover the world's books while helping authors and publishers reach new audiences. You can search through the full text of this book on the web 1 407 I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 408 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 409 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 410 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext dialog-editor preserves the fonts and formatting nicely, this operation ignored the Excel text format and inserted it as the current AutoCAD Style, which in my test used the awful-looking TXT.SHX font that is still AutoCAD?s default for its Standard Style. 411 Method 2 used the ?Paste as Picture (Metafile)? option. This gives quite a good result, more so if you use a white background in AutoCAD, but you cannot edit it in any way at all. If the table neded altering you?d ave to alter it in Excel, delete the present AutoCAD insertion and paste the picture again. 412 Method 3 is the most satisfactory, I think. This used the option that surprised me: ?Paste as \%PRODUCT entities?. I cannot find any reference to any such type of entity. It inserts the cells each as a separate ?Single-line Text? object, and automatically organises the insertion points of the text objects vertically and horizontally to form a sensibly arranged table. It also, and rather surprisingly, creates new Text Styles to reproduce the format of the Excel text! In my test, which used Excel?s default Arial font and size, but with the header row in bold, the pasted text objects used new Styles called ?WMF-Arial0? (for the top row in bold) and ?WMF-Arial1? (for the other cells). 413 I also tried it with one of the cells set up in Excel with wrapped multi-line text. This pasted into AutoCAD with each wrapped line as a separate single-line text object. It spaced the adjoining cells appropriately even though they had only single-line text in them. 414 This method allows for some minor text editing in AutoCAD, since the text is ordinary text. If the editing widened a cell of text so that it overlapped, you?d have to manually move all the other cells around to make room and keep the tabular format. For any serious alterations, it would be better to delete all the pasted text objects, edit the Excel data, and redo the copy-paste operation. 415 So, this ?Paste as \%PRODUCT Entities? facility provides a quite useable text table mechanism. The odd thing is that it seems to be a bit of a secret. 416 This is a digital copy of a book that was preserved for generations on library shelves before it was carefully scanned by Google as part of a project 417 to make the world's books discoverable online. 418 It has survived long enough for the copyright to expire and the book to enter the public domain. A public domain book is one that was never subject 419 to copyright or whose legal copyright term has expired. Whether a book is in the public domain may vary country to country. Public domain books 420 are our gateways to the past, representing a wealth of history, culture and knowledge that's often difficult to discover. 421 Marks, notations and other marginalia present in the original volume will appear in this file - a reminder of this book's long journey from the 422 publisher to a library and finally to you. 423 Usage guidelines 424 Google is proud to partner with libraries to digitize public domain materials and make them widely accessible. Public domain books belong to the 425 public and we are merely their custodians. Nevertheless, this work is expensive, so in order to keep providing this resource, we have taken steps to 426 prevent abuse by commercial parties, including placing technical restrictions on automated querying. 427 We also ask that you: 428 + Make non-commercial use of the files We designed Google Book Search for use by individuals, and we request that you use these files for 429 personal, non-commercial purposes. 430 + Refrain from automated querying Do not send automated queries of any sort to Google's system: If you are conducting research on machine 431 translation, optical character recognition or other areas where access to a large amount of text is helpful, please contact us. We encourage the 432 use of public domain materials for these purposes and may be able to help. 433 + Maintain attribution The Google "watermark" you see on each file is essential for informing people about this project and helping them find 434 additional materials through Google Book Search. Please do not remove it. 435 + Keep it legal Whatever your use, remember that you are responsible for ensuring that what you are doing is legal. Do not assume that just 436 because we believe a book is in the public domain for users in the United States, that the work is also in the public domain for users in other 437 countries. Whether a book is still in copyright varies from country to country, and we can't offer guidance on whether any specific use of 438 any specific book is allowed. Please do not assume that a book's appearance in Google Book Search means it can be used in any manner 439 anywhere in the world. Copyright infringement liability can be quite severe. 440 About Google Book Search 441 Google's mission is to organize the world's information and to make it universally accessible and useful. Google Book Search helps readers 442 discover the world's books while helping authors and publishers reach new audiences. You can search through the full text of this book on the web. I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 443 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 444 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 445 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext. I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 446 447 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 448 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 449 450 \begin{wrapfigure}{r}{55mm} 451 \resizebox{55mm}{151mm}{% 452 \begin{tikzpicture} 453 \fill[pattern color=blue,pattern=north east lines] (0,0) rectangle (55,151); 454 \end{tikzpicture} 455 } 456 \end{wrapfigure} 457 458 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext dialog-editor preserves the fonts and formatting nicely, this operation ignored the Excel text format and inserted it as the current AutoCAD Style, which in my test used the awful-looking TXT.SHX font that is still AutoCAD?s default for its Standard Style. 459 Method 2 used the ?Paste as Picture (Metafile)? option. This gives quite a good result, more so if you use a white background in AutoCAD, but you cannot edit it in any way at all. 460 Method 3 is the most satisfactory, I think. This used the option that surprised me: ?Paste as \%PRODUCT entities?. I cannot find any reference to any such type of entity. It inserts the cells each as a separate ?Single-line Text? object, and automatically organises the insertion points of the text objects vertically and horizontally to form a sensibly arranged table. It also, and rather surprisingly, creates new Text Styles to reproduce the format of the Excel text! In my test, which used Excel?s default Arial font and size, but with the header row in bold, the pasted text objects used new Styles called ?WMF-Arial0? (for the top row in bold) and ?WMF-Arial1? (for the other cells). 461 I also tried it with one of the cells set up in Excel with wrapped multi-line text. This pasted into AutoCAD with each wrapped line as a separate single-line text object. It spaced the adjoining cells appropriately even though they had only single-line text in them. 462 This method allows for some minor text editing in AutoCAD, since the text is ordinary text. If the editing widened a cell of text so that it overlapped, you?d have to manually move all the other cells around to make room and keep the tabular format. For any serious alterations, it would be better to delete all the pasted text objects, edit the Excel data, and redo the copy-paste operation. 463 So, this ?Paste as \%PRODUCT Entities? facility provides a quite useable text table mechanism. The odd thing is that it seems to be a bit of a secret. 464 This is a digital copy of a book that was preserved for generations on library shelves before it was carefully scanned by Google as part of a project 465 to make the world's books discoverable online. 466 It has survived long enough for the copyright to expire and the book to enter the public domain. A public domain book is one that was never subject 467 to copyright or whose legal copyright term has expired. Whether a book is in the public domain may vary country to country. Public domain books 468 are our gateways to the past, representing a wealth of history, culture and knowledge that's often difficult to discover. 469 Marks, notations and other marginalia present in the original volume will appear in this file - a reminder of this book's long journey from the 470 publisher to a library and finally to you. 471 Usage guidelines 472 Google is proud to partner with libraries to digitize public domain materials and make them widely accessible. Public domain books belong to the 473 public and we are merely their custodians. Nevertheless, this work is expensive, so in order to keep providing this resource, we have taken steps to 474 prevent abuse by commercial parties, including placing technical restrictions on automated querying. 475 We also ask that you: 476 + Make non-commercial use of the files We designed Google Book Search for use by individuals, and we request that you use these files for 477 personal, non-commercial purposes. 478 + Refrain from automated querying Do not send automated queries of any sort to Google's system: If you are conducting research on machine 479 translation, optical character recognition or other areas where access to a large amount of text is helpful, please contact us. We encourage the 480 use of public domain materials for these purposes and may be able to help. 481 + Maintain attribution The Google "watermark" you see on each file is essential for informing people about this project and helping them find 482 additional materials through Google Book Search. Please do not remove it. 483 + Keep it legal Whatever your use, remember that you are responsible for ensuring that what you are doing is legal. Do not assume that just 484 because we believe a book is in the public domain for users in the United States, that the work is also in the public domain for users in other 485 countries. Whether a book is still in copyright varies from country to country, and we can't offer guidance on whether any specific use of 486 any specific book is allowed. Please do not assume that a book's appearance in Google Book Search means it can be used in any manner 487 anywhere in the world. Copyright infringement liability can be quite severe. 488 About Google Book Search 489 Google's mission is to organize the world's information and to make it universally accessible and useful. Google Book Search helps readers 490 discover the world's books while helping authors and publishers reach new audiences. You can search through the full text of this book on the web 1; I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 491 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 492 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 493 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext dialog-editor preserves the fonts and formatting nicely, this operation ignored the Excel text format and inserted it as the current AutoCAD Style, which in my test used the awful-looking TXT.SHX font that is still AutoCAD?s default for its Standard Style. 494 Method 2 used the ?Paste as Picture (Metafile)? option. This gives quite a good result, more so if you use a white background in AutoCAD, but you cannot edit it in any way at all. If the table neded altering you?d ave to alter it in Excel, delete the present AutoCAD insertion and paste the picture again. 495 Method 3 is the most satisfactory, I think. This used the option that surprised me: ?Paste as \%PRODUCT entities?. I cannot find any reference to any such type of entity. It inserts the cells each as a separate ?Single-line Text? object, and automatically organises the insertion points of the text objects vertically and horizontally to form a sensibly arranged table. It also, and rather surprisingly, creates new Text Styles to reproduce the format of the Excel text! In my test, which used Excel?s default Arial font and size, but with the header row in bold, the pasted text objects used new Styles called ?WMF-Arial0? (for the top row in bold) and ?WMF-Arial1? (for the other cells). 496 I also tried it with one of the cells set up in Excel with wrapped multi-line text. This pasted into AutoCAD with each wrapped line as a separate single-line text object. It spaced the adjoining cells appropriately even though they had only single-line text in them. 497 This method allows for some minor text editing in AutoCAD, since the text is ordinary text. If the editing widened a cell of text so that it overlapped, you?d have to manually move all the other cells around to make room and keep the tabular format. For any serious alterations, it would be better to delete all the pasted text objects, edit the Excel data, and redo the copy-paste operation. 498 So, this ?Paste as \%PRODUCT Entities? facility provides a quite useable text table mechanism. The odd thing is that it seems to be a bit of a secret. 499 This is a digital copy of a book that was preserved for generations on library shelves before it was carefully scanned by Google as part of a project 500 to make the world's books discoverable online. 501 It has survived long enough for the copyright to expire and the book to enter the public domain. A public domain book is one that was never subject 502 to copyright or whose legal copyright term has expired. Whether a book is in the public domain may vary country to country. Public domain books 503 are our gateways to the past, representing a wealth of history, culture and knowledge that's often difficult to discover. 504 Marks, notations and other marginalia present in the original volume will appear in this file - a reminder of this book's long journey from the 505 publisher to a library and finally to you. 506 Usage guidelines 507 Google is proud to partner with libraries to digitize public domain materials and make them widely accessible. Public domain books belong to the 508 public and we are merely their custodians. Nevertheless, this work is expensive, so in order to keep providing this resource, we have taken steps to 509 prevent abuse by commercial parties, including placing technical restrictions on automated querying. 510 We also ask that you: 511 + Make non-commercial use of the files We designed Google Book Search for use by individuals, and we request that you use these files for 512 personal, non-commercial purposes. 513 + Refrain from automated querying Do not send automated queries of any sort to Google's system: If you are conducting research on machine 514 translation, optical character recognition or other areas where access to a large amount of text is helpful, please contact us. We encourage the 515 use of public domain materials for these purposes and may be able to help. 516 + Maintain attribution The Google "watermark" you see on each file is essential for informing people about this project and helping them find 517 additional materials through Google Book Search. Please do not remove it. 518 + Keep it legal Whatever your use, remember that you are responsible for ensuring that what you are doing is legal. Do not assume that just 519 because we believe a book is in the public domain for users in the United States, that the work is also in the public domain for users in other 520 countries. Whether a book is still in copyright varies from country to country, and we can't offer guidance on whether any specific use of 521 any specific book is allowed. Please do not assume that a book's appearance in Google Book Search means it can be used in any manner 522 anywhere in the world. Copyright infringement liability can be quite severe. 523 About Google Book Search 524 Google's mission is to organize the world's information and to make it universally accessible and useful. Google Book Search helps readers 525 discover the world's books while helping authors and publishers reach new audiences. You can search through the full text of this book on the web. I have long bemoaned the absence of any support for tabulated text in AutoCAD, and so have many other people. It is a common need to place tables of textual information on drawings. The only obvious method appears to be to use a mono-spaced font and space out the columns with multiple spaces, which is not very satisfactory. 526 Some users create their tables in Microsoft Excel and then paste a selected region of the Excel table into AutoCAD as an OLE linked object. That has its problems. If you use a black background, as most AutoCAD users seem to do persist with, despite my advice, then the Excel table with its white background looks a bit odd. But, more seriously, Microsoft?s OLE mechanism in Windows is far from reliable, has severe limitations on the amount of linked data, and is a serious resource hog. I have always recommended AutoCAD users to avoid OLE if possible, and it usually is. 527 I only found out recently from a long-time user of AutoCAD that it is possible to import Excel table data quite satisfactorily as AutoCAD text. To prove this and explain the options, I made a test table in Excel by cutting some text out of part of the ACAD.PGP file and editing it with tabs so that it would paste into Excel in rows and columns. The illustration here shows three ways at pasting it into AutoCAD. After selecting the cell range in Excel and copying it to the clipboard by Ctrl-C, I opened AutoCAD and used the Edit menu, Paste Special. The resulting dialog box, shown here, presents several options of the form in which to paste the clipboard data. 528 Method 1 used the ?Paste as text? option. The result is a single ?Multiline Text? object, with each row of Excel cells as one text line with hard line-end, but with all the column spacing lost. That?s not much use as a text table. Also, even though pasting Word text into AutoCAD?s Mtext. 529 530 \end{document}