Know_How wrote: ↑Sun Feb 25, 2024 12:16 am
This is a problem I have been attempting to solve …
If you need assistance with a problem, please open your own topic so we can help you. Describe the problem in detail, for example, what value are you typing in what cell? How is the feature not working as you would like?
Attach a spreadsheet demonstrating the difficulty
(remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the spreadsheet itself). The
quickest way to get a solution is to attach a spreadsheet.
This topic belongs to jef212 and requests in this topic for help with your problem will be removed.
Know_How wrote: ↑Sun Feb 25, 2024 12:16 am
Unfortunately, there is no way to edit or delete saved items.
Correct. That was explained by acknak 15 years ago in this topic. I am guessing that he used OpenOffice 3.1 then, but OpenOffice 4.1.14 operates the same way.
OpenOffice 4.1.14 Help: Tools → Cell Contents → AutoInput wrote:Switches the AutoInput function on and off, which automatically completes entries, based on other entries in the same column. The column is scanned up to a maximum of 2000 cells or 200 different strings.
The list does not include duplicates, numeric values, or values from formulas. I believe the dynamic list holds the last 2000 nonempty cells, stopping at 200 unique text values, though I know of no documentation which describes the process in detail.
Know_How wrote: ↑Sun Feb 25, 2024 12:16 am
However if you … just start typing a word, a variety of previously entered words are available.
The entries come from the
same dynamic list that the Selection List would show, except only the entries which begin with the letters that you've typed are shown.
Know_How wrote: ↑Sun Feb 25, 2024 12:16 am
… the only way I know of to flush this list is to uninstall Open Office and install a fresh copy.
A new copy will build the
same dynamic list from the existing spreadsheet data that the old one did. Reinstalling would be a waste of your time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).