Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||new formula proposed: last entry|
|Component:||ui||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||issues, ooo, openoffice, thomas.benisch|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
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