all 1 comments

[–]x0x7[S] 1 insightful - 1 fun1 insightful - 0 fun2 insightful - 1 fun -  (0 children)

Advantages. You can put in a large JSON object and parse it out in a spreadsheet. You can have values that are themselves arrays, and address that part of a cell much more directly. Running split on a cell's content is pretty cool. Compare =c0:0:0.split('.')[0] to =left(A1,find(".",A1,0)-1).

The values of the cells could be html elements themselves and you could do some pretty meta shit, referencing the UI you're on.

The values of cells can be functions so you don't have to pull out the visual basic editor to add your own functions.