possible mistake in the getting started guide

Hi @all,

as you might know, the German team is in the process of translating the user guides. While doing this, we found the following text in the getting started guide, in the Calc chapter:

Using selection lists

Selection lists are available only for text, and are limited to using only text that has already been entered in the same column. To use a selection list, select a blank cell and press Ctrl+D. A drop-down list appears of any cell in the same column that either has at least one text character or whose format is defined as Text. Click on the entry you require.

With Version 3.3.3, the key combination is Ctrl+Shift+D for the mentioned selection list. With 3.4.1 neither combination (Ctrl+D and Ctrl+Shift+D) has any effect at all. You might want to check with your versions as well and maybe correct the documentation - if not done already.

Sigrid

Oh, I forgot something:
With 3.4.1:
Go to Tools > Options > LibreOffice Calc > compatibility
Change the settings for the shortcuts from "default" to "OpenOffice.org compatible".
Then Ctrl+D will work. With the default-setting, the key combination has no effect. This might be worth mentioning within the user guides.

Sigrid

Sigrid Carrera schrieb:

With Version 3.3.3, the key combination is Ctrl+Shift+D for the
mentioned selection list. With 3.4.1 neither combination (Ctrl+D and
Ctrl+Shift+D) has any effect at all.

Hi,

the new combination is <alt+arrowdown>, at least for the German UI. For me that seems not userfriendly (2 hands required), additionally it's not mentioned in German LOCALHELP.

The LOCALHELP tex for <alt+arrowdown>, <alt+arrowup> seems to be wrong, it should decrease increase row height due to Help text, but it does not.

<alt+arrowleft> / <alt+arrowright> dercrease / increase column width as I read in LOCALHELP.

Can someone check, maybe file a bug report (and add me to CC, if he wants)?

Kind regards

Rainer

Hello Rainer,

Sigrid Carrera schrieb:

>
> With Version 3.3.3, the key combination is Ctrl+Shift+D for the
> mentioned selection list. With 3.4.1 neither combination (Ctrl+D and
> Ctrl+Shift+D) has any effect at all.

Hi,

the new combination is <alt+arrowdown>, at least for the German UI. For
me that seems not userfriendly (2 hands required), additionally it's not
mentioned in German LOCALHELP.

The LOCALHELP tex for <alt+arrowdown>, <alt+arrowup> seems to be wrong,
it should decrease increase row height due to Help text, but it does not.

<alt+arrowleft> / <alt+arrowright> dercrease / increase column width as
I read in LOCALHELP.

Can someone check, maybe file a bug report (and add me to CC, if he wants)?

I've opened a bug report:
https://bugs.freedesktop.org/show_bug.cgi?id=39137

But, after opening the bugreport I read another mail from Nino, where he says, that after changing to the "OpenOffice.org compatible" mode (you'll find this under tools > options > LibO Calc > compatibility) the key combination with Ctrl+D works for the selection list.

In a blog post, Kohei Yoshida, the developer who implemented this feature, mentioned a few more key bindings that change with this setting:
Delete
Backspace
Ctrl+D
Ctrl+Shift+D

see: http://kohei.us/2010/10/15/key-binding-compatibility-options-take-2/

But he also mentions, that this list might be growing over time.

Sigrid

Sigrid Carrera schrieb:

I've opened a bug report:
https://bugs.freedesktop.org/show_bug.cgi?id=39137

Hello,

thank you, I'll take that!

CU

Rainer

Hi :slight_smile:
There is often an Alt key to the right as well as the left of the space-bar.
The Alt-Gr key is slightly different from the normal Alt key but often does the
same thing. It's still not easy with 1 hand. A bit of a pianists stretch even
using a thumb and that's only if the Alt-Gr key does the same thing in this
case.
Regards from
Tom :slight_smile: