Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can detect type when raw cell type is empty, instead of "Numberic" by default? #807

Open
someblue opened this issue Jun 17, 2024 · 0 comments

Comments

@someblue
Copy link

someblue commented Jun 17, 2024

Thanks for the awesome library! It saved my time a lot! I find an issue with the default cell type behaviour.

I have a system generated xlsx file containing a formula cell type.
image

It's ok in Microsoft Excel. But using tealeg/xlsx, cell. FormattedValue() return str="", err=nil. Expected return str="I18N", err=nil as in excel.

After debugging, I found that the raw cell has no type information for the cell. And then by default, the type will be treated as "numberic", so the formula are ignored when parsing.
image

Maybe the system generates the xlsx file incorrectly, but I cannot contact with the admin of system to change the behaviour. And it work well in Microsoft Excel.

Is it possible to change the default behaviour: check if the rawCell.F exists, set type as "Formula" if so?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant