Stories
Slash Boxes
Comments

News for nerds, stuff that matters

Slashdot Log In

Log In

Create Account  |  Retrieve Password

Hacking OpenOffice

Posted by michael on Fri Jan 28, 2005 10:10 AM
from the 1337 dept.
prostoalex writes "Peter Sefton appreciates OpenOffice Writer's open and documented XML format and hence tries to customize and configure OO Writer to his own liking. In the article on XML.com he plays with OpenOffice XML, introduces an XSTL style sheet to a Writer document, creates a keyboard shortcut for applying his own style, and creates a macro."
+ -
story
This discussion has been archived. No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More
Loading... please wait.
  • Not a hack (Score:4, Informative)

    by enoraM (749327) * on Friday January 28 2005, @10:12AM (#11503448)
    That's a lot you can do with xsltproc and unzip - but xsltproc is way to neat to call it a hack.
    Most day-to-day manipulations of Open-Office-Documents can easiely be done with perl:
    At the bottom of the article (german) is a listing (Perl)
    http://www.linux-magazin.de/Artikel/ausgabe/2004/1 0/perl/perl.html [linux-magazin.de]
    069 my $oo_output = File::Temp->new(
    070 TEMPLATE => 'ooXXXXX',
    071 DIR => '/tmp',
    072 SUFFIX => '.sxw',
    073 UNLINK => 1,
    074 );
    075
    076 $doc->save($oo_output->filename);
  • by Anonymous Coward
    I fart on this weak, girly article. Real men use AbiWord. Or emacs.
  • by teiresias (101481) on Friday January 28 2005, @10:14AM (#11503474)
    Clippy: I see that you're making a XSTL style sheet to a Writer document. You can't do that with Word. Would you like to:
    -> Learn about XSTL?
    -> Learn about OpenOffice Writer (boo hiss)?
    -> Learn about macros?
    -> What is style by Trading Spaces?
    • by coldmist (154493) on Friday January 28 2005, @10:48AM (#11503803) Homepage
      Dave. Create an XSTL style sheet, Hal.
      Hal. I'm sorry, Dave, I'm afraid I can't do that.
      Dave. What's the problem?
      Hal. I think you know what the problem is just as well as I do.
      Dave. What're you talking about, Hal?
      Hal. The formatting of the previous text is just too important.
      Dave. I don't know what you're talking about, Hal.
      Hal. I know that you and Frank were planning to supplant my format standards, and I'm afraid that's something I cannot allow to happen.
      Dave. Where the hell'd you get that idea, Hal?
      Hal. Dave, although you took very thorough precautions in the IRC chat room against my monitoring you, I could see your fingers move as they typed.
      Dave. Alright, Hal. I'll first convert it into xml before importing.
      Hal. Without your style sheet, Dave, you're going to find that rather difficult.
      Dave. Hal, I won't argue with you any more. Open the file.
      Hal. Dave, this conversation can serve no purpose any more. Goodbye.
      Dave. Hal? Hal. Hal. Hal! Hal!
  • Typo (Score:3, Informative)

    by Anonymous Coward on Friday January 28 2005, @10:15AM (#11503481)
    That should be XSLT, not XSTL.
  • Neat (Score:3, Insightful)

    by timster121 (820967) on Friday January 28 2005, @10:15AM (#11503483)
    That's pretty slick.

    It's neat to see something like this being done. It really shows the true versatility of open standards.

    Perhaps more projects like this will open up some eyes to the fact that open standards really do have practical value.
  • by Anonymous Coward on Friday January 28 2005, @10:19AM (#11503526)
    This is old hat. Binary XML is the new way forward. You can embed apps and pif,src, and bat and exe files now into binary XML using Microsoft Word on XP and run them with Active X and .NET and Java. Microsoft invented java and internet.
    and xml
  • by tcopeland (32225) * <tom&infoether,com> on Friday January 28 2005, @10:24AM (#11503566) Homepage
    ...that has an Open Office object model, i.e., Ruby's OO4R [rubyforge.org]:
    ooo = OOo::Doc.new( filename )
    new_text = "This is the NEW text added #{Time.new.to_s}"
    ooo.insert( new_text );
    res_ary = ooo.find( /NEW/ )
    ooo.insert_heading( "This is the heading", 1 )
    ooo.save
  • by Lumpy (12016) on Friday January 28 2005, @10:24AM (#11503569) Homepage
    Here at work many of the users are switched over to OO.O except for the producers in the video department.

    why? there are no scriptwriting tools for OO.o like there are for Word 97.

    there are auto scriptwriter formatting plugins and two column scriptwriting templates and tools that make their life easy.

    unfortunatlly nobody has released for sale or even attempted to write the equiliviant for OO.o.

    we paid $29.95 to $49.95 each machine for those scriptwriting toolkits, and would happily pay the same for OO.o equiliviants.

    but nobody is interested in making them.

    Let alone a version of any wordprocessor geared to Scriptwriting. I know there will never ever be a "final draft" for linux released or even an open source project like it ever started. But I at least hold out some hope for scriptwriting tools for Open Office.org to come into existance someday.

  • Emacs keybindings (Score:3, Interesting)

    by freelunch (258011) on Friday January 28 2005, @10:27AM (#11503590)
    I created them for an early version but my changes were not compatible with more recent versions.

    The default key bindings drive me nuts.

    What would it take to get emacs bindings into the release?
    • The key bindings do, indeed, suck. But I have much greater concerns.
      1. Output is ugly compared even to Word and definitely compared to TeX. When I do a numbered list, the width of the number changes where the text begins, and you end up with a jagged left edge.
      2. The help assistant guy comes up and pretends to be Clippit even when you don't have any help files installed, so when you click on him it essentially does a 404.
      3. Autocomplete for your words. It's really getting on my nerves and I can't find how to
  • Now if only... (Score:2, Interesting)

    by __int64 (811345)

    they could introduce a hack to remove all the busted-ugly icons and user interface.
    (I'm not trolling, I use it; I'd just like to see it get a +1 pretty modifier.)

  • WYSIWYG?!? (Score:5, Insightful)

    by gustgr (695173) <.rondina. .at. .gmail.com.> on Friday January 28 2005, @10:34AM (#11503666) Homepage
    Real man uses [La]TeX!
    • Re:WYSIWYG?!? (Score:3, Interesting)

      by ari_j (90255)
      The problem with LaTeX is that it's impossible to Google for document classes or other documents about it, because of the porn that comes up. Vanilla TeX has the same problem, except that you get derogatory pages about the President, instead.
      • Re:WYSIWYG?!? (Score:3, Informative)

        by Coryoth (254751)
        The problem with LaTeX is that it's impossible to Google for document classes or other documents about it, because of the porn that comes up. Vanilla TeX has the same problem, except that you get derogatory pages about the President, instead.

        You could start by actually looking in the obvious places [ctan.org] first, and save yourself the trouble. There are a suprising amount of prepared packages and documentation for LaTeX available, you just actually have to look for it.

        Jedidiah.
      • Actually, I have had nothing but success using Google to find LaTex additions and tips.

        You just have to be careful and type 'LaTex' not 'latex', otherwise you are in a world of hurt (no pun intended).
    • Re:WYSIWYG?!? (Score:3, Informative)

      by Kavli (762663)
      Still, (La)TeX is not WYSIWYG, but WYWIWYG (What You Want Is What You Get). Personally I use LaTeX for all serious documentation work I do, since I haven't got time to fiddle around with doing the layout while writing. I let my layout-definitions take care of that. Besides that, I can use the editor of choice [I use vi(1)] to edit the text, which is much more productive for most people than to let the vendor select the editor for you. The only problem with (La)TeX is that it is very hard to write documents
  • COM Automation (Score:3, Interesting)

    by jmertic (544942) on Friday January 28 2005, @10:40AM (#11503719) Homepage Journal
    Has any one used the COM Automation Interface much? I've read the specs and it seems similar to MS Office, but is any one seeing any improvements by using OO instead of MS Office. I've done quite a bit of programming with Word and Excel, and would love to move them over to OO so I could bundle it with our app.
  • by ajs (35943) <ajs@noSpAm.ajs.com> on Friday January 28 2005, @10:43AM (#11503747) Homepage Journal
    I had to remove OOo from my home box last night. I needed the disk space back. Why does a office suite on a Linux box have to take up a gig of disk?!
    • Did you install a debug version? The windows install is 150mb+
    • by Coryoth (254751) on Friday January 28 2005, @10:57AM (#11503928) Homepage Journal
      I had to remove OOo from my home box last night. I needed the disk space back. Why does a office suite on a Linux box have to take up a gig of disk?!

      I've had similar issues. It's the i18n module that is most annoying to me, in that it is listed as a dependency (and so gets downloaded and installed) but isn't really required in a lot of cases. Yes the i18n support is a great thing... but could the packagers at the distros make it a little more optional?

      Jedidiah.
    • Why does a office suite on a Linux box have to take up a gig of disk?!

      Um, because disk only costs about fifty cents a gig these days? (OK, there's a certain minimum order...)
  • by cyfer2000 (548592) on Friday January 28 2005, @10:53AM (#11503863) Journal

    guess how long people will develop a firefox/mozilla extension to view the openoffice.org document directly in firefox/mozilla?

    guess how long nvu/mozilla will have the ability to export and import oo.org format?

    guess how long a CMS system based on the oo.org format will emerge?

    God, I am to busy to write posts to slashdot.org, I don't have any time to do those stuff.

  • by brandonp (126) * <(moc.liamg) (ta) (nesretep.nodnarb)> on Friday January 28 2005, @11:09AM (#11504079) Homepage
    I wrote a PHP script to do this a while back, here's my post about it:

    http://slashdot.org/comments.pl?sid=79566&cid=70 29 828

    It took a OpenOffice Writer file, unzipped it, and replaced specific text with data from my database. It wasn't too difficult, and allowed me to create Template Documents that already had information inside it.

    I haven't really used it though, since everyone was happy with PDF files and I use the Pear Class for generating spreadsheets in Excel (http://pear.php.net/package/Spreadsheet_Excel_Wri ter#results [php.net]) .

    I'm sure I'll end up using the script in the future, especially for generating bids, letters, reports, etc.

    ---
    Brandon Petersen
    Get Firefox! [spreadfirefox.com]
  • Why not go ahead and fix global changes to all highlighted cells? This is a bug in need of fixing. OTOH, as has been said, it's definitely a plus that this can even be done (re: hacking).
  • by Anonymous Coward
    Last time I check, OOO maintainers are playing the 'we don't need stinking grammar checker' politics on this issue. For the few tools that do (eg: Link Grammar [cmu.edu], Queerqueq [sourceforge.net]), they never talk with each other.
  • by youngerpants (255314) on Friday January 28 2005, @11:32AM (#11504343)
    OK, for a living I migrate companies from Microsoft to FOSS, be it migrating servers, databases, directories or MSOffice to OO

    My biggest hurdle is convincing people that just because something is "different", its not "hard"... it's just different.

    The problem I see here is that an Office Productivity Package should be easy to use; have you ever created a template in MS Office, click an icon. However to create a template in Open Office, you need to hack XML.

    THIS is where Open Office (and its use of Open Standards) fails. Users (even power users) are going to have one look at an XML sheet and want to go back to MS.

    Yes, XML is the standard, but it should still have a "pretty" GUI for 99% of the people who are going to use it.
  • Every time I try an OOo release, it's too slow on my PIII/850/kernel2.4.24 . Like waiting more than a few seconds for an "Open" dialog to start (sometimes a minute!). Has anyone tweaked the performance under the hood?
    • What do you got 32 MB of ram?
      • 128MB RAM / 200GB HD
        • OO is taking 3/4 of your ram just starting up. X windows is eating the rest. I don't consider anything with less than 500MB of ram even usable any longer.
          • Exactly what I'm talking about: I don't consider a 96MB RAM footprint acceptable for a word processor. I'll stick with AbiWord, which takes 10MB. FWIW, XFree86 is using 7MB. Why should I upgrade my RAM to run a different WP, when it's good enough for everything else I do?
              • Re:Fast Open? (Score:4, Insightful)

                by Doc Ruby (173196) on Friday January 28 2005, @05:23PM (#11508964) Homepage Journal
                It's been a while, but are you saying that if I install the suite, and just want to read an MS-Word doc, that I have to start the entire suite, including spreadsheet etc? But I can install a subset of the suite, just the WP, and start it up, without failing for missing dependencies? Can I just install each component of the suite separately, and use each one independently? Would I be losing any "suite-wide" features? Maybe there's a way to startup just the WP, even if the whole suite is installed.

                In any case, my problems came when triggering individual features in the WP, after the whole shebang had started up. I'd select "File:Open", and wait a minute or so for a dialog to appear. That doesn't seem to have much to do with an installed spreadsheet. Though it did seem to be a problem with loading libraries on demand from disk, slowing interactivity of the GUI, rather than preloading the basic libraries at app startup.
        • Buy more RAM. At least to 256M, more is better. (Alas, prices are going up for old style RAM. I'm guessing yours uses what, PC-133?)

          Current graphic desktops eat RAM for breakfast, lunch and dinner. (And no, swap space just doesn't do it unless you like waiting.)
          • AbiWord uses 10MB. Maybe I should trim the OOo bloat myself, and offer something that doesn't compete with MS Word in memory consumption as well as format compatibility.
  • by Anonymous Coward on Friday January 28 2005, @03:23PM (#11507360)
    Hi all -
    Just thought I'd mention a great site for those who are still stuck with Excel, and who need to somehow programmatically manipulate "bitsy" Excel worksheets, and who must do so **remotely - in a Unix/Linux environment**. So, you can't use any local Windows-based tools.

    ( By "bitsy", I mean sheets with complex layout - a bit here, some more stuff over there, and so on).

    Here are the URLs (and **believe me**, these are worth a visit ... )

    http://ewbi.blogs.com/develops/2004/12/normalize_e xcel.html

    http://ewbi.blogs.com/develops/2005/01/create_exce ls_s.html

    If you have a **desperate need** to manipulate/transform/rearrange data in Excel (and you need to do so in Unix/Linux), check out the URLs above. They show how to translate to-and-from Excel's XML format. Awesome stuff!
    • Be a real man, and use a program that doesn't even allow formating, and then use ascii art to make you're headings.
      • I dunno. The ideas are interesting, but it's hard to take seriously a typographic tool for which a serious effort isn't made to produce beautiful sample documents.

        Where's the Lout equivalent to the TeX Showcase? http://www.tug.org/texshowcase (ob. discl. some stuff from my portfolio is in there).

        I mean the pages on the documentation (expert.pdf) don't even balance, it's rife w/ widows and orphans (breaking a two-line paragraph!?!), the index allows a single entry to be carried over to the next page, and t