Stephen Chung
Stephen Chung
Frankly speaking, this library is getting really good. Pity that some of the API is not very Rust-y... Maybe we can do an overhaul for `2.0`...
Let me know what I can do to help out here. This is a fantastic library.
I can see you working hard on #188. Good hunting!
Unfortunately I must reopen this issue. The situation is much improved but it is still happening. In spreadsheets with heavy embeddings of pictures and drawings, formulas are still missing in...
[xxx.xlsx](https://github.com/user-attachments/files/16128707/xxx.xlsx) Here is a min repo for the error. I have deleted most content and all embedded drawings/images. P16 and Q16 have formulas. Starting from row 17 no more formulas.
Hhhmmm... that's strange. I have a REPL tool that I use to check spreadsheet data. This is a snapshot:  I'll dig out the relevant functions and post here.
```rust /// get_cell_formula book.get_sheet(&index).unwrap().get_cell(address).map_or("", |c| c.get_formula()) ``` `P16` has `formula`: ```text Some(CellFormula { bx: BooleanValue { value: None }, data_table_2d: BooleanValue { value: None }, data_table_row: BooleanValue { value: None...
> One more point i observed. > > Whenever we try to create new row / modify existing cell value CPU utilization is going peek into 99% and so on....
Must you keep all those blank rows? Or can you use column styles instead?
I would suggest reducing the size of the xlsx files. Excel files are not the easiest to parse and this repo does a very thorough job in exposing very detailed...