Automatically auto-correct after Copy/Paste

Hey everyone. I’m looking for a way to get LibreOffice Calc to autocorrect automatically when copying from one document to another. So far, I’ve gone into autocorrect options under tools and have input what I want corrected to what, but it does not automatically do this after copying pasting… So here’s an example:

I have set in Tools > AutoCorrect a setting of : ‘Replace Polyvinyl Chloride’ with ‘PVC’.

I then have a calc open with a list that has several fields of Polyvinyl Chloride. I highlight them and copy, then paste into another calc fields. What I -want- is for this column to automatically translate Polyvinyl Chloride into PVC. Currently it just keeps it as Polyvinyl Chloride, and only makes the change if I type it in manually.

You asked this a year ago, so perhaps you’re not still around - but I found your unanswered question when I had the same question for a different reason … I have a set of autocorrect to “correct” American spellings like honor to British spellings like honour. When I paste American text into my British document, autocorrect does not work, just like you found.

After not finding any answers to your and my question, I looked around in Writer and found that you can go to the Format menu: Format → Autocorrect → Apply after you’ve done the paste, and it applies the autocorrect to the document, including what you just pasted.

So it does not happen as you paste, but it’s still a lot better than not doing it at all.