R Studio crashes reading file

[kuri-pablo]

R Studio crashes reading file

[nacnudus]

Thank you for taking the trouble to report this. I can reproduce the crash, but I don't know why it does yet.

I opened it in LibreOffice Calc, saved a new copy of it, and that copy opens in tidyxl. Perhaps that would work for you (or use Excel, or Google Sheets, or whatever other spreadsheet software is available to you).

[kuri-pablo]

Thanks. I did open the file in Sheets and then exported it to Excel. It worked.

The problem with the approach is the amount of files to open and save. If you find a solution I would appreciate your input.

[nacnudus]

I will keep trying to find the cause of the error.

If you can use libreoffice from the command line, then it's possible to process the files as a batch. See for example https://www.libreofficehelp.com/batch-convert-writer-documents-pdf-libreoffice/.

[kuri-pablo]

Excellent, I'll try your recomendation.

[nacnudus]

I think this is now fixed. Please reopen this issue if not.

[e-mcbride]

Hi @nacnudus I am still encountering this issue using tidyxl to import an .xlsx file downloaded from SurveyMonkey. I have tidyxl version 1.0.7 installed. Your fix did work though: once I opened the file in Excel and saved a new copy, it imported successfully.

[nacnudus]

@e-mcbride sorry that you're having this problem, thank you for reporting it. Are you able to install the latest version 1.0.7.9000 from GitHub by doing, for example, remotes::install_github("nacnudus/tidyxl")? If that fixes the problem, then I will publish this version to CRAN.

[e-mcbride]

@nacnudus unfortunately that didn't work :/ Let me know if there is anything else I can do to test this!

[nacnudus]

@e-mcbride Please can you provide an example file that causes the error?

[e-mcbride]

@nacnudus Thank you so much for looking into it! Here you go: https://ucsb.box.com/s/3h6dg2hsmgx08laseag2ml88v1oqfg0t

Please let me know if the link expires before you get a chance to download it! I can make a new one.

[nacnudus]

@e-mcbride Thanks for providing the file. The cause is different from the one in this issue, so I have created a new issue #73 to track it. Sorry it has taken me so long to address this.