Issue 81686 - new formula proposed: last entry
Summary: new formula proposed: last entry
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-09-18 10:50 UTC by schultzm
Modified: 2013-08-07 15:12 UTC (History)
4 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

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.

@tbe

Something for the UX iTeam ? Sounds easy to implement.

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

=OFFSET(B1;SUMPRODUCT(ISNUMBER(B1:B10))-1;0)

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 
Excel

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