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

[bugzilla-daemon]

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

OfficeUser  changed:

   What|Removed |Added

 Status|REOPENED|RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #11 from OfficeUser  ---
(In reply to Heiko Tietze from comment #9)
> Report from G+ user: Selecting only one cell counts up but when you select
> a1 and a2 it works as requested ignoring the minus before the number. Sounds
> like the most flexible solution.

@Heiko:
Thanks for this information. I did not know that selecting a1 and a2 leads to
the requested behavior. So I agree to close this issue as WORKSFORME.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #10 from Heiko Tietze  ---
(In reply to Heiko Tietze from comment #9)
> Report from G+ user: Selecting only one cell counts up but when you select
> a1 and a2 it works as requested ignoring the minus before the number. Sounds
> like the most flexible solution.

While 50% agree with you and want to count regardless of the minus, I would
close this ticket as WFM. The flexibility argument is striking.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #9 from Heiko Tietze  ---
Report from G+ user: Selecting only one cell counts up but when you select a1
and a2 it works as requested ignoring the minus before the number. Sounds like
the most flexible solution.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

--- Comment #8 from OfficeUser  ---
I want to note that this issue has been filed after bad user experience with
autofilling something like:

REQUIREMENT-NO-1
REQUIREMENT-NO-2
...

I just used letters like a and b for simplification in my initial bug
description. However I do not talk about formula-like strings.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #5 from Heiko Tietze  ---
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.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

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

[bugzilla-daemon]

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

Heiko Tietze  changed:

   What|Removed |Added

  Component|LibreOffice |Calc

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise