readWorkbook fillMergedCells = T is not working

hjia222 commented 4 years ago

Expected Behavior

  plate rows                   col1                   col2
1     1    A       Std 1 (30 ng/mL)       Std 1 (30 ng/mL)
2     1    B       Std 2 (15 ng/mL)       Std 2 (15 ng/mL)
3     1    C      Std 3 (7.5 ng/mL)      Std 3 (7.5 ng/mL)
4     1    D     Std 4 (3.75 ng/mL)     Std 4 (3.75 ng/mL)
5     1    E    Std 5 (1.875 ng/mL)    Std 5 (1.875 ng/mL)
6     1    F   Std 6 (0.9375 ng/mL)   Std 6 (0.9375 ng/mL)
7     1    G  Std 7 (0.46875 ng/mL)  Std 7 (0.46875 ng/mL)
8     1    H Std 8 (0.234375 ng/mL) Std 8 (0.234375 ng/mL)

Actual Behavior

  plate rows                   col1 col2
1     1    A       Std 1 (30 ng/mL)   NA
2     1    B       Std 2 (15 ng/mL)   NA
3     1    C      Std 3 (7.5 ng/mL)   NA
4     1    D     Std 4 (3.75 ng/mL)   NA
5     1    E    Std 5 (1.875 ng/mL)   NA
6     1    F   Std 6 (0.9375 ng/mL)   NA
7     1    G  Std 7 (0.46875 ng/mL)   NA
8     1    H Std 8 (0.234375 ng/mL)   NA

Steps to Reproduce the Problem

mergedCell.xlsx

library(openxlsx)
file = "mergedCell.xlsx"
wb <- openxlsx::loadWorkbook(file)
openxlsx::readWorkbook(wb, sheet = 1, cols = 1:4, fillMergedCells = T)

sessionInfo()

R version 3.6.1 (2019-07-05)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Ubuntu 18.04.3 LTS

Matrix products: default
BLAS:   /usr/lib/x86_64-linux-gnu/openblas/libblas.so.3
LAPACK: /usr/lib/x86_64-linux-gnu/libopenblasp-r0.2.20.so

locale:
 [1] LC_CTYPE=en_US.UTF-8       LC_NUMERIC=C               LC_TIME=en_US.UTF-8        LC_COLLATE=en_US.UTF-8     LC_MONETARY=en_US.UTF-8   
 [6] LC_MESSAGES=en_US.UTF-8    LC_PAPER=en_US.UTF-8       LC_NAME=C                  LC_ADDRESS=C               LC_TELEPHONE=C            
[11] LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C       

attached base packages:
[1] grid      tools     stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
 [1] tidyselect_0.2.5      purrr_0.3.2           shinytoastr_2.1.1     magrittr_1.5          forcats_0.4.0         RColorBrewer_1.1-2    shinyAce_0.4.1       
 [8] shinyBS_0.61          rhandsontable_0.3.7   shinydashboarq_1.0.1  plotly_4.9.0          rlang_0.4.1           shinycssloaders_0.2.0 shinyWidgets_0.4.9   
[15] rmarkdown_1.16        knitr_1.25            openxlsx_4.1.0.1      stringr_1.4.0         scales_1.0.0          ggplot2_3.2.1         tidyr_1.0.0          
[22] dbplyr_1.4.2          dplyr_0.8.3           readxl_1.3.1          plyr_1.8.4            DT_0.9.2              shinyjs_1.0           operators_0.1-8      
[29] sofa_0.3.2.9100       shiny_1.4.0           jsonlite_1.6          plumber_0.4.7.9000   

loaded via a namespace (and not attached):
 [1] fs_1.3.1            usethis_1.5.1       devtools_2.2.1      httr_1.4.1          rprojroot_1.3-2     backports_1.1.5     utf8_1.1.4         
 [8] R6_2.4.0            DBI_1.0.0           lazyeval_0.2.2      colorspace_1.4-1    withr_2.1.2         prettyunits_1.0.2   processx_3.4.1     
[15] curl_4.2            compiler_3.6.1      cli_1.1.0           formatR_1.7         Cairo_1.5-10        desc_1.2.0          callr_3.3.2        
[22] digest_0.6.22       pkgconfig_2.0.3     htmltools_0.4.0     sessioninfo_1.1.1   fastmap_1.0.1       htmlwidgets_1.5.1   rstudioapi_0.10    
[29] httpcode_0.2.0      crosstalk_1.0.0     zip_2.0.4           Rcpp_1.0.2          munsell_0.5.0       fansi_0.4.0         lifecycle_0.1.0    
[36] stringi_1.4.3       yaml_2.2.0          pkgbuild_1.0.6      promises_1.1.0.9000 crayon_1.3.4        miniUI_0.1.1.1      addinexamples_0.1.0
[43] zeallot_0.1.0       ps_1.3.0            pillar_1.4.2        pkgload_1.0.2       crul_0.8.4          glue_1.3.1          packrat_0.5.0      
[50] evaluate_0.14       remotes_2.1.0       data.table_1.12.4   vctrs_0.2.0         httpuv_1.5.2.9000   testthat_2.2.1      cellranger_1.1.0   
[57] gtable_0.3.0        assertthat_0.2.1    xfun_0.10           mime_0.7            xtable_1.8-4        later_1.0.0         viridisLite_0.3.0  
[64] tibble_2.1.3        memoise_1.1.0       ellipsis_0.3.0

Version of openxlsx: 4.1.1
Version of R: 3.6.1

ycphs commented 4 years ago

Hi,

That is the old repository for this R Package.

Please use the new one:

https://github.com/ycphs/openxlsx

Skepe commented 3 years ago

The example from above does not work on my computer (R 4.05, openxlsx 4.2.3) library(openxlsx) file = "mergedCell.xlsx" wb <- openxlsx::loadWorkbook(file) openxlsx::readWorkbook(wb, sheet = 1, cols = 1:4, fillMergedCells = T)

but

library(openxlsx) file = "mergedCell.xlsx" openxlsx::readWorkbook(file, sheet = 1, cols = 1:4, fillMergedCells = T)

works.

awalker89 / openxlsx