• paequ2@lemmy.today
    link
    fedilink
    English
    arrow-up
    29
    ·
    17 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.

  • daniskarma@lemmy.dbzer0.com
    link
    fedilink
    arrow-up
    2
    arrow-down
    2
    ·
    7 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.

  • JustFudgnWork@sh.itjust.works
    link
    fedilink
    English
    arrow-up
    4
    ·
    15 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.works
        link
        fedilink
        English
        arrow-up
        3
        ·
        6 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.