51–54 of 54 posts
[flagged]
Thanks! Honestly, the current implementations are pretty naive — they pass the tests and feel snappy on the small sheets I work with, but they'd buckle pretty quickly under real load. Most of what you're asking about is already on the tracker; I opened a batch of issues citing your comment as the prompt. Recalculation. Right now it's a full recalc on every edit: recalculate collects all formula cells, computes in-deg…
I've been using https://github.com/medialab/xan for anything csv. It's the best tool there is for reading and analyzing csv files, but not for writing them. Something like cell-sheet-tui would fit my workflow very well, since I am using neovim to edit csv files manually (as well as some csv merging features offered by xan to simplify the process). The reason why I find your software promising is because dealing with…
It does not appear to support the file types I regularly work with: https://www.fda.gov/medical-devices/medical-device-reporting...
These files have a field delimiter of '|' with a line delimiter of '\r\n', as individual fields also contain '\n' characters.
I prefer visidata as the program stays running while searching and navigating through large files, making subsequent searches and filtering much faster, plus editing/writing is also supported, as well as Excel and other formats I regularly use.
This looks good, but, I noticed: > Supported Functions (v1) > SUM, AVERAGE, COUNT, MIN, MAX, IF I would recommend switching to numerically stable algorithms for adding numbers and taking their averages sooner rather than later. Looking at the code[1], it looks like you are simply summing the numbers and dividing by count. If that is indeed the case, please switch to a stable average[2]. See also [3]. Additionally, I…
What do you recon Excel does, floating point math for regular entries and lossless point math for currency? Or just does not rely on floats at all?
This looks good, but, I noticed: > Supported Functions (v1) > SUM, AVERAGE, COUNT, MIN, MAX, IF I would recommend switching to numerically stable algorithms for adding numbers and taking their averages sooner rather than later. Looking at the code[1], it looks like you are simply summing the numbers and dividing by count. If that is indeed the case, please switch to a stable average[2]. See also [3]. Additionally, I…
This is valuable feedback. I opened two issues to track this: Use numerically stable algorithms for SUM and AVERAGE: https://github.com/garritfra/cell/issues/43 Keystrokes doubled in Windows Terminal: https://github.com/garritfra/cell/issues/44 Thanks!