Description: On pc Debian x86-64, shortcuts are: Ctrl+; for insert current date (it works) Ctrl+Shift+; for insert current time (it doesn't work) Steps to Reproduce: 1. Launch Calc 2. Try Ctrl+Shift; Actual Results: Nothing happens Expected Results: Either Ctrl+Shift; should insert current time Reproducible: Always User Profile Reset: No Additional Info: See French Keyboard layout here: https://en.wikipedia.org/wiki/AZERTY#/media/File:KB_France.svg In French: " Pour insérer l’heure actuelle, appuyez sur Ctrl+Maj+; (point-virgule). Pour insérer la date actuelle, appuyez sur Ctrl+; (point-virgule). " from: https://support.office.com/fr-fr/article/ins%C3%A9rer-la-date-et-l-heure-actuelles-dans-une-cellule-b5663451-10b0-40ab-9e71-6b0ce5768138
Argh, it seems https://support.office.com/fr-fr/article/ins%C3%A9rer-la-date-et-l-heure-actuelles-dans-une-cellule-b5663451-10b0-40ab-9e71-6b0ce5768138 is a wrong translation. Perhaps insert current time is Ctrl + : in Excel. see https://www.blogdumoderateur.com/raccourcis-clavier-excel/ or Ctrl + , see https://www.formuleexcel.com/74-raccourcis-clavier-pour-excel/ Sophie/Jean-Baptiste: if one of you has Excel, could you give it a try? What's the shortcut to insert current time with French keyboard layout? (I can only test at my job where I got Excel and I'm in vacation)
If I add this line: <value xml:lang="fr">.uno:InsertCurrentDate</value> in COMMA_SHIFT_MOD1 block from officecfg/registry/data/org/openoffice/Office/Accelerators.xcu see (https://opengrok.libreoffice.org/xref/core/officecfg/registry/data/org/openoffice/Office/Accelerators.xcu?r=ef5133e4#1209), I can type: Ctrl+shift+, and it inserts the current time If I add this same line in SEMICOLON_SHIFT_MOD1 (and whereas this shortcut already exists according to Options/Customize/keys but don't know how), it doesn't work.
There is a long thread about in tdf#12888, tdf#126085, tdf88027. The issue happens with all languages where the ';' is the uppercase of the key. Seems to me this is a dup of tdf88027
(In reply to Julien Nabet from comment #1) > Argh, it seems > https://support.office.com/fr-fr/article/ins%C3%A9rer-la-date-et-l-heure- > actuelles-dans-une-cellule-b5663451-10b0-40ab-9e71-6b0ce5768138 is a wrong > translation. > > Perhaps insert current time is Ctrl + : in Excel. > see https://www.blogdumoderateur.com/raccourcis-clavier-excel/ > or Ctrl + , > see https://www.formuleexcel.com/74-raccourcis-clavier-pour-excel/ > > Sophie/Jean-Baptiste: if one of you has Excel, could you give it a try? > What's the shortcut to insert current time with French keyboard layout? > (I can only test at my job where I got Excel and I'm in vacation) Office 365, French UI : Time is inserted with Ctrl+:
Also, I don't know if it's important but (in Excel) after inserting date or time with Ctrl+; or Ctrl+: the cell is in "edit mode".
I noticed it doesn't work with gtk3 and gen renderings but with kf5 rendering it worked! Ctrl+; => insert current date Ctrl+Shift+; => insert current time
(In reply to GerardF from comment #5) > Also, I don't know if it's important but (in Excel) after inserting date or > time with Ctrl+; or Ctrl+: the cell is in "edit mode". So the shorcut to insert current time is "Ctrl+:" in Excel ? (with French UI and French keyboard layout) and not Ctrl+Shift+; ?
(In reply to Julien Nabet from comment #7) > (In reply to GerardF from comment #5) > > Also, I don't know if it's important but (in Excel) after inserting date or > > time with Ctrl+; or Ctrl+: the cell is in "edit mode". > > So the shorcut to insert current time is "Ctrl+:" in Excel ? (with French UI > and French keyboard layout) and not Ctrl+Shift+; ? Ok I just saw you previous comment.
Heiko/Xisco/Eike: in French, if we want to copycat to Excel, it seems we should add "Ctrl+:" for insertCurrentTime, ok for this? Eike: KEY_COLON isn't defined in offapi/com/sun/star/awt/Key.idl (see https://opengrok.libreoffice.org/xref/core/offapi/com/sun/star/awt/Key.idl?r=9c0d40fb), should we just add it?
On a German keyboard I cannot use ctrl+; as it requires the shift key - thus only time works for me. You can assign localized shortcuts to the uno commands, so the default remains. And no objection to allow customization per colon. Better keyboard customization is needed, see bug 115052. One of the GSoC ideas is about that (sounds like a huge effort to me). Additionally, my preferred solution are extensions, see bug 123768. I would close the referenced Estonian, Russian, German etc. tickets as duplicates, or this one.
(In reply to Julien Nabet from comment #6) > I noticed it doesn't work with gtk3 and gen renderings but with kf5 > rendering it worked! > Ctrl+; => insert current date > Ctrl+Shift+; => insert current time On Win10 with master sources updated today + French locale, these shortcuts work. Idem for LO 6.3.4.2 on Win10.
It doesn't work for me on Win 10, with Spanish keyboard layout. Version: 6.5.0.0.alpha0+ (x64) Build ID: c97f9af5e47ea234ad709a1f66c1e8ed20640066 CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: GL; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: threaded I don't know how it can work without change the shortcut, at least on Spanish layout, semicolon it's the capital of comma, so can't be reached with [ctrlç;]
(In reply to m.a.riosv from comment #12) > ... > I don't know how it can work without change the shortcut, at least on > Spanish layout, semicolon it's the capital of comma, so can't be reached > with [ctrlç;] Here's French keyboard: http://xahlee.info/kbd/french_keyboard_layout.html No need to use "Shift" to access ";" and ":" On the contrary, if I believe https://commons.wikimedia.org/wiki/File:KB_Spanish.svg, with Spanish keyboard, you need "Shift" for both.
Right(In reply to Julien Nabet from comment #13) > On the contrary, if I believe > https://commons.wikimedia.org/wiki/File:KB_Spanish.svg, with Spanish > keyboard, you need "Shift" for both. For the second [Ctrl+Shift+;] works as expected, the issue is with [Ctrl+;] there is no way to reach it.
Caolán: any idea why it would work with kf5 not with gtk3 or gen rendering? I tried to retrieve a bt when it was ok on kf5 but it doesn't help. It doesn't show where the event comes from.
I don't see it working with kf5 locally when I set my keyboard map to fr AZERTY, but GetKeyCode in vcl/qt5/Qt5Widget.cxx is probably the place to examine to see what key on the keyboard is considered pressed by the kf5 stuff Another thing you can do here is at XMLBasedAcceleratorConfiguration::getCommandByKeyEvent add... fprintf(stderr, "pressed %s\n", lcl_getKeyString(aKeyEvent).toUtf8().getStr()); and press the key combo and see what shows up here. My understanding is that (under gtk3/gen at least) on your french keyboard it will say POINT_MOD1 for ctrl+: IIRC because we try do a mapping back of the "unknown" key that produced the : back to what key is at the same position in qwerty layout (vcl/unx/gtk3/gtk3gtkframe.cxx at the fdo#41169 comment)
(In reply to Caolán McNamara from comment #16) > ... > > Another thing you can do here is at > XMLBasedAcceleratorConfiguration::getCommandByKeyEvent > add... > fprintf(stderr, "pressed %s\n", > lcl_getKeyString(aKeyEvent).toUtf8().getStr()); > and press the key combo and see what shows up here. > > My understanding is that (under gtk3/gen at least) on your french keyboard > it will say POINT_MOD1 for ctrl+: IIRC because we try do a mapping back of > the "unknown" key that produced the : back to what key is at the same > position in qwerty layout (vcl/unx/gtk3/gtk3gtkframe.cxx at the fdo#41169 > comment) Ctrl + ";" gives SEMICOLON_MOD1 and Ctrl + Shift + ";" gives POINT_SHIFT_MOD1 With Ctrl + ":", I got an assertion: #5 0x00007fffdd8a42e0 in rtl::OUString::copy(int, int) const (this=0x7fffffff0fc0, beginIndex=4, count=-3) at /home/julien/lo/libreoffice/include/rtl/ustring.hxx:2256 #6 0x00007fffdd8a4280 in rtl::OUString::copy(int) const (this=0x7fffffff0fc0, beginIndex=4) at /home/julien/lo/libreoffice/include/rtl/ustring.hxx:2238 #7 0x00007fffdd89a37a in framework::lcl_getKeyString(com::sun::star::awt::KeyEvent const&) (aKeyEvent=...) at /home/julien/lo/libreoffice/framework/source/accelerators/acceleratorconfiguration.cxx:66 #8 0x00007fffdd89a84f in framework::XMLBasedAcceleratorConfiguration::getCommandByKeyEvent(com::sun::star::awt::KeyEvent const&) (this=0x5555584c8e40, aKeyEvent=...) at /home/julien/lo/libreoffice/framework/source/accelerators/acceleratorconfiguration.cxx:102 #9 0x00007ffff2ace010 in svt::AcceleratorExecute::impl_ts_findCommand(com::sun::star::awt::KeyEvent const&) (this=0x555558986680, aKey=...) at /home/julien/lo/libreoffice/svtools/source/misc/acceleratorexecute.cxx:263 #10 0x00007ffff2acda5d in svt::AcceleratorExecute::execute(com::sun::star::awt::KeyEvent const&) (this=0x555558986680, aAWTKey=...) at /home/julien/lo/libreoffice/svtools/source/misc/acceleratorexecute.cxx:174 #11 0x00007ffff2acd9ca in svt::AcceleratorExecute::execute(vcl::KeyCode const&) (this=0x555558986680, aVCLKey=...) at /home/julien/lo/libreoffice/svtools/source/misc/acceleratorexecute.cxx:168 #12 0x00007ffff5afc0e0 in SfxViewShell::ExecKey_Impl(KeyEvent const&) (this=0x5555585ae0a0, aKey=...) at /home/julien/lo/libreoffice/sfx2/source/view/viewsh.cxx:1443
Caolán: there are 2 parts 1) Ctrl + shift + ";" doesn't work 2) ":" so COLON isn't declared and it seems it should: see https://bugs.documentfoundation.org/show_bug.cgi?id=129547#c9 (I'm waiting for Eike's feedback here since I got UX ok from Heiko).
In French keyboard (see https://en.wikipedia.org/wiki/AZERTY#/media/File:KB_France.svg) we got "," and "?" (maj part) on the same key. and we have ";" and "." (maj part) on the same key When I do: Ctrl + "," => COMMA_MOD1 (expected) Ctrl + Shift "," => COMMA_SHIFT_MOD1 (why not) Ctrl + ";" => SEMICOLON_MOD1 (expected) Ctrl + Shift + ";" => POINT_SHIFT_MOD1 There are 2 incompatible logical mechanisms here. Either we should have in first part QUESTION_SHIFT_MOD1 (I don't know if "?" is mapped and if "QUESTION" is the right mapping) or we should have : SEMICOLON_SHIFT_MOD1
I just noticed that with US keyboard layout, maj/shift of ";" corresponds to ":" (the one which should perhaps be declared) so perhaps everything is related here in a way.
"With Ctrl + ":", I got an assertion:", was that with all backends, or just gtk3 ? wrt adding COLON as a key, presumably that on its own won't do anything ? Unless we detect that the COLON key is pressed in our various vcl-plugs and backends and transport that information around. And I don't think that's as trivial as it might appear on the surface.
(In reply to Caolán McNamara from comment #21) > "With Ctrl + ":", I got an assertion:", was that with all backends, or just > gtk3 ? > > wrt adding COLON as a key, presumably that on its own won't do anything ? > Unless we detect that the COLON key is pressed in our various vcl-plugs and > backends and transport that information around. And I don't think that's as > trivial as it might appear on the surface. Yes I sent an email to Eike with lo-dev forum in cc here: http://document-foundation-mail-archive.969070.n3.nabble.com/About-tdf-129547-and-adding-COLON-td4272064.html I thought about submitting a patch containing not only the add of a new code in offapi/com/sun/star/awt/Key.idl but of course, I would have mimicked SEMICOLON/COMMA uses so the new key would have been used (so impact in vcl-plugs indeed).
As replied on the mailing list, I don't see why COLON should not be added, similar to SEMICOLON. Be sure to catch all relevant places where something has to be added to pass things around. So for time Ctrl+: it would be COLON_MOD1 if I'm not mistaken.
(In reply to Eike Rathke from comment #23) > As replied on the mailing list, I don't see why COLON should not be added, > similar to SEMICOLON. Be sure to catch all relevant places where something > has to be added to pass things around. > > So for time Ctrl+: it would be COLON_MOD1 if I'm not mistaken. Thank you for your feedback. I submitted this patch https://gerrit.libreoffice.org/c/core/+/86713 on gerrit. I'll take a look at the result from the different Jenkins since the patch contains lines for Macos, Win and Linux. If it's ok, I'd submit another patch to declare the ":" shortcut for French localization.
Same problem for Italian keyboard layout
*** Bug 130073 has been marked as a duplicate of this bug. ***
*** This bug has been marked as a duplicate of bug 126085 ***
On pc Debian x86-64 with master sources updated today, it still fails Ctrl + : or Ctrl + Shift + ; doesn't insert time.
(In reply to Julien Nabet from comment #28) > On pc Debian x86-64 with master sources updated today, it still fails > > Ctrl + : > or Ctrl + Shift + ; doesn't insert time. Precision: i tried with a brand new LO profile + French UI
(In reply to Valter Mura from comment #26) > *** Bug 130073 has been marked as a duplicate of this bug. *** (In reply to Heiko Tietze from comment #27) > > *** This bug has been marked as a duplicate of bug 126085 *** Unlike Italian and German layouts, French does have a semicolon key (according to Wikipedia, anyway). So those two bugs are not related to this one.
*** Bug 139960 has been marked as a duplicate of this bug. ***
*** Bug 154136 has been marked as a duplicate of this bug. ***
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e056c1ce10779b42ae17866913cf4db06b86a491 Related tdf#129547 and tdf#154136: add COLON key It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
The goal of the patch was just to declare KEY_COLON, it seems it improved the situation for macOS but at least for Linux, it still doesn't work.
I've submitted a patch here: https://gerrit.libreoffice.org/c/core/+/148903 As I commented in the patch, this one concerns only French UI with azerty keyboard. IMHO the patch should be ok for French people but feel free to comment if we can improve it and make "insert time" command work for other UI with other keyboard layout.
Just for the record, I tested the patch with gtk3, gen and kf5 rendering, it worked (still for French UI with azerty).
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/fcbf416dffdc8a9fbbbc41c07bfb4929a14c7099 tdf#129547: Ctrl-":" to insert time in Calc for French UI with azerty It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Fixed in master branch for French UI/azerty. Now perhaps bugtrackers which were considered as dup but concerned other languages should be reopened? If we want to stick to shortcuts on Excel, it seems we can't trust Microsoft website, it was at least the case for French UI. Now reading about German UI, I see: https://support.microsoft.com/de-de/office/einf%C3%BCgen-des-aktuellen-datums-und-der-uhrzeit-in-eine-zelle-b5663451-10b0-40ab-9e71-6b0ce5768138 " Wenn Sie das aktuelle Datum einfügen möchten, drücken Sie STRG+; (Semikolon). Wenn Sie die aktuelle Uhrzeit einfügen möchten, drücken Sie STRG+UMSCHALT+; (Semikolon)." On https://www.traens.com/tipps/microsoft/datum-uhrzeit-excel.html, I see: "Drücken Sie STRG + . (Strg und Punkt)." for date "Drücken Sie STRG+UMSCHALT+. (Strg, Umschalt, Punkt)" for time. So which combination is right?
(In reply to Julien Nabet from comment #38) > So which combination is right? Clearly MS is (mostly) a plain translation from English in its official document. German keyboards have their colon and semicolon keys located on the "top"/"upper" area of their respective keys, i.e. [SHIFT] (or its German equivalent, if you'd like) is required. In Spanish (and similar, for Latin-American countries) the key combinations are supposed to be (currently still failing in Calc by default): _ [CTRL]+[,] (comma) instead of the English [CTRL]+[;] (semicolon) _ [CTRL]+[SHIFT]+[.] (stop/period) instead of the English [CTRL]+[:] (colon) In generic typing (e.g. in Writer) with Spanish and ES-latam keyboards: _ [SHIFT]+[,] equals [;] _ [SHIFT]+[.] equals [:] Using the same principle for other layouts, it should be a simple logic to deduce the correct keyboard combination for each. https://en.wikipedia.org/wiki/Keyboard_layout
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-7-5": https://git.libreoffice.org/core/commit/a9f718eaf505148f0ffd0994b8aa5e4e0d1dac11 Related tdf#129547 and tdf#154136: add COLON key It will be available in 7.5.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/936f2e6924e405433770b98f32a615508fd0670d fix crash seen when experimenting with tdf#129547 It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-7-5": https://git.libreoffice.org/core/commit/98465ee3f987c43bdb0a615ca81ffbbac6bf479f fix crash seen when experimenting with tdf#129547 It will be available in 7.5.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-7-5-2": https://git.libreoffice.org/core/commit/6ea328bc2d3700059d77b110c7825f995ef6c5b3 fix crash seen when experimenting with tdf#129547 It will be available in 7.5.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/6896c12ddeb00210629396046678bc1d83d45644 Related tdf#129547: add Excel shortcuts insert time/date in Calc for German UI It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
(In reply to Commit Notification from comment #44) > Julien Nabet committed a patch related to this issue. > It has been pushed to "master": > > https://git.libreoffice.org/core/commit/ > 6896c12ddeb00210629396046678bc1d83d45644 > ... I don't have a German keyboard to try it and don't know if we can trust virtual German keyboard from gtk. Moreover, the patch itself is quite unexpected. (details in comments here: https://gerrit.libreoffice.org/c/core/+/148931) So the goal is some German people (with a German keyboard) give it a try with a daily build and provide some feedback. If the patch doesn't work, it will be reverted obviously. If it's ok, it means I can trust virtual keyboard from gtk and try to fix the pb for some other languages.
I installed LibreOffice 7.5.2.2 on my MacBook Air, tested Shift+Cmd+; again with the inbuilt AZERTY keyboard -> still doesn't work.
(In reply to Alexander Van den Panhuysen from comment #46) > I installed LibreOffice 7.5.2.2 on my MacBook Air, tested Shift+Cmd+; again > with the inbuilt AZERTY keyboard -> still doesn't work. The patch will be in a master (so future 7.6.0) daily build in 24/48 hours (see https://dev-builds.libreoffice.org/daily/master/)
<node oor:name="COLON_SHIFT_MOD1" oor:op="replace"> <node oor:name="POINT_MOD1" oor:op="replace"> The colon is on the German keyboard shift+. so any combination is not working. Tested with master and neither ctrl+. nor shift+ctrl+. has any effect, which is surprising for the second InsertCurrentDate command. Switched all language/locale settings to German/Deutsch. No success.
It is clear to me that timestamp with Shift+Cmd+; never works because Shift+Cmd+; is assigned to Spelling ! See Tools -> Customize, select tab Keyboard and then scroll down until you see Shift+Cmd+; .
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a135a182c38083511563009fc1c370e36c546d84 Revert "Related tdf#129547: add Excel shortcuts insert time/date in Calc for German UI" It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
(In reply to Heiko Tietze from comment #48) > <node oor:name="COLON_SHIFT_MOD1" oor:op="replace"> > <node oor:name="POINT_MOD1" oor:op="replace"> > > The colon is on the German keyboard shift+. so any combination is not > working. Tested with master and neither ctrl+. nor shift+ctrl+. has any > effect, which is surprising for the second InsertCurrentDate command. > Switched all language/locale settings to German/Deutsch. No success. As I had indicated, I reverted the German specific patch then (see https://cgit.freedesktop.org/libreoffice/core/commit/?id=a135a182c38083511563009fc1c370e36c546d84) Since "virtual" keyboard doesn't help, I can't help more here.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/fe09be20ad4eb17cdbd09cff29de78b55a4135c7 fix crash seen when experimenting with tdf#129547 It will be available in 7.4.7. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.