openoffice-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject [Issue 125031] Replace All hits rows hidden by filter
Date Mon, 02 Jun 2014 19:02:00 GMT

Marcus <> changed:

           What    |Removed                     |Added
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |DUPLICATE

--- Comment #2 from Marcus <> ---
It's not a bug but a normal and wanted behavior. The reason is simple:

A filter gives you only another view of the data but does not modify the data

There are a few other issues (e.g., 118008, 105974, 101011).

You can find this also in the help (topic: "AutoFilter function;applying"):

When you select multiple rows from an area where a filter was applied, then
this selection can include rows that are visible and rows that are hidden by
the filter. If you then apply formatting, or delete the selected rows, this
action then applies only to the visible rows. The hidden rows are not affected.

So, this is no bug but a wanted and correct working behavior.

The solution for you is to output the filtered data on a different place. Then
only the filtered data is shown and editing these is affecting only these, too.

See menu "Data - Filter - Standard Filter", click on button [More Options],
check "Copy results to" and click into the spreadsheet to define the start cell
for the output.

*** This issue has been marked as a duplicate of issue 118008 ***

You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

View raw message