Description: When I start a descending series of months, AutoFill shows the wrong one even if it fills with the correct one. Steps to Reproduce: 1. insert in cell A1 the value December 2. insert in cell A2 the value November 3. select both cells 4. drag the fill handle in the bottom right corner of the cell across the cells that you want to fill Actual Results: The yellow preview cell that appear with the name of the month, reports the wrong one (September instead of January). The preview value is based on an ascending pattern instead of on a descending one. Expected Results: If you drag the fill handle down to A12 cell, it should report January instead of September like in the preview. When you release mouse button, the names auto-filled are correct. Reproducible: Always User Profile Reset: No Additional Info: I have two picture that show clearly and easily the problem, but there is no way to upload them.
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 198589 [details] Screenshot illustrating the problem, i.e. the preview label is generated using an un-reversed order.
Confirmed on macOS using Version: 24.8.4.2 (AARCH64) / LibreOffice Community Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002 CPU threads: 8; OS: macOS 15.2; UI render: default; VCL: osx Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded @Xisco - the 'Sample document' is a blank spreadsheet.
Oh, I see the problem is in the tooltip shown while dragging down Reproduced in Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: db6a6efdc49df054826e9019ebe955282de929a7 CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: en-US (es_ES.UTF-8); UI: en-US Calc: threaded
@Eike, I thought you might be interested in this issue
Reproducible with: Version: 24.2.7.2 (X86_64) / LibreOffice Community Build ID: ee3885777aa7032db5a9b65deec9457448a91162 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: es-MX (es_ES); UI: en-US Calc: CL threaded
With version 6.4.7.2 there is no inverse order fill for months or days.