DDN (dotted decimal notation) dot manipulation by calc app

Using calc app for my (ipv4) networking needs and the application likes to eat my dots as it pleases!

Explanation, writing 255.255.255.0 in a cell works fine and stays as is. Writing 255.255.255.224 auto converts its into 255255255224

In general i think that if the DDN number doesn’t end in a zero it’ll just eat the dots.

Does your locale use dots as thousand separators? In which case, having them correctly dividing three digits would recognize the entered data as number (as intended).

If you want a column to contain some ids (like IPv4, which in the xxx.xxx.xxx.xxx notation is not a number, but rather an id), please format the column as text prior to entering the data.

Yeah formatting the cell/column/row as text solves my issue, thanks!