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 [email protected] Tue Jan 19 17:50:13
+0000 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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
