[Libreoffice-bugs] [Bug 78545] EDITING: spreadsheet cell autocomplete improvements (better algorithim)

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #5 from Buovjaga  ---
I found an older report that is requesting a similar change, I will add a
comment there to check this out.

*** This bug has been marked as a duplicate of bug 43742 ***

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

[Libreoffice-bugs] [Bug 78545] EDITING: spreadsheet cell autocomplete improvements ( better algorithim)

[bugzilla-daemon]

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

Yousuf Philips (jay)  changed:

   What|Removed |Added

 Blocks||103341


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=103341
[Bug 103341] [META] Auto Correct and Completion bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78545] EDITING: spreadsheet cell autocomplete improvements (better algorithim)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=78545

Beluga todven...@suomi24.fi changed:

   What|Removed |Added

 Status|NEEDINFO|NEW
 CC||todven...@suomi24.fi

--- Comment #3 from Beluga todven...@suomi24.fi ---
Let's set this to NEW.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78545] EDITING: spreadsheet cell autocomplete improvements (better algorithim)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=78545

--- Comment #4 from Luuk luu...@gmail.com ---
option 2 would be a nice enhancement!

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78545] EDITING: spreadsheet cell autocomplete improvements (better algorithim)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=78545

Cor Nouws c...@nouenoff.nl changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||c...@nouenoff.nl
 Ever confirmed|0   |1

--- Comment #1 from Cor Nouws c...@nouenoff.nl ---
Hi Richard,

Thanks for writing the idea. I'm not sure how that will work out in various
(different) situations, but...

(In reply to comment #0)

 4:   Long string of test test
 5:   Long string of text
 1003: L
 
 in this case, every single autocomplete is wrong, and I have to type out the
 entry nearly in full, just because of one line which (although it is
 correct), I entered 3 years ago, and it has been messing up autocomplete
 every day since then!

always Ctrl+Tab cycles through the possible autocomplete options...
I think that helps in your case?
Best,
Cor

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78545] EDITING: spreadsheet cell autocomplete improvements (better algorithim)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=78545

--- Comment #2 from Richard Neill x...@richardneill.org ---
Ctrl-Tab does help a bit, but it's much more awkward than a smarter
auto-complete. It needs 2 extra keystrokes (which aren't easy to type fast),
and then we may have to Ctrl-tab multiple times. Furthermore, it's a
non-discoverable and less-intuitive way to work.

There is one extra refinement needed - in that we aren't always appending data
at the bottom of a column; sometimes we insert in the middle or at the top.

(1) Current algorithm is:
  Scan from top of column for match, accept the first one.

(2) Improved algorithm.
  Scan outward (up + down) from the current cell for a match, accept the
  nearest one.

(3) Optimised algorithm:
  Scan the entire column and count matches. Accept the most popular match.


Given that (3) may be harder to write, and possibly worse at runtime, I think
that (2) would suffice - it should be easy to write, and would catch most of
the common cases.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 78545] EDITING: spreadsheet cell autocomplete improvements (better algorithim)

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=78545

m.a.riosv mari...@miguelangel.mobi changed:

   What|Removed |Added

   Severity|minor   |enhancement
 CC||mari...@miguelangel.mobi

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs