https://bugs.documentfoundation.org/show_bug.cgi?id=158308
Bug ID: 158308
Summary: EDITING CTRL-Shift-; didn't work at first and now
overwrites existing format
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
When attempting to insert the current date in a field using CTRL-SHIFT-;
nothing would happen at first.
Following some advice from reddit, I was able to get it to work by modifying
the shortcut key combination several times (to F3, ctrl-shift-,, ctrl-shift-;),
most of which didn't work, despite quitting from libreoffice and restarting
several times.
At first, during the above iterations, I noticed that pressing the
key-combination would not insert the time but would change the cell's format to
HH:MM:SS AM/PM, and eventually it started inserting the time.
Throughout this process, inserting the time using the menus (Insert/Time)
worked.
The next issue I'm having with this, which is also new, is that the cell's
format is overwritten (i.e. if I insert the time in a cell formatted for time
as "HH:MM AM/PM" the cell's format changes to "HH:MM:SS AM/PM"), which I don't
want.
Thank you!
System info:
System:
Kernel: 5.15.0-88-generic x86_64 bits: 64 compiler: gcc v: 11.4.0 Desktop:
Cinnamon 5.4.12
tk: GTK 3.24.33 wm: Mutter dm: LightDM Distro: Linux Mint 21 Vanessa base:
Ubuntu 22.04 jammy
Machine:
Type: Desktop Mobo: ASRock model: B550 Pro4 serial: <superuser required>
UEFI: American Megatrends LLC. v: P2.20 date: 02/24/2022
CPU:
Info: 6-core model: AMD Ryzen 5 5500 bits: 64 type: MT MCP arch: Zen 3 rev: 0
cache: L1: 384 KiB
L2: 3 MiB L3: 16 MiB
Speed (MHz): avg: 3609 high: 4242 min/max: 1400/3600 boost: enabled cores: 1:
3393 2: 3393
3: 3920 4: 3427 5: 3394 6: 4242 7: 3394 8: 3394 9: 3702 10: 3416 11: 3394
12: 4242
bogomips: 86240
Flags: avx avx2 ht lm nx pae sse sse2 sse3 sse4_1 sse4_2 sse4a ssse3 svm
Graphics:
Device-1: AMD Navi 10 [Radeon RX 5600 OEM/5600 XT / 5700/5700 XT] vendor:
Gigabyte
driver: amdgpu v: kernel pcie: speed: 16 GT/s lanes: 16 ports: active: DP-1
empty: DP-2,DP-3,HDMI-A-1 bus-ID: 03:00.0 chip-ID: 1002:731f
Device-2: Logitech Webcam C600 type: USB driver: snd-usb-audio,uvcvideo
bus-ID: 5-2:3
chip-ID: 046d:0808
Display: x11 server: X.Org v: 1.21.1.4 driver: X: loaded: amdgpu,ati
unloaded: fbdev,modesetting,radeon,vesa gpu: amdgpu display-ID: :0 screens:
1
Screen-1: 0 s-res: 2560x1440 s-dpi: 96
Monitor-1: DisplayPort-0 mapped: DP-1 model: Acer XV320QU LV res: 2560x1440
dpi: 93
diag: 801mm (31.5")
OpenGL: renderer: AMD Radeon RX 5700 XT (navi10 LLVM 15.0.7 DRM 3.42
5.15.0-88-generic)
v: 4.6 Mesa 23.0.4-0ubuntu1~22.04.1 direct render: Yes
Audio:
Device-1: AMD Navi 10 HDMI Audio driver: snd_hda_intel v: kernel pcie: speed:
16 GT/s lanes: 16
bus-ID: 03:00.1 chip-ID: 1002:ab38
Device-2: Creative Labs Sound Core3D [Sound Blaster Recon3D / Z-Series]
driver: snd_hda_intel
v: kernel pcie: speed: 2.5 GT/s lanes: 1 bus-ID: 06:00.0 chip-ID: 1102:0012
Device-3: AMD Renoir Radeon High Definition Audio driver: snd_hda_intel v:
kernel pcie:
speed: 8 GT/s lanes: 16 bus-ID: 09:00.1 chip-ID: 1002:1637
Device-4: C-Media CM106 Like Sound Device type: USB driver:
hid-generic,snd-usb-audio,usbhid
bus-ID: 5-1.3:6 chip-ID: 0d8c:0102
Device-5: Logitech Webcam C600 type: USB driver: snd-usb-audio,uvcvideo
bus-ID: 5-2:3
chip-ID: 046d:0808
Sound Server-1: ALSA v: k5.15.0-88-generic running: yes
Sound Server-2: PulseAudio v: 15.99.1 running: no
Sound Server-3: PipeWire v: 0.3.84 running: yes
Network:
Device-1: Realtek RTL8111/8168/8411 PCI Express Gigabit Ethernet vendor:
ASRock driver: r8169
v: kernel pcie: speed: 2.5 GT/s lanes: 1 port: e000 bus-ID: 07:00.0
chip-ID: 10ec:8168
IF: enp7s0 state: up speed: 1000 Mbps duplex: full mac: <filter>
IF-ID-1: zt44xalgg7 state: unknown speed: 10 Mbps duplex: full mac: <filter>
IF-ID-2: zt44xol3hy state: unknown speed: 10 Mbps duplex: full mac: <filter>
IF-ID-3: ztrtav5bwk state: unknown speed: 10 Mbps duplex: full mac: <filter>
Drives:
Local Storage: total: 7.41 TiB used: 4.87 TiB (65.7%)
ID-1: /dev/nvme0n1 vendor: Intel model: SSDPEKNW010T8 size: 953.87 GiB speed:
31.6 Gb/s
lanes: 4 serial: <filter> temp: 34.9 C
ID-2: /dev/sda vendor: SanDisk model: SDSSDH31000G size: 931.51 GiB speed:
6.0 Gb/s
serial: <filter>
ID-3: /dev/sdb type: USB model: USB DISK 3.0 size: 115.43 GiB serial:
<filter>
ID-4: /dev/sdc vendor: Seagate model: ST6000VN0033-2EE110 size: 5.46 TiB
speed: 6.0 Gb/s
serial: <filter>
Partition:
ID-1: / size: 136.45 GiB used: 22.85 GiB (16.7%) fs: ext4 dev: /dev/nvme0n1p2
ID-2: /boot/efi size: 2.79 GiB used: 6.1 MiB (0.2%) fs: vfat dev:
/dev/nvme0n1p1
ID-3: /home size: 732.29 GiB used: 472.2 GiB (64.5%) fs: ext4 dev:
/dev/nvme0n1p3
Swap:
ID-1: swap-1 type: partition size: 32.6 GiB used: 4.86 GiB (14.9%) priority:
-2
dev: /dev/nvme0n1p4
Sensors:
System Temperatures: cpu: N/A mobo: N/A gpu: amdgpu temp: 52.0 C mem: 58.0 C
Fan Speeds (RPM): N/A gpu: amdgpu fan: 857
Repos:
Packages: 2932 apt: 2917 flatpak: 15
No active apt repos in: /etc/apt/sources.list
Active apt repos in: /etc/apt/sources.list.d/audio-recorder-ppa-jammy.list
1: deb http: //ppa.launchpad.net/audio-recorder/ppa/ubuntu jammy main
Active apt repos in: /etc/apt/sources.list.d/google-chrome.list
1: deb [arch=amd64] https: //dl.google.com/linux/chrome/deb/ stable main
Active apt repos in: /etc/apt/sources.list.d/jeffreyratcliffe-ppa-jammy.list
1: deb http: //ppa.launchpad.net/jeffreyratcliffe/ppa/ubuntu jammy main
Active apt repos in: /etc/apt/sources.list.d/libreoffice-ppa-jammy.list
1: deb http: //ppa.launchpad.net/libreoffice/ppa/ubuntu jammy main
Active apt repos in:
/etc/apt/sources.list.d/official-package-repositories.list
1: deb http: //packages.linuxmint.com vanessa main upstream import backport
2: deb http: //archive.ubuntu.com/ubuntu jammy main restricted universe
multiverse
3: deb http: //archive.ubuntu.com/ubuntu jammy-updates main restricted
universe multiverse
4: deb http: //archive.ubuntu.com/ubuntu jammy-backports main restricted
universe multiverse
5: deb http: //security.ubuntu.com/ubuntu/ jammy-security main restricted
universe multiverse
Active apt repos in:
/etc/apt/sources.list.d/pipewire-debian-pipewire-upstream-jammy.list
1: deb http: //ppa.launchpad.net/pipewire-debian/pipewire-upstream/ubuntu
jammy main
Active apt repos in: /etc/apt/sources.list.d/protonvpn-stable.list
1: deb [arch="all",
signed-by=/usr/share/keyrings/protonvpn-stable-archive-keyring.gpg] https:
//repo.protonvpn.com/debian stable main
Active apt repos in:
/etc/apt/sources.list.d/remmina-ppa-team-remmina-next-jammy.list
1: deb http: //ppa.launchpad.net/remmina-ppa-team/remmina-next/ubuntu jammy
main
Active apt repos in:
/etc/apt/sources.list.d/saiarcot895-flightgear-jammy.list
1: deb http: //ppa.launchpad.net/saiarcot895/flightgear/ubuntu jammy main
Active apt repos in: /etc/apt/sources.list.d/zerotier.list
1: deb http: //download.zerotier.com/debian/xenial xenial main
Info:
Processes: 516 Uptime: 3d 1h 33m Memory: 31.21 GiB used: 20.27 GiB (64.9%)
Init: systemd v: 249
runlevel: 5 Compilers: gcc: 11.4.0 alt: 11/12 Client: Cinnamon v: 5.4.12
inxi: 3.3.13
--
You are receiving this mail because:
You are the assignee for the bug.
