| View previous topic :: View next topic |
| Author |
Message |
blackr2d
General User
Joined: 28 Sep 2004
Posts: 24
Location: Republic of Ireland
|
 Posted: Tue Mar 07, 2006 4:19 am Post subject: Strange behaviour of "-" sign in OO 2.0.1 possible |
 |
|
Hello and sorry if this was already addressed, but I couldn't find anything about it in the forums.
Problem:
When entering negative numbers into cells in Calc the "down arrow" button suddenly stops doing it's designed function (leave cell, move one down) and starts trying to add a reference to a field below like when entering a formula. Try yourself - enter any negative number, press "down" and instead of leaving the field it will start adding reference to another field.
I know that it's not really a show stopper as I can use the enter key and it will always do the job, but I got extremely used to leaving cells by "down" key and I'm having a really bad time making that mistake every second time even if I remember. 
As far as I can see it - it's a bug, but before I report it I would like others to share the view, maybe it's by design (although I doubt it - the "=" sign should trigger formula building alone).
Thanks in advance
Jack
_________________
Jack |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8979
Location: Lexinton, Kentucky, USA
|
| Posted: Tue Mar 07, 2006 5:22 am Post subject: |
|
|
| I'm not seeing this behavior. (OOo2.0.1 Win2K) |
|
| Back to top |
|
|
blackr2d
General User
Joined: 28 Sep 2004
Posts: 24
Location: Republic of Ireland
|
| Posted: Tue Mar 07, 2006 5:31 am Post subject: |
|
|
| JohnV wrote: | | I'm not seeing this behavior. (OOo2.0.1 Win2K) |
Oops, forgot to add that the system is Debian Sarge Linux.
Locale is set to EN_IE (English Ireland).
I've tried "EN_US" but the behaviour was the same.
This is interesting that 2.0.1 behaves different under Windows.
Jack
_________________
Jack |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Tue Mar 07, 2006 10:37 am Post subject: |
|
|
Can not confirm this odd behavior with Suse 9.1 and OOo2.0 . Did the debian packagers include a patch?.
http://www.openoffice.org/issues/show_bug.cgi?id=20496
There:-- Additional comments from mmeeks Wed Jul 20 00:39:20 -0800 2005 ---
Are you in formula-mode when you type a leading "+"?
Does input -1+2 return 1? |
|
| Back to top |
|
|
blackr2d
General User
Joined: 28 Sep 2004
Posts: 24
Location: Republic of Ireland
|
| Posted: Tue Mar 07, 2006 11:10 am Post subject: |
|
|
| Villeroy wrote: | Can not confirm this odd behavior with Suse 9.1 and OOo2.0 . Did the debian packagers include a patch?.
http://www.openoffice.org/issues/show_bug.cgi?id=20496
There:-- Additional comments from mmeeks Wed Jul 20 00:39:20 -0800 2005 ---
Are you in formula-mode when you type a leading "+"?
Does input -1+2 return 1? |
I confirmed that on Gentoo with OO 2.0.1.2 too.
Yes, "-1+2" returns "1" and when you come back to the cell it contains "=-1+2"
It seems somebody already included that change you've quoted in the link in 2.0.1
It's a pity they didn't leave it as an option to choose for the user, I can understand some reasoning behind that change, but I don't see why it should affect everybody permanently. I am sure I'm not the only one surprised and finding it difficult to accomodate to it.
Jack
_________________
Jack |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
blackr2d
General User
Joined: 28 Sep 2004
Posts: 24
Location: Republic of Ireland
|
| Posted: Tue Mar 07, 2006 12:21 pm Post subject: |
|
|
| Villeroy wrote: |
Please stop complaining about the wisdom of your packagers
|
Errmm... ok, I just pointed out that it would be nice if it was an option, judging from the discussions mentioned in fora quoted I am not the only one.
Thank you for your time and sorry if I annoyed anyone, I guess I will start getting used to avoiding using "down arrow".
Jack
_________________
Jack |
|
| Back to top |
|
|
strichards
Newbie
Joined: 31 Jul 2006
Posts: 1
|
| Posted: Mon Jul 31, 2006 6:41 am Post subject: |
|
|
Is there a bypass for this behavior ? I am running 2.02 and don't see one.
I really don't like having the +/- start a formula automatically.
Thanks,
Steve |
|
| Back to top |
|
|
|
