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

asked 2017-02-02 16:50:50 +0100

nc-SiOx gravatar image

updated 2017-02-02 16:51:31 +0100


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!

edit retag flag offensive close merge delete


Please share a sample file to test.

m.a.riosv gravatar imagem.a.riosv ( 2017-02-03 00:09:34 +0100 )edit