[Bug 159615] Wrap text automatically works but does not save The wrap is gone when the file is opened XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=159615 ady changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |DUPLICATE --- Comment #11 from ady --- *** This bug has been marked as a duplicate of bug 97106 *** -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159615] Wrap text automatically works but does not save The wrap is gone when the file is opened XLSX
https://bugs.documentfoundation.org/show_bug.cgi?id=159615 ady changed: What|Removed |Added Summary|Wrap text automatically |Wrap text automatically |works but does not save |works but does not save |The wrap is gone when the |The wrap is gone when the |file is opened. |file is opened XLSX Keywords||filter:xls, filter:xlsx --- Comment #10 from ady --- So, not in ods. This is about exporting (saving) as XLSX (or XLS). -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159615] Wrap text automatically works but does not save The wrap is gone when the file is opened.
https://bugs.documentfoundation.org/show_bug.cgi?id=159615 --- Comment #9 from ifb...@hotmail.com --- Created attachment 192462 --> https://bugs.documentfoundation.org/attachment.cgi?id=192462=edit Example in Open Document format. The format issue does not happen when the file is saved in an Open Doc format. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159615] Wrap text automatically works but does not save The wrap is gone when the file is opened.
https://bugs.documentfoundation.org/show_bug.cgi?id=159615 --- Comment #8 from ifb...@hotmail.com --- Created attachment 192461 --> https://bugs.documentfoundation.org/attachment.cgi?id=192461=edit File saved as Excel Here is the file saved as excel -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159615] Wrap text automatically works but does not save The wrap is gone when the file is opened.
https://bugs.documentfoundation.org/show_bug.cgi?id=159615 --- Comment #7 from ady --- Just a comment regarding the Wrap Text cell attribute, FWIW. The Wrap Text changes the height of the cell, depending on the column width and the content (length) of the cell, *at the moment the Wrap Text attribute is applied*. If the IF() function changes the result of the cell (depending on whichever condition), the height of the cell remains as it was at the time the WT was initially applied. IOW, changing the result of the cell (depending on the condition for the IF() function) will not _automatically_ recalculate the height. Now, if you have a cell with text, and you manually edit the text and make it longer, then the cell's height can be extended; it might depend on others factors, especially related to the same row. OTOH, if you reduce the amount of text, the height of the cell is not automatically reduced. Setting Wrap Text OFF and then ON again on the cell, the height will be adapted again, according to the content of the cell at that moment. Using IF() means that the cell is not being edited, but instead its result changes according to the condition for that IF(). This is not the same as editing the content of the cell. In addition to this behavior, I believe that LO 24.2 improved/solved (at least partially) the behavior regarding Optimal Row Height and Optimal Column Width calculations. There are still things being improved for 24.2.1. Whether any of these changes might have some influence regarding Wrap Text behavior, IDK. I am not saying what should happen. I am just describing the behavior in Calc. Besides this behavior, there is the matter of whether the WT attribute is correctly saved as ods (or exported to xls(x) file format), which is the main question in this bug report. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159615] Wrap text automatically works but does not save The wrap is gone when the file is opened.
https://bugs.documentfoundation.org/show_bug.cgi?id=159615 --- Comment #6 from ifb...@hotmail.com --- I have learnt something. The issue I have does not occur if I save the file in Open document format. The issue is there if I save my file as an older style xlsx file format. I guess the older xlsx file format was not written to cope with such formatting. So it’s not a bug but a feature. I have created a 2 small worksheets that prove this. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159615] Wrap text automatically works but does not save The wrap is gone when the file is opened.
https://bugs.documentfoundation.org/show_bug.cgi?id=159615 --- Comment #5 from ifb...@hotmail.com --- If I increase the column width the result of my IF statement will fit the text into the cell with no problem. If I save the file with the column width extra wide then this is saved and the text fits. I will attach an example in the morning. It’s nearly midnight here. Thanks. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159615] Wrap text automatically works but does not save The wrap is gone when the file is opened.
https://bugs.documentfoundation.org/show_bug.cgi?id=159615 --- Comment #4 from ifb...@hotmail.com --- The spreadsheet is saved in .xlsx format. I will supply a cutdown version of my spreadsheet in the morning as an attachment The text shown in the cell as a result of an if statement does not fit the cell width. So I use the format option to spreadsheet over 2 lines in the cell. This works as it formats correctly on screen. I then save the spreadsheet. Then switch off the computer. Next day I start the computer and open the spreadsheet. The formatting that has saved has gone and I have a red pointing arrow indicating that the text does not fit in the cell. I can reformat the cell to get the alignment correct. So I wonder should I use a different format to save the file? I can try this tomorrow and load up an example. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159615] Wrap text automatically works but does not save The wrap is gone when the file is opened.
https://bugs.documentfoundation.org/show_bug.cgi?id=159615 --- Comment #3 from m_a_riosv --- (In reply to Rafael Lima from comment #2) > I can't reproduce this issue neither in 7.6 nor in 24.2. > > However I'm not sure I could understand the bug correctly. A sample file > would help a lot. Right, we don't know what file format is used to save. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159615] Wrap text automatically works but does not save The wrap is gone when the file is opened.
https://bugs.documentfoundation.org/show_bug.cgi?id=159615 Rafael Lima changed: What|Removed |Added CC||rafael.palma.l...@gmail.com --- Comment #2 from Rafael Lima --- I can't reproduce this issue neither in 7.6 nor in 24.2. However I'm not sure I could understand the bug correctly. A sample file would help a lot. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 159615] Wrap text automatically works but does not save The wrap is gone when the file is opened.
https://bugs.documentfoundation.org/show_bug.cgi?id=159615 m_a_riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #1 from m_a_riosv --- Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon. -- You are receiving this mail because: You are the assignee for the bug.