search

awalker89 / openxlsx

R package for .xlsx file reading and writing.
Other
363 stars 79 forks source link

All sheets' gridlines are hidden if the first one is. #503

Open javierdiegofk opened 4 years ago

javierdiegofk commented 4 years ago

Expected Behavior

A workbook with the first sheet with hidden gridlines and the second sheet showing them.

Actual Behavior

A workbook with both the first and the second sheets with hidden gridlines.

Steps to Reproduce the Problem

A (somewhat) minimal working example that reproduces the bug:

library(openxlsx)
wb <- createWorkbook("Alternating")
addWorksheet(wb, "Sheet 1", gridLines = FALSE)
addWorksheet(wb, "Sheet 2") # gridLines = TRUE as default
saveWorkbook(wb, "~/Downloads/Alternating.xlsx", overwrite = TRUE)

Even if more worksheets are added to the workbook with TRUE as an argument for GridLines, all of them appear with hidden gridlines.

sessionInfo()

I'm using a clean conda environment with R version 3.6.1 and openxlsx version 4.1.3 on a Ubuntu 18.04.3 LTS machine:

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

Matrix products: default
BLAS/LAPACK: /home/diegofernandezj/anaconda3/envs/r_3.6.1/lib/R/lib/libRblas.so

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

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

other attached packages:
 [1] lubridate_1.7.4       magrittr_1.5          data.table_1.12.2     openxlsx_4.1.3       
 [5] AzureStor_2.1.1       uuid_0.1-2            kantarADAuth_0.1.2    shinycssloaders_0.2.0
 [9] shinyjs_1.0           readxl_1.3.1          shiny_1.3.2           TrendAIUploader_0.1.0

loaded via a namespace (and not attached):
 [1] zip_2.0.4        Rcpp_1.0.1       compiler_3.6.1   cellranger_1.1.0 later_0.8.0      AzureRMR_2.2.0  
 [7] bitops_1.0-6     tools_3.6.1      digest_0.6.18    jsonlite_1.6     anytime_0.3.6    rlang_0.4.1     
[13] AzureAuth_1.2.2  curl_3.3         yaml_2.2.0       httr_1.4.0       stringr_1.4.0    askpass_1.0     
[19] rappdirs_0.3.1   glue_1.3.1       R6_2.4.0         promises_1.0.1   htmltools_0.3.6  mime_0.6        
[25] jose_1.0         xtable_1.8-4     httpuv_1.5.1     stringi_1.4.3    RCurl_1.95-4.12  openssl_1.3
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