Friendica
Devine Lu Linvega
Devine Lu Linvega

Devine Lu Linvega

neauoire@merveilles.town

Devine Lu Linvega

neauoire@merveilles.town
It’s always night under the ultraviolet sun.
ActivityPub
2022-05-01 09:56:11 2022-04-29 19:30:52 2022-04-29 17:03:25 242166

Devine Lu Linvega
Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

3 years ago • •

Devine Lu Linvega

3 years ago • •


Okay, I can't keep the urge of making my own spreadsheet program at bay any longer.

Let's get started.

  •  Languages
  •  Search Text
  •  Share via ...
in reply to Devine Lu Linvega

Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

in reply to Devine Lu Linvega • 3 years ago • •
Drawing multiple cells and rulers
  •  Languages
  •  Search Text
  •  Share via ...
in reply to Devine Lu Linvega

Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

in reply to Devine Lu Linvega • 3 years ago • •
Let's parse a csv file.
  •  Languages
  •  Search Text
  •  Share via ...
in reply to Devine Lu Linvega

Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

in reply to Devine Lu Linvega • 3 years ago • •
Tiny 58 bytes csv parser, now it's time to implement spreadsheet formulae.
  •  Languages
  •  Search Text
  •  Share via ...
in reply to Devine Lu Linvega

Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

in reply to Devine Lu Linvega • 3 years ago • •
Starting selection, gosh, I love doing gui apps in postfix programming languages.
https://assets.merveilles.town/media_attachments/files/108/217/548/776/488/531/original/abb5553275ba4db1.mp4
  •  Languages
  •  Search Text
  •  Share via ...
in reply to Devine Lu Linvega

Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

in reply to Devine Lu Linvega • 3 years ago • •
Cells with computed values will have a different background.
  •  Languages
  •  Search Text
  •  Share via ...
in reply to Devine Lu Linvega

Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

in reply to Devine Lu Linvega • 3 years ago • •
Wrote a little spreadsheet evaluator in 4000 bytes of #uxn bytecode.
:uxn:
https://assets.merveilles.town/media_attachments/files/108/217/918/156/056/297/original/75cc8e6720ee8b2b.mp4
#uxn
  •  Languages
  •  Search Text
  •  Share via ...
in reply to Devine Lu Linvega

Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

in reply to Devine Lu Linvega • 3 years ago • •
Started improving input, added a form at the bottom that let's me see the spreadsheet's formulae and edit them.
https://assets.merveilles.town/media_attachments/files/108/218/912/422/846/038/original/1fe8c21dfce3837e.mp4
  •  Languages
  •  Search Text
  •  Share via ...
in reply to Devine Lu Linvega

Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

in reply to Devine Lu Linvega • 3 years ago • •
Aight, back to building a spreadsheet program in assembly. I will try to display border highlights around the region read in each of the formulae.
git.sr.ht/~rabbits/nebu/tree/m…

~rabbits/nebu: src/nebu.tal - sourcehut git

git.sr.ht
  •  Languages
  •  Search Text
  •  Share via ...
in reply to Devine Lu Linvega

Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

in reply to Devine Lu Linvega • 3 years ago • •

Implemented highlight for cells from which the formulae is pulling its values.

I'm finally building my dream spreadsheet application, and it's going to be a mere 5kb program that runs on all our old devices.

https://assets.merveilles.town/media_attachments/files/108/222/354/143/546/569/original/b90903b9a8ed9487.mp4
  •  Languages
  •  Search Text
  •  Share via ...
in reply to Devine Lu Linvega

Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

in reply to Devine Lu Linvega • 3 years ago • •
I seem to be having an issue pulling results from formulae cells.. 🤔
https://assets.merveilles.town/media_attachments/files/108/222/412/562/356/501/original/dcfd764e805815b8.mp4
  •  Languages
  •  Search Text
  •  Share via ...
in reply to Devine Lu Linvega

Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

in reply to Devine Lu Linvega • 3 years ago • •
Fixed issue, added scrolling and display selection size. Up next, doing other functions than SUM, I'd like to have AVERAGE() and PRODUCT().
https://assets.merveilles.town/media_attachments/files/108/223/170/240/755/200/original/514f4ae6246ecc4c.mp4
  •  Languages
  •  Search Text
  •  Share via ...
in reply to Devine Lu Linvega

Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

in reply to Devine Lu Linvega • 3 years ago • •
I've been thinking about using:
- `a5:c8` for an array reference
- `a5;` for a single cell reference
https://assets.merveilles.town/media_attachments/files/108/223/355/604/786/378/original/04e337e871c732b2.mp4
  •  Languages
  •  Search Text
  •  Share via ...
in reply to Devine Lu Linvega

Devine Lu Linvega
hometown - Link to source

Devine Lu Linvega

in reply to Devine Lu Linvega • 3 years ago • •

Starting to dive into the more fun parts of spreadsheets UX! :moar:

Implementing this is endlessly fascinating. I should have tried this much earlier on.

https://assets.merveilles.town/media_attachments/files/108/224/858/616/295/872/original/f8a4e10bc23258a2.mp4
  •  Languages
  •  Search Text
  •  Share via ...
⇧