The dialogue that allows to format cells shows inconsistent behaviour when handling the options "Wrap text automatically" and "Shrink to fit cell size". How to reproduce: Open Calc, select some cell. Open the "Format Cells" dialog (select Format -> Cells... or press CTRL+1). Select the "Alignment" tab. Below the "Properties" header you will find two check boxes labeled "Wrap text automatically" and "Shrink to fit cell size". If the cell is not formatted, both are unchecked, and both are active. Check "Wrap text automatically". This disables the "Shrink to fit cell size" check box. Therefore you cannot change it. Uncheck "Wrap text automatically". "Shrink to fit cell size" is now enabled again. Check it. Wrap text automatically" remains enabled, so you can now check it. Now both controls are checked. It is not clear what the intended behaviour of this mechanism is: Are "Wrap text automatically" and "Shrink to fit cell size" mutually exclusive? I saw some cases where the text uses some smaller font when "Shrink to fit cell size" is enabled but the text still gets truncated (see bug 84012). When a smaller font is used more lines may fit into a cell. This effect could be used to show the complete content. So the combination of "Wrap text automatically" and "Shrink to fit cell size" could make sense too. On the other hand, when both controls are checked, the text does not use a smaller font, so the state of the "Shink to fit cell size" control seems to be ignored. The expected behaviour should convey clearly what the intended behaviour is. If both features are mutually exclusive then the interface should make sure that at most one control is checked. If Calc supports a combination of both features then there is no need to disable one of the check boxes. This is what I would consider the better solution. Observed with Version 4.2.6.3 on Windows 7 (64 Bit)
Reproducible with Version: 4.3.3.0.0+ Linux
** 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.0.1 or preferably 5.0.2.2 or later) 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) http://downloadarchive.documentfoundation.org/libreoffice/old/ 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 your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-10-14
Problem is still there with version Version: 4.4.4.3 Build-ID: 2c39ebcf046445232b798108aa8a7e7d89552ea8 BTW: In the German version the text "Shrink to fit cell size" appears as "An Zellgröße anpassen". This translation has a somewhat different meaning. The English version states that the cell size will be reduced, the German version includes both reduction and enlargement of cell size. I don't know which version describes the actual behaviour.
** 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.1.6 or 5.2.3 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) http://downloadarchive.documentfoundation.org/libreoffice/old/ 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! Warm Regards, QA Team MassPing-UntouchedBug-20161108
This behavior is inherited from OO and is still the same in master LO 6.0+. It looks logical: "Wrap text" and "Shrink to fit" are separate options, but if "Wrap text" is used then "Shrink to fit" is not available, only last state is remembered. You say "the interface should make sure that at most one control is checked" but how exactly? Do you have a mockup? It's not radio and this way is OK. And I find keeping that last state useful. I cannot conceive a practical implementation of "the combination could make sense too". If wrap is on, how will LO know what size of shrinked text you want? What could be improved, although it's self-explanatory on usage, is to amend documentation at https://help.libreoffice.org/index.php?title=Common/Alignment_1 to say in "Shrink to fit cell size" also: "You cannot apply this command to a cell that has text wrapped". When this bug was confirmed, it was more reproduced then analyzed and questioned. So, I'll close as NotABug and cc people who may object here.
Yes wrap simply disables/overwrites the effect of shrink when it is enabled, but retains the check/uncheck setting of shrink for when wrap is disabled. This makes sense and is also how Excel functions.