Bug 151129 - Overlapping images when PRINTING from a SHEET using AUTOSELECT
Summary: Overlapping images when PRINTING from a SHEET using AUTOSELECT
Status: RESOLVED DUPLICATE of bug 147420
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-09-22 11:22 UTC by Graham Tapper
Modified: 2024-03-25 11:59 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Test spreadsheet that displays the problem (1.81 MB, application/vnd.oasis.opendocument.spreadsheet)
2022-09-22 11:22 UTC, Graham Tapper
Details
Screenshot showing AUTOSELECT criteria chosen (209.36 KB, image/jpeg)
2022-09-22 11:26 UTC, Graham Tapper
Details
Screenshot showing the image row of the selection criteria. (189.28 KB, image/jpeg)
2022-09-22 11:28 UTC, Graham Tapper
Details
PRINT window, showing page as to be printed (214.15 KB, image/jpeg)
2022-09-22 11:30 UTC, Graham Tapper
Details
Screenshot of AUTOSELECT criteria for second print page (210.41 KB, image/jpeg)
2022-09-22 11:32 UTC, Graham Tapper
Details
Screenshot showing the image row of the new selection criteria. (198.43 KB, image/jpeg)
2022-09-22 11:34 UTC, Graham Tapper
Details
PRINT window, showing page as it will be printed (219.15 KB, image/jpeg)
2022-09-22 11:40 UTC, Graham Tapper
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Graham Tapper 2022-09-22 11:22:45 UTC
Created attachment 182617 [details]
Test spreadsheet that displays the problem

I have created a sheet where specific rows are selected by ticking AUTOSELECT criteria.  One of the rows contains an image anchored to a cell in that row.

When I view the resulting selected rows, all appears correct.  I select PRINT and the Print Image matches the displayed rows.

I then return to the AUTOSELECT criteria and change ONE of the parameters, to select a different set of rows, unticking the first rows selection.  When I view the resulting selected rows, all appears correct.  I then select PRINT and the Print Image displays TWO images, the one from the original selection criteria and on top of it and displaced from it, the image from the current selection criteria!

This is clearly wrong.
Comment 1 Graham Tapper 2022-09-22 11:26:04 UTC
Created attachment 182618 [details]
Screenshot showing AUTOSELECT criteria chosen

The screen shot shows the Cover Sheet sheet from which all prints emanate.  In this first example, *Heading, *Contact and Amber Hill have been selected.
Comment 2 Graham Tapper 2022-09-22 11:28:07 UTC
Created attachment 182619 [details]
Screenshot showing the image row of the selection criteria.

The selection criteria shows the correct image for the criteria chosen.
Comment 3 Graham Tapper 2022-09-22 11:30:09 UTC
Created attachment 182620 [details]
PRINT window, showing page as to be printed

The PRINT command displays the Print Image, as it will be printed.  The image displayed is correct.
Comment 4 Graham Tapper 2022-09-22 11:32:40 UTC
Created attachment 182621 [details]
Screenshot of AUTOSELECT criteria for second print page

Having printed the first page, return to the selection criteria, untick Amber Hill and tick instead Azalea.
Comment 5 Graham Tapper 2022-09-22 11:34:14 UTC
Created attachment 182622 [details]
Screenshot showing the image row of the new selection criteria.

The image displayed in the row chosen by the new selection criteria is correct, as expected.
Comment 6 Graham Tapper 2022-09-22 11:40:05 UTC
Created attachment 182623 [details]
PRINT window, showing page as it will be printed

Once again, the PRINT function for the page is chosen but this time the image displayed is incorrect.  It clearly shows that the image selected for the first print has failed to be removed and is visible peaking out below the image from the new selection criteria.
Comment 7 Buovjaga 2023-02-17 08:22:13 UTC
I reproduce, but this was actually broken with the first filtering in older versions. I bibisected with linux-64-7.1 and found the improvement to the current state was made in 1f0b3c7a40edfa81bbc7a58d123a6a2dfd83e4ca by Regina Henschel.

Adding Regina to CC, maybe she has ideas for making this even more robust.
Comment 8 Stéphane Guillou (stragu) 2024-03-25 11:59:01 UTC
Graham had already reported the issue in bug 147420.

*** This bug has been marked as a duplicate of bug 147420 ***