To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=74434
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Feb 13 10:15:50 +0000
2007 -------
Hi,
this behaviour is not a defect. The guy who has produced this document has
probably linked content of three sheets to another worksheet, deleted the sheet
with the refferenced cells and inserted two sheets after that. The result is
that the same three sheets exist twice, with different names and three of them
hidden, but they exist in the used range for the SUM(). So the result is
correct.
Have a look at the left area of the statusbar, you will see that the document
contains eight sheets but only five are shown. Go to Formmat-Sheet-Show and
select all Sheets shown here. Press Ok and have a look at the values and the
position of the sheets.
Deleting or moving the former hidden sheets to the End position and therefore
out of the summation range will give you the expected result.
The solution used by Calc for storing linked data is not optimal in this case
and is on the agenda for a later version of OOo.
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]
