1. 10
  1. 2

    I’d love for someone to do the same talk, just using LibreOffice, and pointing out what’s missing.

    So far I’ve found in:

    libreoffice –version LibreOffice 10m0(Build:2)

    • R1C1 notation works, it’s under Tools -> Options… and then in the next dialog pick ‘LibreOffice Calc’ and you’ll see “Excel R1C1” as a format option.

    • Named Ranges works, just highlight, give it a name, and the equations all seem to work with these names as well.

    The auto-fill features aren’t that important to me.

    1. 1

      Yes, it would be great. I learned a lot with the video, but since I use LibreOffice (not that often), I don’t know how much of it I can put into practice.

      1. 3

        Ok, I found these notes:


        Going through each one in libreoffice and finding out which do and don’t work.

        So far:

        • WORKS: Riding the range: Libreoffice does this with Ctrl-d, didn’t try the other methods.
        • WORKS: R1C1 Notation as above.
        • WORKS: ctrl-` will switch between equation and value view
        • WORKS: When selecting a column, drag the fill handle from the bottom to the top to erase cells.
        • DIDN’T TRY: Use $ to change relative cell references in formulas in A1 mode to absolute references that won’t change if you paste the formula. Think of the $ as an anchor.
        • DOESN’T: cmd-t on Mac or F4 on Windows when editing a formula will cycle the reference under your cursor between relative and absolute.
        • WORKS: Double click on a column border in the heading (where it says A, B, etc. at the top of the spreadsheet) to autosize.
        • WORKS: You can select multiple columns and double click the border of one to autosize all.
        • WORKS: You can select multiple columns and drag the border to resize one of them. This will give all the selected columns the same size.
        • WORKS: Select a range of cells and start typing. Then hit enter and it will jump to the next selected cell.
        • DOESN’T: Hit ctrl-enter and the range will be filled from the selected cell.
        • WORKS: Enter 1 in a cell and 2 in the cell directly below. Then select these cells and drag the fill handle down (lower right corner of the selection box). It will continue the series of numbers.
        • DOESN’T: Right-click drag the fill handle to get a list of options for how Excel should fill.
        • DOESN’T: You can do this with days of the week, dates, and lots of stuff. (Joel shows an example using the last day of the month, which Excel can figure out from 1/31/13 and 2/28/13.

        Have to do work you know, at work, but will be back to update this later! Looks like libreoffice covers the first step of many of these features, but doesn’t take it as far as excel (what I would expect). More works than I would have thought.

        Anything with DOESN’T I tried and didn’t work, but I may be wrong. Everything with WORKS I tried, but I may be wrong.

    2. 2

      OMG, if he had actually talked like the “You Suck at Photoshop” guy, even just for a little bit, that would have been amazing.

      Still though… I learned a lot from this video.

      Stories with similar links:

      1. You Suck at Excel (2015) via edoput 3 months ago | 14 points | 2 comments
      2. You Suck at Excel with Joel Spolsky via pushcx 7 years ago | 15 points | 4 comments