News for hackers. Stuff that matters.
Re:Show HN: Small, public, shareable spreadsheets by rahimnathwani on Thursday September 11, 2014 @10:44PM (#8306372)
Also check out this project, being featured in the next AOSA book:

https://github.com/audreyt/500lines/blob/master/spreadsheet/...

Re:Show HN: Small, public, shareable spreadsheets by wffurr on Thursday September 11, 2014 @03:35PM (#8304662)
I see empty cells are treated as zero by SUM and the + operator: http://sheets.alhur.es/c8045lb

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

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).

Re:Show HN: Small, public, shareable spreadsheets by consultutah on Thursday September 11, 2014 @02:23PM (#8304201)
I was thinking of doing something similar (not spreadsheets, but open editable pages). How to do generate the ids?
Re:Show HN: Small, public, shareable spreadsheets by stevekemp on Thursday September 11, 2014 @03:17PM (#8304566)
A lot of simple sites just use an incrementing ID which is encoded in base36 for output:

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.

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 fiatjaf on Thursday September 11, 2014 @02:30PM (#8304249)
About open editable pages, are you imagining something like http://consultutah.42pag.es/?
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!
Re:Show HN: Small, public, shareable spreadsheets by fiatjaf on Thursday September 11, 2014 @02:28PM (#8304234)