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
    • maniii@lemmy.worldEnglish
      10·
      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
    10·
    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
      31·
      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
    9·
    6 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
        6·
        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.

  • 474D@lemmy.world
    5·
    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.

  • Treczoks@lemmy.world
    2·
    6 days ago

    I wonder when I can set default options for importing images. I’m using Open/LibreOffice since nearly the beginnings as StarOffice (I think I still have the CD somewhere), and one thing really irks me: Whenever I import an image (which I do rather regularly), it always imports the image as “Anchor->To Character”. For me, this is the wrong default, I always need “Anchor->As Character”. For thousands of images, I have to set this manually.