19
Put multiple values in one cell with lists and arrays in Excel (techcommunity.microsoft.com)
submitted 3 weeks ago by to c/technology@lemmy.world
17 comments fedilink hide all child comments

all 17 comments

sorted by: hot top controversial new old
[–] 12 points 3 weeks ago (3 children)

Wow. Great.
So tell me what happened with that Sept patch that broke Copy/Paste. But you keep on giving us features the majority of users will never use. Thanks

I’m sure this is some AMAZING thing that a few users need/ want. But we had lists and arrays

  • permalink
  • fedilink
  • source
  • hideshow 3 child comments
    •
  • [–] 1 point 3 weeks ago (2 children)

    What happened to copy/paste? Works fine for me

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 5 points 3 weeks ago

    Not OP but I use an Enterprise version that is fine, I guess a different release branch. My mother doesn't have the enterprise version as she works for a small business and it broke.

  • permalink
  • fedilink
  • source
  • parent
    • [–] 10 points 3 weeks ago* (2 children)

    LibreOffice > Microslop Office

  • permalink
  • fedilink
  • source
  • hideshow 2 child comments
    •
  • [–] 4 points 3 weeks ago

    From an ideological viewpoint, I agree fully.

    From a technical viewpoint, Excel is still the best by far.

    For a normal office worker, LibreOffice Calc is all they need out of a spreadsheet software.

    But those working in finance or in other power user roles will either not be able to switch or have a very hard time switching from Excel.

    Calc is a brilliant program, there is no denying that, but it is far from a drop in replacement for Excel

  • permalink
  • fedilink
  • source
  • parent
    • [–] 5 points 3 weeks ago (1 child)

    I just learned about the sequence function.

    If the two work together, I’m going to be so fucking insufferable at work.

  • permalink
  • fedilink
  • source
  • hideshow 1 child comment
    •
    • [–] 2 points 3 weeks ago (5 children)

    The whole spreadsheet paradigm is an appallingly stupid way to handle most data. It should really die a death, outside of (maybe) a few boneheaded accountancy uses.

  • permalink
  • fedilink
  • source
  • hideshow 5 child comments
    •
  • [–] 2 points 3 weeks ago (4 children)

    Ok, if a spreadsheet is a stupid way to deal with most data, what do you suggest is used instead?

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 4 child comments
    •
  • [–] -1 points 3 weeks ago* (last edited 3 weeks ago) (3 children)

    Lots of people require basic level functionality. Often one or more lists with a few columns and some adding up. Spreadsheets designed for serious users are not very good at that. As you need data integrated into other things not separated in another application. More than 1 list is a pain as you can't move them freely as cell sizes must line up so they mess the other one up. They can't be overlapped or separated easily. Most users are not finance wizards. But the world of open standards is so screwed up that there is no decent way to handle information. Silos are to be avoided too. So it's hard to find an alternative to suffering using the wrong tool. Microsoft doesn't care about users. And open source is focussed on the IT side and not on users.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 3 child comments
    •
  • [–] 2 points 3 weeks ago (2 children)

    You have yet to suggest an alternative, you just told me why you think it is bad, not what should be used instead

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
    • [–] 1 point 3 weeks ago

    if you need arrays perhaps use a more ergonomic programming language

  • permalink
  • fedilink
  • source
    •
    [–] 1 point 3 weeks ago

    Muelltonne is spilling.

  • permalink
  • fedilink
  • source
    •