WTF Excel?!

from blog Sebastian Witowski, | ↗ original
For a tool that probably underlies most of the financial systems in the world, Excel has some incredibly weird limitations and quirks. Let me share a few WTFs I encountered when working with it.
This is a short summary. ↗ Open original to view full content

Related

Navigating config files using tree-sitter
meain/blog | original ↗
xlsx-dict-reader 0.2.0, or, publishing to pypi in 2024
Brain Dump | original ↗
5 minutes to import CSV to a database: What do you do?
secretgeek.net | original ↗
Spreadsheet Formula Parsing
Vlad's Website | original ↗
Experimenting with column- and row-oriented datastructures
Notes on software development | original ↗
No really, Python's pathlib is great
Redowan's Reflections | original ↗
What’s wrong with the grid?
Chris Done's Blog | original ↗
Adventures building a spreadsheet engine in Python
James' Coffee Blog | original ↗
IPython Startup Files
Sebastian Witowski | original ↗
SDFSheets
Szymon Kaliski | original ↗

More from Sebastian Witowski

macOS Apps That I'm Using
16 Nov 2024 | original ↗

A list of my favorite, currently used macOS apps.

I Like Makefiles
18 Sept 2024 | original ↗

Fancy new build tools come and go, but I think I will stick with using makefiles to orchestrate everyday tasks in my projects.

Web Automation With n8n, Telegram, Online Forms, and a Bit of Python
22 Aug 2024 | original ↗

How I used a bunch of open-source tools to automate the management of my side project.

I've Built My First Successful Side Project, and I Hate It
19 Aug 2024 | original ↗

How I learned the old truth that when building a software product and selling it to people, "building" is just the beginning. And often, it's the easiest part.

My Stream Deck Setup
13 May 2024 | original ↗

My setup and some tips and tricks for other MacOS users who want to make the most of their Stream Decks.