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. 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.
(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++.