CRAN Package Check Results for Maintainer ‘Jan Marvin Garbuszus <jan.garbuszus at ruhr-uni-bochum.de>’

Last updated on 2026-01-17 03:52:30 CET.

Package	ERROR	NOTE	OK
openxlsx		2	11
openxlsx2	2	3	8

Package openxlsx

Current CRAN status: NOTE: 2, OK: 11

Version: 4.2.8.1
Check: installed package size
Result: NOTE installed size is 7.5Mb sub-directories of 1Mb or more: extdata 1.2Mb libs 5.1Mb Flavors: r-oldrel-macos-arm64, r-oldrel-macos-x86_64

Package openxlsx2

Current CRAN status: ERROR: 2, NOTE: 3, OK: 8

Additional issues

clang-UBSAN M1mac

Version: 1.23
Check: tests
Result: ERROR Running ‘testthat.R’ [311s/400s] Running the tests in ‘tests/testthat.R’ failed. Complete output: > library(testthat) > library(openxlsx2) > > test_check("openxlsx2") Saving _problems/test-wb_styles-1056.R Saving _problems/test-wb_styles-1062.R Saving _problems/test-wb_styles-1188.R Saving _problems/test-wb_styles-1267.R [ FAIL 4 | WARN 0 | SKIP 80 | PASS 2028 ] ══ Skipped tests (80) ══════════════════════════════════════════════════════════ • !file.exists("C:\\Program Files\\7-zip\\7z.exe") is TRUE (1): 'test-loading_workbook.R:583:3' • On CRAN (15): 'test-conditional_formatting.R:1390:3', 'test-conditional_formatting.R:1420:3', 'test-date_time_conversion.R:66:3', 'test-pugi_cpp.R:203:3', 'test-read_sources.R:3:3', 'test-read_sources.R:29:3', 'test-read_sources.R:197:3', 'test-read_sources.R:312:3', 'test-read_sources.R:517:3', 'test-read_xlsb.R:3:3', 'test-read_xlsb.R:24:3', 'test-read_xlsb.R:68:3', 'test-read_xlsb.R:169:3', 'test-read_xlsb.R:182:3', 'test-write.R:944:3' • Skip on CRAN (64): 'test-class-comment.R:63:3', 'test-class-workbook-wrappers.R:288:3', 'test-class-workbook.R:377:3', 'test-class-workbook.R:873:3', 'test-cloneWorksheet.R:8:3', 'test-cloneWorksheet.R:22:3', 'test-cloneWorksheet.R:113:3', 'test-cloneWorksheet.R:260:3', 'test-conditional_formatting.R:290:3', 'test-conditional_formatting.R:450:3', 'test-formulas.R:3:3', 'test-loading_workbook.R:4:3', 'test-loading_workbook.R:20:3', 'test-loading_workbook.R:46:3', 'test-loading_workbook.R:64:3', 'test-loading_workbook.R:156:3', 'test-loading_workbook.R:193:3', 'test-loading_workbook.R:294:3', 'test-loading_workbook.R:316:3', 'test-loading_workbook.R:347:3', 'test-loading_workbook.R:407:3', 'test-loading_workbook.R:418:3', 'test-loading_workbook.R:622:3', 'test-loading_workbook.R:648:3', 'test-loading_workbook_tables.R:4:3', 'test-named_regions.R:64:3', 'test-named_regions.R:124:3', 'test-read_sources.R:46:3', 'test-read_sources.R:57:3', 'test-read_sources.R:74:3', 'test-read_sources.R:82:3', 'test-read_sources.R:92:3', 'test-read_sources.R:143:3', 'test-read_sources.R:214:3', 'test-read_sources.R:232:3', 'test-read_sources.R:252:3', 'test-read_sources.R:274:3', 'test-read_sources.R:290:3', 'test-read_sources.R:334:3', 'test-read_sources.R:365:3', 'test-read_sources.R:375:3', 'test-read_sources.R:392:3', 'test-read_sources.R:401:3', 'test-read_sources.R:426:3', 'test-read_sources.R:485:3', 'test-read_sources.R:496:3', 'test-read_sources.R:505:3', 'test-read_sources.R:511:3', 'test-read_xlsb.R:132:3', 'test-read_xlsb.R:154:3', 'test-read_xlsx_correct_sheet.R:3:3', 'test-remove_worksheets.R:71:3', 'test-save.R:469:3', 'test-styles_xml.R:3:3', 'test-styles_xml.R:39:3', 'test-styles_xml.R:67:3', 'test-styles_xml.R:94:3', 'test-styles_xml.R:119:3', 'test-styles_xml.R:145:3', 'test-utils.R:510:3', 'test-wb_functions.R:5:3', 'test-wb_functions.R:139:3', 'test-write.R:148:3', 'test-write.R:184:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Failure ('test-wb_styles.R:1056:3'): date and time formatting works ───────── Expected `got` to be identical to "01:45:30 PM". Differences: `actual`: "01:45:30 pm" `expected`: "01:45:30 PM" ── Failure ('test-wb_styles.R:1062:3'): date and time formatting works ───────── Expected `got` to be identical to "01:45:30 PM". Differences: `actual`: "01:45:30 pm" `expected`: "01:45:30 PM" ── Failure ('test-wb_styles.R:1188:3'): special formatting works ─────────────── Expected `got` to be identical to "08:15:01 P". Differences: `actual`: "08:15:01 p" `expected`: "08:15:01 P" ── Failure ('test-wb_styles.R:1267:3'): apply_numfmts works ──────────────────── Expected `got` to equal `exp`. Differences: actual vs expected daily_time - actual[1, ] 08:30:00 am + expected[1, ] 08:30:00 AM - actual[2, ] 09:45:00 am + expected[2, ] 09:45:00 AM actual[3, ] NA - actual[4, ] 11:15:00 am + expected[4, ] 11:15:00 AM - actual[5, ] 12:00:00 pm + expected[5, ] 12:00:00 PM actual$daily_time | expected$daily_time [1] "08:30:00 am" - "08:30:00 AM" [1] [2] "09:45:00 am" - "09:45:00 AM" [2] [3] NA | NA [3] [4] "11:15:00 am" - "11:15:00 AM" [4] [5] "12:00:00 pm" - "12:00:00 PM" [5] [ FAIL 4 | WARN 0 | SKIP 80 | PASS 2028 ] Error: ! Test failures. Execution halted Flavor: r-devel-linux-x86_64-fedora-clang

