[Libreoffice] Calc usability improvements

2010-11-11 Thread Patrick Bakker
Having grown very used to Excel defaults I find Calc very annoying to use. Now that contributing to LibreOffice looks sane I'm curious how receptive people would be to some patches for the following Calc conventions... SEMI-COLON INSTEAD OF COMMA AS FUNCTION ARGUMENT SEPARATOR Current Calc behavi

Re: [Libreoffice] Calc usability improvements

2010-11-11 Thread Kevin Hunter
At 8:21pm -0500 Thu, 11 Nov 2010, Patrick Bakker wrote: SEMI-COLON INSTEAD OF COMMA AS FUNCTION ARGUMENT SEPARATOR Current Calc behaviour: =subtotal(9;a1:a5) Desired behaviour: =subtotal(9,a1:a5) I believe OpenOffice has supported both semicolon and comma since at least 3.0. Take a look at

Re: [Libreoffice] Calc usability improvements

2010-11-11 Thread Patrick Bakker
On Thu, Nov 11, 2010 at 9:31 PM, Kevin Hunter wrote: > At 8:21pm -0500 Thu, 11 Nov 2010, Patrick Bakker wrote: >> >> SEMI-COLON INSTEAD OF COMMA AS FUNCTION ARGUMENT SEPARATOR >> >> Current Calc behaviour: >> =subtotal(9;a1:a5) >> >> Desired behaviour: >> =subtotal(9,a1:a5) > > I believe OpenOffic

Re: [Libreoffice] Calc usability improvements

2010-11-12 Thread Michael Meeks
Hi Patrick, On Thu, 2010-11-11 at 23:30 -0800, Patrick Bakker wrote: > >> SEMI-COLON INSTEAD OF COMMA AS FUNCTION ARGUMENT SEPARATOR Kohei (or was it Jody) fixed this many moons ago; I believe the default is set to improve usability here in LibreOffice; I too fell over this as my first st

Re: [Libreoffice] Calc usability improvements

2010-11-12 Thread Sebastian Spaeth
On Fri, 12 Nov 2010 10:32:04 +, Michael Meeks wrote: > > > - Shift+Del permanently removes the file right then. > > Which makes me wonder; should shift-del give you this 'delete contents' > option in that mode (or is the menu sufficient). Yes, that is how I would expect it. del doing th

Re: [Libreoffice] Calc usability improvements

2010-11-12 Thread Kevin Hunter
At 5:32am -0500 Fri, 12 Nov 2010, Michael Meeks wrote: On Thu, 2010-11-11 at 23:30 -0800, Patrick Bakker wrote: SEMI-COLON INSTEAD OF COMMA AS FUNCTION ARGUMENT SEPARATOR Kohei (or was it Jody) fixed this many moons ago; I believe the default is set to improve usability here in LibreOffice; I

Re: [Libreoffice] Calc usability improvements

2010-11-12 Thread Kevin Hunter
At 5:32am -0500 Fri, 12 Nov 2010, Michael Meeks wrote: On Thu, 2010-11-11 at 23:30 -0800, Patrick Bakker wrote: DELETE CELL "HELPER" The delete cell "helper" dialog box pops up anytime I try to delete a cell or cell selection. It gives me options to delete some And this is deadly annoying too

Re: [Libreoffice] Calc usability improvements

2010-11-12 Thread Kevin Hunter
At 5:32am -0500 Fri, 12 Nov 2010, Michael Meeks wrote: Might be a good easy-hack; how we tell the user in an unobtrusive way that this has happened, I don't know - some good UI ideas there appreciated; the 'status bar' is not such a great plan I suspect for this. "alpha transparent, hovering noti

Re: [Libreoffice] Calc usability improvements

2010-11-12 Thread Kohei Yoshida
On Fri, 2010-11-12 at 10:32 +, Michael Meeks wrote: > Hi Patrick, > > On Thu, 2010-11-11 at 23:30 -0800, Patrick Bakker wrote: > > >> SEMI-COLON INSTEAD OF COMMA AS FUNCTION ARGUMENT SEPARATOR > > Kohei (or was it Jody) fixed this many moons ago; I believe the default > is set to improv

Re: [Libreoffice] Calc usability improvements

2010-11-12 Thread Kohei Yoshida
On Fri, 2010-11-12 at 07:22 -0500, Kevin Hunter wrote: > Do you know roughly when? I could have sworn it was 3.0, but perhaps > that was because of out-of-band patches from the *nix distros I was > using at the time. I would say 2.4 or 3.0, and it was only in Go-OO, which most Linux distros pa

Re: [Libreoffice] Calc usability improvements

2010-11-12 Thread Rolf Gloor
Am 12.11.2010 11:32, schrieb Michael Meeks: Kohei (or was it Jody) fixed this many moons ago; I believe the default is set to improve usability here in LibreOffice; I too fell over this as my first step using calc (as an en_US user). Of course - our patch 'fixes' this only for locales wh

Re: [Libreoffice] Calc usability improvements

