Bug 82212

(In reply to comment #0)
> Entering CTRL-End instantaneously moves the pointer to the cell at the
> intersection of the last row and last column that contain data. It would be
> ever so nice if there was a built-in "Category Spreadsheet" function that
> would return the reference of this cell, so that kludges like COUNTA() on
> rows and columns are no longer required. 

Seems like a fine request. Marking as such:

New
Enhancement
Low - not going to benefit the majority of users


> 
> The fact that the above key-combination works instantaneously leads me to
> believe that Calc holds already holds this information internally, which
> means that adding LASTCELL (and possibly LASTCOL/LASTROW) function(s) should
> be relatively easy.

Please don't assume - millions of lines of code can make something that "looks easy" quite hard. If you're willing to code it yourself, I can try to find you a mentor.

(In reply to comment #1)
> (In reply to comment #0)
> > Entering CTRL-End instantaneously moves the pointer to the cell at the
> > intersection of the last row and last column that contain data. It would be
> > ever so nice if there was a built-in "Category Spreadsheet" function that
> > would return the reference of this cell, so that kludges like COUNTA() on
> > rows and columns are no longer required. 
> 
> Seems like a fine request. Marking as such:
> 
> New
> Enhancement
> Low - not going to benefit the majority of users

ROFL - it's often mentioned that 80% of all users use no more than 20% of all functions. If

> > The fact that the above key-combination works instantaneously leads me to
> > believe that Calc holds already holds this information internally, which
> > means that adding LASTCELL (and possibly LASTCOL/LASTROW) function(s) should
> > be relatively easy.
> 
> Please don't assume - millions of lines of code can make something that
> "looks easy" quite hard. If you're willing to code it yourself, I can try to
> find you a mentor.

And the processing of CTRL-End requires millions of lines of code? As for coding it myself, I sadly only have nearly 30 years of experience with PL/I on z/OS and no interest in learning C or C++.