Jon Connell
Jon Connell
OK I have a first pass which is essentially a manual port of your JS version to equivalent Python. Do you have tests you use?
Looks like your Wiki has a bunch of examples I can use and that's throwing up some helpful bugs which is a good start. The fork now lives at https://github.com/masaccio/compact-json...
Also look to retain reference to styles in existing rows/columns when re-writing maps
Added to v3.6.0
v3.5.2 prints `#REF!` for reference errors and in non-formula mode for error cells. Here's your test file without `--formulas`: ```shell % cat-numbers -b tests/data/issue-42.numbers sum,prod 1.0,2.0 1.0,4.0 2.0,#REF! 3.0,#REF! ,#REF!...
Just checking back on this @SheetJSDev OK to close?
v1.8.0 should have all options. Please check if you can.
Thank you for the thorough test case. It does seem that if you accept the refresh and then undo, the resulting data is valid. I can certainly take a look...
@ralfzosel would you mind expanding on your use case for how you want to edit Numbers documents? There are two options for supporting pivot tables in `numbers-parser`: leaving pivot tables...
I've added a test to skip modifying pivot tables which was a small change so quicker than I thought. I've tested on your example and it looks good, but I've...