Created attachment 113295 [details]
Picture anchored To Cell in XLSX created in MS Office
"Optimal row hight" command garbles picture in cell if picture is anchored To Cell.
That can be reproduced from scratch, if that picture is anchored To Cell. If other picture is anchored to Page it is normally seen.
In the attached XLSX file that was created in MS Office, pictures are already read as anchored To Cell.
I can not confirm with Version: 220.127.116.11.alpha0+
Build ID: 40432ac6caa478474d73786f95b808c14e106ff2
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-02-03_01:24:42
Please specify your version, OS and attach printscreen. Thank you.
Created attachment 113312 [details]
Upper picture anchored to Page, lower picture anchored to Cell
Created attachment 113313 [details]
Picture anchored to Page visible, picture anchored to Cell NOT visible after Optimal Row Hight
- insert 2 picture in Calc, one picture anchored to Page, other picture anchored to Cell (in different rows)
- select rows with pictures, right-click for "Optimal row hight", and OK on default value of 0,0 cm
- after Optimal row hight, you see that picture anchored to Page is visible, but picture anchored to Cell is NOT visible (shrunk to minimal cell height)
Tested on Win7 64bit, LO 4.3.6 and 4.4.0. Seems that started with 18.104.22.168. and that was OK on 22.214.171.124. Regression?
BTW, diff. versions seem that import pictures from attached file differently, anchored to Cell or Page, so that has to be set first.
*** This bug has been marked as a duplicate of bug 48123 ***
I don't see how Bug 89289 is a duplicate of Bug 48123.
Bug 89289 is about proper picture preview during "Optimal row hight" with anchor "To Cell", both for setting in LO or opening xls(x).
Bug 48123 is about keeping anchor "To Cell" when saving as XLS. And it seems resolved, please test and mark as WFM.
I marks as New again and kindly ask for 3rd opinion on those 2 bugs.
(In reply to Timur from comment #5)
> Tested on Win7 64bit, LO 4.3.6 and 4.4.0. Seems that started with 126.96.36.199.
> and that was OK on 188.8.131.52.
Too bad -- that's outside the bibisect range.
Whiteboard -> notBibisectable
Migrating Whiteboard tags to Keywords: (notBibisectable)
Not sure if that is really a bug. The image is not inside the cell and if you protect the size of the image (right click on the image, choose Position and Size), it will not be crushed when you apply "Optimal row height".
Best regards. JBF
Replacing keyword 'notBibisectable' by 'preBibisect' as this bug is outside the bibisect range
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice
(5.4.1 or 5.3.6 https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the version of LibreOffice and
your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave
a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
Same in 6.0+ and same dilemma: is this a bug or not per comment 11, which has grounds.
MSO doesn't have this anchors, AFAIK. On picture Properties it has:
- move and size with cells
- move but don't size with cells
- don't move or size with cells
MSO also doesn't seem to have Optimal Row Height (?) but we can put some small value there to test:
- move and size with cells behaves like Anchor to cell (picture shrunk)
- move but don't size with cells behaves like Anchor to page (picture intact)
- don't move or size with cells behaves like Protect Position and Size
I add Heiko to check. Maybe sometimes we can move from these anchor and protect terms to some descriptive result-oriented ones.
We must never distort images, that should only be done manually. But "Anchor > To cell" scales the image on resize of column or row. Doesn't happen for images anchored to the page.
My expectation is that an _anchored_ images keeps its size as it does in Writer. Default of row height there is 'Fit to size' taking the image into account. But it's possible to reduce the row height, where 'to character' shows the images in front of other content while 'as character' crops the bottom for smaller rows.
It makes sense to have only an equivalent of 'to character' in Calc. Meaning the image size is not bound to the cell size.
If we get _inline_ images, i.e. placed in the cell background, the situation is different. In that case the image scales and stretches with the cell size. And 'optimal row height' takes the image size into account, which doesn't in case of _anchored_.
(In reply to Timur from comment #14)
>- move and size with cells behaves like Anchor to cell (picture shrunk)
Rather the cell background 'inline' image
>- move but don't size with cells behaves like Anchor to page (picture intact)
Anchor to Cell
>- don't move or size with cells behaves like Protect Position and Size
Anchor to Page
It's now possible to anchor images to cell without resizing them with the cell: