Please add colletions
Hey, I’m of the impression that Excel is stuck in a old accountant dinosaur tech world.
The addition of “let” and js- like scripting is a small step forward..
But real improvement for humanity comes when you’re able to right-click and declare a “sheet” and/or “column” to be strongly typed, and support collections framework in formulas.
I.e [signedDisclosure].contains({“yes”;”maybe”})
I don’t even know if the lamda => operator is supported, but if, it should be readily available in common usecases, autocomplete etc.
Also:
I’d like som sort of primary key, to text imports i.e (“pete1″;{60;”washington”;”student”}) stored like a dictionary or complex object, without the hefty datamodel memory footprint.
Hey, I’m of the impression that Excel is stuck in a old accountant dinosaur tech world.The addition of “let” and js- like scripting is a small step forward..But real improvement for humanity comes when you’re able to right-click and declare a “sheet” and/or “column” to be strongly typed, and support collections framework in formulas. I.e [signedDisclosure].contains({“yes”;”maybe”})I don’t even know if the lamda => operator is supported, but if, it should be readily available in common usecases, autocomplete etc.Also:I’d like som sort of primary key, to text imports i.e (“pete1″;{60;”washington”;”student”}) stored like a dictionary or complex object, without the hefty datamodel memory footprint. Read More