Autofill to left or up direction would fill increasing number text and autofill for row direction does not work well for date data.


Version: 2025

Type: Bug Fixes

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-29307


In a new workbook, fill A10 with text like “a10”. When dragging up to A1, it would fill increasing number text like a11,a12,…

In a new workbook with 6 columns, set the columns as Date format, type 1/1/2024 in A1 cell and 2/1/2024 in B2 cell. When dragging the 2 highlighted cells to F1, the 4th cell did not fill the first date of the month.

Fixed in Origin 2025.