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.

Sign up for GitHub

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

Jump to bottom

Investigate warning about "chartsheet" not being imported #7

Open

Bisaloo opened this issue Mar 31, 2023 · 1 comment

Owner

Bisaloo commented Mar 31, 2023 •

edited

Loading

I don't have a reprex for this just yet as this appeared in a live debugging session with users and we didn't have time to dig deeper.

I suspect this appears when you have a plot in your worksheet.

Owner Author

Bisaloo commented Apr 11, 2023

https://github.com/nacnudus/tidyxl/blob/158030d77805d8c9d422f2f1a0e565bd3e41f8a8/R/utils.R#L43-L45

This appears when the selected sheet is not a worksheet but a chartsheet. In this situation, a warning is thrown and a 0-rows data.frame is returned.

From my tests, a chartsheet is a sheet with nothing else than a chart. As soon as you add text anywhere, it turns into a worksheet.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment