https://bugs.documentfoundation.org/show_bug.cgi?id=171415
Bug ID: 171415
Summary: AutoFill fails to increment numbers inside square
brackets in complex strings; repeats pattern instead.
Product: LibreOffice
Version: 25.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When entering a sequence of strings where the incremental number is located
inside square brackets (e.g., Event[0][0], Event[0][1]...), LibreOffice Calc
fails to detect the linear progression. Instead of incrementing the number, it
repeats the selected pattern.
Microsoft Excel correctly identifies the increment and continues the series.
Steps to Reproduce:
1.In cell A1, enter:Event[0][0]
2.In cell A2, enter:Event[0][1]
3.In cell A3, enter:Event[0][2]
4.In cell A4, enter:Event[0][3]
5.Select range A1:A4.
6.Drag the fill handle downwards.
Actual Results:
The cells are filled with a repeating pattern: ...[0], ...[1], ...[2], ...[3],
...[0], ...[1]...
Expected Results:
The number inside the brackets should increment: ...[4], ...[5], ...[6]...
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Compatibility & Migration Impact:
Behavior in Competitors:
Microsoft Excel: Correctly identifies the incremental pattern inside the
brackets ([0], [1], [2], [3]) and continues the series as [4], [5], [6]....
WPS Office Spreadsheets: Also correctly handles this pattern and increments the
numbers as expected.
Conclusion: This is a specific limitation in LibreOffice Calc's pattern
recognition logic compared to the industry standard.
Migration Blocker:
Our organization is currently migrating large-scale test data workflows from
Excel to LibreOffice.
These data patterns (e.g., {INS,PTR_VALUE,Event[0][N]}) are extensively used in
our automated testing scripts and configuration files.
Impact: The inability to auto-fill these sequences forces users to manually
enter thousands of rows or rely on complex formula workarounds, which
significantly reduces productivity and introduces a high risk of human error.
This behavior is a critical blocker for our migration plan, as it breaks
existing user habits and data preparation workflows that function seamlessly in
Excel and WPS.
Request:
We kindly request the development team to enhance the AutoFill pattern
detection regex to recognize incremental integers located within square
brackets or similar delimiters, aligning with Excel/WPS behavior to facilitate
smoother migration for enterprise users.
Help - About LibreOffice:
Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID:
CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render:
Skia/Vulkan; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
