Ask Your Question
0

Coordinate Input [closed]

asked 2012-07-25 19:48:16 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I'm writing an ecosystem computer model where each cell on a grid needs to have specified values. Is there a way that, given the x and y size of the grid, I can automatically generate a column of all of the coordinates that I can then assign value to in the corresponding rows.

Ex: For a 50x50 grid, once given the size, the spreadsheet would automatically create either one column with 2500 entries like (0,0) (0,1) (0,2).....

Or it would create two column, each with 2500 like 0 0 0 1 0 2...

Any ideas?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-23 13:40:14.595062

Comments

1

Sometimes LO isn't the best solution. You might use a bash script to generate a csv file that LO could read. E.g. for i in $(seq 0 49); do for j in $(seq 0 49); do echo $i, $j; done; done > output.csv

w_whalley gravatar imagew_whalley ( 2012-07-25 21:13:59 +0200 )edit

@w_whalley, Could you please turn your comment into an answer so we can resolve this question? Thanks!

qubit gravatar imagequbit ( 2013-01-29 10:17:06 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2013-01-30 20:38:41 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Sometimes LO isn't the best solution. You might use a bash script to generate a csv file that LO could read. E.g.

for i in $(seq 0 49); do for j in $(seq 0 49); do echo $i, $j; done; done > output.csv
edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-07-25 19:48:16 +0200

Seen: 137 times

Last updated: Feb 24 '13