2010-11-12 Thread Kohei Yoshida
Hi Kevin, On Fri, 2010-11-12 at 07:55 -0500, Kevin Hunter wrote: > This leads to a perhaps bigger thought process of generally all our > shortcuts and actions. Is there a list somewhere? Or are these > piecemeal throughout the code? I do see Tools->Customize, which begins > to address the k

Re: [Libreoffice] Calc usability improvements

2010-11-12 Thread Kohei Yoshida
On Fri, 2010-11-12 at 15:08 +0100, Rolf Gloor wrote: > Am 12.11.2010 11:32, schrieb Michael Meeks: > > > Kohei (or was it Jody) fixed this many moons ago; I believe the default > > is set to improve usability here in LibreOffice; I too fell over this as > > my first step using calc (as an en_U

Re: [Libreoffice] Calc usability improvements

2010-11-12 Thread Cor Nouws
Patrick Bakker wrote (12-11-10 02:21) DELETE CELL "HELPER" The delete cell "helper" dialog box pops up anytime I try to delete a cell or cell selection. It gives me options to delete some combination of text / numbers / date& time / formulas / notes / formats / objects. Occassionally this is u

Re: [Libreoffice] Calc usability improvements

2010-11-12 Thread Cor Nouws
Michael Meeks wrote (12-11-10 11:32) COPY& PASTE TO A CELL WITH AN EXISTING VALUE I wonder if switching the polarity of the check-box - so it is checked might help people 'see' it, and thus un-check it to get rid of it (some Mozilla dialogs do that I guess ?). Best suggestion I have

Re: [Libreoffice] Calc usability improvements

2010-11-12 Thread Kohei Yoshida
On Sat, 2010-11-13 at 02:06 +0100, Cor Nouws wrote: > Default OOo: > Backspace = delete without options > Dell = delete with options > > Default LibreOffice: the other way round. > > Maybe this setting is included in the 'Compatibility options' ? Sure is. :-) Allow me to refer to this blog

Re: [Libreoffice] Calc usability improvements

2010-11-13 Thread Cor Nouws
Kohei Yoshida wrote (13-11-10 04:14) On Sat, 2010-11-13 at 02:06 +0100, Cor Nouws wrote: Default OOo: Backspace = delete without options Dell = delete with options Default LibreOffice: the other way round. Maybe this setting is included in the 'Compatibility options' ? Sure is. :-) Al

Re: [Libreoffice] Calc usability improvements

2010-11-13 Thread Kevin Hunter
At 7:57am -0500 Fri, 12 Nov 2010, Kevin Hunter wrote: At 5:32am -0500 Fri, 12 Nov 2010, Michael Meeks wrote: I wonder if switching the polarity of the check-box - so it is checked might help people 'see' it, and thus un-check it to get rid of it (some Mozilla dialogs do that I guess ?). Switch

Re: [Libreoffice] Calc usability improvements

2010-11-15 Thread Kohei Yoshida
On Thu, 2010-11-11 at 17:21 -0800, Patrick Bakker wrote: > COPY & PASTE TO A CELL WITH AN EXISTING VALUE > > The first time I copy and pasted a cell formula into another cell > which already had something in it a dialog came up asking something > like "This cell already has a value. Are you sure y

Re: [Libreoffice] Calc usability improvements

2010-11-15 Thread Kevin Hunter
At 9:47am -0500 Mon, 15 Nov 2010, Kohei Yoshida wrote: On Thu, 2010-11-11 at 17:21 -0800, Patrick Bakker wrote: COPY& PASTE TO A CELL WITH AN EXISTING VALUE The first time I copy and pasted a cell formula into another cell which already had something in it a dialog came up asking something lik

Re: [Libreoffice] Calc usability improvements

2010-11-15 Thread Drew Jensen
On Mon, 2010-11-15 at 09:47 -0500, Kohei Yoshida wrote: > 2) change the polarity of the current dialog so that the user > *unchecks* > the check box to dismiss future popups of the dialog, or Hi folks, Have been reading along quietly. +1 for that solution. Best wishes, Drew __

Re: [Libreoffice] Calc usability improvements

2010-11-15 Thread Kohei Yoshida
Hello Santiago, On Mon, 2010-11-15 at 16:04 -0300, Santiago Bosio wrote: > El 15/11/10 11:47, Kohei Yoshida escribió: > > So, just to summarize this thread, we have three possible options for > > this: > > > > 1) no changes, > > 2) change the polarity of the current dialog so that the user *unche

Re: [Libreoffice] Calc usability improvements

2010-11-15 Thread Kohei Yoshida
On Mon, 2010-11-15 at 09:47 -0500, Kohei Yoshida wrote: > If so, I'd say let's make this change on the > master branch. Ok, done on master. Testing appreciated. Kohei -- Kohei Yoshida, LibreOffice hacker, Calc ___ LibreOffice mailing list LibreOff

Re: [Libreoffice] Calc usability improvements

2010-11-15 Thread Kohei Yoshida
On Mon, 2010-11-15 at 16:06 -0500, Kohei Yoshida wrote: > On Mon, 2010-11-15 at 09:47 -0500, Kohei Yoshida wrote: > > If so, I'd say let's make this change on the > > master branch. > > Ok, done on master. Testing appreciated. One implementation note. I've implemented this by making changes to