Bug 82212

Summary: Additional "Category Spreadsheet" function(s)
Product: LibreOffice Reporter: Robert <spamtrap>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: low CC: jmadero.dev
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
i915 platform: i915 features:

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

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.