Ask Your Question

row number in calc function [closed]

asked 2013-03-21 18:16:53 +0100

PhiJ gravatar image

updated 2013-03-22 23:51:32 +0100

I'm trying to make a function in calc that prints the row number of a cell. I tried creating the sequence:





and then dragging the formula downwards, but it just cycles 4 5 6 7 4 5 6 7.

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-27 12:32:11.880079


I fail to understand what it is that you want to achieve. Could you please be more specific on the expected results.

mahfiaz gravatar imagemahfiaz ( 2013-03-21 18:46:28 +0100 )edit

Sorry. I'm rubbish at writing and should really sit on my posts before rereading them and clicking submit. I'll edit it for clarity.

PhiJ gravatar imagePhiJ ( 2013-03-22 23:50:01 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-03-21 22:30:37 +0100

mahfiaz gravatar image
edit flag offensive delete link more

answered 2013-03-22 08:59:39 +0100

JohnSUN gravatar image

Try drag the formula downwards WITH HOLD DOWN CTRL-key

edit flag offensive delete link more

Question Tools


Asked: 2013-03-21 18:16:53 +0100

Seen: 10,067 times

Last updated: Mar 22 '13