To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108441 Issue #|108441 Summary|New formula options for Calc Component|Spreadsheet Version|1.0.3 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|scottinsocal
------- Additional comments from [email protected] Mon Jan 18 23:34:07 +0000 2010 ------- I've switched to OpenOffice and love it. I gave away my license for Office2007, because I don't see myself going back. However, there's a feature for cell formulas that I've needed several times, and it would give you one up on MS. Last() and First() Given a range of cells in a row or column, it would return the first and last entry in the list. Optional: allow a second parameter that would specify top to bottom/left to right or bottom to top/right to left listing. Have it return whatever value is there - number, date, string, whatever. An extra added bonus would be stripping of intermixed null values. I need the last value in a random length list of items several times a day, and I've got a fairly complex - and fragile - formula I use for it. Personally I've never needed a First() value, but if there's a Last() it only makes sense that there would also be a First(). Use: =Last(A1:Z1,0) (read the values in cells A1 to Z1, return the last valid entry in the list, reading top to bottom) =Last(A1:Z1,1) (read the values in cells A1 to Z1, return the last valid entry in the list, reading bottom to top) If the second parameter isn't passed, assume TtB and LtR order. I don't program regularly in any language that would be useful to you, but it seems like it would be fairly easy to read the values in, convert to an array, strip null values, and return the last entry. Or first. --------------------------------------------------------------------- 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]
