Stephen Chung

Results 546 comments of 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: ![image](https://github.com/user-attachments/assets/5c8b94a4-747a-4957-bb12-0f91337abd85) 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...