https://bugs.freedesktop.org/show_bug.cgi?id=78545
Priority: medium
Bug ID: 78545
Assignee: [email protected]
Summary: EDITING: spreadsheet cell autocomplete improvements
(better algorithim)
Severity: minor
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.3.3 release
Component: Spreadsheet
Product: LibreOffice
For larger spreadsheets, especially with considerable repetition of values, the
auto-completion feature in new cells is extremely helpful. However, the
algorithm for suggestions could be much smarter than it is.
Consider the following very simple example spreadsheet. The first 4 cells have
been filled in with values "xa", "xb", "xb", "xc", and the user is part-way
through entering the data in cell A5, having typed "x".
COL
A
ROW 1 xa
ROW 2 xb
ROW 3 xb
ROW 4 xc
ROW 5 x...
Currently, the autocomplete proposes "xa". This is doing an alphabetical search
back through the column A.
I think that this is the worst possible algorithm to choose.
A smarter choice would be "xc", i.e. a reverse-search though history starting
at the current position.
A possible alternative (maybe even better) would be "xb", i.e. a search for the
most common match in the column.
The reason why this matters to me is that I have a spreadsheet with about 1000
rows, where the columns are like the following:
1: Long string of text
2: Long string of text
3: Long string of text
4: Long string of test test
5: Long string of text
6: Long string of text
7: Long string of text
[repeat for 1000 rows]
1001: Long string of text
1002: 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!
--
Thanks for your time, and your work on a great program.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
