Hi Folks,
this is the case that happens nowadays almost every time with Calc and R because files and folders under C:\Program files are Read-only by default (by Windows). In this case, R (and RStudio) puts all packages under C:\Users\USERNAME... and Calc can not find them. Calc assumes that R packages are under Library folder in the same path where R is installed.
There are multiple solutions to fix this, until Calc programmer fixes this.
Solution 1) Right click C:\Program files\R and take a tag out from Read-only. Then reinstall all packages in R/Rstudio so that the target in the Library folder under that path.
Solution 2) Remove Read-only tag as above. Copy all installed R packages from C:\Users\USERNAME... to C:\Program files\R\R_VERSION\Library\ and start using Calc
Solution 3) Reinstall R under C:\Users\Public.. and reinstall all R packages. This is not a Read-only folder by default.
I strongly wish that this issue can be solved in Calc without these tricks by its users.
Cheers