Ask Your Question

Counting Rows [closed]

asked 2012-08-30 20:39:32 +0100

Farmer Bob gravatar image

updated 2020-08-19 05:47:52 +0100

Alex Kemp gravatar image


I am trying trouble with the ROWS function in LO 3.5.0rc3 on my iMac. If I put the formula =ROWS($A$1:$A1) and copy and past it into cells A2 to A5 I get the following formulas: A2=ROWS($A$2:$A2) result =1 A3=ROWS($A$3:$A3) result =1 A4=ROWS($A$4:$A4) result =1
A5=ROWS($A$5:$A5) result =1

What I would expect and need is: A2=ROWS($A$1:$A2) result =2 A3=ROWS($A$1:$A3) result =3 A4=ROWS($A$1:$A4) result =4
A5=ROWS($A$1:$A5) result =5

For some reason the absolute cell reference to cell $A$1 does not stick. It does not matter which column I try it in. However if I save the file and open it in Open Office I can copy and paste the formula with no trouble, save the file, reopen in LO and it works fine. But that is a pain of a work around.

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-17 21:10:04.869847

1 Answer

Sort by » oldest newest most voted

answered 2012-08-30 22:11:14 +0100

m.a.riosv gravatar image

updated 2012-08-30 22:11:40 +0100

One option, reset the user profile:

And update an X.X.0rcX, is not a good option release.

edit flag offensive delete link more

Question Tools


Asked: 2012-08-30 20:39:32 +0100

Seen: 5,978 times

Last updated: Aug 30 '12