Description: When I close the .xls and reopen it, the wrapping of the text in the cells is wrong. Steps to Reproduce: 1. Open the .xls file. 2. Correct the wrapping of the cells. 3. Save it. Close it and reopen it. Actual Results: The wrapping of the text is wrong. Expected Results: The wrapping of the text should be maintained. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: I even tried to copy the cells to a new .xls file, but with the same results. If you want I can send you the .xls file for testing. [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: yes [Copied from Help - About LibreOffice] Version: 6.2.0.3 (x64) Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62 CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; Locale: pt-PT (pt_PT); UI-Language: en-US Calc: threaded [Copied from OpenGL Extensions Viewer 5.2.0] Renderer: ATI Mobility Radeon HD 5730 Vendor: ATI Technologies Inc. Memory: 1024 MB Version: 3.1.9210 Forward-Compatible Context Shading language version: 1.50
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Created attachment 150013 [details] The .xls that shows the bug. The .xls that shows the bug.
Included the .xls file in attahcment.
(In reply to jcrmatos from comment #3) > Included the .xls file in attahcment. >2. Correct the wrapping of the cells. Please add a detailed description how the bug can be reproduced. Which cells did you format? Did you change row height and/or column width? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested info is provided.
I select column A to E, rows 38 to 45. I press the Wrap text button on the toolbar. The text looks fine. Save the file. Close the file. Re-open the file, and the text on column A and E is no longer correct. I don't change the column width or height in this process. If you want I can send you a print-screen of the before and after.
(In reply to jcrmatos from comment #5) > If you want I can send you a print-screen of the before and after. thanks, i can reproduce it with: Version: 6.1.5.2 (x64) Build ID: 90f8dcf33c87b3705e78202e3df5142b201bd805 CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: de-DE (de_DE); Calc: Version 3.6.7.2 (Build ID: e183d5b) and even with AOO 4.1.5 - open attached file - select cell A39 - press "Wrap Text" from Toolbar -> layout changes - save *.xls - reload *.xls btw: works if saved as *.ods file
Created attachment 152543 [details] Example xls document with wrapped text created with MS Office 2016 After export .xls file by LibreOffice, wrapped text are gone
Created attachment 152544 [details] Comparison of test.xls document under Libreoffice and MS Office 2016 It looks like the same document looks differently under LibreOffice and MS Office. It means that it is an import issue.
Dear jcrmatos, 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 with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. 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) from https://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: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Dear jcrmatos, 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 with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. 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) from https://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: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
(In reply to Oliver Brinzing from comment #6) > - open attached file > - select cell A39 > - press "Wrap Text" from Toolbar > -> layout changes > - save *.xls > - reload *.xls It still fails for these STR on the attached file from comment 2 – whether setting "wrap text" ON or OFF, the changed attribute is not saved to the file. The attribute (ON or OFF) is saved correctly in a new clean file (such as in attachment from comment 7). IDK what exactly triggers the problem. I wonder whether it can be reproduced with some other file, or in safe mode, or...
Let's consolidate into bug 97106. *** This bug has been marked as a duplicate of bug 97106 ***
This bug shows the Excel BUG of not being able to have multiline content without being wrapped. It can never be fully solved (limitation of MS implementation) but is being changed via bug 158460. This particular report seems more to do with Calc failing to set an optimal height on import - which is also an existing bug report so I won't bother making any changes to this bug's meta data.