‹ BackHN Continuity

Thread

Excel now supports multiple values in a single cell

278 points · 196 comments · luispa

  1. oniony · · focus · HN ↗
    Weird, because I remember a job where we had arrays in Excel cells back in 2008.
    1. hyperlinerapp · · focus · HN ↗
      These arrays are IN A SINGLE CELL
      1. oniony · · focus · HN ↗
        So were the 2008 ones.
    2. tomrod · · focus · HN ↗
      You could call a named range or ctrl+shift+enter to run an array command. You couldn't put a defined array in a single cell, it would read at text.
    3. agar · · focus · HN ↗
      Excel arrays are difficult to work with, exceedingly slow, and didn't have some basic formula support.

      This looks like a very sane implementation, addresses some issues with traditional arrays (while extending them nicely) and implements those much-needed formulas.

      1. NetMageSCW · · focus · HN ↗
        That should be were difficult to work with - that changed drastically with a new calculation engine. This just makes arrays more of a first class cell type.
Open on Hacker News to reply ↗

Unofficial Hacker News client; not affiliated with Y Combinator.