Running ‘testthat.R’ [17s/32s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > library("testthat")
  > test_check("openxlsx")
  Loading required package: openxlsx
  ── 1. Error: Workbook properties (@test-Workbook_properties.R#15)  ─────────────
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::write.xlsx(...)
   2. openxlsx::saveWorkbook(wb = wb, file = file, overwrite = overwrite)
   3. wb$saveWorkbook()
   4. openxlsx:::write_file(...)
  
  ── 2. Error: Save and load Table Deletion (@test-deleting_tables.R#146)  ───────
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb = wb, file = temp_file, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 3. Error: Write read encoding equality (@test-encoding.R#19)  ───────────────
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, tempFile, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 4. Error: fill merged cells (@test-fill_merged_cells.R#23)  ─────────────────
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb = wb, file = tmp_file, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 5. Error: Reading from loaded workbook (@test-load_read_file_read_equality.R#
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, tempFile, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 6. Error: Maintaining Named Regions on Load (@test-named_regions.R#34)  ─────
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, out_file, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 7. Error: Missing rows in named regions (@test-named_regions.R#191)  ────────
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, file = temp_file, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 8. Error: Missing columns in named regions (@test-named_regions.R#267)  ─────
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, file = temp_file, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 9. Error: Matching Substrings breaks reading named regions (@test-named_regio
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, file = temp_file, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 10. Error: Reading NAs and NaN values (@test-read_from_created_wb.R#203)  ───
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, file = fileName, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 11. Error: Reading from new workbook 2  (@test-read_from_created_wb.R#272)  ─
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::write.xlsx(df, file = fileName, overwrite = TRUE)
   2. openxlsx::saveWorkbook(wb = wb, file = file, overwrite = overwrite)
   3. wb$saveWorkbook()
   4. openxlsx:::write_file(...)
  
  ── 12. Error: Reading from new workbook cols/rows (@test-read_from_created_wb.R#
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, tempFile, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 13. Error: TRUE, FALSE, NA (@test-read_write_logicals.R#22)  ────────────────
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::write.xlsx(x, file = fileName, colNames = TRUE)
   2. openxlsx::saveWorkbook(wb = wb, file = file, overwrite = overwrite)
   3. wb$saveWorkbook()
   4. openxlsx:::write_file(...)
  
  ── 14. Error: Deleting worksheets (@test-remove_worksheets.R#39)  ──────────────
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, tempFile, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 15. Error: skip empty rows (@test-skip_empty_cols.R#15)  ────────────────────
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::write.xlsx(df, xlsxfile)
   2. openxlsx::saveWorkbook(wb = wb, file = file, overwrite = overwrite)
   3. wb$saveWorkbook()
   4. openxlsx:::write_file(...)
  
  ── 16. Error: skip empty rows (@test-skip_empty_rows.R#15)  ────────────────────
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::write.xlsx(df, xlsxfile)
   2. openxlsx::saveWorkbook(wb = wb, file = file, overwrite = overwrite)
   3. wb$saveWorkbook()
   4. openxlsx:::write_file(...)
  
  ── 17. Error: skip empty cols (@test-skip_empty_rows.R#67)  ────────────────────
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, file = xlsxfile)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 18. Error: Worksheet ordering from new Workbook (@test-worksheet_ordering.R#2
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, file = tempFile, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 19. Error: Worksheet ordering from new Workbook (@test-worksheet_ordering.R#2
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, tempFile, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 20. Error: Can rename worksheets under all conditions (@test-worksheet_renami
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, tempFile, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 21. Error: Write zero rows & columns (@test-write_data_to_sheetData.R#223)  ─
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb, tempFile, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 22. Error: Writing then reading returns identical data.frame 1 (@test-write_r
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::write.xlsx(df, file = fileName, overwrite = TRUE)
   2. openxlsx::saveWorkbook(wb = wb, file = file, overwrite = overwrite)
   3. wb$saveWorkbook()
   4. openxlsx:::write_file(...)
  
  ── 23. Error: Writing then reading returns identical data.frame 2 (@test-write_r
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::write.xlsx(dates, file = fileName, overwrite = TRUE)
   2. openxlsx::saveWorkbook(wb = wb, file = file, overwrite = overwrite)
   3. wb$saveWorkbook()
   4. openxlsx:::write_file(...)
  
  ── 24. Error: Writing then reading rowNames, colNames combinations (@test-write_
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::write.xlsx(...)
   2. openxlsx::saveWorkbook(wb = wb, file = file, overwrite = overwrite)
   3. wb$saveWorkbook()
   4. openxlsx:::write_file(...)
  
  ── 25. Error: Writing then reading returns identical data.frame 3 (@test-write_r
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::write.xlsx(df, file = fileName, overwrite = TRUE)
   2. openxlsx::saveWorkbook(wb = wb, file = file, overwrite = overwrite)
   3. wb$saveWorkbook()
   4. openxlsx:::write_file(...)
  
  ── 26. Error: Writing then reading returns identical data.frame 4 (@test-write_r
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::write.xlsx(x = df, file = tf, keepNA = TRUE)
   2. openxlsx::saveWorkbook(wb = wb, file = file, overwrite = overwrite)
   3. wb$saveWorkbook()
   4. openxlsx:::write_file(...)
  
  ── 27. Error: Special characters in sheet names (@test-write_read_equality.R#265
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::saveWorkbook(wb = wb, file = tf, overwrite = TRUE)
   2. wb$saveWorkbook()
   3. openxlsx:::write_file(...)
  
  ── 28. Error: Writing then reading returns identical data.frame 1 (@test-write_x
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::write.xlsx(...)
   2. openxlsx::saveWorkbook(wb = wb, file = file, overwrite = overwrite)
   3. wb$saveWorkbook()
   4. openxlsx:::write_file(...)
  
  ── 29. Error: Writing sheetData rows XML - iris (@test-writing_sheet_data.R#12) 
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::write.xlsx(iris, temp_file)
   2. openxlsx::saveWorkbook(wb = wb, file = file, overwrite = overwrite)
   3. wb$saveWorkbook()
   4. openxlsx:::write_file(...)
  
  ── 30. Error: Writing sheetData rows XML - mtcars (@test-writing_sheet_data.R#18
  WEIRD RETURN VALUE: (nil)
  Backtrace:
   1. openxlsx::write.xlsx(mtcars, temp_file, row.names = TRUE)
   2. openxlsx::saveWorkbook(wb = wb, file = file, overwrite = overwrite)
   3. wb$saveWorkbook()
   4. openxlsx:::write_file(...)
  
  ══ testthat results  ═══════════════════════════════════════════════════════════
  [ OK: 548 | SKIPPED: 1 | WARNINGS: 0 | FAILED: 30 ]
  1. Error: Workbook properties (@test-Workbook_properties.R#15) 
  2. Error: Save and load Table Deletion (@test-deleting_tables.R#146) 
  3. Error: Write read encoding equality (@test-encoding.R#19) 
  4. Error: fill merged cells (@test-fill_merged_cells.R#23) 
  5. Error: Reading from loaded workbook (@test-load_read_file_read_equality.R#19) 
  6. Error: Maintaining Named Regions on Load (@test-named_regions.R#34) 
  7. Error: Missing rows in named regions (@test-named_regions.R#191) 
  8. Error: Missing columns in named regions (@test-named_regions.R#267) 
  9. Error: Matching Substrings breaks reading named regions (@test-named_regions.R#310) 
  1. ...
  
  Error: testthat unit tests failed
  Execution halted