Bug 140984

Summary:	EDITING Autofill with user list does not change small/large caps
Product:	LibreOffice	Reporter:	NISZ LibreOffice Team <libreoffice>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	UNCONFIRMED ---
Severity:	enhancement	CC:	attila.szucs, nemeth
Priority:	medium
Version:	7.2.0.0.alpha0+
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	113499
Attachments:	Example file from Excel Screenshot of the original document side by side in Excel and Calc Screenshot of the original document after autofilling side by side in Excel and Calc

Description NISZ LibreOffice Team 2021-03-12 14:04:37 UTC

Created attachment 170439 [details]
Example file from Excel

Attached Excel-made file contains day names which are also defined as user lists in both Excel and Calc.
When there is a series of these in Excel, autofilling considers the starting small/large capitals and fills cells according to the first cells capitals.
Calc always autofills with small caps.

Steps to reproduce:
    1. Open attached file in Excel and Calc
    2. Select B2:C2 and autofill to H2
    3. Select B4:C4 and autofill to H4

Actual results:
In Excel D2:H2 becomes filled with large capitals day names.
In Calc D2:H2 is also filled with small capitals day names.
D4:H4 becomes filled with small capitals day names in both programs, this is good.

Expected results:
In Calc D2:H2 should be filled with large capitals day names.

LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 9d8accf03984a64a4105826e55b221962628eb93
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-GB
Calc: CL

Comment 1 NISZ LibreOffice Team 2021-03-12 14:04:55 UTC

Created attachment 170440 [details]
Screenshot of the original document side by side in Excel and Calc

Comment 2 NISZ LibreOffice Team 2021-03-12 14:05:17 UTC

Created attachment 170441 [details]
Screenshot of the original document after autofilling side by side in Excel and Calc

Comment 3 Andreas Heinisch 2021-04-02 09:04:18 UTC

Can't confirm in:

Version: 6.3.3.2 (x64)
Build-ID: a64200df03143b798afd1ec74a12ab50359878ed
CPU-Threads: 6; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: CL

and not present in:

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 94179fee33f3494d4e4be32b9975ae0b62eaa124
CPU threads: 6; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL

Comment 4 Justin L 2022-02-11 04:57:21 UTC

The opposite is true in an English locale. Sunday, Monday autofills into capitalized days of the week, but sunday, monday also autofill into capitalized Tuesday...  (sunday and monday are marked as spelling errors, so the current behaviour is good for English.)

Comment 5 Armondo Lopez 2024-03-26 18:59:40 UTC

Can't confirm in 

Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

nor in 

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded