Bug 154136 - macOS: Command+Shift+; and cmd+; to insert timestamp and date in a Calc does not work
Summary: macOS: Command+Shift+; and cmd+; to insert timestamp and date in a Calc does ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.1.2 release
Hardware: Other macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:7.6.0 target:7.5.3
Keywords:
Depends on:
Blocks: Shortcuts-Mac Shortcuts-Locale
  Show dependency treegraph
 
Reported: 2023-03-11 16:32 UTC by Alexander Van den Panhuysen
Modified: 2024-07-05 23:19 UTC (History)
2 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 Alexander Van den Panhuysen 2023-03-11 16:32:24 UTC
Description:
I'm using LibreOffice 7.5.1.2 on a MacBook Air 2019. In Calc I want to insert a timestamp in a cell with key combination Command+Shift+; , but that is doing nothing at all although I found that key combination in a Help Tip (once a day). When I use the Menubar -> Insert -> Time, it works by clicking with mouse or something, but I don't see the key combination at the right of the word Time.

Steps to Reproduce:
1.Open a Calc and be sure a cell is selected.
2.Do what is written in Help Tip 42/224: key combination Command+Shift+;.
3.

Actual Results:
The cell in Calc remains empty.

Expected Results:
A timestamp should inserted in the selected cell.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.5.1.2 (X86_64) / LibreOffice Community
Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129
CPU threads: 4; OS: Mac OS X 13.2.1; UI render: default; VCL: osx
Locale: nl-BE (nl_BE.UTF-8); UI: en-US
Calc: threaded
Comment 1 Stéphane Guillou (stragu) 2023-03-11 17:36:40 UTC
What keyboard layout do you use?
Comment 2 Alexander Van den Panhuysen 2023-03-11 17:42:37 UTC
I am using a AZERTY keyboard which is the normal used keyboard in Belgium for the Dutch people. It works fully correct.
Comment 3 Stéphane Guillou (stragu) 2023-03-11 17:58:05 UTC
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 ***
Comment 4 Alexander Van den Panhuysen 2023-03-11 18:13:49 UTC
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".
Comment 5 Stéphane Guillou (stragu) 2023-03-11 18:32:02 UTC
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 + ; ?
Comment 6 Alexander Van den Panhuysen 2023-03-11 19:12:17 UTC
Shortcut Command+; to become a Datestamp, is doing nothing either.
Comment 7 Eike Rathke 2023-03-14 00:04:13 UTC
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.
"
Comment 8 Alexander Van den Panhuysen 2023-03-14 06:05:41 UTC
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.
Comment 9 ady 2023-03-14 10:12:03 UTC
(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.
Comment 10 Commit Notification 2023-03-14 17:36:41 UTC
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.
Comment 11 eisa01 2023-03-18 11:29:59 UTC
Setting as confirmed
Comment 12 Commit Notification 2023-03-18 18:09:56 UTC
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.
Comment 13 eisa01 2023-12-29 12:00:58 UTC
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