Summary: | macOS: Command+Shift+; and cmd+; to insert timestamp and date in a Calc does not work | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Alexander Van den Panhuysen <dralexander_vandenpanhuysen> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | guibomacdev, iplaw67, stephane.guillou |
Priority: | medium | ||
Version: | 7.5.1.2 release | ||
Hardware: | Other | ||
OS: | macOS (All) | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=126888 https://bugs.documentfoundation.org/show_bug.cgi?id=154137 |
||
Whiteboard: | target:7.6.0 target:7.5.3 | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 98290, 107243 |
Description
Alexander Van den Panhuysen
2023-03-11 16:32:24 UTC
What keyboard layout do you use? I am using a AZERTY keyboard which is the normal used keyboard in Belgium for the Dutch people. It works fully correct. Thank you, Alexander. That makes your report a duplicate of the older bug 129547. *** This bug has been marked as a duplicate of bug 129547 *** Excuse me? Resolved? Duplicate of bug 129547 ?! I am talking about LibreOffice on MacBook Air which is an Apple computer with a build-in AZERTY keyboard, in the help Tip I read "Command", not "Ctrl". My understanding is that it would have the same root cause. I'm happy to set back to unconfirmed until someone else who knows more about keyboard layout detection chimes in. What happens if you use the Date field shortcut, Command + ; ? Shortcut Command+; to become a Datestamp, is doing nothing either. Could it be that this is related? https://ask.libreoffice.org/t/ctrl-doesnt-insert-date-into-cell-in-calc-on-dell-xps-13-plus/89139/6 " ibus-setup was using it for inserting emoticons. I deleted it and now LO sees the hotkey and inserts the date into a cell. [...] It appears it defined TWO hotkeys for inserting emoticons, Control-period and Control-semicolon. I have no idea why they would define TWO. I don’t use emoticons so I just deleted the hotkey Control-semicolon in ibus-setup. " What is this? On an Apple computer it is NOT Ctrl, it is Command according the help tip ! And secondly what is ibus? Never heard of. And I have written: "nothing happens", so I don't see an emoticon appearing either. (In reply to Eike Rathke from comment #7) > ibus-setup was using it for inserting emoticons. I deleted it and now LO > sees the hotkey and inserts the date into a cell. The insertion of date and/or time stamps in Calc by means of default keyboard shortcuts, for _all_ OSs has been broken since... Having to use [SHIFT] in some layouts was thought as part of the problem (I'd bet it's not enough). I lost track of the dups already. Basically, it works for QUERTY USA layout; maybe by chance in some other case. 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. Setting as confirmed 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. Despite the patch, cmd+shift+; doesn't do anything (or colon for that matter, since the patch notes mention that) Tested with Norwegian keyboard layout where ";" is on the "," key FYI: I tested and it works in Excel In Excel the shortcut for inserting date is ctrl+shift+; Only cmd+; as mentioned in the comment #5 would not work, as cmd+, is the shortcut key for preferences Version: 24.2.0.0.beta1 (AARCH64) / LibreOffice Community Build ID: 5f390384195b7264c6e52add9e90a39790285249 CPU threads: 10; OS: macOS 14.2; UI render: Skia/Metal; VCL: osx Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded |