Steps to reproduce: 1. Type 001-001-001 in cell A1. 2. Fill down from A1 to A5. Current Behaviour: 001-001-001 001-001000 001-001001 001-001002 001-001003 Expected Behaviour: 001-001-001 001-001-002 001-001-003 001-001-004 001-001-005 This bug is inherited from the old OpenOffice.org 3.3.0 Still reproducible in the most recent master.
Confirmed in Version: 5.4.0.0.alpha0+ Build ID: 9a30cb2161506e003f14592d83075ab9d30516c1 CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: gtk2; Locale: ca-ES (ca_ES.UTF-8); Calc: group @Eike: I thought you might be interested in this one...
-001 is treated as -1 and incremented by 1. compare: a-01 a00 a01 a02 a03 a04 a05 a06 a07 a08 a09 a10
Actually it should depend on the existing sequence that was selected, i.e. Single cell: a-01 => a-02 a-03 Two consecutive cells: a-03 a-02 => a-01 a+00 a+01 Likewise: a+03 a+02 => a+01 a+00 a-01 Starting without embedded sign: a03 a02 => a01 a00 a-01 a-02
Making this an EasyHack, code pointers: sc/source/core/data/table4.cxx ScTable::FillAnalyse() ScTable::FillAutoSimple() ScTable::GetAutoFillPreview() Places that call lcl_DecompValueString() and act on / use its results.
Here is a link to a patch I think provides the requested behavior https://gerrit.libreoffice.org/#/c/45280/
That unfortunately crosses https://gerrit.libreoffice.org/45262 for which Daniel probably forgot to assign this bug to himself to indicate he's working on it.
I am very sorry. In the future I will ask before taking a bug on.
(In reply to Jim Raykowski from comment #7) > I am very sorry. In the future I will ask before taking a bug on. You don't have to be sorry. Actually, it was my mistake. I should had assigned myself to solve this bug, so you would know somebody else was working on it. I'm sorry. Next time I won`t forget to do it.
Daniel committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=76c1e7287e29a2a2739fce895fbded3c04764bca tdf#105268 - Auto Fill: Fix The Next Value for 001-001-001 It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Daniel committed a patch related to this issue. It has been pushed to "libreoffice-6-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=87efbdb1ae5a73d081667e10f1571f1e523c1b9c&h=libreoffice-6-0 tdf#105268 - Auto Fill: Fix The Next Value for 001-001-001 It will be available in 6.0.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Zdeněk Crhonek committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2833a26a81adcf6a50106fd047423e229b35e79e uitest for bug tdf#105268 It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
The test exist, set status to Verified.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/1af1458fa44c6ed9f73a68696f494657ef8e2bc5 tdf#105268: sc: move UItest to CppUnittest It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.