Ask Your Question

Calc function predictive type and autocomplete

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

Indirectcell 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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 669 times

Last updated: May 02 '15