Is there a method for checking language in a cell in calc and sorting a column by language?
I use spreadsheets to maintain my flashcards for studying vocabulary, idioms, and the like in foreign languages. When I first started creating flash cards, I did so without much thought, but after some time decided to solidify the format. I have the word/phrase in one language in column A, and the other language in column B. However, due to the switch in method, I have a significant portion in each column in the wrong language.
Are there ways I could check for language using Calc's spellchecker or something of the like? And if so, beyond that is it possible to check for all languages in a cell? The idea being that highlighting if multiple languages are dedicated I can manually inspect them (as it's inevitable the same spelling is going to be found in both languages for a number of words and phrases).
If any other details are needed, please ask! :) Thanks in advance.