Is there a method for checking language in a cell in calc and sorting a column by language?

[idshanks]

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.

[PYS]

Hi

You can use a macro… In locale.ods attached, I created a user function LOCALE.

2 Arguments:

• reference of the cell to be inspected (use CELL function to calculate this and to be able to copy the function)
• “scope” (optional) if omitted or 0 returns the language set for the cell, if 1 returns all langages in the cell.

Note: I discover a bug in my version (5.2.1.2 windows) while writing this program. Language set for portions of text lost after saving. This is a regression…

[EDIT 2016-10-21]

Thank you to Eike Rathke, the bug has been fixed see tdf#102357

Regards