We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Set LO to notify when same characters/words already exist elsewhere in list?

asked 2019-09-14 07:46:26 +0200

appreciatethehelp gravatar image

updated 2020-08-08 23:33:52 +0200

Alex Kemp gravatar image

Libreoffice, OSX Mojave

Hi all, I have been using Calc to create lists of items, including various details such as where to get them, how much they cost etc, with one item per cell, and I was wondering: is there any way to set LO to notify me if the same characters/words already exist elsewhere in the list? I ask as I have accidentally added multiple iterations of the same item to the lists by mistake on multiple occasions and was hoping to safeguard against this.

I could use a Find & Replace search to work it out, however I'd rather not have to do this each and every time an item is added- it'd be far more convenient if LO notified me on a case-by-case basis.

As items are added in chronological order from top to bottom, I could also set Conditional Formatting for all cells below the item that states that if they contain a key phrase regarding the item, to highlight them by applying a coloured cell style/other indicator. However, again this is inconvenient and laborious as I don't want to have to add conditional formatting for every item added to the list.

Any ideas? Cheers.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-09-14 08:01:42 +0200

ebot gravatar image

You can recognize when entering whether this entry already exists. It is called "word suggestions".

image description

edit flag offensive delete link more


This is true, however this only works when the item is entered in exactly the same way both times. Sometimes the wording may be slightly different when an item is recorded multiple times, for example one might record the item "clear ruler" first time, then "ruler" second time- in this case, typing "ruler" wouldn't produce a word suggestion, leading one to erroneously believe that the item wasn't previously recorded when in reality it was.

appreciatethehelp gravatar imageappreciatethehelp ( 2019-09-14 08:46:50 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-14 07:46:26 +0200

Seen: 67 times

Last updated: Sep 14 '19