DDN (dotted decimal notation) dot manipulation by calc app

asked 2020-07-16 13:51:02 +0200

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

Explanation, writing in a cell works fine and stays as is. Writing 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.

edit retag flag offensive close merge delete



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.

Mike Kaganski gravatar imageMike Kaganski ( 2020-07-16 14:00:28 +0200 )edit

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

Harbinger gravatar imageHarbinger ( 2020-07-16 14:11:29 +0200 )edit