Version: 1.23
Check: tests
Result: ERROR Running ‘testthat.R’ [6m/15m] Running the tests in ‘tests/testthat.R’ failed. Complete output: > library(testthat) > library(openxlsx2) > > test_check("openxlsx2") Saving _problems/test-wb_styles-1056.R Saving _problems/test-wb_styles-1062.R Saving _problems/test-wb_styles-1188.R Saving _problems/test-wb_styles-1267.R [ FAIL 4 | WARN 0 | SKIP 80 | PASS 2028 ] ══ Skipped tests (80) ══════════════════════════════════════════════════════════ • !file.exists("C:\\Program Files\\7-zip\\7z.exe") is TRUE (1): 'test-loading_workbook.R:583:3' • On CRAN (15): 'test-conditional_formatting.R:1390:3', 'test-conditional_formatting.R:1420:3', 'test-date_time_conversion.R:66:3', 'test-pugi_cpp.R:203:3', 'test-read_sources.R:3:3', 'test-read_sources.R:29:3', 'test-read_sources.R:197:3', 'test-read_sources.R:312:3', 'test-read_sources.R:517:3', 'test-read_xlsb.R:3:3', 'test-read_xlsb.R:24:3', 'test-read_xlsb.R:68:3', 'test-read_xlsb.R:169:3', 'test-read_xlsb.R:182:3', 'test-write.R:944:3' • Skip on CRAN (64): 'test-class-comment.R:63:3', 'test-class-workbook-wrappers.R:288:3', 'test-class-workbook.R:377:3', 'test-class-workbook.R:873:3', 'test-cloneWorksheet.R:8:3', 'test-cloneWorksheet.R:22:3', 'test-cloneWorksheet.R:113:3', 'test-cloneWorksheet.R:260:3', 'test-conditional_formatting.R:290:3', 'test-conditional_formatting.R:450:3', 'test-formulas.R:3:3', 'test-loading_workbook.R:4:3', 'test-loading_workbook.R:20:3', 'test-loading_workbook.R:46:3', 'test-loading_workbook.R:64:3', 'test-loading_workbook.R:156:3', 'test-loading_workbook.R:193:3', 'test-loading_workbook.R:294:3', 'test-loading_workbook.R:316:3', 'test-loading_workbook.R:347:3', 'test-loading_workbook.R:407:3', 'test-loading_workbook.R:418:3', 'test-loading_workbook.R:622:3', 'test-loading_workbook.R:648:3', 'test-loading_workbook_tables.R:4:3', 'test-named_regions.R:64:3', 'test-named_regions.R:124:3', 'test-read_sources.R:46:3', 'test-read_sources.R:57:3', 'test-read_sources.R:74:3', 'test-read_sources.R:82:3', 'test-read_sources.R:92:3', 'test-read_sources.R:143:3', 'test-read_sources.R:214:3', 'test-read_sources.R:232:3', 'test-read_sources.R:252:3', 'test-read_sources.R:274:3', 'test-read_sources.R:290:3', 'test-read_sources.R:334:3', 'test-read_sources.R:365:3', 'test-read_sources.R:375:3', 'test-read_sources.R:392:3', 'test-read_sources.R:401:3', 'test-read_sources.R:426:3', 'test-read_sources.R:485:3', 'test-read_sources.R:496:3', 'test-read_sources.R:505:3', 'test-read_sources.R:511:3', 'test-read_xlsb.R:132:3', 'test-read_xlsb.R:154:3', 'test-read_xlsx_correct_sheet.R:3:3', 'test-remove_worksheets.R:71:3', 'test-save.R:469:3', 'test-styles_xml.R:3:3', 'test-styles_xml.R:39:3', 'test-styles_xml.R:67:3', 'test-styles_xml.R:94:3', 'test-styles_xml.R:119:3', 'test-styles_xml.R:145:3', 'test-utils.R:510:3', 'test-wb_functions.R:5:3', 'test-wb_functions.R:139:3', 'test-write.R:148:3', 'test-write.R:184:3' ══ Failed tests ════════════════════════════════════════════════════════════════ ── Failure ('test-wb_styles.R:1056:3'): date and time formatting works ───────── Expected `got` to be identical to "01:45:30 PM". Differences: `actual`: "01:45:30 pm" `expected`: "01:45:30 PM" ── Failure ('test-wb_styles.R:1062:3'): date and time formatting works ───────── Expected `got` to be identical to "01:45:30 PM". Differences: `actual`: "01:45:30 pm" `expected`: "01:45:30 PM" ── Failure ('test-wb_styles.R:1188:3'): special formatting works ─────────────── Expected `got` to be identical to "08:15:01 P". Differences: `actual`: "08:15:01 p" `expected`: "08:15:01 P" ── Failure ('test-wb_styles.R:1267:3'): apply_numfmts works ──────────────────── Expected `got` to equal `exp`. Differences: actual vs expected daily_time - actual[1, ] 08:30:00 am + expected[1, ] 08:30:00 AM - actual[2, ] 09:45:00 am + expected[2, ] 09:45:00 AM actual[3, ] NA - actual[4, ] 11:15:00 am + expected[4, ] 11:15:00 AM - actual[5, ] 12:00:00 pm + expected[5, ] 12:00:00 PM actual$daily_time | expected$daily_time [1] "08:30:00 am" - "08:30:00 AM" [1] [2] "09:45:00 am" - "09:45:00 AM" [2] [3] NA | NA [3] [4] "11:15:00 am" - "11:15:00 AM" [4] [5] "12:00:00 pm" - "12:00:00 PM" [5] [ FAIL 4 | WARN 0 | SKIP 80 | PASS 2028 ] Error: ! Test failures. Execution halted Flavor: r-devel-linux-x86_64-fedora-gcc

Version: 1.23
Check: installed package size
Result: NOTE installed size is 13.4Mb sub-directories of 1Mb or more: R 2.0Mb libs 9.0Mb Flavors: r-oldrel-macos-arm64, r-oldrel-macos-x86_64

Version: 1.22
Check: installed package size
Result: NOTE installed size is 5.2Mb sub-directories of 1Mb or more: R 1.1Mb libs 1.7Mb Flavor: r-oldrel-windows-x86_64