To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=66479
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Thu Jun 15 07:47:00 -0700
2006 -------
Hi,
the first line with the countif shows as =COUNTIF('Note onorarie'.B4:B53;A4)
the second line shows =COUNTIF('Note onorarie'.B5:B54;A5). Note that also the
range reference is increased by one not only the criteria cell reference. This
is also valid for all the other countif cells. To avoid this just make the
cellrange absolute so it reads like =COUNTIF('Note onorarie'.$B$4:$B$54;A4)
before you dragcopy it down.
Frank
---------------------------------------------------------------------
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]
