MathNya / umya-spreadsheet

A pure rust library for reading and writing spreadsheet files
MIT License
238 stars 41 forks source link

Embedded images are not adjusted when rows/columns are inserted/removed #190

Open schungx opened 1 month ago

schungx commented 1 month ago

There are a whole bunch of adjustment_insert/delete_row/column API's that are marked pub(crate) but are not called anywhere.

They should be called in insert_cols, remove_cols, insert_rows, remove_rows etc.

Currently, inserting/removing rows/columns require manual adjustment of the cell anchor of embedded images (as well as I believe all other embedded objects).

schungx commented 4 weeks ago

Additionally, I find that, once columns/rows are deleted, then it seems that all formulas in all the cells beyond the deleted columns/rows are deleted (or at least the majority of them).

MathNya commented 3 weeks ago

@schungx Thank you for your report as well. We will respond to it as well.