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
  • Treczoks@lemmy.world
    2·
    2 hours 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.

  • daniskarma@lemmy.dbzer0.com
    42·
    3 hours 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.

  • PushButton@lemmy.world
    5·
    5 hours 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

    • fine_sandy_bottom@discuss.tchncs.deEnglish
      1·
      2 hours ago

      Click the column header to select the column, then click and drag the selected cells to wherever you want.

      Note that dragging cells in this way is the same as copy & paste, so it will not insert the column at your destination and move the existing columns along, it will leave a gap where you dragged it from and overwrite the column wherever you leave it.

    • maniii@lemmy.worldEnglish
      4·
      5 hours 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.

  • paequ2@lemmy.todayEnglish
    34·
    14 hours 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.

  • 474D@lemmy.world
    63·
    10 hours ago

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

    • canihasaccount@lemmy.world
      8·
      5 hours ago

      ONLYOFFICE (sorry about the caps, poor name choice IMO) has even better docx compatibility, and its source code is open

    • ProgrammingSocks@pawb.social
      46·
      10 hours 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.

  • JustFudgnWork@sh.itjust.worksEnglish
    5·
    12 hours 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
        1·
        2 hours 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.