learned some time ago that there is a special symbol “…” different from three sequential separate dots! “…” which is often not spotted and has special functionality?
e.g. in one calcsheet at bug tdf#105314 this symbol being used in nearly all cells is suspected the reason why one cell having three dots instead not being found by filtering,
and when i just tried to paste the ellipsoid in a calc sheet, then a space and a second paste of that symbol, the space made the first symbol selected and overpasted, in a second attempt the first symbol disappeared on typing the space, thus getting “… " and " …” instead of “… …” ??? but not reproducible,
because the filter problem was also irregular - after exchanging the contents of the suspicious cell with another one, the previously irregular cell continued to be filtered out ???
i feel motivated to ask here if the symbol has any special functionality in calc or in windows or in general that prevents it from being used as a ‘normal’ character and which i should be aware of …
tia for any help,
P.S. in most fonts the ellipsis symbol is smaller than three separate dots, in the filtering bug it’s the other way around! hard to spot …