back to article LibreOffice 6.3 hits beta, with built-in redaction tool for sharing those █████ documents

The Document Foundation has released the first beta of LibreOffice 6.3, with new features including a redaction tool and a Fourier Analysis spreadsheet function. LibreOffice was forked from OpenOffice in 2010, which is when The Document Foundation was formed, including a team of OpenOffice contributors. OpenOffice has also …

  1. Charlie Clark Silver badge

    Improved UI

    At least from the screenshot it looks like they've got rid of that awful "child's crayon" theme.

  2. 0laf
    Linux

    Hopefully they have made some performance improvements as well. It was pretty damn clunky the last time I used it.

    1. jake Silver badge

      How long ago did you last try it?

      I am using Eric Hameleers' build of LibreOffice 6.2.4 on a 16 year old HP laptop (zv5105, Radeon 9000 IGP, 2gigs). It works just fine, not clunky at all, never even hits swap when doing normal office stuff. This is on Slackware 14.2 -stable ...

    2. Will Godfrey Silver badge
      Happy

      Seems absolutely fine to me. I'm not exactly a power user, but then again neither are the vast majority of users of any document processor.

    3. Chairman of the Bored

      OO performance?

      Actually I use OO's calc tool to manipulate enormous machine generated .csv files that cause Excel (any variant) to segfault and go down in flames. Hundreds of meg in a go? No problem, even on modest hardware.

      For me, where OO really shines is the equation editor. Unlike MS Word you can compose complex equations without having to constantly bat your hand between keyboard and mouse. It's a beautiful design. Not as powerful as LaTeK, mind, but good enough for government work.

      Where OO suffers is when you convert to and from the Microsoft file formats to the open formats; I waste far too much time re-doing PowerPoint graphics foo, redoing margins in Word, and so forth. Suspect it's a combination of differing font configurations between a Linux and Windows box, combined with non-standard or undocumented cruft in the MS file formats.

      1. werdsmith Silver badge

        Re: OO performance?

        Hundreds of meg in a go?

        You write that like you consider sub GB files to be large these days.

        Excel handles hundreds of meg .csv no problem in my experience.

        I do use OO and it is the equation editor that is the attraction too. However, everything still have to be loaded into MS Word, formatting checked and then saved in a Word format before I can send it on to anyone else.

        1. twellys

          Re: OO performance?

          Erm... I saved a logic analyser run in csv (16k lines), for my colleague to analyse on they Mac using Ofiice 365 a couple of days ago. Excel barfed repeatedly...

      2. Charlie Clark Silver badge

        Re: OO performance?

        Excel 2016 does contain significant performance improvements (fully 64-bit, multihreaded calcs) over previous versions, but use whatever works best for you. Not sure what you're doing with the CSVs subsequently but many people I know just use Pandas for the heavy-lifting and save to Excel for the manager-friendly reporting.

    4. Muppet Boss

      I concur, OpenOffice/LibreOffice circa 2014 UI and document rendering felt horribly slow on Windows (one could _see_ elements being rendered), contemporary MS Office felt so much faster in comparison on the same machine. Together with the extravagant-lloking UI, OO/LO was simply frustrating to use.

      I checked latest stable OO 4.1.6 and LO 6.2.4 on the same machine: while still not instant, the rendering is much faster now indeed and does not feel frustrating. The LO 6.2.4 default UI looks so much better too.

    5. Chris Parsons

      I name you...

      Microsoft Office, and I claim my £5

  3. Joseph Haig

    ██████

    ███ █████████ ███ ██ ██████ ███-█████ but ████ ██████████ ███

    1. Baldrickk

      Re: ██████

      I certainly find it a little funny that there isn't an option to replace blocks of text with ██████ as a redaction tool...

      you could just mark the beginning and end of sections in the original document, and the export would do the blocking out for you.

      1. Charlie Clark Silver badge

        Re: ██████

        I think the importing to any kind of digital format requires, of course, that the blacked out text really is removed and not merely concealed, and you also want to keep the flow of the document the same (not all letters are equally spaced). But this should indeed be possible when exporting to PDF using a graphic filter and LaTex presumably also has some filters that let you substituion.

        1. Baldrickk

          Re: ██████

          It would still be through an export process, but you wouldn't have to draw on the lines

    2. Anonymous Coward
      Anonymous Coward

      Re: ██████

      The reason for the issue is a matter of national security. Thought up by people concerned about the welfare of the children.

      That explains why ███ ████ ███ ███ ██ ███████ ███ ██ ████ helicopter.

      AC, just in case I have failed to redact properly...

    3. ibmalone

      Re: ██████

      ███████ think ██████ one of the ████ creative ████ opening █████████ I've ████ https://www.youtube.com/watch?v=NBQJjqnG1iI

    4. spold Silver badge

      Re: ██████

      Bunch of overpaid and head-slappingly-under-educated-in technical-matters lawyers once sent me a bunch of redacted word documents, regarding technical security compliance in a Mergers and Acquisition situation. They had just highlighted the redacted text in black.

      Select all.....

    5. Anonymous Coward
      Anonymous Coward

      Re: ██████

      Reminds me of the "censored songs" round they used to have on ISIHAC (non-UK readers might as well give up now as you probably won't understand this!) where the teams were given songs to sing but had to use a buzzer to censor any words that might "frighten the horses" ... this reached a high point when Tim and Graeme were asked to sing a well known welsh song/hymn .... which in their rendition went

      "buzz buzz buzz buzz, buzz buzz buzz buzz, all through the night

      buzz buzz buzz buzz buzz buzz buzz buzz,

      buzz buzz buzz buzz buzz buzz buzz buzz,

      buzz buzz buzz buzz, buzz buz buzz buzz, all through the night"

    6. Anonymous Coward
      Anonymous Coward

      The World's Dirtiest Limerick

      ███ ████████ ███

      ███ █████████ ██

      ██████████

      ███ ██ ████

      ████ river of shit

      1. Francis Boyle Silver badge

        Re: The World's Dirtiest Limerick

        That's fucking ████!

    7. Aussie Doc
      Trollface

      Re: ██████

      Easy for you to say.

    8. Anonymous Coward
      Anonymous Coward

      Re: ██████

      You are Julie from Scott Pilgrim, and I claim my £5

  4. mark l 2 Silver badge

    It is good that they are continuing developing a decent alternative to MS Office but I would rather they spent time on improving the MS Office compatibility than adding in functions for 1% of users.

    The redaction tool is something you could achieve the same result with the older versions of Libreoffice with just a couple more steps. Just tried it with Libreoffice 5.1. Export your document as a PDF, open the PDF in Draw, paste shapes over the words you want to redact, select all and convert to bitmap from the tools menu and save it.

    1. John Brown (no body) Silver badge

      "It is good that they are continuing developing a decent alternative to MS Office but I would rather they spent time on improving the MS Office compatibility than adding in functions for 1% of users."

      It's meant to be an alternative to MSOffice, not an open source clone. I'd prefer it if MS spent more time on getting decent .odf compatibility rather than working on functions for 1% of user :-)

      1. werdsmith Silver badge

        It's meant to be an alternative to MSOffice, not an open source clone.

        Would be nice, but when publishers insist on a 10 year out of date MS Word format, it won't be much help.

      2. big_D Silver badge

        Nobody is talking about cloning, but if you have to regularly exchange files with MS Office users, it can be a real pain.

        LibreOffice's filters for importing or exporting MS Office formats is as bad as MS attempts at importing/exporting ODF files. Either way, neither party shines and the users suffer, if they have to regularly exchange files.

        I used to use OO.o and LibreOffice on Linux, but I always had a Windows machine with MS Office in the corner of the office for checking and reformatting documents, before sending them out to customers. In the end, I gave up and went back to MS Office by default, because all my customers used MS Office and I was spending a third of my time checking and reformatting finished documents before sending them out.

        1. Charlie Clark Silver badge

          it wouldn't surprise me at all if MS switched to ODF at some point – it's a better format – but politics will probably stop that happening. While I do think that, by and large LO has got reasonablly compatible with OOXML, there are still longstanding bugs in some of the code that the developers seem to have little interest in fixing.

          1. big_D Silver badge

            They did try, but ODF doesn't provide the flexibility to store current documents created using OOXML - there are a lot of tags and features missing and ODF wasn't interested in adding those features for compatibility, so MS went with OOXML.

            That also accounts for why some things go bat shit crazy when imported into LO, because LO is written to handle ODF and those extra tags in OOXML can't be translated into anything useful in LO.

            The simplest problems are pagination, which LO generally messes up in Word documents - annoying at best, but embarrassing if you have TOCs and Indexes in your documents that suddenly don't match up any more.

            At one employer, they used LO in the conference room and a customer turned up with a PowerPoint slide stack and about halfway through the discussion on process flows, we noticed that LO had moved the flow arrows to random positions on the slides...

            1. Charlie Clark Silver badge

              Yes, I've heard from people working on standardisation that ODF itself is somewhat rudderless. MS has been reluctant in the past to support work OOXML but have recently really improved in this respect.

              I agree with your assessment: lots of stuff works very well but there's a lot that the developers just don't care about. I work almost exclusively with XLSX so everytime I see worksheets set to 1024 x 1024 dimensions I know they're from LO. Sigh: it's an optional element so better left out altogether.

              Coordinate systems in OOXML (used when positioning graphical objects) are a complete nightmare!

    2. oiseau
      Pint

      ... rather they spent time on improving the MS Office compatibility than adding in functions ...

      Indeed ...

      Was thinking exactly the same thing when I read your comment.

      Have a beer!

      O.

    3. phuzz Silver badge
      Thumb Up

      LibreOffice 6.2 doesn't have the 'convert to bitmap' function, and I suspect that if it did the resulting pdf would be much larger than one containing text.

      On the other hand, I never knew I could edit pdfs with Libre Draw, so thanks for that tip.

      1. Soruk
        Go

        I've been doing that for a few years now, it's really handy for filling in forms that get sent as a pdf, and emailing them back as an edited pdf. It's the best pdf editor I've come across for Linux.

  5. Anonymous Coward
    Anonymous Coward

    LO already has some other security features

    I must admit I haven't experimented with the digital signatures option, but the already integrated TSCP compliant facility to classify documents is of interest for us, although it requires more study before we decide if we implement it (we will, for instance, need to test if we can set up pre-classified templates). Apparently it's implemented to the point of refusing to copy classified information to a document classed as less secure.

    Now, keep in mind that this is *free* software. Amazing. If it wasn't for our Excel munchers I don't think we'd use MS Office at all.

  6. Anonymous Coward
    Anonymous Coward

    What a dumb way to do redaction

    Why would they make it a bitmap where you can't search on text? What a redaction tool should do is simply to replace the characters being redacted with black blobs (or maybe some lightly shaded grey blobs as the "ink saver" option if it will be printed) but otherwise produce a normal PDF. You only need one freaking character in your "redaction font" after all. OK, maybe three - you should randomly vary between three widths so people can't count spacing to determine the length of a redacted word.

    1. cbars Bronze badge

      Re: What a dumb way to do redaction

      Dev's probably just thought: fork it

    2. Roland6 Silver badge

      Re: What a dumb way to do redaction

      It's even more dumb, if the original document is 448 pages, as it makes the redacted version unwieldy.

      Mind you it would probably guarantee that no one (other than a determined journo) would download and read the document; so no one would know what Mueller actually wrote..

    3. Anonymous Coward
      Anonymous Coward

      Re: What a dumb way to do redaction

      Or, since they already have protected sections in place, they could gaved replaced the text with some other font for the protected section....

      This way it stays one and the same document for everyone and the person having encrypted the document is the only one to be able to read and modify those redacted & protected sections....

      Well, a lost opportunity, or perhaps there were other reasons

  7. JeffyPoooh
    Pint

    Is there a 'Redaction Font' yet ?

    All the characters replaced with black blocks.

    Well, right up until somebody changes the font back.

  8. rcxb Silver badge

    Wake me when Calc can handle thousands of columns. Until then, it's no competitor to proprietary options.

    1. jake Silver badge

      Because as we all know ...

      ... 99% or more of all office workers use thousands of columns per spreadsheet on a daily basis. </sarcasm>

      Wake me when you have real objections.

      1. Anonymous Coward
        Anonymous Coward

        Re: Because as we all know ...

        "...office workers use thousands of columns..."

        I've noticed that a given company might employ maybe a dozen financial staff. Made me curious about the rough amount of data that they're dealing with on a weekly basis. Is it a flood of data? Not exactly...

        Between time sheets (rolled up for the week), a bit of procurement, some invoices, etc. Total information to be processed is certainly more than 1kB, but way less than 100kB. So very roughly 10kB of actual data (pure info). That's per week.

        Putting it in this perspective, what the heck are they all doing? This amount of data could be chiseled into granite at that tiny trifling data rate.

        It's all very strange.

        1. jake Silver badge

          Re: Because as we all know ...

          "what the heck are they all doing?"

          The same thing as the rest of corporate middle management. Creating Power Point presentations and attending meetings. Really. It is typically very easy to get rid of over half of all any given company's middle management based on how many hours of their working week is spent wasted on those two things. And get this ... after the purge, the company runs cleaner, smoother and faster, with zero drop in production. Try it. You might like it.

          1. werdsmith Silver badge

            Re: Because as we all know ...

            I've seen data held in an Excel spreadsheet that would not be out of place in a Data Warehouse.

            1. Warm Braw

              Re: Because as we all know ...

              It's an old study, but there's no reason to suggest much has changed: any data computed from a spreadsheet is more than likely wrong. I imagine that this is often self-correcting and that the people who abuse spreadsheets go on to lose their fingers to chainsaws in misguided can-opening incidents before any real harm is done, but perhaps Excel should simply be banned just to be on the safe side.

          2. stiine Silver badge

            Re: Because as we all know ...

            Yeah, but you can only do that once or twice before everything goes to shit.

  9. Beau
    Happy

    Works well.

    I use LibreOffic,5.1.6.2. on Linux 4.15, most days, as a author, well I think I'm an author. Never have any serious problems even with alternate headers, footers, page brakes, page numbers, chapter indexing, and all the other formatting that is required by the printers. And believe me, E. books are even worse. Although I must admit one thing, its spell checker in English English, does have some strange ideas sometimes.

    1. werdsmith Silver badge

      Re: Works well.

      Never have any serious problems even with alternate headers, footers, page brakes, page numbers, chapter indexing, and all the other formatting that is required by the printers.

      Tell me the name of your printer please. I guess it's one of those PoD ones. No publisher middle man with copy edit services etc.

    2. stiine Silver badge

      Re: Works well.

      The first thing I do is disable spell checking and empty the dictionaries. The last thing I want to do is click some oddball key combination and convert every other word to Swiss or Latvian.

  10. steelpillow Silver badge

    List styles

    Just move away from the crappy Silurian epoch MS Word mimic and give us a usable list styling dialog. Oh, and fix those format painter, clear formatting, frame repositioning and gazillion other bijou bugettes from almost as far back while you are at it, thanks.

    Then I would not use all those words that need redacting.

    1. John 110

      Re: List styles

      It's open source and welcomes contributions. Go on, fix those bugs!

      1. steelpillow Silver badge
        Coat

        Re: List styles

        Believe me I would if I could. After all these years I still can't fathom sed or awk, never mind c or whatever. Now, if it was written in FORTRAN...

        1. jake Silver badge

          Re: List styles

          You don't have to be able to code to contribute. Documentation always needs work. If you speak more than one language, your translation skills will probably be highly valued. You can Beta test code, and learn to properly report bugs. Volunteer to answer questions in the user help forum. Cash donations are usually welcome ... even something as simple as turning off your adblocker in the specific forum is a help.

  11. Kev99 Silver badge

    Overall I like OpenOffice. My biggest complaint is some of the simpler action in MSOffice, such as mail merge, are more convoluted in OO. After MSO bribed the PC market for 30 years, many of its quirks are now SOP. OO seems to change many of these which can be a titch bothersome.

  12. Tim99 Silver badge
    Linux

    Sigh...

    It still requires Java for some things...

  13. man_iii

    Fonts of Blotted Ink

    I think Extended ASCII has text blocks 128-255? Also some font called Donger?

    1. stiine Silver badge
      Devil

      Re: Fonts of Blotted Ink

      I just convert the text from Arial Narrow to Lovecraft. That seems to keep my data safe.

  14. JakeMS
    Thumb Up

    Interesting Tool!

    But.. I don't think I would ever have a usage for it.

    It's always good to see LibreOffice progressing though, regardless of if it is something I use or not.

    For the most part, LibreOffice always works perfectly though!

    I can honestly say recently with 6.2 there is only one bug I've noticed. That is, if you write a document in Japanese as opposed to English (I know! Who would do such a thing!), after the first fully written page LibreOffice will slow to a crawl if it has to fallback to Japanese characters from a font such as Sans for example. (Other applications are fine on Linux)

    Luckily, using fonts made specifically for Japanese such as Ume, resolves this issue and LibreOffice will resume being fast.

    So, aside from that easily worked around bug, all good for the many years I've used it!

  15. find users who cut cat tail

    Fourier

    I love Fourier analysis and use it a lot. But when you find yourself needing it in a spreadsheet please take it as a slight nudge you are using the utterly wrong tool for the job...

    1. stiine Silver badge

      Re: Fourier

      I can only upvote this once. but I really want to sit here and click UpVote for another half hour.

  16. slartybartfast

    Any poor students working on their dissertations should give LibreOffice a go. I managed, a long time ago, to figure out the formatting and even created an automatically updating contents. Bit of a faff but the money saved not buying MS Office (especially on Mac) was well worth it. I’ve never used any other office product since as it handles all my requirements. It would be nice if MS Office had more .odf compatibility but we know Microsoft would rather all their formats were the standard (IE6 springs to mind!).

    1. sal II

      Nowadays (at least in the UK) Unis get free O365 licenses for their students. Converting the youngsters in the "true faith", before they can be radicalized to use OS software...

  17. Andy The Hat Silver badge

    Bugs fixed?

    I use it regularly but my biggest LO gripe was trying to do a basic mail merge with an image on the master page (company logo or whatever). About five years ago a bug appeared which broke formatting if there were more that about 20 images in a document - LO generates a mail merge output document so 30 recipients with a single logo on each page would do the job for instance. This was on the bug list and was fixed then immediately broken in the next update ... last time I looked it was still an outstanding bug.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon

Other stories you might like