As someone who spent way too much time obsessing over this stuff, this is awesome and very promising.
One reason I'm not happy with traditional spreadsheets is that there's no non-hackish way to implement "tagging" (as in, hashtagging) a given row. You can create a "tag" column for storing "tag strings" (all the tags that have been applied to this row, delimited by say comma) and then filter by instr or some regex, but it's inconvenient.
Haven't fully checked out the features of TreeSheets yet but I imagine it would be quite suited for this purpose? Is it possible to do a search for all the rows whose 'tag' column's value includes as a member (not: contains as a substring) a particular tag?
It's quite flexible in how you structure your data, so besides rows and columns, "tags" can be children or parents. It even has an explicit tagging feature where you define tags that can easily be applied. See also the "Hierarchy Swap" feature as a powerful tagging related feature.
On the downside, the built-in search is purely textual, not structural, so your example query can't be done. Structural queries would be an awesome addition though.
One reason I'm not happy with traditional spreadsheets is that there's no non-hackish way to implement "tagging" (as in, hashtagging) a given row. You can create a "tag" column for storing "tag strings" (all the tags that have been applied to this row, delimited by say comma) and then filter by instr or some regex, but it's inconvenient.
Haven't fully checked out the features of TreeSheets yet but I imagine it would be quite suited for this purpose? Is it possible to do a search for all the rows whose 'tag' column's value includes as a member (not: contains as a substring) a particular tag?