Easing Compatibility Between OpenOffice, MS Office
Jane Walker writes "An office suite expert describes how to format documents in OpenOffice and Microsoft office using program features that will make ease compatibility headaches." From the article: "No two office suites are alike, and the more manual, highly controlled items you have in your document, the more likely the formatting will get messy when you go from one office suite to another. But if you use the formatting capabilities to indent and add spacing--well, that's more like just labeling a box Kitchen and putting the box somewhere that makes sense. The formatting tips in this article will also give you more professional-looking documents that are easier to update when the content or formatting rules change."
He sure goes to a lot of trouble to do simple things in a more universal way. Is it the case that the more correct you are about word processor usage, the closer you get to HTML/CSS? Should we just skip word processors and use that or LaTex?
As title.
http://www.ieaa.org/~adrian/
Go to "Save as" and select the type ".txt". You'll never have to worry about formatting isssues ever again.
>Should we just skip word processors and use that or LaTex?
I know I do.
Belief is the currency of delusion.
Too many people think it's OK just to use rows of spaces for formatting.
The worst example of this I ever saw was a document where the page numbers were typed, by hand, aligned using spaces, within the page themselves {not in the footer}; and there were no page breaks, just loads of hard returns. I was tasked with fixing a minor spelling mistake. This should have been an easy job; but the correctly-spelt word was one letter longer, which caused the line to wrap -- thus making an utter arse of the formatting.
I fixed it, but I got a bollocking for taking too long. I suppose I would have got just as big a bollocking for messing up the formatting.
I think a great service would be done if word processing software could detect attempts at such manual formatting, warn the user there is a better way to do it; and then do it properly, automagically. It can't be that hard. I'll concede that spaces and hard returns do have a place, but that place is far away from proportionally-spaced fonts.
Oh yes, one more thing. Bring back Wordstar/Protext-style rulers which can be inserted into the document anywhere, not just one ruler at the top of the screen which changes as you move from one paragraph to another. It's as confusing as fuck and it's probably half the reason why people use spaces for formatting in the first place.
Je fume. Tu fumes. Nous fûmes!
However from practise, any tips how to react in these situations:
ME: "Please don't use enter for spacing between paragraphs, it's wrong"
CO: "You pedantic freak! It's exactly the same on the screen, and when I print it it won't even be there, who cares?"
CO: "Shit Word is retarded, the tab ends on different places each line, what the HELL is that?"
ME: "Use indenting, it's more predictable"
CO: "Indenting? Why do you never explain what I wanna know, I don't care what indenting is, I wanna fix the damn tabs"
CO: "Oh great, perfect, I wanna make all headlines gray, this means whole hour hunting them down and reformatting it. THANK YOU WORD, BUT NO THANK YOU."
ME: "Man.. this is why I told you to use Headings 1, 2, 3... It's easy to format at once from the styles palette, and you also get automatic Outline view and Table of Contents..."
CO: "Oh shut up, geek..."
Haha!
Microsoft Office for Mac and Windows dont handle "Styles and Formatting" in completely consistent ways... not to talk about what happens when you mix older versions of Word on PC with newer.
I'd say: formatting is ALWAYS a mess in MS Word, REGARDLESS how you do it.
My tip: invest some time in a template with just a few styles. Stick to those styles - dont improvise and be creative.
I like to write in HTML, just using P,B,U,I,TT,H1,H2,H3,TABLE (with friends), UL, OL... however, it is hard to print it in a nice way... Anyone has any ideas about how to make really nice printouts from HTML (that look as nice as a LaTeX report) without writing my own XSLT-tranform and make an XSL-FO of everything?
warn the user there is a better way to do it; and then do it properly, automagically. It can't be that hard.
<CHIME> <A message box appears:>
Belief is the currency of delusion.
As long as word processors won't erase superfluous spaces, doubled returns, and start of line tabs, I see no hope of a global users' skills rising.
I wrote my doctorate thesis using MS Word 5.1 on an old 68k Macintosh. (OK, it was some years ago...) I learned a lot about Word, and was very careful to use styles for everything, exactly as this article recommends. There were a few limitations - character styles were not supported back then. But on the whole it worked very well and was easy to do.
When I started work a little later I had to prepare reports that then went to a secretary 'for final formatting' before publication. This was presumably to ensure that they followed the house style.
In fact, the first few came back completely garbled. (This was despite the fact that they were already - visually at least - in the house style when I submitted them.) Not long after, an edict came down that we were not to use 'automatic formatting'. When I queried this, it meant no styles, no automatic header numbering, no changing the paragraph spacing with the Format command, etc.
No one ever admitted it, but we all suspected the reason was that the secretaries did not understand enough about Word to realise why they couldn't manually change the heading numbers, why hitting return was inserting a double line space, or whatever.
Even now that we are all using Office 2003, all of our company templates are still set up using direct (manual) formatting.
It's even worse though, because Word 2003 is set up to automatically define a new style every time you manually apply direct formatting to a paragraph. If you look in the styles list for these templates, there are literally hundreds of styles defined there, all with meaningless names.
If only the templates were defined using proper styles and users were educated not to use the buttons on the toolbar but to select a style from the Styles and Formatting sidebar instead, all of this mess could be avoided, and all documents would 'automagically' come out with the house style with no effort at all.
(I'd even like to see Microsoft add some 'policies' to Word so that it can be set up on users' machines to enforce this way of working.)
>any tips how to react in these situations: [...] CO: "Oh shut up, geek..."
How about ''That's Alpha Geek to you, newbie. Now listen and learn from your betters...''
Depending on setting you might want to slap cow-orker in the back of the head too.
Belief is the currency of delusion.
For all our quality documents, we use Word with some propietary plugin to help with the formatting. You can read and print it in a copy of word which doesn't have the plugin, but wheep he who shall alter the layout! These documents (preferably with embedded Powerpoint which has embedded Excel) get uploaded in our central documentation database, where they are supposed to remain for the next 20 years. I recently needed 3 days to convert my 7 year old thesis to PDF. Something tells me we are in deep shit...
10 ?"Hello World" life was simple then
If you'd like the advantages of LaTeX without having to remember every nuance, then LyX ( http://www.lyx.org/ ) is definately a GREAT thing.
Since converting to LyX all our documents come out with consistently high quality. Best of all, from LyX you can convert to almost any other format as you need.
Too many of yesterday's assumptions in this article. It's about how the user should conform to what the program wants to do or is expecting. The program doesn't like an extra line space between paragraphs, so the user should inconvenience themselves by using styles and formatting instead.
Users are going to do what they do regardless. So I guess the answer is to write much better import/export filters for when files are going to be used in more than one program. It's no good going on about typography either. Most people don't know what that is. But they know a friendly program that produces nice-looking results when they use it. And that is all they want.
Las qué passoun
tournoun pas maï
Remember, Microsoft has filed and received a patent for the Microsoft Office file formats in XML.
All it takes is for Microsoft to take their ball & bat to go home via some trojan in the guise of a special security alert, (Patches O'Houlihan appearing to make the official announcements on Patch Tuesday...between teaching rounds of the ADAA -American Dodgeball Association of America ). Tada! MS Office only writes to XML format and Microsoft has an enforceable patent in place. This puts a fence between two companies or even two departments. It's all or nothing. And if you (corporation) attempt to migrate (not all at once), writing is a one-way street. Anyone can read. But that's passive.
The only way to get around it would be a widespread migration away from MS Office in a very, very short period of time.
Realistically, how fast do you think that will happen? Don't use your office by saying, "We can do it!" Look at how many Fortune 100 or 500 or 1000 companies which would have to jump into the fray during a long weekend.
(Microsoft is still waiting on a substantial number of corporations to migrate from Windows 2000, MS Office 2000, and VS6. And they're chasing their tails trying to find out how to convince businesses to migrate by paying lots of money for new software, new hardware, increased TCO. What makes you think they're going to switch to non-MS Office? Seriously. Even the storytellers Huey, Dewey, and Louie, er, Microsoft's vast Sales, Marketing, and PR departments are pounding their heads. They've never faced a defeat like this -- and it's their own damn fault!)
LaTeX requires you to read at least a tutorial first. Incorrect documents don't compile and nobody will ever litter LaTeX documents with unnecessary formatting commands, since LaTeX commands make the text obnoxious to read.
i'll speak from my years of experiance with page layout, first thing i do when i get a document to lay out is to copy and paste it into notepad, then i use the replace feature and replace " " with a " " then i will convert the quotes and finally i'll remove the soft-returns and replace double returns with a single return and then i'll run a spell checker.
and thats to get the text in a format i can start laying out with, then once its in my layout i'll do tracking a kerning and forced returns if need be by hand. thats after i've applied all the formatting styles from my style sheets
now, i'f i'm working in chinese i'll copy and paste into notepad, replace all numbers with a real number (funny numbers in chinese) replace the " " with a " " replace , . ' " -- with the chinese version and then copy and paste that into wordpad and then into my document.
if only they knew!
Not many people know how to write documents that survive re-paginations (eg, changing margins, paper size, moving from portrait to landscape), exporting to another format, etc. I still wonder if those who attended basic wordprocessor courses are being taught to use the right feature to achieve what was desired.
I used WordPerfect 5.1 long ago and it has trained me well on using the correct code (seen under reveal code) or features for the things I want. Like using Indent at the beginning of a paragragh (for indenting a paragraph), rather than using multiple [Tabs] at the beginning of all lines in a paragraph. Or, a Hard Page Break (still rememver it's Ctrl-Enter) to force a new page rather than multiple Hard Returns (to create empty lines to push text down the next page).
Once a person learns to use the correct feature, his document is definitely more robust and can withstand major reformatting.
OOO seems to default to it's own formats. Rather that .rtf or .doc. Change this and it will be a lot easier for new adaptors...Like my 70 year old mother using Ubuntu. She uses it to type up her recipes and book club discussions. Emails me everytime a document can't be opened by one of her Windows-using old lady friends.
My small crystallization of the whole word processing: You write text. Computer formats it.
If you want the computer to not mess up your formatting, you've got to think like a machine and understand the structure of the formatting. Humans, by default, only care about superficial formatting: "this is in wrong place, let's move it a bit." Computer sees a bunch of formatting instructions.
The biggest problem with WYSIWYG word processing is... well, basically the exact same problem with WYSIWYG HTML editors: You think you have the utter and ultimate control over the presentation, while you actually don't have that luxury. You merely have real-time response to the formatting decisions. Some other day (and in some other version of the program), the formatting decisions the program makes will be different. When using word processor, you have to stop thinking about the formatting and just let it do the thing for you.
Word processing and typesetting are separate tasks. If you don't understand that, and do typesetting decisions while you're doing word processing, you end up in a completely wrong place.
You have to assume your tab key doesn't know damn where to align the text - if you're submitting text for publication somewhere, it's likely to go completely wrong anyway. You have to not rely on spaces being always "space" width at all. (I export my OO.o docs to HTML which gets converted to LaTeX for PDF generation. HTML doesn't care damn about extraneous whitespace. Neither really does LaTeX.)
If you want to preserve formatting instructions at all, OpenOffice.org's style system is your bestest friend ever. You can't produce robust formatting without that thing, so learn it and learn it well.
In closing, two words: Reveal Codes.
Does anybody talk here about OpenOpenOffice ? http://o3.phase-n.com/ They are still promising a release without giving us anything to eat but anyway, be aware that one day, it will be really easy for everybody to switch between all office suite. Manu
Before starting on his first wp doc, I helpfully told a co-worker in advance not to use Enter to create new lines.
Righto!
The day after I had to fix the doc where tons of spaces had been used to wrap to next line.
Difference in suite formatting aside. Most ppl have no idea how to even properly format what they are typing anyway. So when you throw in a program with several dozen buttons to play with and the person know not how to click "help". Well you might get just about any type of style format you can imagine. Not to mention the fact that most editors "set" a users style as a style format for that doc no matter if it is a far left style of not... Dang hard to type without my glasses. Hard on the eyes too...
It's LaTeX, but graphic. Really nice.
It's better to be the foot on the boot than the face on the pavement. ~~ tkx Kadin2048
I use Latex for everything I can. Unfortunately not everyone else does, especially for presentations. Recently I've had to work on a presentation in a group that wanted to use powerpoint. I did my part in OO.o and embedded equations as rendered pngs of latex output, but this is a big pain in the arse when it comes to wanting to *edit* the equations. There are a nice packages in windows, osx, and *nix for putting latex equations into powerpoint/oo.o presentations (unhappily, the windows and osx ones are superior b/c they integrate nicely and allow you to edit the equations), but they are all different and aren't really compatible (other than that the rendered output is pretty universal, which is a good start).
Having said that, the equation editors in Office and OO.o are awful for compatibility.
m0nstr42.blogspot.com
Not everyone will be willing to change his/her X-Office for LaTex, but Lyx is between them and could do the trick
The big problem, I think, is that everyone is sending each other word processing files. If I receive a .doc, and I don't have Word (and don't want to pay for it) I can view the file, but my program may paginate/format it differently.
Portable formats have been around for years: postscript, pdf, etc. Most recipients aren't interested in editing what you send to them. Just send them a pdf and avoid the problem (OpenOffice 2.0 has a very nice pdf export function.) If it turns out that the recipient wants the text he can cut and paste it into whatever he wants.
As usual, the problem is not in the software; it is in the use of the software.Instead of writing mind-reading software and popping up a paper clip, they could just make the default document come with page numbers in a footer. This would clue people in that these capabilities exist. Those that just want a simple text document won't mind, or can use notepad, or figure out how to remove the footer. Removing something is usually simpler than figuring out how to add it. Now taken to the extreme, this would be a nightmare - the default document would have headers, footers, and several other default formatting options that would take a lot of work to remove.
Or people could just learn to use the tools properly.
It seems to me that word processors are over-thought if you have to worry about doing things the "right" way (as defined by the programmers). If I want to treat a WP like a TV typewriter and manually format everything just like we did in Bank Street Writer on my Apple //c, it should be perfectly OK with that. If I then want to intersperse some fancy formatting like bulleted lists, handle it without me having to think hard about it. I don't want to care about these things, I just want to write the stupid way and get it over with.
Is there a (preferably cross-platform) word processor that will do what I want? I don't want to have to write code like LaTeX or just use a plain old text editor (though that's what I almost always fall back on).
Hail Eris, full of mischief...
E pluribus sanguinem
How would that be different from Docbook?
"Ladies and gentlemen, my killbot features Lotus Notes and a machine gun. It is the finest available."
It's nice that OpenOffice 2 has a PDF export function, but that's a different statement entirely. Alas, the function itself is limited and buggy when put to serious use. For example, it chokes on some professional-grade OpenType fonts, resulting in incorrect fonts being used in the output PDF. It also has very limited control if you're creating documents in OpenOffice that are then sent to a professional print shop. In other words, as a tool for outputting portable documents, it's not bad, but it still has major limitations compared to what a decent DTP app would offer.
If you disagree, post your argument. (-1, Overrated) isn't your personal censorship tool for views you don't like.
The problem (apart from the microsoft-induced part, with useless and/or closed formats) is word processing itself. What we all need to do is move towards document processing, which will represent data in a way that is meaningful to computers (titles, sections, subsections, addresses, names, code, haiku, etc.), and format it for printing WHEN printing, automatically. This way, you can easily load it into another program, and you don't have to worry about whether the page is too big or too small, or if it'll print the same as it did for the other person; because, an address is still an address, and a section is still a section. If you print it in your organisation, it can be printed in the format YOUR organisation likes, not the sender's organisation's format. Of course, there is still PDF etc. for exact layouts, but that is solving an entirely different issue.
If anyone is still confused about all this, I'd recommend a few days' playing around with LyX.
Wow, that's so clever. Slashdot has the best comedians.
WTF is up with the use of semicolons in formulas which would match Excel if they used commas? How about the default calculation of the log function? Don't expect M$ to change their format, and don't expect people to be happy that they have to change tiny syntax issues in every formula in a large, complex, spreadsheet, each time that they change platforms. Make them truely compatable, so that I can use the same spreadsheet in either Excel, or OO-Calc, without having to translate (manually), each cell, each time that I open the file on a different platform (e.g. If I make a template for a post-doc to use, for data entry, aggregation, &c., I don't want to have to change all of the formulas each time that I send the data to someone who's using Excel/OO-Calc, and change it back each time that data is added from the other. It's a serious P.I.T.A.
It's weird. When I first came to work for my current employer we used to have something called an "editorial staff". That was back in the day when we were able to afford secretaries. (i.e Un the dark ages when document preparation was considered a skill requiring some training.) Back then all of our secretaries knew troff, TeX, and LaTeX. A large fraction of them could write shell scripts that would merge disparate inputs and output a TeX document (for example merging text into a fax cover page template).
Then WYSIWYG showed up. Document preparation tasks got easier for the untrained, but the duration of those task was vastly increased because the WYSIWYG word processor never quite did what you wanted the first time. Shortly thereafter it was decided that secretarial staff was too expensive, and so all the document preparation tasks were transitioned to engineers, scientists, and executives. We're told that this saves money, because apparently engineers, scientists, and executives don't have anything else they should be doing. Most of the trained document preparers were shoved out the door or transitioned into other work. Secretarial salaries stagnated and now you get fresh graduates from rodeo clown college that have never seen a computer when you try to hire one at such a pittance.
Maybe it would be better if we valued document preparation skills and payed accordingly. Maybe I'm just naive.
Support SETI@home
Does anybody talk here about OpenOpenOffice ?
One thing that worries me about that is that it sends your file off on the internet (or to your server, if you have one you bothered to set up like that). Can't it just convert it right there on your machine?
"What is Internet Explorer 7? Are you saying we can't access the normal internet?" - I love tech support. Really.
You're right, but I didn't find anything else for opening odf files from m$ office.
You're right, but I didn't find anything else for opening odf files from m$ office.
I'm sure there'll be something eventually.
"What is Internet Explorer 7? Are you saying we can't access the normal internet?" - I love tech support. Really.
It's 2006 already, why can't I have a spreadsheet program be able to handle more than 64K rows?!? Excel has been stuck with this forever, I thought OpenOffice would be better but it seems that they have only just broken past the 32K barrier to the same 64K wall. I'll gladly give up some columns, who uses all those anyway :)
Post the link if you find one :)
You changed the subject to read that "every other fortune 500" was migrating, but you only quoted three examples (and IBM really doesn't count). I consult for a Fortune 50 (that's fifty) in Europe and I'd like to see more examples of Fortune 500 companies migrating. So, please provide some links to document your claim.
Thanks.
MS word can output to PDF too with the appropriate printer driver.
BTW, it makes perfect sense for OOO to default to it's own formats - other ones are moving targets they have no control over.
I don't recommend slapping them in the back of the head, but I do recommend getting angry at them.
...or shut off the computer without saving or whatever.
Them:I don't want to know about indenting, I want to fix tabs.
Me:Okay, if you don't do what I tell you to do, I'm going to leave.
Oh oh oh, look at me! I'm talking about OpenOffice.org (TM)!!! I'm a super smart geek! No, really, you know what? None of this matters. None of you have any say whatsoever in any standard that comes out of the ISO. So just shut the fuck up, and let the people with actual power do their damn jobs,
Fuck off and die. I hate you all.
I just went through essentially this situation with my cousin's 7 year old. She wanted me to read the passage for her homework, and then she'd answer the questions. Well, she didn't know the right answers from me reading it and then her glancing at the passage for clues, so I told her she had to read the whole passage aloud. She said that she didn't want to read the passage, she wanted to answer the questions. I said that I told her what she needed to do and that she wouldn't get any help from me if she wanted to try to do something else. She crumpled up the page the passage and questions were on and ripped up one of her other schoolwork papers, and then proceded to kick and scream and throw things until she got her way. I told her that I would not let her get her way, and that if I were to get her way she'd just act the same way the next time she wanted to get her way.
Kword, which I haven't actually used much, seems to be simpler in terms of GUI clutter but still quite powerful. I'd have thought it was better for someone new to computers than OOo. I gather it reads and writes ODF and other major formats too.
http://www.linux-watch.com/news/NS5139606687.htmlC oming soon: ODF for MS Office
Some more days to wait until new opportunities in the office suite world !!
That's funny. The company is too smart to buy a new copy of M$ Office and you don't think they will take a free version instead? You need to look at GM, Lowes, IBM and every other fortune 500 company is doing.
Friends don't help friends install M$ junk.