Hi,
I have always been using mainly Quattro Pro, for some years I am shifting to LibreOffice Calc.
I have some minor, but very regular irritations. I guess mainly because old habits die hard.
But perhaps they are easy to fix, or I have some settings wrong?
- When I enter a text in a cell, and I see a mistake, I want to go Left with the left arrow key.
- LO enters the cell and moves to the cell to the left.
- QPW moves IN the text so I can correct it. Much easier.
Same with control-Left for jumping to the previous word.
(This does not happen when I press F2 first)
- When entering a value in a cell, for example I type “12” and enter
Both QPW and LO recognise this as a number, and it can be used for calculations.
Then I want to add to that number (or divide it, etc): F2 , “+20” , enter
- QPW knows it is a number, sees it as a formula 12+20 and shows 32 .
Still a number, available for calculations - LO changes the number to text, and then shows “12+20”,
It does not calculate with it anymore.
Why is that?
I have to manually add “=” before the 12, so it will see it as a formula and add those two numbers
I cannot believe it is standard practice to always type ‘=’ or ‘+’ before a number ?
Any tips?