Bug 142227 - [EDITING] Image displayed in the wrong place when it is inside an outline-group and sheet is set to freeze-row-and-columns
Summary: [EDITING] Image displayed in the wrong place when it is inside an outline-gro...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-05-12 05:14 UTC by zzz
Modified: 2022-05-11 18:46 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
FoldTestFc3.ods (test data with image) (157.66 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-05-12 05:16 UTC, zzz
Details
FoldTestFc2.ods (test data with image) (175.77 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-05-12 05:20 UTC, zzz
Details
FoldTestFc3a_ods_screenshot.png (problem) (108.25 KB, image/png)
2021-05-12 05:22 UTC, zzz
Details
FoldTestFc2a_ods_screenshot.png (correct) (713.48 KB, image/png)
2021-05-12 05:24 UTC, zzz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description zzz 2021-05-12 05:14:05 UTC
Description:
Images pasted on the sheet are displayed far away from where it is actually anchored. This happens when the image is inside a folded outline, and the file is re-opened and then the outline is unfolded. Symptom most reproducible when the image is within the Freeze-Rows-And-Columns region.


Steps to Reproduce:
1. Open attached file FoldTestFd3.ods
2. On the left edge of the pane, click the "+" button in the outline-group indicator column "1", to unfold that outline-group.


Actual Results:
Only the edge of an image pasted onto the sheet is seen more than 30 lines above where it is supposed to be, almost invisible because most part of it is outside of the sheet.
You can know where it is supposed to be by clicking the fragment of the image, which will show its anchor.
FoldTestFc3a_ods_screenshot.png
Reproducibility: 100% (5/5)


Expected Results:
The image should be displayed with it's top-left corner anchored to cell B3.
FoldTestFc2a_ods_screenshot.png



Reproducible: Always


User Profile Reset: No



Additional Info:
(A) Happens with any image.
(B) How to create FoldTestFd3.ods:
  1. Download sample image file  https://www.libreoffice.org/assets/Uploads/Timeline-pics/berlin-conference.jpg
  2. In LibreCalc, File|New|Spreadsheet
  3. Paste that image file onto cell B3. Drag-and-drop it from Windows Explorer. Or, Copy-paste from apps such as IrfanView also works.
  4. Right-click on that image and Anchor|ToCell.
  5. Select row 3..33. Menu|Data|GroupAndOutline|Group. This will create the outline-group.
  6. Select cell B34. Menu|View|FreezeRowsAndColumns
  7. Fold the outline-group by clicking the "-" button in the left edge.
  8. Save that file.
  9. You must close the file once and re-open it, to observe the symptom. You don't need to close LibreCalc app, though.
(C) Once you unfold the outline group and save the file, and then re-open that file, it displays correctly. So the bug seems to be only in the display routine, not in the stored data.
(D) Symptom sometimes observed even when the sheet is not set to freeze-row-and-columns, but this is harder to reproduce.

p.s. Couldn't find "OpenGL" in settings menus.
Comment 1 zzz 2021-05-12 05:16:15 UTC
Created attachment 171902 [details]
FoldTestFc3.ods (test data with image)

test data with image, and outline folded
Comment 2 zzz 2021-05-12 05:20:18 UTC
Created attachment 171904 [details]
FoldTestFc2.ods (test data with image)

Test data with image, for comparision. Outline is unfolded, and this file shows no problem.
Comment 3 zzz 2021-05-12 05:22:38 UTC
Created attachment 171905 [details]
FoldTestFc3a_ods_screenshot.png (problem)

Screenshot of symptom, how the FoldTestFc3.ods (after unfolding) appears.
Comment 4 zzz 2021-05-12 05:24:32 UTC
Created attachment 171906 [details]
FoldTestFc2a_ods_screenshot.png (correct)

Screenshot of a correctly displaying example for comparison, FoldTestFc2.ods.
Comment 5 Oksana Ivanova 2021-07-31 22:02:59 UTC
no repro in

Windows 7

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: ac80ec817eb07c77a51bc0729985a473c734182e
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: en-US (ru_RU); UI: en-US
Calc: CL
Comment 6 Buovjaga 2022-05-11 14:36:16 UTC
(In reply to zzz from comment #0)
> Steps to Reproduce:
> 1. Open attached file FoldTestFd3.ods
> 2. On the left edge of the pane, click the "+" button in the outline-group
> indicator column "1", to unfold that outline-group.

I don't see the problem with your file. Can you re-test with 7.3?

Set to NEEDINFO.
Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.

Version: 7.3.3.2 (x64) / LibreOffice Community
Build ID: d1d0ea68f081ee2800a922cac8f79445e4603348
CPU threads: 2; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: fi-FI (fi_FI); UI: en-US
Calc: threaded
Comment 7 zzz 2022-05-11 15:46:08 UTC
Confirmed that FoldTestFc3.ods now works as expected so the problem has disappeared.

Version: 7.3.2.2 (x64) / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: en-US
Calc: CL