LibreOffice 25.2 has been released, this year's first major update to the leading open-source office software for Windows, macOS, and Linux. Image: The
  • paequ2@lemmy.todayEnglish
    7·
    7 days ago

    I’ve been using LibreOffice more these days for writing, slides, and spreadsheets. I can’t remember now the last time I used a Google app for this.

    • maniii@lemmy.worldEnglish
      2·
      6 days ago

      I wanna make LO look exactly like MSOFF and troll the hell outta every MSOFF user.

      Also I wanna go back to IBM Lotus Symphony look. It was the best interface for me.

  • PushButton@lemmy.world
    3·
    6 days ago

    Does someone know how to move columns around in Calc?

    A colleague was telling me the other day that feature is missing. I tested it, like grab the column from the top and drag and drop… to no avail.

    I am not an office expert, so maybe you guys could help out?

    Thanks

    • Jenseitsjens@lemmy.world
      01·
      6 days ago

      I’ve looked that up before. I think you have to hold Alt while grabbing the edge of the selection.

  • JustFudgnWork@sh.itjust.worksEnglish
    2·
    7 days ago

    I just need spill ranges from excel before I can fully ditch the microsoft office suite, so many of my spreadsheets rely on them.

      • JustFudgnWork@sh.itjust.worksEnglish
        4·
        6 days ago

        Sure! Basically, certain formulas in excel affect more than one cell. For example, there is a function called “sequence”. “=SEQUENCE(5)” puts a 1 in the cell where it is, a 2 in the cell below, 3 below that etc. up to 5. I.e. it “spills” out of its cell.

        I mostly use this feature when A) designing spreadsheets where I need to update the number of rows of data during operation, or where the number of rows is truly dynamic (a real example is a sheet that goes through my asset purchases and bundles them into buy-sell chunks for tax) B) Where I want to do anything with filters that excel doesn’t have by default - since one of the spill-enabled functions is “FILTER”

        I know the ‘right’ way to perform these tasks is with an actual programming language but I want to be able to share these sheets with others and have them be vaguely happy to have them.

  • daniskarma@lemmy.dbzer0.com
    0·
    6 days ago

    Did they fix this bug when you put writer in Fullscreen it won’t actually be fullscreen and let a border of one pixel all around? It has been there ages.

  • 474D@lemmy.world
    0·
    6 days ago

    Libre is good but I have no idea why WPS Office isn’t discussed more. It’s essentially a functioning MS Office clone.

    • ProgrammingSocks@pawb.social
      3·
      6 days ago

      Because it’s not free software. It’s proprietary, so you’re still putting everything into the hands of some random corporation. Software freedom is important, and important to this community specifically.