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
Created attachment 170440 [details] Screenshot of the original document side by side in Excel and Calc
Created attachment 170441 [details] Screenshot of the original document after autofilling side by side in Excel and Calc
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
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.)
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