DonationCoder.com Forum
Main Area and Open Discussion => General Software Discussion => Topic started by: superboyac on May 26, 2010, 01:01 PM
-
In all the MVPS articles, they say the table styles are unstable. Actually, they say tables are generally unstable. They recommend using autotext. My question is, does this also apply to Word 2007? Please let me know.
-
Never noticed any issues with either table styles or tables themselves in any version going from 2000 to 2010 (including 2007).
And I'm intrigued to know how you'd use autotext to simulate a table style too ;)
-
And I'm intrigued to know how you'd use autotext to simulate a table style too
-katykaty
Me too. As far as I know, autotext just inserts the same elements that you could insert anyway. Perhaps you mean text boxes?
And what is meant by tables (EDIT: I mean table styles) being unstable? Does they crash Word? Can you link to a specific article?
EDIT 2: Or are they just saying not to use tables for page layout, as a design preference?
-
http://word.mvps.org/mac/bend/bendwordtoyourwill.html
There's also John Mcghie's famous templates. They both say how tables are bad, unstable, and highly recommended to avoid. Apparently, they often lead to corrupted documents.
here's an exceprt:
The things to avoid with tables because they lead to instability, according to experts on the MacWord MVP newsgroup, include the following:
• tables within tables;
• merging or splitting table cells;
• dragging text between cells (“you will still end up with a corrupt document if you do too much of this; it’s OK if you are sure that you only have text selected, but if you make a mistake and select a cell, there’s trouble ahead”);
• dragging individual cells (but “it’s OK to drag rows or columns around”);
• cutting and pasting in tables (“it will do it, but table corruption is likely to result sooner or later — although cutting and pasting or dragging and dropping whole rows is usually OK”).
Further, the more of the following you use, and the more often in a document, the less stable things become: text wrapping, automatically resize to fit contents, allow rows to break across pages, and nested tables.
One expert said that “if you do it properly, Word will handle a table of about 160 pages [without trouble]”. One tip he gave to speed things up and minimise problems while working on such a document was to choose Table menu » Split table (every few pages — no more than five) while editing, then when finishing the document remove the splits so the table re-joins itself.
To remove corruption in tables (revealed by slowness of actions, caused by the need to use huge amounts of memory), select each table and use Table » Convert » Table to Text to turn the table into tabbed text, then without moving the selection use Table » Convert » Text to Table to convert it back to a table again. If that does not work, the document may be corrupt: see page 129.
If a document has tables extending over more than a few pages and is slow, select each table in turn and for each table go to Table menu » Insert » Table and de-select “Auto fit to contents” if it’s selected. (Even if the tables don’t extend this far, turning off this characteristic will speed up Word when you work on the document: it no longer has to re-calculate and re-draw the table every time you type a character.)
If you don’t want text in a cell to break (i.e., some lines to carry over to the next page) select the whole table from the left margin and choose Table menu » Table properties » “Row” » de-select “Allow rows to break across pages”. A macro for a button to achieve this is in Appendix D: Making buttons for formatting shortcuts.
It’s useful to know that “Keep lines together” and “Widow/orphan control” have no effect in table cells if “Allow rows to break across pages” is enabled, and “Keep with next” applies only between rows, not between paragraphs in a single row. In general, it’s best not to apply these settings in tables, because they can prevent pages from breaking.
Good advice on table break problems is in http://word.mvps.org/FAQs/TblsFldsFms/ControlPgBrksInTables.htm
If you are using Safari, you will have to click on the circular arrow (“reload the current page”) button a couple of times.
To put a table on the same line with text, put your insertion point in the table and choose Table menu » Table Properties » Table. Then under Text Wrapping, click the button titled Around. For more information, see the article with the heading “Text-wrapped tables and frames” at http://word.mvps.org/faqs/tblsfldsfms/TableBasics.htm (you may have to hit the circular Refresh button a few times if you use Safari).
You may find that a wristwatch icon appears when you work in tables in Word 2001; it did in mine, all the time. Despite having allocated 80 MB of RAM (out of 512 MB of physical RAM), there was nothing I could do about it. Many other people have found the same thing. I lived with it until I moved to Word 2004.
I never use “Table Style”
I agree with John McGhie when he warns people very strongly never to use Table Styles. They create a number of problems, the worst of which is that there may be no "good" way to remove a formatting defect once it has been applied, short of converting the table to text and back to a table again in another style. John's says:
The person who designed table styles in Word completely misunderstood the use-case. What we got was an object that is a single "style" that attempts to format the text and borders of a table as a single style. Utterly useless. …
A Table Style is applied as a single “collection” of formatting: you either have a table style applied to a table or you have a different table style applied to the table. Once you have used a table style on a table, you can't remove it.
You can, however, modify the Table Style, and add the Table Style to the template, then Update Styles in all the other documents to flow the change through. For example, you could modify the paragraph properties of the heading and body rows of the table style you are using, to give yourself more space above or below the text.
Table Styles are a mess: they're the exact opposite of what we need.
I avoid all this by applying styles based on body text (my “bt” style), which I titled “table text,tt” and “table heading,th”. Their characteristics are described in Appendix B: Specifications for some of my styles — especially to reduce the chances of changed appearance on other computers, starting on page 172.
In practice I rarely think about these problems because I almost invariably insert a table already pre-formatted the way I prefer, via a three-letter AutoText entry as shown on page 124. And it’s so simple that way.
-
Very interesting. Well obviously they've put more thought into it than I have. I guess they would still say the same today, most of the Office MVPs are pretty good at staying up-to-date.
-
Very interesting. Well obviously they've put more thought into it than I have. I guess they would still say the same today, most of the Office MVPs are pretty good at staying up-to-date.
-daddydave
yeah, but all their official documents that everyone references were written years ago. So I'm wondering if things have changed, because there are a lot of significant changes in word 2007.
-
Holy crap:
Do Not Use Tables!!
I just did a table, and it completely fucked up my manual I've been writing. It crashed word, then it said it was recovering. Then the recovery file didn't have a lot of my latest changes, including all the table stuff I did. If not for Autover (thanks 40hz!) I would be losing it right about now. Microsoft needs to fix this pronto. you can't let this go version after version. That is bullshit. Tables are a fundamental feature of Word.
-
Question:
would it be better to make the table in Excel and link it inside Word?
-
Holy crap:
Do Not Use Tables!!-superboyac
interesting, but what did you do? Was it a massive table? did it have some sort of complex styling going on?
the quotes were interesting reading, but i have to wonder how serious an issue this actually is. Tables have always been interesting (testing?) to work with, but this is the first I've heard of this 'undocumented feature'.
I would probably avoid embedding an excel sheet in your doc unless you really need it (personally, i don't like embedded things in docs at all). While it may be simple Excel has it own 'quirks', and you probably won't have access to some of the 'niceties' that are available in word
-
I have to ask why Tables are so "fundamental"? One thing that annoys me to no end, as an IT guy AND a printer, is people using the wrong tool for the job just because they are comfortable in that environment. Now I know you are willing to stretch, but many are not. TABLES ARE BAD,BAD,BAD! (In Word). Word is meant to be a word processor, not a spreadsheet. If you are just formatting a report, that is one thing, that is what tab stops are for, but if you want form filled tables, then it is really the wrong tool. Microsoft adds these features because of requests, but that doesn't mean they SHOULD be added. Excel is designed around tables and should be used for that purpose. I only miss the Binder tool Microsoft used to have that allowed you to combine pages from tools like Word and Excel into a single manuscript.</rant>
Now back to the original program....
Why would you need tables in your Word document?
-
I have to ask why Tables are so "fundamental"? One thing that annoys me to no end, as an IT guy AND a printer, is people using the wrong tool for the job just because they are comfortable in that environment. Now I know you are willing to stretch, but many are not. TABLES ARE BAD,BAD,BAD! (In Word). Word is meant to be a word processor, not a spreadsheet. If you are just formatting a report, that is one thing, that is what tab stops are for, but if you want form filled tables, then it is really the wrong tool. Microsoft adds these features because of requests, but that doesn't mean they SHOULD be added. Excel is designed around tables and should be used for that purpose. I only miss the Binder tool Microsoft used to have that allowed you to combine pages from tools like Word and Excel into a single manuscript.</rant>
Now back to the original program....
Why would you need tables in your Word document?
-steeladept
interesting, but what makes them so bad?
I have no qualifications here, I'm just an interested observer, but I'm not aware of any reason not use tables in a document (aside from the potential stability issues referred to above).
Tables are a well understood means of segregating and organising content, and most people will find them logical/natural to read. They are not spreadsheets (I suspect anyone trying to use one like that will work that out pretty quickly)
Provided they are used sensibly and in context they're a useful tool (same as tabs, and bulleting, and, and, and...)
FYI, the OP is producing a large procedural document, so I don't believe there is any form filling involved
-
Why would you need tables in your Word document?
-steeladept
among other reasons, easiest way to do certain kinds of underlining. also handy for forms, both printed and fill-in-the-blanks. Unless you are using VBA to do forms in Excel (powerful but much more to learn), Word is much handier for fill in the blank stuff. Without using tables it's almost impossible to keep variable length fields from changing your line-length and therefore your pagination.
Word tables can be handy for entering data or for composing/designing when you know you will have some kind of row/column setup but not sure what the final layout will be. The kind of thing I have in mind would be tedious using tabs (which most definitely have their place - tables aren't always the best tool).
Generally it's easier to line things up with a table than with tabs. Except when it's not.
(Word 2002) I've always found Table Styles to be useless, so I've never used them enough to cause the formatting problems cited in the excerpt from superboyac's post.
As far as the other things it says not to do because they lead to instability, I've already learned not to do them, but not due to instability problems. Some of the things he talks about (tables within tables, merging or splitting cells) I don't do because they don't turn out to be useful, don't work well enough to be useful, or make things tougher (eg merged cells make selecting rows/columns and a few other things difficult).
I've never had instability problems using tables, but my tables are seldom complicated, and rarely more than a few pages.
If you are talking about a generic table (rows and columns), sometimes Word is better, sometimes Excel is better. Word is usually much better if there's much text and fancy formatting, Excel if the numeric formulas are anything more than really simple (try copying a calculated field formula with cell references down a column in Word).
If I'm importing rows and columns of data that I'm ultimately going to put in Word, sometimes it's easier to first import the data into Excel, do some massaging/formatting and then copy it to Word where it automatically turns into a table, and then finish the massaging and formatting. This is because some things are easier in Excel than Word and the reverse.
Holy crap:
Do Not Use Tables!!-superboyac
interesting, but what did you do? Was it a massive table? did it have some sort of complex styling going on?
-Target
Yeah, what did you do? ;)
-
If I'm importing rows and columns of data that I'm ultimately going to put in Word, sometimes it's easier to first import the data into Excel, do some massaging/formatting and then copy it to Word where it automatically turns into a table, and then finish the massaging and formatting. This is because some things are easier in Excel than Word and the reverse.
Yes, i may have to do this, it sounds easier. I'm trying to make a glossary. Nothing fancy, but there is formatting involved. two columns, bold words, normal definitions, headers are formatted. But there are a lot of items. I already have all the words and definitions in InfoQube, so I want an easy way to bring it into Word. So when I did at first, I copied and pasted, then adjusted some stuff, removed some rows, appleid some styles. That's when it all broke. So now, I'm going to try the Excel method.
-
... If you are just formatting a report, that is one thing, that is what tab stops are for, ...
-steeladept
Since my answer would be formatting "things" I'm very interested in how tabstops can be used to create a multi-column (say 10) table. How is this done?
-
You set the nine tabstops (for ten columns) for the first row at the top (the ruler thing), or set them in the tab settings dialog, spaced the way you want.
You enter data across, inserting a tab to jump to the next column. When you get to the end of the row, you hit enter, which ends the single-line paragraph and starts a new paragraph with the identical tabstops already there. Enter the next row.
If you already have some kind of delimited data, you replace the delimiters with tabs if necessary and paste the data instead of typing it in.
Since each line is a paragraph (it's handy to show the formatting marks - ShowAll, the pilcrow symbol - to see the tabs and the endparagraph marks), you set the space before/after each line to zero in Paragraph settings.
There are several different types of tabstops (right/left aligned, center, decimal). Btw, the way to make things line up by decimal in a table is to use decimal tabstops.
You can create a style from your 10-column paragraph, and any time you apply it to a line with 9 tabs it will look the same.
-
That's interesting, Andy. i would have never thought of that.
I'm thinking of doing all of the formatting in Excel, and then bringing it directly into Word with copy/paste normal. That seems to be working pretty well, even though all Shauna Kelly prefers pasting the chart in as a picture instead. The problem with that is the table is pretty long (spans 5-6 pages).
-
Thank you for making my point on the tabstops, AndyM. I would have to say, though, much of the reasons provided for Word being "easier" is because of lack of knowledge (in many cases anyway). Specifically you state:
among other reasons, easiest way to do certain kinds of underlining. also handy for forms, both printed and fill-in-the-blanks. Unless you are using VBA to do forms in Excel (powerful but much more to learn), Word is much handier for fill in the blank stuff. Without using tables it's almost impossible to keep variable length fields from changing your line-length and therefore your pagination.-AndyM
I can understand the underlining thing, though I feel there has got to be better ways to do this (I never had an issue with the way Word works here, however, so I have never needed to try). As for forms, I have, without exception, found Excel to be easier and much better at building forms (though a dedicated form builder is even nicer). The only catch is making sure you size your cells correctly, but that is easier to do than you might think, you just type everything out and merge cells as needed. You end up with an Excel file that has probably something like 40 columns on one 8.5x11 page, each only a few pixels wide, but it works well and you automatically avoid the variable length field problem you mention.
Word tables can be handy for entering data or for composing/designing when you know you will have some kind of row/column setup but not sure what the final layout will be. The kind of thing I have in mind would be tedious using tabs (which most definitely have their place - tables aren't always the best tool).
-AndyM
Word was never designed for final layout inline with composition anyway, so this really is something of a non-issue. If you create the data, then apply formatting, you are following the workflow Word was designed for. If you are creating the layout and then filling in the content, tables are much more efficient, and that is the way Excel is designed and should be used - hence my statement about using the correct tool for the job.
Generally it's easier to line things up with a table than with tabs. Except when it's not.
-AndyM
Well stated. ;)
As for the rest of what you are saying, I guess I can agree with it since it is rather subjective anyway. (What is easier to you is not necessarily easier for others). I never really got heavy into formatting anything other than the text itself, and that is equally easy in Excel as it is in Word. I can imagine a situation where you want certain text flowing around a picture so, I guess there are some limited uses for it - and even with everything I stated, I have used small, simple tables in Word (Very small mind you, 3x4 at the largest). It is just so many people use Word when they should use Excel and Excel when they should use Access. Excel is not a database, even if it has some of that functionality, just like Word is not a spreadsheet even though it can contain tables.
Now getting back to the OP issue -
I'm trying to make a glossary. Nothing fancy, but there is formatting involved. two columns, bold words, normal definitions, headers are formatted. But there are a lot of items.
-superboyac
If this is all you are looking for, just make the glossary in a single column as normal. Apply all your text formating next. Then highlight it all and make it two column. The only thing left is to make the headers which should be (oddly enough) in the page header. Word is made for this type of thing without resorting to tables or any special styling.
-
interesting, but what makes them so bad?
-Target
Tables are not bad at all, it is using tables in Word instead of using the right tool. You stated that tables are not spreadsheets, and this is true, but spreadsheets are tables. Nothing but tables. If most of your work is in a table, why would you use a word processor to make them?
You hit the nail on the head when you said "used sensibly". The problem is most people do not use them sensibly in Word. They know Word, they know they can insert a table, so they insert table upon table into document upon document when it would be much simpler, quicker, and easier for all involved if it was an Excel file.
The reason this is so poignant to me is, as a printer, I end up having to fix all these documents all the time, just to get them to print right. Because these are internal customers, I can't charge back my time, but I do get dinged for not producing. Simple changes such as using the right tool would allow me to be more productive, the requester to be more productive, and produce a more manageable, effective document.
-
I just have to chime in with emphatic agreement on: Use the right tool for the job! Tables (and text boxes) in particular have been hugely problematic for me with Word. Huge tables created in Word when they should have been done in Excel. And text boxes used when they just shouldn't have been used at all (to accomplish things like aligning text properly, because the person doesn't know how to use tab stops!).
So yeah, it's a big problem when people get focused on just 1 tool and use it for all their problems.
- Oshyan
-
I just have to chime in with emphatic agreement on: Use the right tool for the job! Tables (and text boxes) in particular have been hugely problematic for me with Word. Huge tables created in Word when they should have been done in Excel. And text boxes used when they just shouldn't have been used at all (to accomplish things like aligning text properly, because the person doesn't know how to use tab stops!).
So yeah, it's a big problem when people get focused on just 1 tool and use it for all their problems.
- Oshyan
-JavaJones
So, what would you do if you already had a long glossary completed in another program (i.e. InfoQube) and you wanted to stick that information into a Word document? That's what I'm doing. Before I can stick it in, I have to massage IQ's output a little (headers, formatting, etc.) So what I'm doing now is doing that all in Excel, and copy/paste it into Word.
I'm not sure how effective these tabs stops would be for the same thing. Please advise, thanks.
-
I guess I'm not clear on how you want to format your glossary visually (nor on what the data looks like already in IQ). But likely I'd bring it into Excel and then just export as tab-separated data, load it into Word and then adjust the tabs as needed. That should neatly turn spreadsheet columns into adjustable tabs...
- Oshyan
-
So, what would you do if you already had a long glossary completed in another program (i.e. InfoQube) and you wanted to stick that information into a Word document? That's what I'm doing. Before I can stick it in, I have to massage IQ's output a little (headers, formatting, etc.) So what I'm doing now is doing that all in Excel, and copy/paste it into Word.
-superboyac
since your formatting requirements are minimal here (if i remember rightly you mentioned plain text, left column bold) I'd probably try pasting without any formatting (forgive me if I'm teaching you to suck eggs here).
that ties in with one of the suggestions from the MVP quote, and it's easy to apply that level of formatting uniformly to the whole table
-
Here's an example of what I'd like the glossary to look like. This is done in excel:
[ You are not allowed to view attachments ]
-
Sorry to jump in, but isn't that exactly what the InfoQube built-in HTML export (settings mode) gives you ?
-
Sorry to jump in, but isn't that exactly what the InfoQube built-in HTML export (settings mode) gives you ?
-PPLandry
I have used the html export feature, but is that the "best" way of putting it into a Word document? I make a point of this, because this is the first time I'm using Word the "right" way with styles, templates, fields, etc. If I use the html export from IQ, how does that integrate with the styles I've set up in my document?
All the MVPs are very strict about what they do and don't do with Word. I haven't heard anyone say anything about bringing in html, that's why I don't know. But they have very strong opinions about the proper way to use (or not use) tables.
-
Sorry to jump in, but isn't that exactly what the InfoQube built-in HTML export (settings mode) gives you ?-PPLandry
not to denigrate a useful function in a great app, but in my experience pasting html into word = blech!!
-
Hi,
I don't know if it can be of any help but here'S my own experience :
I have a document here that I created using an IQ HTML export (it was a whole play that I directed about a year ago.)
Document statistics :
Pages: 99
Paragraphs: 1298
Lines : 9988
Words: 15185
Characters: 70042
Characters (with spaces): 90391
It contains 7 columns and exactly 612 rows.
This is by no means a small table. I don't know how big do you need your table to be, but mine seems pretty big...
As far as the documents resistance to "corruption", well, no idea. I only once experienced corruption in a Word document, and it was such a long time ago that I don't remember when. Keep in mind that I have 100s of Word documents, and that I wrote my 250p Masters and started my 500 pages PhD with Word -- and with many tables, graphics, etc. And... I use a laptop
The biggest document I have on my HD is a social science book I had to scan a long time ago. It contains columns and tables, heavy formatting everywhere, etc. It's 527p long -- the book was actually 1022 p long. It's not corrupted yet and I've used it a lot (underlined, highlighted, commented, etc.).
Pages: 527
Paragraphs: 15597
Lines: 51784
Words: 445505
Characters: 2408220
Characters (with spaces): 2846525
I'm using Word 2003 BTW. It's light, fast and works well...
============
As far as formatting and styles goes : if you work in IQ anyways to generate your index, working/editing in Word isn't probably be what you'll be doing most of the time. You'll basically end up 1- exporting 2- formatting using styles. Which is very easy when you've got a table since you can select a full 99 pages column and... Apply a style. It takes a 2-3 second on my very average laptop (just tried it)
But of course this depends on the complexity of the needed formatting.
Keep in mind though that IQ generates lots of columns at the right. Those need to be selected and deleted for easier table manipulation. I have no idea why these are there.
-
I have used the html export feature, but is that the "best" way of putting it into a Word document? I make a point of this, because this is the first time I'm using Word the "right" way with styles, templates, fields, etc.
-superboyac
HTML Export is one way,
The other way is :
1- Select the content
2- Edit>>Copy and choose Tab-delimited format.
3- Paste this into Word (paste special > unformatted text)
4- Select the text and Table >> convert it to a table (tab delimited)
-
I have used the html export feature, but is that the "best" way of putting it into a Word document? I make a point of this, because this is the first time I'm using Word the "right" way with styles, templates, fields, etc.
-superboyac
HTML Export is one way,
The other way is :
1- Select the content
2- Edit>>Copy and choose Tab-delimited format.
3- Paste this into Word (paste special > unformatted text)
4- Select the text and Table >> convert it to a table (tab delimited)
-PPLandry
Interesting. I'll have to try that tomorrow. incidentally, when I have carriage returns in one of the cells in my grid in InfoQube, when I export it in anything besides HTML export, those carriage returns become a new line or cell, which makes sense, I suppose. The problem is that it adds blank cells under the cells next to it to make it all fit. The problem with that is when you use it to make a table, it messes up all the grid border format, because all the blank cells get borders also. If there's a way around it, that would be nice. I can't think of a good solution.
-
Interesting. I'll have to try that tomorrow. incidentally, when I have carriage returns in one of the cells in my grid in InfoQube, when I export it in anything besides HTML export, those carriage returns become a new line or cell, which makes sense, I suppose. The problem is that it adds blank cells under the cells next to it to make it all fit. The problem with that is when you use it to make a table, it messes up all the grid border format, because all the blank cells get borders also. If there's a way around it, that would be nice. I can't think of a good solution.
-superboyac
this is one of those situations where you don't use 'hard' carriage returns - in Word you use SHIFT+RETURN instead, though whether or not IQ follows this behaviour I don't know
-
I would have to say, though, much of the reasons provided for Word being "easier" is because of lack of knowledge
-steeladept
I wasn't trying to come up with any comprehensive list, only tossed out a few things that came to mind after reading the posts. My "knowledge" is based on what I have found useful. In any event, I've used tables extensively in Word, and "tables" extensively in Excel. My successful experience with both is making it difficult to persuade me that there is any validity to the idea that tables should rarely if ever be used in Word. I'll listen to the arguments, but so far they are not consistent with my experience, which is that tables in Word are often handy, useful, and the right tool for the job.
Word tables can be handy for entering data or for composing/designing when you know you will have some kind of row/column setup but not sure what the final layout will be. The kind of thing I have in mind would be tedious using tabs (which most definitely have their place - tables aren't always the best tool).
-AndyM
Word was never designed for final layout inline with composition anyway, so this really is something of a non-issue. If you create the data, then apply formatting, you are following the workflow Word was designed for. If you are creating the layout and then filling in the content, tables are much more efficient, and that is the way Excel is designed and should be used - hence my statement about using the correct tool for the job.
-steeladept
Not sure you and I are talking about the same thing here. When I say compose, I mean something from scratch, all sorts of different things. If I am manipulating primarily text - text that I am writing, importing, or both - nine times out of ten I will find Word to be the more suitable tool, Excel only rarely.
Re "Word was never designed for final layout inline with composition..." , what do you mean by "final layout inline with composition?"
-
Here's an example of what I'd like the glossary to look like. This is done in excel: (see attachment in previous post (https://www.donationcoder.com/forum/index.php?topic=22863.msg206994#msg206994))
-superboyac
What happens when you copy that table from Excel and simply paste it into Word?
And when you talk about "headers" I only see the one (Item Description) at the top of your sample. I assume there are others since it's easy to make the first row/rows of a Word table repeat at the top of each page.
-
Thanks for the info on setting up tabstops... I'll have to keep that in mind when I next use word....
-
Here's an example of what I'd like the glossary to look like. This is done in excel: (see attachment in previous post (https://www.donationcoder.com/forum/index.php?topic=22863.msg206994#msg206994))
-superboyac
What happens when you copy that table from Excel and simply paste it into Word?
And when you talk about "headers" I only see the one (Item Description) at the top of your sample. I assume there are others since it's easy to make the first row/rows of a Word table repeat at the top of each page.
-AndyM
When I paste from Excel, it seems to work fine. I haven't had any problems yet. From the articles, it seems like you get more problems when you edit the table within Word (move cells, add rows, columns, drag drop text, etc.) So now I'm doing everything in Excel and then copy/paste to Word. It's easier in Excel anyway.
I didn't know about this headers on top of each page. I'm going to do that!
-
ARmando! i totally missed your long post above. Thanks, it's good to know how you do things. So is that what you would do? Use html export from IQ, and then paste in Word and apply a table style?
Could you maybe post a screenshot of a finished product table you've inserted using this method? I'd appreciate it.
-
superboyac, I wonder what the data looked like originally, the data you imported. Because when I look at the example you posted, my first thought is Word. This just looks like a natural for a Word table, right from scratch. And the fact that these are not one-line records would make tabs the wrong tool here imo. Plus as soon as you want borders around the cells, tabs stop being convenient.
The stuff they talk about in the article, I have run into that sort of problem. In general the bulk of the problems seem to happen when you are copying and pasting cells (as opposed to just the text). When there are no merged cells (problematic in both Word and Excel and worth avoiding), I usually don't have problems moving/adding/deleting/copying/sorting whole rows or columns. Tried a table within a table once or twice, never again. Merging tables has at times caused major headaches.
I do serious and extensive version saving/backup while I'm working and check carefully that things are ok before I press on. Mutters heard often from my corner: "shouldn'ta done that, sure glad I saved a version just before I tried it."
-
... So is that what you would do? Use html export from IQ, and then paste in Word and apply a table style? ...
-superboyac
Unless they work in Word 2007, not a table style!!! If it doesn't import as a table, import it as tabbed data. Then turn it into a table (Table>convert>...). Once it's a table, then apply paragraph styles column by column (usually everything in a single column has the same basic format). Select a cell's contents, make it pretty, name a style after it. Select the whole column (and any other suitable columns) and apply that paragraph style.
btw, Word stores paragraph formatting in the endPara mark (the pilcrow). If you have the cursor in the paragraph, with nothing selected, then any paragraph style you apply will automatically be applied to the whole paragraph (same as if you selected the entire paragraph including the endPara mark). If you select part of the paragraph, which also includes the scenario where you select everything except the endPara mark, then the style will be applied as a character style, not what you want. (Remember the difference between including and not including the endPara mark when you select and copy. When pasting into another document this will determine whether or not the style also gets pasted. Experiment.)
The thing about table cells: they are paragraphs without endPara marks. I think the little shaded square that appears at the end of cell text, when you show formatting marks, serves the same purpose.
You can use end para marks in a table cell, but I usually use line breaks if I want to force a newline. That way everything, both sides of any line breaks, is still all in the same paragraph.
-
Another advantage to processing text in Word compared to Excel is that the Search & Replace in Word is more powerful. Many of the tricks to massage imported data require clever Search&Replacing.
But I do find Excel easier to use to parse or concatenate strings. And if your data includes dates, a pass thru Excel can save grief and time.
-
ARmando! i totally missed your long post above. Thanks, it's good to know how you do things. So is that what you would do? Use html export from IQ, and then paste in Word and apply a table style?
Could you maybe post a screenshot of a finished product table you've inserted using this method? I'd appreciate it.
-superboyac
Hi Aram,
Sorry for the delay.
I think it's very straight forward.
Either use what Pierre suggested in his previous post (
The other way is :
1- Select the content
2- Edit>>Copy and choose Tab-delimited format.
3- Paste this into Word (paste special > unformatted text)
4- Select the text and Table >> convert it to a table (tab delimited)
-PPLandry
Or
Export to HTML and copy to Word. This works even better now as the "multiple empty columns to the right of the page" problem is now fixed (it was a problem with how Word interpreted HTML).
Then do exactly as AndyM suggested :
Once it's a table, then apply paragraph styles column by column (usually everything in a single column has the same basic format). Select a cell's contents, make it pretty, name a style after it. Select the whole column (and any other suitable columns) and apply that paragraph style.
-AndyM
I could provide you with a screenshot, but... You'd only see a Word table with some formatting. Nothing special.
In any case I don't think you'll run into any problem.
Let us know.
-
AndyM... going back to your advice on using tabs instead of tables. How would one format text so each "cell" could have multiline text in it? I dont see how tabs allow you to do this.
-
When you need more than one line per record is when I stop looking at tabs and start looking at tables.
I suppose you could have several types of "lines" (actually one-line paragraphs). One line would be set up with a style (styles include tabstops) to always be the first line in a "record", the other(s) to be the second, third, etc, with different tabstops if you wanted the second line indented, etc.
But then your records would be multiline and multiparagraph, which would make sorting (manually or automatic) a nightmare. For me, generally in this scenario a borderless table would be the right tool for the job.
-
AndyM... going back to your advice on using tabs instead of tables. How would one format text so each "cell" could have multiline text in it? I dont see how tabs allow you to do this.
-kfitting
By using the correct tool - a table ;)
-
AndyM... going back to your advice on using tabs instead of tables. How would one format text so each "cell" could have multiline text in it? I dont see how tabs allow you to do this.
-kfitting
By using the correct tool - a table ;)
-katykaty
haha. Funny. :D