Issue 81686 - new formula proposed: last entry
Summary: new formula proposed: last entry
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-09-18 10:50 UTC by schultzm
Modified: 2013-08-07 15:12 UTC (History)
4 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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