First forzen column (firstActiveCol = 2) becomes the entire dataframe itself mirrored.

Expected Behavior

First column frozen

Actual Behavior

First column becomes the entire dataframe itself (yes)

Open file

Now Scroll right in the first column:

firstActiveRow or firstRow works no problem
firstActiveCol or firstCol both seem broken (or maybe its a feature :-D)

Steps to Reproduce the Problem

(Cant post the file. Will eventually create a dummy)

  openxlsx::write.xlsx(x = named_list, file = FnP, rowNames = 1
                       , firstActiveRow = 2
                       , firstActiveCol = 2
                       , headerStyle = hs, tabColour = TabColor
                       , colWidths = "auto")

sessionInfo()

Version of openxlsx: openxlsx_4.2.5.2
Version of R: 4.3.1

> sessionInfo()
R version 4.3.1 (2023-06-16)
Platform: x86_64-apple-darwin20 (64-bit)
Running under: macOS Ventura 13.5.2

Matrix products: default
BLAS:   /System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.framework/Versions/A/libBLAS.dylib 
LAPACK: /Library/Frameworks/R.framework/Versions/4.3-x86_64/Resources/lib/libRlapack.dylib;  LAPACK version 3.11.0

locale:
[1] en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8

time zone: Europe/Vienna
tzcode source: internal

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

other attached packages:
 [1] openxlsx_4.2.5.2 lubridate_1.9.2  forcats_1.0.0    stringr_1.5.1    dplyr_1.1.3      purrr_1.0.2      readr_2.1.4     
 [8] tidyr_1.3.0      tibble_3.2.1     ggplot2_3.4.4    tidyverse_2.0.0  clipr_0.8.0      Stringendo_0.3.8 ReadWriter_0.3.3
[15] colorout_1.2-2  

loaded via a namespace (and not attached):
 [1] writexl_1.4.2         tidyselect_1.2.0      fastmap_1.1.1         promises_1.2.1        digest_0.6.33        
 [6] timechange_0.2.0      mime_0.12             lifecycle_1.0.4       ellipsis_0.3.2        processx_3.8.2       
[11] gdata_2.19.0          magrittr_2.0.3        compiler_4.3.1        rlang_1.1.2           tools_4.3.1          
[16] utf8_1.2.4            knitr_1.45            prettyunits_1.2.0     htmlwidgets_1.6.2     pkgbuild_1.4.2       
[21] plyr_1.8.8            xml2_1.3.5            pkgload_1.3.3         miniUI_0.1.1.1        withr_2.5.2          
[26] desc_1.4.2            grid_4.3.1            fansi_1.0.5           roxygen2_7.2.3        urlchecker_1.0.1     
[31] profvis_0.3.8         colorspace_2.1-0      xtable_1.8-4          scales_1.2.1          gtools_3.9.4         
[36] cli_3.6.1             crayon_1.5.2          generics_0.1.3        remotes_2.4.2.1       rstudioapi_0.15.0    
[41] tzdb_0.4.0            commonmark_1.9.0      sessioninfo_1.2.2     readxl_1.4.3          cachem_1.0.8         
[46] cellranger_1.1.0      vctrs_0.6.4           devtools_2.4.5        callr_3.7.3           hms_1.1.3            
[51] testthat_3.2.0        glue_1.6.2            ps_1.7.5              stringi_1.8.1         gtable_0.3.4         
[56] CodeAndRoll2_2.5.2    later_1.3.1           munsell_0.5.0         pillar_1.9.0          htmltools_0.5.7      
[61] brio_1.1.3            MarkdownHelpers_0.2.2 R6_2.5.1              rprojroot_2.0.4       shiny_1.8.0          
[66] memoise_2.0.1         httpuv_1.6.12         Rcpp_1.0.11           zip_2.3.0             xfun_0.41            
[71] fs_1.6.3              usethis_2.2.2         pkgconfig_2.0.3      
>

awalker89 / openxlsx

First forzen column (firstActiveCol = 2) becomes the entire dataframe itself mirrored. #551

Expected Behavior

Actual Behavior

Steps to Reproduce the Problem

sessionInfo()