[Libreoffice-ux-advise] calc background colors ...

Hi guys,

        Trawling negative user comments (as we ought to to try to improve ;-) I
saw this:

        http://news.slashdot.org/comments.pl?sid=2671075&cid=39034649


        "Well, they're obviously moving much faster than openoffice did.
         The product looks very clean, opens fast, and is mostly
         enjoyable to use."

        "There's still a number of key combinations that Calc is missing
         (most noticeably ctrl-D to copy cell above), and the background
         color tool is still horribly designed (only contains colors too
         dark for use as a background, and it does not remember the last
         chosen color). It's simple stuff like this that keeps people on
         Excel."

        Which makes me wonder ... what we can do about this ? :-) do we need a
custom palette for calc cell backgrounds ? that has many more pastel
shades, or something (?) Since we ship a number of palettes - is there
one that artists / Excel users would prefer instead - that we could
default to for calc ?

        Thoughts on a postcard ;-)

        ATB,

                Michael.

--
[hidden email]  <><, Pseudo Engineer, itinerant idiot

_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

On Wed, 2012-02-15 at 16:06 +0000, Michael Meeks wrote:
You mean fill down via Ctrl-D?  That's been the default key binding
since 3.3....

> and the background
> color tool is still horribly designed (only contains colors too
> dark for use as a background, and it does not remember the last
> chosen color).

Not sure about the colors being too dark.  Someone should look into that
for sure.

But haven't we recently landed a patch that implements the
remember-the-last-color functionality?

> It's simple stuff like this that keeps people on
> Excel."

Obviously some of his claims have been addressed.

> Which makes me wonder ... what we can do about this ? :-)

Ask him to try out 3.5 would be my first choice.  I'm sure he'll come up
with a whole load of new reasons to stay on Excel (which is to be
expected; that's what users do). :-)

As for the color palette issue, I don't have a strong opinion so I'll
stay away from making any feedback on that one.

Kohei

--
Kohei Yoshida, LibreOffice hacker, Calc

_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

On Wed, 2012-02-15 at 11:16 -0500, Kohei Yoshida wrote:
Ah, he means just copy the value of the cell above when that cell above
is *not* the top cell in the selection i.e.

1. Put a value in cell A1.
2. Move the cursor to A2.
3. Ctrl-D to copy the value of A1 into A2.

Excel appears to do this only when a single cell is selected, so it's a
very limited case it should be trivially easy to implement it, I think.

Kohei

_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

On Wed, 2012-02-15 at 11:16 -0500, Kohei Yoshida wrote:
> > "There's still a number of key combinations that Calc is missing
> > (most noticeably ctrl-D to copy cell above),
>
> You mean fill down via Ctrl-D?  That's been the default key binding
> since 3.3....

        Doesn't work for me. I enter 23 in A1, move to A2, ctrl-d - no effect.
I'd expect that A2 to turn into '23' when I do that - is that what you
get ? [ I'm using master ].

> As for the color palette issue, I don't have a strong opinion so I'll
> stay away from making any feedback on that one.

        Heh :-) to me they are too dark as well - but just checking for advice
here ;-)

        ATB,

                Michael.

--
[hidden email]  <><, Pseudo Engineer, itinerant idiot

_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Cell A1 and A2 has to be selected and A2 has the curor. Then it works.

Em 15-02-2012 15:04, Michael Meeks escreveu:
- --
Olivier Hallot
Founder, Board of Directors Member - The Document Foundation
LibreOffice translation leader for Brazilian Portuguese
+55-21-8822-8812
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJPO+awAAoJEJp3R7nH3vLxDqoH/1diXet33lmMnQwbTgwzWvFB
n3RBMjO+m1WnNfJYs2VHnfqx2Zh7X8hOAVCddSh4tc+p7nevAby4AOU+yv5gghFw
tjc43D3gj5lOvh9AdorgfffCZm1um4cpwJpyN66EUrpeSrlVx0TgcGBc3I/r3GsP
mlsTBl/g6/H4NFuuI8jvXD7sKGPQFBsTEUcECop0v8DNcFxjBINghzgFSx9EquD4
FyZ/HUcQCmu6Q7suXZfHlEwOtlET2qzsj++054255aQE8HfDaQ1u8GmT4pMpVtD1
NfmkRmOhVc8dFdeu1QPGfePt8yIJNfkhGbUGrI2YSeU+HIUcdNnJINFgbRY4etU=
=161L
-----END PGP SIGNATURE-----
_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

