olivier7121

Thanks for the quick reply, @JanMarvin. Yes, that's what I did: I called `mergeCells` and then applied a centering style with `addStyle`. My proposal (and it was just an enhancement...

Thanks for the quick reply, @JanMarvin. I tried with the line you recommended: `remotes::install_github("ycphs/openxlsx", lib = "G:/Programmation/R/R-4.2.1/library", ref = "development")` Now my R session uses the version 4.2.5.1 of `openxlsx`....

It doesn't work on my computer with Windows 10 and Excel 2007. Your link is dead. No, data validation lists already existed in Excel 2007 (and most likely already before...

Hi @JanMarvin. > Though data validation lists are a feature introduced with Office 2010 (it requires internally: "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main" (that's just some xml namespace to be evaluated by excel) which makes...

Yes, I noticed from your posting times that your night had probably been quite short^^ > Could you by any chance copy the content of the header of `sheet1.xml` or...

Hi @JanMarvin. Oh yes, you're right, my mistake, apologies for that. Here you are: https://gist.github.com/olivier7121/d4804f52131c6963aa159a197fca069e [EDIT]: Just updated the gist file. Now it should be OK.

> Follow up question regarding the Excel behavior you're seeing. Is there a warning that the file has newer features or does it open silently and the list selection is...

Thanks for the quick reply, @JanMarvin. Your assumption is right: I didn't want the font color to be modified. I wanted exactly the same behaviour as the one we get...