Issue 81686

Summary:	new formula proposed: last entry
Product:	Calc	Reporter:	schultzm <mail>
Component:	ui	Assignee:	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.

@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