error with R directory when starting calc

  • Asked
  • Active
  • Viewed 4318 times
0

Hello, When we start Calc it does not go to the home screen but instead it says "R executable directory must contain valid R executable file". When we put the directory in line it does not accept it. What are we doing wrong? Calc Version: 2.1 R Version: 3.4.3 Thanks

0

Accepted answer

Did you put a valid directory? Note it should be the full path of where r.exe is located.

Also, make sure you install R in a folder without space.

E.g. C:\opt\R\R.3.3.1\bin

Thank you

Mino

0

Accepted answer

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

Your answer

Markdown text. Shortcuts: Ctrl+B bold, Ctrl+I italic, Ctrl+K link, Ctrl+E code, Ctrl+Shift+V paste as plain text. Tab indents list items and code; press Escape, then Tab, to leave the text box.

Insert an image

Say what the image shows, for people who can't see it.

Menu

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.