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 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.

edit retag flag offensive close merge delete

Comments

1

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