On Wed, 2012-02-15 at 11:29 -0500, Kohei Yoshida wrote:
>
> Excel appears to do this only when a single cell is selected, so it's
> a very limited case it should be trivially easy to implement it, I
> think.

Implemented on master.

http://cgit.freedesktop.org/libreoffice/core/commit/?id=ab0096ed68cdc08906f518d3499a8e1afc5ba80c

Turns out that you could also select multiple cells and copy multiple
cells down in one step i.e. select A2:B2 and ctrl-D to copy A1:B1 down.
I've implemented that as well.

The same applies for the other 3 directions.

Kohei

--
Kohei Yoshida, LibreOffice hacker, Calc

_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

On Wed, 2012-02-15 at 11:16 -0500, Kohei Yoshida wrote:
> > and the background
> >        color tool is still horribly designed (only contains colors
> too
> >        dark for use as a background, and it does not remember the
> last
> >        chosen color).

> But haven't we recently landed a patch that implements the
> remember-the-last-color functionality?

Yup.  We have.  This one is already implemented on master as well.

So, the only issue still remaining is the color palette.

Kohei

--
Kohei Yoshida, LibreOffice hacker, Calc

_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

Kohei Yoshida wrote (15-02-12 17:29)
> 1. Put a value in cell A1.
> 2. Move the cursor to A2.
> 3. Ctrl-D to copy the value of A1 into A2.

For me this never worked in Calc ..

--
  - Cor
  - http://nl.libreoffice.org

_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

Kohei Yoshida wrote (15-02-12 17:16)

> But haven't we recently landed a patch that implements the
> remember-the-last-color functionality?

Winfried Donkers works on some of those. Don't know any details right away.

--
  - Cor
  - http://nl.libreoffice.org

_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

Olivier Hallot wrote (15-02-12 18:09)

> Cell A1 and A2 has to be selected and A2 has the curor. Then it works.

 From what I remember (long time ago) that was not needed in Excell

--
  - Cor
  - http://nl.libreoffice.org

_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

On Wed, 2012-02-15 at 21:24 +0100, Cor Nouws wrote:
> Kohei Yoshida wrote (15-02-12 17:29)
> > 1. Put a value in cell A1.
> > 2. Move the cursor to A2.
> > 3. Ctrl-D to copy the value of A1 into A2.
>
> For me this never worked in Calc ..

Note I said:

Excel appears to do this only when a single cell is selected, so it's a
very limited case it should be trivially easy to implement it, I think.

in my post you didn't quote, which implies that it was not yet
implemented.

--
Kohei Yoshida, LibreOffice hacker, Calc

_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

Kohei Yoshida wrote (15-02-12 17:16)
>> and the background
>> color tool is still horribly designed (only contains colors too
>> dark for use as a background, and it does not remember the last
>> chosen color).
>
> Not sure about the colors being too dark.  Someone should look into that
> for sure.

IIRC, Christoph (et all) had done some initial work on the colors?

--
  - Cor
  - http://nl.libreoffice.org

_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

Þann mið 15.feb 2012 20:34, skrifaði Cor Nouws:
One rant worth reading is here:

<http://jefsblog.wordpress.com/2011/10/22/redesigning-libreoffices-color-system/>

The guy has interesting points IMHO.

Regards

Sveinn í Felli

_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

On Wed, 2012-02-15 at 14:12 -0500, Kohei Yoshida wrote:
> Implemented on master.
>
> http://cgit.freedesktop.org/libreoffice/core/commit/?id=ab0096ed68cdc08906f518d3499a8e1afc5ba80c

        Oooh ! pretty :-)

        Thanks for that Kohei ! :-)

        Sorry to distract you from the next round of heavy lifting, I added it
to:

        https://wiki.documentfoundation.org/ReleaseNotes/3.6#Calc

        for you,

        All the best,

                Michael.

--
[hidden email]  <><, Pseudo Engineer, itinerant idiot

_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise