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

S3: integer64s become zeros in Excel file #25

Open
EarlGlynn opened this issue Oct 16, 2018 · 1 comment
Open

S3: integer64s become zeros in Excel file #25

EarlGlynn opened this issue Oct 16, 2018 · 1 comment

Comments

@EarlGlynn
Copy link

Here’s a reproducible example using the bit64 package to create an int64:

library(tidyverse)
library(bit64) # as.integer64
library(writexl)
library(readxl)
d <- tibble(a=pi, b=3L, c=as.integer64(3))
d
write_xlsx(d, "saveint64.xlsx")
read_xlsx("saveint64.xlsx")

"c" is written to the file as 1.482197E-323 (near zero) instead of the expected 3.

@jeroen
Copy link
Member

jeroen commented Oct 16, 2018

Did you try the dev version? This was fixed recently.

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

2 participants