Hello,
I noticed a bug when exporting CryptPad spreadsheets in XLSX format. I have a spreadsheet with a few sheets, all of which have a filtered table. On one sheet ("Sheet A"), I filtered the table by one of the columns. When I download this spreadsheet, I see that the formulas in Sheet A that reference other cells in the same row are incorrect.
Yes - I am aware that references get clobbered when you sort a table with formulas that are referencing cells in other rows, but that's not what's going on. When I look at Sheet A in CryptPad after my column sorting operation, the data and its formulas are correct. When I look at the exported XLSX version of the same spreadsheet, the formulas are incorrect, but only for the rows that were moved per the sorting operation.
Any ideas?