Ask Your Question

desk calculator behavior [closed]

asked 2013-02-09 15:16:25 +0100

Ton gravatar image


Is there a way that you can enter numbers in Calc cells the same way you are used to do on a desk calculator? Example : entering 123.45+55.25 in a cell does not work. You have to put a "=" in front of it, which is so unnatural that I always forget it. Back in 1990 I worked with a program called Supercalc and the beauty was that it could auto recognize if you were entering numbers or text in a cell... Pherhaps this could also made available for LibrOffice?

Thank you!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-21 15:26:31.781851

2 Answers

Sort by » oldest newest most voted

answered 2013-02-09 16:30:17 +0100

horst gravatar image

updated 2013-02-09 16:48:45 +0100

Yes you are right. I am also used to this from Lotus 123.

If you start the formula with "+" or "-" then CALC inserts the = by itself. I think the best solution because "=" is not on the calculator keypad.

Have to find out if this is a bug or we have to file an enhencement bug.


It is not a bug, it is the right behavior. NOT filing an enhancement because:

If you enter 12/3+Enter you get 12/3/2013 a date or in your case you want the result 4.

It will be difficult for the Algorithm to decide if an entry is a formula or a date or text.

edit flag offensive delete link more


@horst - thanks for the hint with "+" at the beginning. This makes Calc quite a good desktop calculator!

ROSt52 gravatar imageROSt52 ( 2013-02-27 07:29:56 +0100 )edit

answered 2013-02-09 20:22:45 +0100

Ton gravatar image

Thanks for the answer.

In Supercalc 12/3 gives 4. If you wanted a date instead, then you just typed the command TODAY (present) or DATE(mm,yy,dd) in the cell. Easy and logic, since with that TODAY/DAY command you could also made calculations. Maybe it is still worth to reconsider the algorithm in LibreOffice.

edit flag offensive delete link more


It is always a question how many user want one or the other functinality. BTW Excel has the same behavior.

horst gravatar imagehorst ( 2013-02-09 22:16:44 +0100 )edit

Hi @Ton, if you're still interested in promoting this for LO (perhaps as a mode that can be enabled?) please file an enhancement bug and provide as much information as possible. Please post a link to any bugs you file in a comment below.

qubit gravatar imagequbit ( 2013-02-27 04:50:26 +0100 )edit

Question Tools


Asked: 2013-02-09 15:16:25 +0100

Seen: 87 times

Last updated: Feb 09 '13