[Libreoffice-bugs] [Bug 84927] Calc - Errors in function Conditional Formatting
https://bugs.freedesktop.org/show_bug.cgi?id=84927 Markus Mohrhard markus.mohrh...@googlemail.com changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |DUPLICATE --- Comment #7 from Markus Mohrhard markus.mohrh...@googlemail.com --- *** This bug has been marked as a duplicate of bug 86253 *** -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 84927] Calc - Errors in function Conditional Formatting
https://bugs.freedesktop.org/show_bug.cgi?id=84927 --- Comment #6 from Markus Mohrhard markus.mohrh...@googlemail.com --- Looks like another duplicate of Bug 86253. I tested the sheet after fixing the bug and it seems that I can't reproduce the issue anymore. Please retest as soon as the fix appears in a daily build. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 84927] Calc - Errors in function Conditional Formatting
https://bugs.freedesktop.org/show_bug.cgi?id=84927 Beluga todven...@suomi24.fi changed: What|Removed |Added CC||todven...@suomi24.fi Whiteboard||bibisected -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 84927] Calc - Errors in function Conditional Formatting
https://bugs.freedesktop.org/show_bug.cgi?id=84927 Jacques Guilleron guillero...@aol.com changed: What|Removed |Added Keywords||regression Status|NEEDINFO|NEW Hardware|x86-64 (AMD64) |All OS|Linux (All) |All --- Comment #3 from Jacques Guilleron guillero...@aol.com --- Hi Llogic, You are right. Conditional format is applied but not recorded with paintbrush in LO 4.3.2.1 Build ID: f9b3ad49d92181b0a1fe7e76f785a2c2cd0847d3 Windows 7 Home Premium. Works as expected with LO 4.2.7.0.0+ Build ID: 92216be6ce13990b8ea6b6264c656d2bc1746401 TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-07-14_16:21:42 Set the Status to NEW, Hardware to ALL and Keywords to regression. Regards, Jacques -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 84927] Calc - Errors in function Conditional Formatting
https://bugs.freedesktop.org/show_bug.cgi?id=84927 --- Comment #4 from Llogic lazylo...@gmail.com --- Hi Jacques, thanks for confirmation. just curious, what is the next step? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 84927] Calc - Errors in function Conditional Formatting
https://bugs.freedesktop.org/show_bug.cgi?id=84927 --- Comment #5 from Jacques Guilleron guillero...@aol.com --- First version found with applied and non-recorded paintbrush: LO 4.3.0.0.beta1 Build ID: b7cfa1eab1cb1e94f71d6df6612b73f231d0bf92 These leaves no gap betwween the working version and the non-working one with hope this helps dev. Next step: Wait for Markus advice. Have a nice day, Jacques -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 84927] Calc - Errors in function Conditional Formatting
https://bugs.freedesktop.org/show_bug.cgi?id=84927 Jacques Guilleron guillero...@aol.com changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||guillero...@aol.com Ever confirmed|0 |1 --- Comment #1 from Jacques Guilleron guillero...@aol.com --- I Llogic, Once set conditional formatting for C2, you can use Paintbrush to copy and paste it to the range you want. Click on C2 to select the cell, click on paintbrush to copy the format and select the range you desire. Format is applied when you release mouse button. Another way to do that: Format Conditional Format Manage: Select C2. Edit: In the range windows insert : and set K31, for example, or D31. OK to apply our settings. you can delete C3, C4, C5 and D3, D4, D5. OK again. The whole range from C2 to D31 ot K31 is formated. Is there a problem to do this for you? Jacques -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 84927] Calc - Errors in function Conditional Formatting
https://bugs.freedesktop.org/show_bug.cgi?id=84927 --- Comment #2 from Llogic lazylo...@gmail.com --- Hi Jacques, thanks for replying. 1. I've downloaded the file that I've previously uploaded and tried what you've suggested. Direct link (https://bugs.freedesktop.org/attachment.cgi?id=107731) Action: === Copy format using paintbrush as you've suggested. Result: === Yes, the range is formated properly. Save the file. Problem: Re-open the file and found that the formatting is lost. Observation: Reference Screnshot http://postimg.org/image/e5rtwaen7/ Noticed that after using the paintbrush for formatting, the conditional formatting is visually correct. However, select (example shown here, cell K23) and verify the conditional formatting criteria, it is not there. Therefore when you save and reopen, the formatting is lost. 2. Testing with actual use case - daily update - For actual usage, data are added daily so the conditional formatting have to be done daily - Also the conditional formatting for each row (of the same column) may be different. Just like copying of value and formulas, can the copying of conditional formatting be done as a whole column ? Action: === Using the same file that I've previously uploaded, copy conditional formatting from C2 to C2:C31 Conditional formatting is okay visually for C2:C31 Select column C and copy format using paintbrush. Paste format to column D. Result: === The conditional formatting is copied over to column D but not properly done. The above information for your review. Llogic -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 84927] Calc - Errors in function Conditional Formatting
https://bugs.freedesktop.org/show_bug.cgi?id=84927 Julien Nabet serval2...@yahoo.fr changed: What|Removed |Added Attachment #107731|text/plain |application/vnd.oasis.opend mime type||ocument.spreadsheet -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 84927] Calc - Errors in function Conditional Formatting
https://bugs.freedesktop.org/show_bug.cgi?id=84927 Llogic lazylo...@gmail.com changed: What|Removed |Added Priority|medium |high CC||lazylo...@gmail.com -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs