Bug 141605 - Images anchored to a cell and selected with AutoFilter are not PRINTING correctly
Summary: Images anchored to a cell and selected with AutoFilter are not PRINTING corre...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-04-10 11:58 UTC by Graham Tapper
Modified: 2021-08-05 12:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot of sheet with AutoFilter invoked (237.51 KB, image/jpeg)
2021-04-10 12:01 UTC, Graham Tapper
Details
Screenshot of sheet with Print Preview invoked (86.44 KB, image/jpeg)
2021-04-10 12:02 UTC, Graham Tapper
Details
Screenshot of sheet with Print invoked (185.09 KB, image/jpeg)
2021-04-10 12:04 UTC, Graham Tapper
Details
Test File (262.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-08-03 12:45 UTC, Graham Tapper
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Graham Tapper 2021-04-10 11:58:20 UTC
Description:
I have created a spreadsheet with data and images.  

The images are each anchored to a specific cell on the same row as the AutoFilter selection data for that row.  

When I auto-filter to specific data in a column, the rows that relate appear correctly, including the image for that selection.  When I run Print Preview the image presented as it would print, also appears correctly. 

When I then go to actually print the image selected, the images shown are all wrong.  Instead of the individual image shown in Print Preview, what is shown is a composite of all of the images anchored to all of the cells, one on top of the other. The topmost image is that anchored to the highest numbered row.

If I then go on to actually print the page, that is also what is printed.

Steps to Reproduce:
1. Define sheet with images anchored to cells and with associated selectable data in another cell on the same row.  Do this with multiple rows and different selectable data
2. AutoFilter to a specific item of data. The relevant image appears on the screen
3. Click Print Preview to confirm that image and only that image appears
4. Click Print and check the print image shown - contains *all* images instead of just one

Actual Results:
Print prints a composite of layer upon layer of all images instead of just the selected image

Expected Results:
Expect the print image to be as shown by Print Preview, i.e. just the selected image shown


Reproducible: Always


User Profile Reset: No



Additional Info:
As described.  I haven't reset my Profile.  This is clearly not relevant to this bug.  I can provide screenshots to confirm my findings.
Comment 1 Graham Tapper 2021-04-10 12:01:14 UTC
Created attachment 171079 [details]
Screenshot of sheet with AutoFilter invoked

This is what I see when I run AutoFilter.  The correct image is selected
Comment 2 Graham Tapper 2021-04-10 12:02:53 UTC
Created attachment 171080 [details]
Screenshot of sheet with Print Preview invoked

Again, the correct image is shown
Comment 3 Graham Tapper 2021-04-10 12:04:28 UTC
Created attachment 171081 [details]
Screenshot of sheet with Print invoked

This time, the images are all wrong.  Every image is shown, layered, with the image anchored to the highest numbered row on top
Comment 4 Graham Tapper 2021-04-10 12:37:44 UTC
I have installed Ver 7.1.2.2 and retested.  The bug still exists.
Comment 5 Hanna Yefremova 2021-08-03 09:30:53 UTC
Thanks for reporting the bug.
You can attach the file you worked with for more correct testing.
I have set the error status to "NEEDINFO". Please change it back to "UNCONFIRMED" after attaching the file.
Comment 6 Graham Tapper 2021-08-03 12:45:59 UTC
Created attachment 174044 [details]
Test File

This is a copy of the file that revealed the problem.  It is not the original but identical, all except for the removal of personal information to ensure GDPR compliance
Comment 7 Graham Tapper 2021-08-03 12:51:12 UTC
I have today upgraded LibreInfo to Rel 7.1.5.2 and retested.  I can confirm that at this release level the problem no longer reveals.  It would appear that a fix has been applied that resolves the overlapping anchored images on Print issue.  Feel free to use the test file I have supplied to confirm, against the reported and the latest releases
Comment 8 QA Administrators 2021-08-04 03:46:37 UTC Comment hidden (obsolete)