Last updated on 2026-05-13 05:52:29 CEST.
| Flavor | Version | Tinstall | Tcheck | Ttotal | Status | Flags |
|---|---|---|---|---|---|---|
| r-devel-linux-x86_64-debian-clang | 1.2.1 | 34.74 | 26.18 | 60.92 | OK | |
| r-devel-linux-x86_64-debian-gcc | 1.2.1 | 49.49 | 22.08 | 71.57 | ERROR | |
| r-devel-linux-x86_64-fedora-clang | 1.2.1 | 46.00 | 39.71 | 85.71 | OK | |
| r-devel-linux-x86_64-fedora-gcc | 1.2.1 | 76.00 | 37.22 | 113.22 | OK | |
| r-devel-windows-x86_64 | 1.2.1 | 38.00 | 61.00 | 99.00 | OK | |
| r-patched-linux-x86_64 | 1.2.1 | 37.59 | 24.20 | 61.79 | OK | |
| r-release-linux-x86_64 | 1.2.1 | 36.45 | 24.26 | 60.71 | OK | |
| r-release-macos-arm64 | 1.2.1 | 7.00 | 7.00 | 14.00 | OK | |
| r-release-macos-x86_64 | 1.2.1 | 20.00 | 26.00 | 46.00 | OK | |
| r-release-windows-x86_64 | 1.2.1 | 42.00 | 71.00 | 113.00 | OK | |
| r-oldrel-macos-arm64 | 1.2.1 | OK | ||||
| r-oldrel-macos-x86_64 | 1.2.1 | 19.00 | 20.00 | 39.00 | OK | |
| r-oldrel-windows-x86_64 | 1.2.1 | 43.00 | 74.00 | 117.00 | OK |
Version: 1.2.1
Check: tests
Result: ERROR
Running ‘coerce.R’ [0s/1s]
Running ‘encoding.R’ [0s/1s]
Running ‘escape.R’ [0s/1s]
Running ‘geometry.R’ [0s/1s]
Running ‘types.R’ [0s/1s]
Running the tests in ‘tests/coerce.R’ failed.
Complete output:
> library(SheetReader)
> options(stringsAsFactors = FALSE)
> data <- read_xlsx(system.file("extdata", "multi-test.xlsx", package = "SheetReader"), sheet="coerce", col_types=c("text", "numeric", "numeric", "date", "date", "logical", "numeric", "numeric"))
> base_date <- as.POSIXct("1900-01-01", "UTC")
> date1 <- as.POSIXct("2021-01-01", "UTC")
> date2 <- as.POSIXct("2020-04-01 13:37", "UTC")
> compare <- function(x, y) {
+ (length(x) == length(y)) && all((x == y) | (if(all(is.numeric(x))) (abs(x - y) < 0.0001) else FALSE) | (is.na(x) & is.na(y)))
+ }
> stopifnot(colnames(data) == c("Text", "Integer", "Real", "Date", "DateTime", "Boolean", "Formula", "Error", "Blank"))
> stopifnot(compare(data[, "Text"], c("Blabla", NA, "#REF!", "14", "1", "43922.567361111112", "44197", "-234.72389999999999", "29384723")))
> stopifnot(compare(data[, "Integer"], c(29384723, NA, NA, NA, 14, 1, 43922.5674, 44197, -234.7239)))
> stopifnot(compare(data[, "Real"], c(-234.7239, 29384723, NA, NA, NA, 14, 1, 43922.5674, 44197)))
> # for dates here: 1 == base_date so we have to subtract 1; then due to excel stuff if <61 add +1
> stopifnot(compare(data[, "Date"], c(date1, base_date + ((-234.7239 - 1) * 86400), base_date + ((29384723 - 2) * 86400), NA, NA, NA, base_date + ((14 - 1) * 86400), base_date + ((1 - 1) * 86400), date2)))
> stopifnot(compare(data[, "DateTime"], c(date2, date1, base_date + ((-234.7239 - 1) * 86400), base_date + ((29384723 - 2) * 86400), NA, NA, NA, base_date + ((14 - 1) * 86400), base_date + ((1 - 1) * 86400))))
> stopifnot(compare(data[, "Boolean"], c(TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, NA, FALSE, TRUE)))
Error: compare(data[, "Boolean"], c(TRUE, TRUE, TRUE, FALSE, TRUE, FALSE, .... is not TRUE
Execution halted
Flavor: r-devel-linux-x86_64-debian-gcc