search

MathNya / umya-spreadsheet

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

Some cells are missing formulas #194

Open schungx opened 3 weeks ago

schungx commented 3 weeks ago

It is strange that, for certain spreadsheets, some cells are missing their formulas, but not all.

This usually happens for cells that are beyond a particular row/column.

I have created a minimal reproduction sheet (attached).

test.xlsx

You'll find that all cells in row 1 have their appropriate formulas (i.e. it returns the correct formula string for the get_formula call).

However, all the cells from D2 to J2 should have formulas, but get_formula returns the empty string. A debug dump shows that those cells have the formula field set to None.

The funny thing is, the formulas for cells B2 and C2 remain intact. The emptiness starts from column D and row 2.

MathNya commented 3 weeks ago

@schungx Thank you for your report. We will respond to this as well. (We do not have time to respond this week. We will start next week.)

schungx commented 2 weeks ago

Let me know what I can do to help out here.

This is a fantastic library.

MathNya commented 2 weeks ago

@schungx Sorry. The update is behind schedule. This is due to an unexpected error in the #188 fix. We will try to respond as soon as possible.

schungx commented 1 week ago

I can see you working hard on #188. Good hunting!