Bug 140984 - EDITING Autofill with user list does not change small/large caps
Summary: EDITING Autofill with user list does not change small/large caps
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.0.0.alpha0+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: AutoFill
  Show dependency treegraph
 
Reported: 2021-03-12 14:04 UTC by NISZ LibreOffice Team
Modified: 2022-02-11 04:57 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Example file from Excel (8.80 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-03-12 14:04 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc (61.22 KB, image/png)
2021-03-12 14:04 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document after autofilling side by side in Excel and Calc (66.15 KB, image/png)
2021-03-12 14:05 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
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.)