We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

CALC: CTRL+SHIFT+; deletes cells but does not enter the time [closed]

asked 2017-03-03 05:39:54 +0200

ROSt52 gravatar image

updated 2020-07-10 20:46:24 +0200

Alex Kemp gravatar image

Libo Version: Build ID: 1:5.0.3~rc2-0ubuntu1~trusty2 Locale: en-US (en_US.UTF-8) OS LM17.3KDE

CTRL+SHIFT+; deletes cells but does not enter the time

I checked the customization of the keyboard: CTRL+SHIFT+; is allocated to enter the date CTRL+- is allocated to delete cells

How can I get LibO Calc to enter the time? Is this bug in this LibO version?

Thanks for your help1

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-10-16 11:22:22.659968


Cannot confirm with :

Build-ID: 1:5.3.0~rc3-0ubuntu1~xenial1.1
Gebietsschema: de-DE (de_DE.UTF-8)   OS LM17.3 Cinnamon
karolus gravatar imagekarolus ( 2017-03-03 12:59:01 +0200 )edit

Bug exist also in

Build ID: 686f202eff87ef707079aeb7f485847613344eb7
CPU Threads: 4; OS Version: Linux 3.19; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: en-US (en_US.UTF-8); Calc: group

See EDIT of my answer below.

ROSt52 gravatar imageROSt52 ( 2017-09-25 16:41:35 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2017-03-22 09:58:38 +0200

ROSt52 gravatar image

updated 2020-10-16 11:22:06 +0200

Alex Kemp gravatar image

Thanks everybody for comments.

I intend to install a newer version of LibO parallel to the - a bit old - version from the Linux Mint / Ubuntu repository. For The time being I have to live with the bug.


I installed now LIbO parallel to the and observe exactly the same problem.

The exact version is:

    Build ID: 686f202eff87ef707079aeb7f485847613344eb7
    CPU Threads: 4; OS Version: Linux 3.19; UI Render: default; VCL: kde4; Layout Engine: new; 
    Locale: en-US (en_US.UTF-8); Calc: group

I am using a Japanese keyboard, which is concerning "Crtl+shift+;" the same as the US keyboard.

In Windows versions up to 5.3.x it "ctrl+shift+;" perfectly inserted the time. I used exactly the same keyboard.

What can cause the bug? Difference to @karolus: - US version - German version - KDE version - Cinnamon version

Can a macro be written which enters time in a cell using the same key combination?

Thanks for comments and help.

EDIT 170926

Thanks for all your comments.

While looking for the "comma" instead of "semi-colon" possibility I found that in Tools > customize > functions > category = insert has no "Time" item in Function table but only "Date" and others.


However Tools > customize > Shortcut keys shows the "Insert Time" combined with "crtl+shift+;"


I installed also LibO and see exactly the same situation.

Is this a bug in LibO, LibO, anmd LibO Linux version? Is there a way to get "Time" in the Function table? Can it be related to the KDE version of LM 17.3?

What is your understanding of this? Ways to solutions?

(edit: activated screenshots)

edit flag offensive delete link more


@ROSt52 Using:

Build ID: ea7cb86e6eeb2bf3a5af73a8f7777ac570321527
CPU threads: 4; OS: Linux 4.8; UI render: default; VCL: gtk2; 
Locale: en-US (en_US.UTF-8); Calc: group

on Mint 18.2 I have no problem with the Ctrl+Shift+; inserting current time. Time permitting will try other versions.

Ratslinger gravatar imageRatslinger ( 2017-09-25 17:02:35 +0200 )edit

Had this version on Mint 18.2 KDE:

Build ID: f82d347ccc0be322489bf7da61d7e4ad13fe2ff3
CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: en-US (en_US.UTF-8); Calc: group

and again it works without a problem. The difference seen is the Kernel version. Could this be the cause?

Ratslinger gravatar imageRatslinger ( 2017-09-25 17:39:00 +0200 )edit

I believe it is also worth mentioning, OpenGL is off on all my installs. Menu Tools->Options, LibreOffice->View. A last check was done on Xubuntu 16.04, LO v5.4.1.2, Kernel 4.4.x and again all worked.

Ratslinger gravatar imageRatslinger ( 2017-09-25 19:40:18 +0200 )edit

Can a macro be written

see my extension DateTime2 - old, but still working

komma4 gravatar imagekomma4 ( 2017-09-25 23:41:09 +0200 )edit

@Ratslinger - OpenGL is off on both versions

@komma4 - I installed your extension but still have to find out how I can start and do changes from German to English version. Unfortunately I did not find an explanation on how to modify and how to run your attractive extension. Do you have an hint? Guideline? etc?

ROSt52 gravatar imageROSt52 ( 2017-09-26 04:44:38 +0200 )edit

answered 2017-03-03 12:47:57 +0200

Lupp gravatar image

updated 2017-03-25 21:46:23 +0200

You may remember that I am on silly Win 10, and that I mostly use very fresh versions.
I cannot test with V5.0.3 (and, of course, not on Ubuntu), but I preserved a V5.0.2 Portable. Just tried it and can confirm same behaviour: Key assigned but not working. I also cannot think of an extension installed for the old version probably overlaying the shortcut assignment.

With V5.3.0.3 I see the same state and behaviour, except that I have installed 'Compose Special Characters' for this version (rarely use it), and this might probably interfere in a hidden way. Did you look for related bug reports already? I didn't find the needle with a finger in the haystack.

Regards und alles Gute

Sorry. Missed to mention that I did not get an effect like "delete cell" or "clear cell" with either version.
(Edit 2:)
The functionality is present. I suppose @ROSt52 to use like myself a keyboard with German pysical layout. There may be a conflict only afflicting users with a German keyboard layout. Shift+Ctrl+, and Shift+Ctrl+; are both offered when customising the keyboard to create shortcuts. These combinations are, however, not physically different under the mentioned layout as there Shift+, = ; holds true. I get the expected behaviour if I assign 'Insert Current Time' from category 'Insert' to the alternative combination Ctrl+Shift+, . This with V5.3.1.2 under Win 10.

edit flag offensive delete link more


Choose your version from https://downloadarchive.documentfound... and then portable if it exists.

rautamiekka gravatar imagerautamiekka ( 2017-03-03 16:51:20 +0200 )edit

@rautamiekka: Yes. I have 14 versions of LibO and AOO here for testing (and á StarOffice 5.2 from 2000). I just didn't want to download another (only different by third digit) version. Thanks nonetheless.

Lupp gravatar imageLupp ( 2017-03-03 17:32:22 +0200 )edit

answered 2017-09-25 18:01:38 +0200

m.a.riosv gravatar image

Now at least in Spanish works with ',' instead ';' maybe it was changed in other languages.

The issue is they were assigned to characters ';' that are the shift of the key on some languages like Spanish.

Maybe it should be changed for all languages with ';' as shift key.

See Shortcuts ctrl+; and ctrl+shift+; does not work in ru/es/pt/fi keyboard layouts

edit flag offensive delete link more


Problem is that on an English keyboard it is Ctrl+; and Ctrl+: for which for the latter one has to hit Shift+Ctrl+; and users don't imply that : is actually Shift+; so the description uses Shift+Ctrl+;

Other layouts (have to) use other key assignments, things may be easier or more complicated to describe for other languages' keyboard layouts, and sometimes help/description isn't aligned with reality.

erAck gravatar imageerAck ( 2017-09-25 19:05:56 +0200 )edit

Question Tools

1 follower


Asked: 2017-03-03 05:39:54 +0200

Seen: 453 times

Last updated: Oct 16 '20