Ask Your Question

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

asked 2016-09-21 01:04:28 +0200

idshanks gravatar image

updated 2016-09-21 01:05:26 +0200

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.

edit retag flag offensive close merge delete

1 answer

Sort by » oldest newest most voted

answered 2016-09-22 14:28:47 +0200

pierre-yves samyn gravatar image

updated 2016-10-21 10:42:27 +0200


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 ( 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


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-09-21 01:04:28 +0200

Seen: 166 times

Last updated: Oct 21 '16