Bug Hunting Session
Bug 82212 - Additional "Category Spreadsheet" function(s)
Summary: Additional "Category Spreadsheet" function(s)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: low enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2014-08-05 21:42 UTC by Robert
Modified: 2017-07-11 22:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Robert 2014-08-05 21:42:19 UTC
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.
Comment 1 Joel Madero 2014-08-06 02:10:21 UTC
(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.
Comment 2 Robert 2014-08-08 22:30:48 UTC
(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++.