To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=83119
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |DUPLICATE
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Oct 30 13:10:55 +0000
2007 -------
Hi,
the problem is the filter range set by Excel. If Excel sets the Filter range
(needed for filter operations) to only one row, e.g. the developer of the
spreadsheet applied an autofilter just before some data was entered, Excel
automatically adds the new data to the range but did not store it with the file.
Therefore Calc and maybe other Applications can not set the Autofilter range
correctly. So you have two choices :
1.) Go to Data-Define range, select the Build in Autofilter range and modify the
values to the correct one. In your case to $I$111
2.) Remove the autofilter in Excel and apply it again.
This Issue is a double to Issue 55141
Frank
*** This issue has been marked as a duplicate of 55141 ***
---------------------------------------------------------------------
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]
