Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

IP Address auto fill

It's 2015 and apparently Numbers still doesn't understand IP addresses as a series of numbers. Experience in another spreadsheet says I should be able to start a column like this:


10.10.10.1

10.10.10.2

10.10.10.3


Then grab the bottom cell and use auto-fill to drag on down and it will correctly add


10.10.10.4

10.10.10.5....


and so on.


But not Numbers!


I'm running 3.5.3 (2150)


Any tips on how to make this happen with scripting or other programming? How does Apple not recognize IP addresses as a data type?

Posted on Oct 9, 2015 9:55 AM

Reply
Question marked as Best reply

Posted on Oct 9, 2015 11:31 AM

You could consider a custom format for this.


1. Select the cells were you want IP addresses.


2. Click 'Create Custom Format' here:

User uploaded file


3: Make your format look like this:


User uploaded file


To reduce the number of digits make a choice from this contextual menu:



User uploaded file



4. Apply the custom format to the cells.


5. Enter consecutive values in two cells (you don't have to enter the . separators since you have those in the custom format).


6. Select the two cells and pull the 'dot' down the column to fill as you would with a number.


User uploaded file


SG

4 replies
Question marked as Best reply

Oct 9, 2015 11:31 AM in response to CyberNorris

You could consider a custom format for this.


1. Select the cells were you want IP addresses.


2. Click 'Create Custom Format' here:

User uploaded file


3: Make your format look like this:


User uploaded file


To reduce the number of digits make a choice from this contextual menu:



User uploaded file



4. Apply the custom format to the cells.


5. Enter consecutive values in two cells (you don't have to enter the . separators since you have those in the custom format).


6. Select the two cells and pull the 'dot' down the column to fill as you would with a number.


User uploaded file


SG

Oct 11, 2015 2:56 AM in response to CyberNorris

Now that you asked for scripting solution, here's a shell script to generate IP addresses in a given range. Run the script and it will put the generated addresses in the clipboard which you may paste into target range.



#!/bin/bash printf '%s\n' 10.10.10.{1..100} | pbcopy




In case, here's an AppleScript wrapper.



do shell script "printf '%s\\n' 10.10.10.{1..100} | pbcopy"




H

IP Address auto fill

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.