Reading data (Number) not populating 'Text' (cell.w) property #3016

New Issue

rodrigocesaar · 2023-10-19T08:36:53Z

rodrigocesaar commented

2023-10-19 08:36:53 +00:00

Hi,

Not sure if this is the right way to check whether it is a bug or not. I am trying to read an excel file, putting the option to cellNF:true just to see the formats for numbers. For some cells, like the 'H516', is not coming up the cell.w, the 'Text' property. Opening the xml files inside, I can see this cell has an attached style. Can I ask for help?

I noticed the docs say this property will be populated "if applicate". I thought it would always be populated for Number.

Thanks,
Rodrigo

Hi, Not sure if this is the right way to check whether it is a bug or not. I am trying to read an excel file, putting the option to `cellNF:true` just to see the formats for numbers. For some cells, like the 'H516', is not coming up the `cell.w`, the 'Text' property. Opening the xml files inside, I can see this cell has an attached style. Can I ask for help? I noticed the docs say this property will be populated "if applicate". I thought it would always be populated for Number. Thanks, Rodrigo

test2.xlsx

247 KiB

sheetjs commented

2023-10-19 08:46:21 +00:00

Thanks for sharing!

The formatted text doesn't exist in the file. There is a separate function that takes the number format and the value and generates the formatted text.

There are a few custom number formats in the file (e.g. ###,###,##0.00) that are not currently supported by the formatting library. We'll take a closer look.

Thanks for sharing! The formatted text doesn't exist in the file. There is a separate function that takes the number format and the value and generates the formatted text. There are a few custom number formats in the file (e.g. `###,###,##0.00`) that are not currently supported by the formatting library. We'll take a closer look.

rodrigocesaar commented

2023-10-19 22:32:35 +00:00

Thanks for the explanation!

Sign in to join this conversation.