Ask Your Question

Calc function predictive type and autocomplete [closed]

asked 2015-05-02 14:41:43 +0100

Indirectcell gravatar image

updated 2020-07-19 19:42:24 +0100

Alex Kemp gravatar image

I have figured out that enter is the equal to tab from ms excel.

Im just wondering if its possible to move it from enter to tab button as the movement when writeing formulas feels unnatural for me after years of useing excel.

Also the same whit the comma signs, is it possible to replace them whit ; or : ?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-19 19:42:34.027136

2 Answers

Sort by » oldest newest most voted

answered 2015-05-02 18:36:26 +0100

m.a.riosv gravatar image

The place in relation with separators is: Menu/Tools/Options/LibreOffice calc/Formula - Separators.

edit flag offensive delete link more

answered 2015-05-02 15:41:58 +0100

Rugslug gravatar image

The Enter button movement from cell to cell is configurable. With a Calc Spreadsheet Open, Under Tools, Options, Click + for Libreoffice Calc, General, Under Input Settings, the first choice is for the Enter Button. See the picture.

Tab will still move horizontally.

image description

For the comma signs, they may be language or region dependent. I don't think they are configurable in LO. Perhaps if your decimal point in your Operating System is a comma, the formula separator may switch to a ;

You may also be able to type in a ; but it will be replaced by a comma.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-05-02 14:41:43 +0100

Seen: 1,027 times

Last updated: May 02 '15