What data types/format needs to be used for "remove duplicates" ?

Hi,

what are the requirements for the data type to successfully remove duplicates in Calc? And what format has to be used?

I am asking since I encountered several problems using this “no duplicates” filter function.

  • It does not work when: changing the number format, like decimal mark from “.” to m “,”

  • It does not work when: using long numbers like 1,124087102847107401824701E22
    or 5,17247120410710247091470197

  • It changes data when used on data like “A 1”

Plz help! Thx!

Please share a sample file to test.