|
Target
|
 |
« Reply #25 on: May 27, 2010, 08:49:15 PM » |
|
Sorry to jump in, but isn't that exactly what the InfoQube built-in HTML export (settings mode) gives you ? not to denigrate a useful function in a great app, but in my experience pasting html into word = blech!! |
|
|
|
|
Logged
|
"Look wise, say nothing, and grunt. Speech was given to conceal thought" - Sir William Osler
|
|
|
|
Armando
|
|
« Reply #26 on: May 27, 2010, 09:19:32 PM » |
|
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.
|
|
|
|
|
Logged
|
"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
|
|
|
|
PPLandry
|
|
« Reply #27 on: May 27, 2010, 10:11:06 PM » |
|
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.
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) |
|
|
|
|
Logged
|
Real generosity toward the future lies in giving all to the present -- Albert Camus -- www.InfoQube.biz |
|
|
|
|
superboyac
|
|
« Reply #28 on: May 27, 2010, 11:01:12 PM » |
|
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.
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) 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. |
|
|
|
|
Logged
|
|
|
|
|
Target
|
|
« Reply #29 on: May 27, 2010, 11:17:53 PM » |
|
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.
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 |
|
|
|
« Last Edit: May 27, 2010, 11:44:06 PM by Target »
|
Logged
|
"Look wise, say nothing, and grunt. Speech was given to conceal thought" - Sir William Osler
|
|
|
|
AndyM
|
|
« Reply #30 on: May 27, 2010, 11:29:57 PM » |
|
I would have to say, though, much of the reasons provided for Word being "easier" is because of lack of knowledge
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).
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. 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?" |
|
|
|
|
Logged
|
|
|
|
|
AndyM
|
|
« Reply #31 on: May 27, 2010, 11:35:04 PM » |
|
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. |
|
|
|
« Last Edit: May 27, 2010, 11:40:13 PM by AndyM »
|
Logged
|
|
|
|
|
kfitting
|
|
« Reply #32 on: May 28, 2010, 08:38:24 AM » |
|
Thanks for the info on setting up tabstops... I'll have to keep that in mind when I next use word....
|
|
|
|
|
Logged
|
|
|
|
|
superboyac
|
|
« Reply #33 on: May 28, 2010, 09:30:57 AM » |
|
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. 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! |
|
|
|
|
Logged
|
|
|
|
|
superboyac
|
|
« Reply #34 on: May 28, 2010, 12:20:11 PM » |
|
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.
|
|
|
|
|
Logged
|
|
|
|
|
AndyM
|
|
« Reply #35 on: May 28, 2010, 12:22:11 PM » |
|
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."
|
|
|
|
« Last Edit: May 28, 2010, 12:25:29 PM by AndyM »
|
Logged
|
|
|
|
|
AndyM
|
|
« Reply #36 on: May 28, 2010, 12:45:23 PM » |
|
... So is that what you would do? Use html export from IQ, and then paste in Word and apply a table style? ...
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. |
|
|
|
|
Logged
|
|
|
|
|
AndyM
|
|
« Reply #37 on: May 28, 2010, 12:49:07 PM » |
|
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.
|
|
|
|
|
Logged
|
|
|
|
|
Armando
|
|
« Reply #38 on: May 31, 2010, 10:16:52 PM » |
|
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.
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)
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.
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. |
|
|
|
|
Logged
|
"I suppose it can be said that I'm an absent-minded driver. It's true that I've driven through a number of red lights on occasion, but on the other hand, I've stopped at a lot of green ones but never gotten credit for it."
Glenn Gould
|
|
|
|
kfitting
|
|
« Reply #39 on: June 03, 2010, 02:11:07 PM » |
|
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.
|
|
|
|
|
Logged
|
|
|
|
|
AndyM
|
|
« Reply #40 on: June 03, 2010, 03:24:41 PM » |
|
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.
|
|
|
|
|
Logged
|
|
|
|
|
katykaty
|
|
« Reply #41 on: June 05, 2010, 04:51:35 PM » |
|
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.
By using the correct tool - a table  |
|
|
|
|
Logged
|
|
|
|
|
superboyac
|
|
« Reply #42 on: June 05, 2010, 09:45:26 PM » |
|
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.
By using the correct tool - a table haha. Funny.  |
|
|
|
|
Logged
|
|
|
|
|
