Created attachment 40396 [details]
The spreadsheet has a macro to change the student photo automatically
I have a spreadsheet with the photos of my students and they are anchored in a cell.
When I zoom in or out the position of the images or other drawing objects change.
This is very annoying and is a bug that doesn't happens in Go-OOo 3.2.1.
I haven't tested this in other plataforms... just Ubuntu 10.10 (32 bits)
libo3.3 beta 3
Confirmed. E.g. the 'niveis por periodo' moves up and down, depending on zoom level. Kohei, please have a look.
Sorry, I don't see what the problem is. When I zoom in and out, the images stay where they are...
Can you give me more detail? Perhaps the screenshots of the images moving would be great.
Created attachment 40407 [details]
Screenshots where you can see images changing position
Please see the new attachment named screenshots.pdf.
Screenshots where you can see images changing positions.
I didn't test this in the OOo3.3 RC
Thanks for the screenshot. This helps.
However, I'm still not seeing what the screenshot shows...
The release beta3 shows the object moving up and down. I'm using the latest dev build which is newer than beta3, and that build doesn't exhibit the problem.
Perhaps already fixed (by Oracle)?
This may be what fixed this:
which comes from Oracle's Open Office code, which just missed the tag for beta 3 by one commit (!)
I've tested this in OpenOffice.org 3.3 RC6 and it's fixed.
Should I wait for the next beta/rc of libo?
Yes please. We're merging the OOo fixes when they become available in milestones.
Solved in LibO RC1
Setting it FIXED per comment #10.
Verified - Closed - Sophie
This is a Calc issue, therefore changed 'Component' accordingly.
Zooming is again erratic on Libreoffice 4.1, 4.2, 4.3 on the Y axis, for pictures inside high height cells.
The fix in /sc/source/ui/view/drawview.cxx :
- if (nEndRow<1000)
+ if (nEndRow<20)
has been reverted by
To reproduce :
- load Image_y_axis_zoom_preview_problem.xls
- Select the last image
- Zoom in and out, notice how the selection corners move on the Y axis
- Launch a preview, the pictures at the bottom are not at the right position
If you apply the attached patch correction (done in AOO on bug #i116848#), zomming and preview are correct.
(Tested on linux 64 , libreoffice 22.214.171.124.alpha0+ Build ID: ccd765079ae573d24ded2a07ec434e4e89b619a2 )
Note that on the spreadsheet ERROR-1.ods attached in the bug, the problem is not visible, with or without the correction.
You should have huge cell height, and anchored picture fit inside. More the cell is far from the top, more the problem is visible.
Created attachment 95757 [details]
Created attachment 95760 [details]
spreadsheet with Y position during zooming problem and wrong picture Y position in preview
Comment on attachment 95757 [details]
>Zooming is again erratic on Libreoffice 4.1, 4.2, 4.3 on the Y axis, for pictures inside high height cells.
>The fix in /sc/source/ui/view/drawview.cxx :
>- if (nEndRow<1000)
>+ if (nEndRow<20)
>has been reverted by
>To reproduce :
>- load Image_y_axis_zoom_preview_problem.xls
>- Select the last image
>- Zoom in and out, notice how the selection corners move on the Y axis
>- Launch a preview, the pictures at the bottom are not at the right position
>If you apply the correction done in AOO on bug #i116848#, zomming and preview are correct.
>(Tested on linux 64 , libreoffice 126.96.36.199.alpha0+ Build ID: ccd765079ae573d24ded2a07ec434e4e89b619a2 )
>Note that on the spreadsheet ERROR-1.ods attached in the bug, the problem is not visible, with or without the correction.
>You should have huge cell height, and anchored picture fit inside. More the cell is far from the top, more the problem is visible.
Created attachment 95761 [details]
patch for correct Y picture position with zoom
NEVER reopen a bug report against such an old version. Please file a brand new bug.