https://bugs.documentfoundation.org/show_bug.cgi?id=155016
Bug ID: 155016
Summary: New feature: set the source/scope of AutoComplete
search
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Currently the autocomplete feature proposes results from the current column.
I would like to suggest a feature and an option:
"Source of AutoComplete results": "Current column of current sheet
(default)"/"All columns from current sheet"/"Current column of all sheets"/"All
columns of all sheets"
Use case: we are storing a lot of invoice information in .ods files, where the
second column always contains a company name, but the different years are
contained in same file, but different sheets. The Company names are mostly
repeating, but there are lots of new entries each year.
Currently the AutoComplete is mostly unusable for some time each year, at least
as long as the list gets filled up with recurring company names.
For our case it would be really useful to be able to set the source of
AutoComplete results to "Current column of all sheets", this way we could use
the same names over and over without having to search for them in other sheets.
The other options besides "Current column of current sheet (default)"/"Current
column of all sheets" are the logical extrapolations of this feature which - I
would say - should be added to handle all cases.
Albeit we already had several cases when it would have been useful to be able
to AutoComplete values from other columns as well.
I've tried to search for similar feature requests, but I couldn't find anything
related. Sorry if I was inattentive and there is already a ticket about this.
If there is anything that can/should be cleared I'm really happy to correspond
about it.
--
You are receiving this mail because:
You are the assignee for the bug.
