| Summary: | Auto Filling of a string in a column of information | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Don <DonGall425> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | DonGall425, gerard.fargeot, jmadero.dev, sophi |
| Priority: | medium | ||
| Version: | 4.0.1.2 release | ||
| Hardware: | x86 (IA32) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
This works fine for me in Bodhi Linux, Version 4.0.1.2 - will look for a Windows tester I presume you are refering to "Autoinput" functionality. Works fine for me. You say that you have around 5000 items. The AutoInput functionality is limited to 200 different items. (Only the *last* 200) Workaround : Press Alt + ↓ (down arrow) will show a drop-down list with all the previous items of the column sorted alphabetically. Typing a letter like F will preselect the 1st item beginning with a F. @Don: GerardF pointed you to the right direction to go through the AutoInput list. I'm closing this issue as I think that you know now how to deal with the list, if it's not the case, please reopen the bug. Resolved as worksforme - Sophie |
I have a list of items in a mini SPREADSHEET database, about 5000 items (rows). in Column "C" I enter a description of an item In Column "D" I enter the name of the manufacturer Example in "C" Windshield for 2012 Focus In "D" Ford My problem, if I have entered "Ford" in the present session, it will autofill the next time I try to type the name Ford. But if I have saved the file, reopened it on another day, added a new item in column "C" such as "Left Driver Door Window for 2012 Focus", and I begin to type the word "Ford" in column "D" it does not recognize that there is the string "Ford" somewhere above in Column "D" and does NOT autofill. Don't know if I am doing something wrong, (too many rows to Search) or this is an actual bug. If not a Bug, can someone point me in the right direction please. Regards, Don Gallaher