[sc-issues] [Issue 108441] New formula options for C alc

[discoleo]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108441


User discoleo changed the following:

What|Old value |New value

  CC|''|'discoleo'





--- Additional comments from disco...@openoffice.org Tue Jan 19 17:50:13 
+ 2010 ---
The generic issue is finding the last entry in a list/spreadsheet. Although Calc
does not support selecting a whole row or column (it always generates a
cellrange with start & stop-cells), lets suppose it is possible to select a
generic row or column. I will symbolize this as [Row_n] and [Column_n] (this is
different from Rows[1:MaxRow]).

The issue is then finding the last element in [Row_n] or in [Column_n].

The more generic range:
 [Row_ri:Row_rj][Column_ci:Column_cj] can be decomposed into:

 MAX(Column_ci:Column_cj] between the Rows [ri, rj]
 or
 MAX(Row_ri:Row_rj] berween the Columns [ci, cj]
depending on request to have the last horizontal, or last vertical element.

-
Actually, the more accurate function is:
 MAX(1:Column_cj] - MAX(1:(Column_ci-1)) between the Rows [ri, rj]

-
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[sc-issues] [Issue 108441] New formula options for C alc

[scottinsocal]

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 scottinso...@openoffice.org Mon Jan 18 
23:34:07 + 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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org