-
Notifications
You must be signed in to change notification settings - Fork 155
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
Ignoring Cell Formatting #424
Comments
The value in the xlsx file really shows <c r="E2" s="2"><v>7.0000000000000009</v></c>< Formatting is not properly supported in calamine unfortunately. |
oh hmm. i didn't realize that excel would export the CSV based on what was displayed rather than what the actual value was. i guess i shouldn't be surprised excel does something unexpected. thanks for looking at this. is formatting just something that hasn't been implemented yet or is there an argument against supporting it? if it hasn't been implemented, is this where you would recommend looking for prior art? https://git.sheetjs.com/sheetjs/sheetjs/src/branch/master/packages/ssf/ssf.js |
This hasn't been implemented yet because I don't have the bandwidth for that. It is highly requested though. |
is there a way to skip processing cells based on their excel defined format(e.g.
![Screenshot 2024-04-15 at 3 45 21 PM](https://private-user-images.githubusercontent.com/8271228/322638150-efc25665-9c21-4645-a90b-fc5cce7f806f.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjA2OTU3MzYsIm5iZiI6MTcyMDY5NTQzNiwicGF0aCI6Ii84MjcxMjI4LzMyMjYzODE1MC1lZmMyNTY2NS05YzIxLTQ2NDUtYTkwYi1mYzVjY2U3ZjgwNmYucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDcxMSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA3MTFUMTA1NzE2WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9MmUzYmNlMzg4NDU1MmZkZTRiMTg4NDJmMjQyMmUxZTI0ZTY5Zjc4NWIzYWYzN2E0ZTJiYjEzMDllNTRiNDMzNiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.xYQgoR9xXDgJavwRmQiJr1fWckidF9pS0XMfEGno2-A)
Number
)? we have users who upload excel files that are displayed one way in excel, but get converted to floats when they are processed through calamine.this screenshot shows the issue. the csv was generated by saving the xlsx file as a csv. the last two columns have the
Number
format applied and get converted to floats before getting converted back into strings.ideally, those values would get preserved as strings to avoid things like differences in float precision adding a bunch of extra digits or truncating trailing or leading 0s. is there a way to do that currently? i made a small repo showing the problem using the
deserialize
function to specify that the output should always be Stringhttps://github.com/TomPridham/calamine-float
The text was updated successfully, but these errors were encountered: