Issue 81686

Summary: new formula proposed: last entry
Product: Calc Reporter: schultzm <mail>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, ooo, openoffice, thomas.benisch
Version: OOo 2.3   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description schultzm 2007-09-18 10:50:27 UTC
AFAIK there is any easy formula to access the last entry in a given area.

What I'm looking for is the following:
Given a spreadsheet with an unknown number of entrys in a known area (i.e. adding a line per 
month). I want to adress the lowest filled line. At the moment, I have to do some workarounds. 
These work as long as I have a column which has a chronological order, because there is a 
formula for the highest value in an area (I don't know the english translation, it's KGROESSTE in 
german). It won't work - in this way - without this column (it contains the date in my example).

Therefor it would be a great enhancement, if OOo would provide a formula which adresses 
directly the last filled line / column in a known / unknown area.
Comment 1 michael.ruess 2007-09-18 12:29:25 UTC
More for spreadsheet than for Math.
Comment 2 frank 2007-09-18 15:10:37 UTC
so it's one for the requirements team.


Something for the UX iTeam ? Sounds easy to implement.

Comment 3 drking 2007-12-05 16:39:54 UTC
With B1:B10, starting at B1, and filling in numbers consecutively:


returns the last number filled in. Does that help? 

There are 2 hidden costs when adding new functions:
1. confuses the user (there are hundreds of functions already for a user to 
wade through)
2. introduces incompatibilty - so the spreadsheet cannot be exported to say 

I'd be very cautious about any new function...
Comment 4 thomas.benisch 2007-12-06 08:43:57 UTC
cc'd er