A document with formatted (word wrap, adjustment etc) empty cells (yes, it is important to continue write in the document and get the same looks) is saved in Excel 97/2000/XP/2003 format (also important since the document is shared between computers with different offiec installations). When the document is reopened the formatting is lost.
Hello @micke, Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (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.)
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/FDO/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team This NEEDINFO message was generated on: 2015-09-03
Hi @micke, please some hint about this.
Created attachment 118453 [details] .ods version, keeps cell format This is a very simple spreadsheet I started with. As you can see, rows 2 and three keeps the format (col1 fat, col 2 right adjust, col 3 wrap) between close and open. This is as it should work.
Created attachment 118454 [details] .xls version, BUG, drops format between close and open This is the same spreadsheet as my recent .ods attachment, only saved in Microsoft Excel 97/XP... format (.xls). As is very apparent, the formatting in rows 2 and 3 is gone. You can format e.g. col 1 to fat, col 2 to right adjusted, and maybe all rows to top adjustment and word wrap. Then write something in the cells and you see that the format is ok. Delete just the test text you wrote, save the document and close it. Reopen it, and write test text in the recently formatted cells. Voila, the formatting is gone !
Hi ! I have changed the LO version to 4.3.3.2 since that's what I have. I do not know if this bug is still in the latest version. I have attached two files with comments, the bug is very simple to reproduce. Just make a spreadsheet and format empty cells (adjusstments, word wrap etc) and save the document in .xls format (MS Escel 97/XP/2003). Close the document and reopen it and the formatting is gone. Every change INCLUDING cell formatting shall be kept when saving a document regardless of document type.
Hi ! I have changed the LO version to 4.3.3.2 since that's what I have. I do not know if this bug is still in the latest version. I have attached two files with comments, the bug is very simple to reproduce. Just make a spreadsheet and format empty cells (adjusstments, word wrap etc) and save the document in .xls format (MS Excel 97/XP/2003). Close the document and reopen it and the formatting is gone. Every change INCLUDING cell formatting shall be kept when saving a document regardless of document type.
(In reply to micke_wahlberg from comment #6) > Hi ! > I have changed the LO version to 4.3.3.2 since that's what I have. I do not > know if this bug is still in the latest version. > I have attached two files with comments, the bug is very simple to reproduce. > Just make a spreadsheet and format empty cells (adjusstments, word wrap etc) > and save the document in .xls format (MS Escel 97/XP/2003). Close the > document and reopen it and the formatting is gone. Every change INCLUDING > cell formatting shall be kept when saving a document regardless of document > type. I spelled Excel wrong in this comment. Is it possible to remove comments ? I did not find a way within one minute....
Win10 Version: 4.3.7.2 Build ID: 8a35821d8636a03b8bf4e15b48f59794652c68ba and Version: 5.0.1.2 (x64) Build ID: 81898c9f5c0d43f3473ba111d7b351050be20261 formats in xls are opened like with the ods, the only difference is the font "Arial" for xls, and "Liberations Sans" for ods. If you can update the version, all versions here: http://downloadarchive.documentfoundation.org/libreoffice/old/?C=M;O=D otherwise please try resetting the user profile, sometimes solves strange issues. https://wiki.documentfoundation.org/UserProfile
Resolved, three months without any input from reporter. Please if bug remain with last versions, open it again.