Description: I have a spreadsheet with 5 different types of conditional formatting in some columns. The program simply does not save the styles you choose for each condition. When you close and open the software again, your choices are preserved, but the styles you picked/created are substituted by at style with the same characteristics named "ConditionalStyle_1" (and subsequent numbers). After you open and close your spreadsheet a few times (or, after waiting a few days), these automatically created styles are reset. They still exist, but all specific formatting is erased and the text reverts to default. The practical consequence of this is that you have to keep redoing your Conditional Formatting from time to time. Actual Results: I have not tried to reproduce it. I am short of time and not such a skilled user. Expected Results: I have not tried to reproduce it. I am short of time and not such a skilled user. Reproducible: Didn't try User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Version: 6.0.7.3 Build ID: 1:6.0.7-0ubuntu0.18.04.10 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: en-GB (en_US.UTF-8); Calc: group
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.)
(In reply to lcfreitasf from comment #0) > Description: > I have a spreadsheet with 5 different types of conditional formatting in > some columns. > > The program simply does not save the styles you choose for each condition. > When you close and open the software again, your choices are preserved, but > the styles you picked/created are substituted by at style with the same > characteristics named "ConditionalStyle_1" (and subsequent numbers). > "ConditionalStyle_1" - this makes me assume you save using .xlsx (MS Excel) format or at least your file has a history with MS Excel (Created by Excel / converted from Excel format)? If yes - then your observation is a consequence of the conversion process from one document mode into the other and from my perspective not a bug. Did you try so save in LibreOffice ODF format (.ods)?
(In reply to Xisco Faulí from comment #1) > 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.) Hi Xisco, if I understand well, I should upload the document where the bug is happening? Thank you!
(In reply to Uwe Auer from comment #2) > (In reply to lcfreitasf from comment #0) > > Description: > > I have a spreadsheet with 5 different types of conditional formatting in > > some columns. > > > > The program simply does not save the styles you choose for each condition. > > When you close and open the software again, your choices are preserved, but > > the styles you picked/created are substituted by at style with the same > > characteristics named "ConditionalStyle_1" (and subsequent numbers). > > > > > "ConditionalStyle_1" - this makes me assume you save using .xlsx (MS Excel) > format or at least your file has a history with MS Excel (Created by Excel / > converted from Excel format)? If yes - then your observation is a > consequence of the conversion process from one document mode into the other > and from my perspective not a bug. > > Did you try so save in LibreOffice ODF format (.ods)? You are correct that it is a .xlsx file, but I never used MS Excel to create, open or edit the document, only Libre Office. I will try saving in .ods.
(In reply to Uwe Auer from comment #2) > > "ConditionalStyle_1" - this makes me assume you save using .xlsx (MS Excel) > format or at least your file has a history with MS Excel (Created by Excel / > converted from Excel format)? If yes - then your observation is a > consequence of the conversion process from one document mode into the other > and from my perspective not a bug. > Indeed, see: https://bugs.documentfoundation.org/show_bug.cgi?id=124788#c5
(In reply to NISZ LibreOffice Team from comment #5) > (In reply to Uwe Auer from comment #2) > > > > "ConditionalStyle_1" - this makes me assume you save using .xlsx (MS Excel) > > format or at least your file has a history with MS Excel (Created by Excel / > > converted from Excel format)? If yes - then your observation is a > > consequence of the conversion process from one document mode into the other > > and from my perspective not a bug. > > > > Indeed, see: > https://bugs.documentfoundation.org/show_bug.cgi?id=124788#c5 Thanks. This is exactly what is happening to me, with one expection: "So it is normal to see the style "Good" becoming "ConditionalStyle_3" - but that's only the name: the font color and background color is retained and works fine after opening in Excel too." To me, after opening and closing the file a few times, or waiting a few days, the "ConditionalStyle_N" styles are reset to default and I lose the formatting. Regardless, I will save all in .ods from now on.
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to lcfreitasf from comment #6) > > To me, after opening and closing the file a few times, or waiting a few > days, the "ConditionalStyle_N" styles are reset to default and I lose the > formatting. > How can I reproduce it? Please provide test file and instructions. Thanks
Dear lcfreitasf, 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 INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/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 MassPing-NeedInfo-Ping
Dear lcfreitasf, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp