Re:Show HN: Small, public, shareable spreadsheets
by fiatjaf on Thursday September 11, 2014 @03:48PM
(#8304737)
Are you saying this is bad, or just quoting the blog post for fun and information? I don't think it is bad. Spreadsheets are not meant as programming engines, just as practical editable tables.
As for "the wrong sum" he complais about in the link, people would know it was meant to be the eternally correct sum, because they will see the empty cells waiting to be filled (either by data or by imagination).
If you don't care about the lengths of identifiers you can instead use a GUID. Otherwise you're down to compressed strings that slowly expand in length, and uniqueness tests on generation.
Re:Show HN: Small, public, shareable spreadsheets
by nateparrott on Thursday September 11, 2014 @03:25PM
(#8304604)
You might also want to append some random data onto each id you assign, to prevent malicious bots from just iterating through all the id's and doing evil on them.
Re:Show HN: Small, public, shareable spreadsheets
by consultutah on Thursday September 11, 2014 @03:38PM
(#8304676)
No, it's not really "editable pages". I've just got an idea for a weekend project that needs unique, but book markable pages. I could easily use a guid, but wanted a shorter id, saw this and thought I'd ask. Thx!
https://github.com/audreyt/500lines/blob/master/spreadsheet/...
This reminds me of http://www.haskell.org/pipermail/haskell-cafe/2014-August/11...
>> There is no excuse for a spreadsheet quietly taking a never-assigned cell as zero, but indeed it does. WHAT THE HELL WERE THESE PEOPLE SMOKING?
HN link: https://news.ycombinator.com/item?id=8284939
As for "the wrong sum" he complais about in the link, people would know it was meant to be the eternally correct sum, because they will see the empty cells waiting to be filled (either by data or by imagination).
http://en.wikipedia.org/wiki/Base_36
If you don't care about the lengths of identifiers you can instead use a GUID. Otherwise you're down to compressed strings that slowly expand in length, and uniqueness tests on generation.