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
It changes data when used on data like “A 1”
Plz help! Thx!