Getting the value of a cell with number format?

[ktiniatros]

Hello,

I cannot read values from cells which contain numbers, eg the value 1,19. The cell is formatted as Number.

Is this possible with this library?

Thanks!

[MaxDesiatov]

Hi @ktiniatros, thank you for reporting this issue. Would you be able to attach the spreadsheet file and specify cells that you're having the problem with? That would greatly help in fixing the issue.

If your spreadsheet file contains any sensitive information that can't be shared publicly, can you please send it to hello@corexlsx.org?

[ktiniatros]

It turns out I was trying to access the cell number value in the wrong way. But I believe I was a bit mislead by the inconsistency of the api + the lack of documentation. I'll explain what I mean:
If cell 1 of a row contains a string then row.cells[1].value returns the index to file.parseSharedStrings()
But if cell 1 of a row contains a number then row.cells[1].value returns the value (i.e. the number itself).
I would expect either to get always indexes or always the values themselves.

Please don't take this comment personally, it's just feedback. You've done a great job with this library, which helped me a lot and I thank you for that!

[MaxDesiatov]

Thank you very much for the update @ktiniatros, I'll keep this issue open until the documentation and the API are updated if you don't mind.

[MaxDesiatov]

There's a new API added with an extension on the Cell type: func stringValue(_: SharedStrings) -> String? in #102, it automatically checks if a cell references a shared string and fetches one if needed, otherwise it returns an inline value as a string. Hope that resolves the issue.