https://bugs.documentfoundation.org/show_bug.cgi?id=160232
Bug ID: 160232
Summary: LibreOffice Calc - Autocomplete completes Number cells
with date cells
Product: LibreOffice
Version: 7.6.5.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a cell structure like this
|some name|12.03.24|
|name1 |3 |
|name2 |2 |
|name3 |1 |
When I press 1, it tries to autocomplete 1 as "12.03.24". I confirm date cell
is formatted as date and other cells with numbers formatted as number. As a
workaround I type 01 then enter. MS Excel wasn't suggesting date on a number
cell. I think autocompleting date is needs to be only triggered after i press
the dot like "12.", or not autocomplete date on number cells, or disable this
at all.
Steps to Reproduce:
1. Format A1 as date and format A2, A3, A4 as general number.
2. Enter a date to A1 which is formatted as date
3. Enter a number that starts how date starts. Like, if date is "21.02.24",
press 2.
Actual Results:
Autocompletes to date
Expected Results:
Autocomplete to number from upper rows / don't autocomplete.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.6.5.2 (X86_64) / LibreOffice Community
Build ID: 60(Build:2)
CPU threads: 16; OS: Linux 6.7; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
7.6.5-1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
