How to select specified cells?

krakatoa · General User Joined: 17 Nov 2011 Posts: 8

Hello dear readers.

I have got a txt file, which has data output from some appliance in it. I need to chart these data. The problem is the data are dispersed throughout the file in a regular patern. Basicly I need to select from column B every other 5th cell. Then I would like to copy selected values to other column.

rrashkin · Posted: Thu Nov 17, 2011 10:09 am Post subject:

1. is "every other 5th cell" the same as "every 10th cell"?
2. you say you have a text file but you talk about the data like it's already in a spreadsheet, so where exactly is the data?
3. if I were going to go down column A and select every 10th cell between row 1 and, say, row42, I'd use:

krakatoa · General User Joined: 17 Nov 2011 Posts: 8

1. yes
2. I load the txt file as csv file in calc.
3. Can you please write whole macro?

If i write:

rrashkin · Posted: Thu Nov 17, 2011 10:59 am Post subject:

krakatoa · General User Joined: 17 Nov 2011 Posts: 8

Than I'd like make a column vector from these values. That means to put these values in column.

e.g. I want to select cells A1, A4, A7 (every 3rd cell) from:
A1 100
A2 15
A3 16
A4 20
A5 30
A6 40
A7 80
A8 45
A9 78

and put them in somwhere else e.g.:
B1 100
B2 20
B3 80

In R it is called array sliceing but its quite tedious and confusing to make chart in R from such data.

rrashkin · Posted: Thu Nov 17, 2011 12:04 pm Post subject:

gerard24 · Posted: Thu Nov 17, 2011 12:10 pm Post subject:

If you want every 3 rows beginning in row 1 :

krakatoa · General User Joined: 17 Nov 2011 Posts: 8

Thank you Bob. But I don't know how to use it. I run the macro but it does nothing. If you dont't have patience with me please tell me where to look for macro creating guide for beginners which is comprehensive.

krakatoa · General User Joined: 17 Nov 2011 Posts: 8

rrashkin · Posted: Thu Nov 17, 2011 12:41 pm Post subject:

I created a blank spreadsheet.
In Column A I entered
100
15
16
20
30
40
80
45
78

Then I went to the Macros:
alt+F11, then <this spreadsheet name>, then "standard", then "new"
In the new module I inserted the code so it looked like this:

krakatoa · General User Joined: 17 Nov 2011 Posts: 8

Yes it works.
Bob please how do I change column from which the macro takes values and column (place) where the macro puts selected data?

rrashkin · Posted: Thu Nov 17, 2011 12:53 pm Post subject:

in this: a= oSheet.getCellByPosition(0,i).value
"0" is the column (A) where the number is found.

In this: oSheet.getCellByPosition(1,n).value=a
"1" is the column (B) where the number is placed.
_________________
Bob Rashkin

krakatoa · General User Joined: 17 Nov 2011 Posts: 8

Wow. Powerfull. My problem is partialy solved. It does what I needed.

Also I would like to put selected data in new document or append to old one.

How did you learned macro programing?

rrashkin · Posted: Fri Nov 18, 2011 6:24 am Post subject:

BASIC is BASIC (ABASIC>GWBasic>VBA>OOBasic). I'm still struggling with the OOo API (star, uno, ... they're all just magical incantations to me).
_________________
Bob Rashkin