Problem description: Steps to reproduce: 1. if cell[A5] > cell[A6] then font color = red 2. save file 3. reopen file : conditional formatting wasn't saved!! Current behavior: black font remains black Expected behavior: saved font color of red to remain as red Operating System: Linux (Other) Version: 4.1.3.2 release Last worked in: 4.1.1.2 release
Cannot confirm. Attached is a file created in 4.1.3.2, you'll see that B6 has a conditional format that is saved correctly and working. Marking as WFM Try resetting your profile https://wiki.documentfoundation.org/UserProfile If that still fails - what distro are you running and how did you install? Mark as UNCONFIRMED if resetting doesn't help & you answer the previous questions. Thanks!
Also please attach a sample document
Created attachment 91067 [details] Showing Conditional Formatting Working
Created attachment 91106 [details] clubchamp2013_withtemplates.ods Joel : I don't think it is my Profile because the problem occurs on both my home Laptop AND Desktop AND on my sports club's laptop. The first two are using Mageia 3 and the latter is MS Windows. (v4.1.4 first two; the latter is v4.1.3 I think). I will attach the ods spreadsheet that is problematic. If, for example, you choose '5 x 5tp' and highlight cells C4 across and down to L8 and then do ctrl-C (copy). Then go to 'Division 2' and highlight the same cells; do a Paste Special using only 'Formats' you will see the winning scores change to red. Now save and recall. THE SCORES ARE ALL BLACK AGAIN!! -------- Original Message -------- > Joel Madero <mailto:jmadero.dev@gmail.com> changed bug 72941 > <https://bugs.freedesktop.org/show_bug.cgi?id=72941> > What Removed Added > Status UNCONFIRMED RESOLVED > Resolution --- WORKSFORME > CC jmadero.dev@gmail.com > > *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=72941#c1> on bug 72941 > <https://bugs.freedesktop.org/show_bug.cgi?id=72941> from Joel Madero > <mailto:jmadero.dev@gmail.com> * > Cannot confirm. > Attached is a file created in 4.1.3.2, you'll see that B6 has a conditional > format that is saved correctly and working. > > Marking as WFM > > Try resetting your profilehttps://wiki.documentfoundation.org/UserProfile > > If that still fails - what distro are you running and how did you install? > > Mark as UNCONFIRMED if resetting doesn't help & you answer the previous > questions. > > > Thanks! > ---------------------------------------------------------------------------------------------------- > You are receiving this mail because: > > * You reported the bug. >
Thanks for the attachment - we'll move it back to UNCONFIRMED and someone (perhaps me) will check it out hopefully soon :-D
Not sure what to make of this. I just notice that in Joel's test document I find conditional formatting with Apply Style and a red box and that works, while in Mike's test document I do not see such conditional formatting. Testing further repro steps from comment4: * open clubchamp test doc * go to 5 x 5tp sheet * then what? "highlight the same cells"? Unclear. Please be as specific as possible. Just write down exact cells and re-rpo steps and we'll be happy to help testing. Please provide exact repro steps, after that set the bug to UNCONFIRMED.
Basically, copy the rectangle of cells from C4 : L8. This will/should include the conditional formatting formulae etc. Special Paste over the identical cells in 'Division 2' using only 'Formats'. The winning scores turn to red! This is correct. Save the spreadsheet and then exit it. Reload the spreadsheet and the red formatting has returned to black. THE LATTER IS THE PROBLEM!! -------- Original Message -------- > Foss <mailto:foss@openmailbox.org> changed bug 72941 > <https://bugs.freedesktop.org/show_bug.cgi?id=72941> > What Removed Added > Status UNCONFIRMED NEEDINFO > Ever confirmed 1 > > *Comment # 6 <https://bugs.freedesktop.org/show_bug.cgi?id=72941#c6> on bug 72941 > <https://bugs.freedesktop.org/show_bug.cgi?id=72941> from Foss <mailto:foss@openmailbox.org> * > Not sure what to make of this. I just notice that in Joel's test document I > find conditional formatting with Apply Style and a red box and that works, > while in Mike's test document I do not see such conditional formatting. > > Testing further repro steps fromcomment4 <show_bug.cgi?id=72941#c4>: > > * open clubchamp test doc > * go to 5 x 5tp sheet > * then what? "highlight the same cells"? Unclear. > > > Please be as specific as possible. Just write down exact cells and re-rpo steps > and we'll be happy to help testing. > > Please provide exact repro steps, after that set the bug to UNCONFIRMED. > ---------------------------------------------------------------------------------------------------- > You are receiving this mail because: > > * You reported the bug. >
changed platform to ALL according to comment 4 @Mike Finch please do not use your mailer to reply. drop new comments directly in the bugzilla page at this link: https://bugs.freedesktop.org/show_bug.cgi?id=72941
Not reproduced with LibO 4.2.0.1 rc1 on Win7 : after copy/paste, save, close and reload, the red scores remain red. I noticed a large number of cell styles (> 410). May it affect CALC behaviour in some situations ?
Found a close/resembling bug with conditional formatting. If the sheet name contains apostrophe ( division ' 2) , conditional formatting is lost on save ( Loo 4.1.5, windows 7 pro 64 bits). Same bug or do I need to open a new bug
This is almost positively a duplicate of another confirmed bug ( I don't have the #) and has been fixed in 4.2 - 4.1 is nearing EOL so if it's still a problem in 4.1 I wonder if it's going to be backported. Can someone else confirm that it works fine in 4.2? If so I'm tempted to mark as WORKSFORME
(In reply to comment #11) > This is almost positively a duplicate of another confirmed bug ( I don't > have the #) and has been fixed in 4.2 - 4.1 is nearing EOL so if it's still > a problem in 4.1 I wonder if it's going to be backported. > > Can someone else confirm that it works fine in 4.2? If so I'm tempted to > mark as WORKSFORME Tested with 4.2.2.1 and bug fixed for me( apostrophe in sheet prevent saving of conditional formatting). Sorry for my wrong search.
Migrating Whiteboard tags to Keywords: (possibleRegression) [NinjaEdit]