Bug 93125 - SHORTCUT: For fixed date Ctrl+; and fixed time Shift+Ctrl+; are not accesible on a Spanish keyboard, because ';' it's a shift key.
Summary: SHORTCUT: For fixed date Ctrl+; and fixed time Shift+Ctrl+; are not accesible...
Status: RESOLVED DUPLICATE of bug 88027
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.5.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-08-04 23:37 UTC by m_a_riosv
Modified: 2016-02-29 21:05 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description m_a_riosv 2015-08-04 23:37:15 UTC
As on Spanish keyboard ; is the shift key of ,
it's not accessible as short.

May be it happens in other keyboard layouts.
Comment 1 Buovjaga 2015-09-01 13:09:08 UTC
It is true for Finnish also, but I think this should be closed as WONTFIX, because if we go down this road and start changing default shortcuts, there will always be someone with a "less fortunate keyboard layout".
Comment 2 Buovjaga 2015-09-01 13:14:37 UTC
Btw. what is the shortcut for fixed date in Spanish Excel?
Ctrl+; for fixed date is apparently derived from Excel.
Comment 3 m_a_riosv 2015-09-01 20:15:48 UTC
I think the issue is restricted to some composed keys, in a quick look to custom keyboard options, like ";" "[" "]" could be affected.

I don't know what it is in Spanish excel, in 33 years working with spreadsheets, I have used excel only a few times.

I'm not talking about change default, but if was needed, why not, surely it wouldn't the first.

I think there are two ways that can go together:

- Add another shortcuts for problematic keys in the most common languages. There are a lot of unused combinations, I think not a problem having two combinations for the same.

- Localized, if I'm not wrong shortcuts are localized, so why not this one.

If it's not an issue for you, lucky you, but it doesn't mean the same for other people, I have seen a lot of times questions about how to introduce a fixed date in a cell.

BTW, how users know what is happening?, they can tried to use it, but it does nothing.

One of the main purpose it's make things as agreeable as possible to the USERS. so this doesn't look for me like a good election, there are millions of keyboards with non US layout, so it's important to maintain the respect by a plural world as much as possible.
Comment 4 GerardF 2015-09-02 06:44:58 UTC
(In reply to Beluga from comment #2)
> Btw. what is the shortcut for fixed date in Spanish Excel?
> Ctrl+; for fixed date is apparently derived from Excel.

I don't have Excel, nor a spanish keyboard, but a goo** search returns Ctrl+, (comma instead of semi-colon.
Comment 5 Buovjaga 2015-09-02 06:53:11 UTC
(In reply to GerardF from comment #4)
> (In reply to Beluga from comment #2)
> > Btw. what is the shortcut for fixed date in Spanish Excel?
> > Ctrl+; for fixed date is apparently derived from Excel.
> 
> I don't have Excel, nor a spanish keyboard, but a goo** search returns
> Ctrl+, (comma instead of semi-colon.

What is the source for this? I only found Ctrl+;

http://www.techrepublic.com/blog/microsoft-office/the-10-most-useful-excel-keyboard-shortcuts/
https://exceljet.net/keyboard-shortcuts/insert-current-date
http://www.lifehacker.com.au/2012/10/insert-todays-date-in-excel-with-a-handy-keyboard-shortcut/

Somehow I don't get hits to any official documentation :D
Comment 6 Buovjaga 2015-09-02 06:54:58 UTC
(In reply to Beluga from comment #5)
> (In reply to GerardF from comment #4)
> > (In reply to Beluga from comment #2)
> > > Btw. what is the shortcut for fixed date in Spanish Excel?
> > > Ctrl+; for fixed date is apparently derived from Excel.
> > 
> > I don't have Excel, nor a spanish keyboard, but a goo** search returns
> > Ctrl+, (comma instead of semi-colon.
> 
> What is the source for this? I only found Ctrl+;
> 
> http://www.techrepublic.com/blog/microsoft-office/the-10-most-useful-excel-
> keyboard-shortcuts/
> https://exceljet.net/keyboard-shortcuts/insert-current-date
> http://www.lifehacker.com.au/2012/10/insert-todays-date-in-excel-with-a-
> handy-keyboard-shortcut/
> 
> Somehow I don't get hits to any official documentation :D

Ok I found this referring to Spanish Excel: http://www.excelforum.com/excel-general/603675-excel-spanish-keyboard-shortcuts.html#post2901202

But it seems LibO shortcuts are not localized.
Comment 7 m_a_riosv 2016-02-29 11:28:01 UTC

*** This bug has been marked as a duplicate of bug 88027 ***
Comment 8 Yousuf Philips (jay) (retired) 2016-02-29 21:05:04 UTC
(In reply to Beluga from comment #6)
> Ok I found this referring to Spanish Excel:
> http://www.excelforum.com/excel-general/603675-excel-spanish-keyboard-
> shortcuts.html#post2901202
> 
> But it seems LibO shortcuts are not localized.

Some LO shortcuts are localized. Simple example Ctrl+A in en-US is for Select All, but in es it is for the Open dialog.