To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81686 Issue #|81686 Summary|new formula proposed: last entry Component|Formula editor Version|OOo 2.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P5 Subcomponent|code Assigned to|mru Reported by|schultzm
------- Additional comments from [EMAIL PROTECTED] Tue Sep 18 09:50:27 +0000 2007 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]