Bug 2084627

Summary:	Inserting current date with ctrl+; in LibreOffice Calc does not work any more
Product:	[Fedora] Fedora	Reporter:	Jan Vlug <jan.public>
Component:	ibus	Assignee:	fujiwara <tfujiwar>
Status:	CLOSED NEXTRELEASE	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	36	CC:	caolanm, drdrgraham, dtardon, erack, i18n-bugs, sbergman, shawn.p.huang, tfujiwar
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	ibus-1.5.26-16.fc37	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2022-08-25 11:12:15 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Jan Vlug 2022-05-12 14:32:53 UTC

In Fedora 36, LibreOffice Calc 7.3.3.2 inserting the current date in a spreadsheet with the Ctrl+; key combination does not work any more.

Maybe this related to a new keyboard shortcut for inserting emojis. I tried to map inserting the date to Ctrl+. but that gives the same problem.

Instead of the date, I get an underlined e.


Version: 7.3.3.2
Build ID: 30(Build:2)
CPU threads: 16; OS: Linux 5.17; UI render: default; VCL: gtk3
Locale: en-GB (en_US.UTF-8); UI: en-US
Calc: threaded

Comment 1 Jan Vlug 2022-05-12 14:48:24 UTC

See also: https://askubuntu.com/questions/1405881/ctrl-doesnt-insert-current-date-in-libreoffice-calc

Comment 2 Caolan McNamara 2022-05-12 15:00:50 UTC

I don't think there's anything I can do about it in LibreOffice, by default ibus intercepts that sequence: https://stackoverflow.com/questions/72009437/ctrl-semicolon-not-inserting-date-in-google-sheets-instead-showing-under

Comment 3 Daniel Graham 2022-05-19 10:10:50 UTC

This 'bug' is the result of the emoji hotkey setting in etc/dconf/db/ibus.d/00-upstream-settings.  In Fedora36 the setting is hotkey=['<Control>period', '<Control>semicolon'], whereas in Fedora35 the setting was hotkey=['<Control>period'].  

I think whoever made this change was not aware that many spreadsheet programs, Excel, LibreOffice, Google Sheets, use the <Ctrl>; key combination to insert the current date.


As a temporary fix, the end-user can restore the old setting by executing

dconf write /desktop/ibus/panel/emoji/hotkey "['<Control>period']"

Comment 4 fujiwara 2022-08-25 11:12:15 UTC

This is not a bug but an expected result.
IBus had followed GTK emoji shortcut keys but libreoffice disable the GTK shortcut keys.

I had several discussion about this and finally IBus emoji shortcut key is now moved to Super-period.