[Libreoffice-ux-advise] [Bug 94676] Calc autofill confused, hyphen vs. minus

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Oct 5 09:48:31 UTC 2016


https://bugs.documentfoundation.org/show_bug.cgi?id=94676

Heiko Tietze <tietze.heiko at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WORKSFORME

--- Comment #5 from Heiko Tietze <tietze.heiko at gmail.com> ---
Excel autofill:
aaa-bbb-ccc-03  aaa-bbb-ccc+01  1       -3
aaa-bbb-ccc-04  aaa-bbb-ccc+02  2       -2
aaa-bbb-ccc-05  aaa-bbb-ccc+03  3       -1
aaa-bbb-ccc-06  aaa-bbb-ccc+04  4       0
aaa-bbb-ccc-07  aaa-bbb-ccc+05  5       1
aaa-bbb-ccc-08  aaa-bbb-ccc+06  6       2

LibO 5.3 autofill:
Aaa-bbb-ccc-03  Aaa-bbb-ccc+01  1       -3
Aaa-bbb-ccc-02  Aaa-bbb-ccc+02  2       -2
Aaa-bbb-ccc-01  Aaa-bbb-ccc+03  3       -1
Aaa-bbb-ccc00   Aaa-bbb-ccc+04  4       0
Aaa-bbb-ccc01   Aaa-bbb-ccc+05  5       1
Aaa-bbb-ccc02   Aaa-bbb-ccc+06  6       2

LibO counts more reliable as the combined cells are treated like the numbers.
And if you pull up instead of pull down, starting for instance in row 10 with
Aaa-bbb-ccc05, you end up at row 1 with Aaa-bbb-ccc-04. Excel, however, goes
from 05 down to 00 and then up again to 04. Better file a bug report at
Microsofts bugtracker... :-)

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list