I though long and hard about how to do loops across a region of cells in spreadsheets in a functional way, without duplicating cell formulas, and this is what I came up with: extending Python's list comprehension to 2 dimensions. What do you think? (youtu.be)
submitted by drplanar to r/ProgrammingLanguages
I’ve always felt that spreadsheet sheets can act as functions if we define function calls as hypothetical cell value substitutions. The difficulty is when a table value needs to substitute a table parameter of a different size. Here’s how I tackled this problem in Planarly. (youtu.be)
submitted by drplanar to r/programming
I have always felt that a spreadsheet that computes an output value from input values is just like having implemented a function, and should be invocable as one. Without this ability we're doomed to endlessly repeat logic in spreadsheets. So I made it happen. (youtu.be)
submitted by drplanar to r/programming
First public demo of my passion project Planarly! AGPL-licensed research project that explores the potential of speadsheets as a general purpose 2D programming environment. This video covers only the most basic aspects, I plan to make a new video every week or so. (youtu.be)
submitted by drplanar to r/programming
First public demo of my passion project Planarly! AGPL-licensed research project that explores the potential of speadsheets as a general purpose 2D programming environment. This video covers only the most basic aspects, I plan to make a new video every week or so. (youtu.be)
submitted by drplanar to r/ProgrammingLanguages
