MathNya / umya-spreadsheet

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

Cell borders are lost #200

Open Expurple opened 5 days ago

Expurple commented 5 days ago

Thank you for providing this library. For some reason, it loses cell borders. Here's a minimal reproduction with an .xlsx file made in LibreOffice. I have a single cell with no data, some borders and some background color. I read the Spreadsheet from that file and then immediately save it to another file. That new file still has the background color, but the cell borders are gone.

umya_spreadsheet_repro.zip

MathNya commented 5 days ago

@Expurple Thank you for your report. We will investigate.

schungx commented 4 days ago

I have a feeling that all the recent issues may have a common source -- that when round-tripping, some structures are omitted and so everything beyond those omitted data are shifted in position and thus disappear or mapped to other cells.