XlsxReaderWriter icon indicating copy to clipboard operation
XlsxReaderWriter copied to clipboard

Cell type always BRACellContentTypeUnknown

Open ddaddy opened this issue 6 years ago • 3 comments

Hi, Thank you for keeping this project up to date. I am only just starting to implement this in a new project.

I have exported an OSX Numbers spreadsheet to xlsl and the resulting BRACell type is always BRACellContentTypeUnknown. When reading the cell string the result is always General Is this a known issue with Numbers exported spreadsheets or an issue with this library?

ddaddy avatar Mar 04 '19 18:03 ddaddy

I just tried a spreadsheet I created in Excel for Mac, and it still shows cell type as BRACellContentTypeUnknown yet the returned string is the correct value.

Any idea if it's possible to read .numbers files?

ddaddy avatar Mar 04 '19 18:03 ddaddy

It's even worse for me: when type is "unknown", it returns different values (Numbers reports 426073064007 as value):

(lldb) p cells[4].doubleValue()
(Double) $R7 = 426073064007
(lldb) p cells[4].integerValue()
(Int) $R8 = 426073063424
(lldb) p cells[4].stringValue()
(String?) $R9 = "426073063424"
(lldb) 

chbeer avatar Jul 19 '21 11:07 chbeer

Hi, Thank you for keeping this project up to date. I am only just starting to implement this in a new project.

I have exported an OSX Numbers spreadsheet to xlsl and the resulting BRACell type is always BRACellContentTypeUnknown. When reading the cell string the result is always General Is this a known issue with Numbers exported spreadsheets or an issue with this library?

is this fixed?

rufutecharasu avatar Oct 08 '21 07:10 rufutecharasu