https://bugs.documentfoundation.org/show_bug.cgi?id=147420
Bug ID: 147420
Summary: IMAGEs ANCHORed TO a CELL and selected with AUTOFILTER
are not displaying or PRINTING correctly
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have created a spreadsheet with multiple rows that can be selected together
from a single criteria, based on data in a single column, to produce a
printable page. The purpose is to be able to print different pages from the
same sheet simply by using different filter criteria selections.
When you start from all filter criteria selected, all rows showing, and then
deselect all criteria and then select a single criteria, the rows presented are
correct.
If you then deselect that criteria and then select a different criteria,
without first again selecting *all* criteria, the rows are not all selected
correctly.
The problem seems to revolve around rows that contain a cell with an anchored
image. Either the image that is selected is that which was associated with the
previous criteria or else both new and old images are selected, one on top of
the other. All other rows seem correctly selected.
Autofilter incorrectly selecting images anchored to cells on adjacent rows was
a problem I reported a couple of years ago. That seemed to have been fixed but
maybe this shows it hasn't been entirely fixed?
Steps to Reproduce:
1. Deselect all selection criteria from the selection column
2. Select the desired criteria and press OK
3. Rows selected are correct
4. Deselect the selected criteria
5. Select a new criteria and press OK
6. Rows selected are not all correct. A Row containing an anchored image
appears not to have "forgotten" the image previously selected
7. Deselect the new criteria and select *all* criteria and press OK
8. Deselect *all* criteria and once again select the new criteria. This time
the rows are presented correctly
Actual Results:
If a new criteria is selected immediately after deselecting an old criteria,
the incorrect image is presented
Expected Results:
I would expect the rows to be correctly selected without first having to go
through the additional requirement to reselect *all* criteria first
Reproducible: Always
User Profile Reset: No
Additional Info:
I can't find anything relevant in the Help. Everything else is working as
expected. The problem seems solely to do with cells containing anchored
images, and the action of criteria selection from an Autofilter drop-down list
--
You are receiving this mail because:
You are the assignee for the bug.
