Preview in data import tools fail (from Excel, from Text: readr)

[GegznaV]

System details

RStudio Edition : Desktop 
RStudio Version : 1.2.1226
OS Version      : Windows 10
R Version       : 3.5.2

Steps to reproduce the problem

Use RStudio tool to import Excel file. File is attached:

iris.xlsx

The same situation is with import from text tool:

Describe the problem in detail

Preview of dataset fails (see print screen), but file is imported successfully.

Describe the behavior you expected

Correct preview of the dataset.

[kevinushey]

I can reproduce this as well, but it also seems to reproduce in RStudio v1.1. Perhaps something has changed in readxl that affects some of the assumptions made by RStudio?

[ronblum]

For what it's worth, it works on MacOS Mojave Desktop and Red Hat 7.6 Server, so this appears to be a Windows-only issue.

[kevinushey]

It didn't work for me on macOS Mojave. @ronblum what version of readxl do you have? I see:

> packageVersion("readxl")
[1] '1.2.0'

[kevinushey]

It appears the underlying issue may be caused by the latest version of tibble.

[ronblum]

Confirmed. It works with tibble 1.4.2 but not 2.0.0. (And regarding readxl, I tried both 1.1.0 and 1.2.0.)

[krlmlr]

Workaround added to tibble 2.0.1, on CRAN now.

[kevinushey]

Thanks!