[Libreoffice-bugs] [Bug 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 ign_christian ign_christ...@yahoo.com changed: What|Removed |Added CC||absolutely...@asiamail.com --- Comment #20 from ign_christian ign_christ...@yahoo.com --- *** Bug 65660 has been marked as a duplicate of this bug. *** -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 --- Comment #19 from Lenge spam...@gmx.net --- (In reply to comment #18) Please report new bug reports as requested by Markus (who is one of our expert developers). Ok, I'll do so as I come across issues that I can reliably reproduce with the current version. A first spin-off is bug 81611. BTW: Keep in mid that after this bug has been closed, those bugs that were previously closed as duplicates should be revisited and possibly reopened if they still apply to the current version (such as bug 61890, bug 68776, bug 76522). -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 Lenge spam...@gmx.net changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|NOTABUG |--- --- Comment #17 from Lenge spam...@gmx.net --- This bug report is a total mess. I just checked my original report and it still is clear and precise. In addition, according to the comments and duplicate bug reports, it still applies to the latest versions. The only inappropriate thing is that someone set it to RESOLVED NOTABUG while it is neither resolved nor not a bug. If there is still an issue please open new bug reports with one bug per report. Sure, one report per bug is reasonable. Would you still recommend doing so even although the observed misbehavior is likely to be related to a common cause? -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 Joel Madero jmadero@gmail.com changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |NOTABUG CC||jmadero@gmail.com --- Comment #18 from Joel Madero jmadero@gmail.com --- Please report new bug reports as requested by Markus (who is one of our expert developers). -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 Markus Mohrhard markus.mohrh...@googlemail.com changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |NOTABUG --- Comment #16 from Markus Mohrhard markus.mohrh...@googlemail.com --- This bug report is a total mess. If there is still an issue please open new bug reports with one bug per report. -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 Joel Madero jmadero@gmail.com changed: What|Removed |Added CC||torgerie...@gmx.de --- Comment #15 from Joel Madero jmadero@gmail.com --- *** Bug 76522 has been marked as a duplicate of this bug. *** -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 mike.h...@onepoyle.net changed: What|Removed |Added CC||kouka...@gmail.com --- Comment #14 from mike.h...@onepoyle.net --- It's not working the same as before but something weird is still going on. If you insert a row above R1 the resulting line works as if the conditional formatting was there (as it should) but with Format Conditional Formatting Manage there are no references to the new R1. If you insert a line above a lower line, there are references to the new line. The software must be generating A1:A2 conditional formatting internally even though it's not being shown. I had problems this week with conditional formatting with only one condition. It didn't transfer correctly from LO to MSO and in the end I had to do the work (for someone else) in MSO. When working there, I noticed that MSO refused to save a spreadsheet with conditional formatting in .xls format, but it works fine with .xlsx I need to do more to extend all of the above, but I have no time until later. I plan to do it in conjunction with the bug chase on 4.3.0 next week. In the meanwhile, please would someone move this to MAB 4.2? Also, it would be good if someone would respond to comment 10 and give kougasio some hints (added as a cc). -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 tommy27 ba...@quipo.it changed: What|Removed |Added Blocks|60270 |65675 -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 tommy27 ba...@quipo.it changed: What|Removed |Added CC||ba...@quipo.it --- Comment #13 from tommy27 ba...@quipo.it --- please retest against 4.2.4.2 if bug persists please move it to mab4.2 list since 4.1.x is EOL -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 --- Comment #12 from Hugh Hyatt bmr2st6...@snkmail.com --- Saving a spreadsheet as .xls seems to preserve more — though not all — conditional formatting than other file formats. -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 Björn Michaelsen bjoern.michael...@canonical.com changed: What|Removed |Added Priority|medium |highest --- Comment #11 from Björn Michaelsen bjoern.michael...@canonical.com --- (This is an automated message.) Setting priority to highest as this is a 4.1 MAB. This is part of an effort to make the importance of MAB reflected in priority too. -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 Owen Genat owen.ge...@gmail.com changed: What|Removed |Added CC||el...@hotmail.com --- Comment #9 from Owen Genat owen.ge...@gmail.com --- *** Bug 68776 has been marked as a duplicate of this bug. *** -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 --- Comment #10 from kouka...@gmail.com --- I confirm the problem. It started happening with LO 4.0 , also confirmed in LO 4.1.3.2 Linux. There is always an error when pasting-special formatting only, and there is an error when pasting cell with conditional formatting. What happens is that the formatting is pasted to a custom cell but not the one pasted. I found many duplicates of this bug. It practically means no conditional formatting until fixed. This thing is really annoying, I consider it critical. I previously managed to reproduce bug 39484 which led to resolution. I am willing again to try hard to deal with this one. I am kindly asking for directions on what to do. -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 kouka...@gmail.com changed: What|Removed |Added Blocks||60270 -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 --- Comment #8 from Eike Rathke er...@redhat.com --- (In reply to comment #7) I also noticed that copying conditional formatting between different tables of the same document, or between different documents, may cause all sorts of problems with the formatting of the copied cells (also in the current LO 4.1.2 release). Unrelated to whatever original problems were reported in this bug, the copying between sheets problem is fixed with bug 61946. -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 --- Comment #7 from Lenge spam...@gmx.net --- I also noticed that copying conditional formatting between different tables of the same document, or between different documents, may cause all sorts of problems with the formatting of the copied cells (also in the current LO 4.1.2 release). As with the other observations, the problems sometimes don't show up immediately after copying, but only after saving and re-opening the document. It seems that checking the list entries under Format/Conditional Formatting/Manage... is a good indicator of whether something went wrong with the conditional formatting. (In general, I start to wonder if it was a good design decision to store conditional cell formatting separate from the normal (static) format. If all format settings of a certain cell were stored together in one place, it would probably be much more robust and consistent when being copied.) -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 Rainer Bielefeld libreoff...@bielefeldundbuss.de changed: What|Removed |Added CC||fcollo...@terra.es --- Comment #6 from Rainer Bielefeld libreoff...@bielefeldundbuss.de --- *** Bug 58921 has been marked as a duplicate of this bug. *** -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 Michel Rudelle mchl.r...@gmail.com changed: What|Removed |Added CC||mchl.r...@gmail.com --- Comment #5 from Michel Rudelle mchl.r...@gmail.com --- I wonder if all that is the same bug. Here are the results of my tests (platform: Vista-32b): 1/ Testing the procedure described in the initial report (comment 0): 1a/ Using Version 3.6.5.2 (Build ID: 5b93205) - I confirm all 3 defective behaviours 1b/ Using Version 4.0.1.2 (Build ID: 4102822e3d61eb989ddd325abf1ac077904985) - Only the third behaviour is still defective 2/ Testing the procedure described in comment 2 with its associated file: 2a/ Using Version 3.6.5.2 (Build ID: 5b93205) - I do not reproduce 2b/ Using Version 4.0.1.2 (Build ID: 4102822e3d61eb989ddd325abf1ac077904985) - I reproduce only the defective insertion of row above row 1 -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 Jorendc joren.libreoff...@telenet.be changed: What|Removed |Added CC||oudei...@gmail.com --- Comment #4 from Jorendc joren.libreoff...@telenet.be --- *** Bug 61890 has been marked as a duplicate of this bug. *** -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 --- Comment #2 from mike.h...@onepoyle.net --- Created attachment 75370 -- https://bugs.freedesktop.org/attachment.cgi?id=75370action=edit conditional formatting insert row and copy/paste errors Confirmed in 4.0.0.3 on Win Vista. The attachment can be used to test some of the issues: 1) Select Row 1 2) Insert Row Result is that the formula originally in A1 now in A2 refers to the wrong cell Similar result if a cell is inserted above A1 3) Copy row 1 4) Paste in row 6 or below Result is that the formula copied from A1 now refers to the wrong cell Similar result if any number of rows including row 1 are copied and pasted Copy and paste of rows not including row 1 (eg rows 2-4) copy the formats correctly In most cases, the incorrectly referenced cell is 2n-1 where n is the new row number Occasionally it’s the row range in the formula which is incorrect Test whether or not the formula in column A is working by altering the text in the adjacent column B -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 mike.h...@onepoyle.net changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||markus.mohrhard@googlemail. ||com, mike.h...@onepoyle.net Ever confirmed|0 |1 -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 --- Comment #3 from Markus Mohrhard markus.mohrh...@googlemail.com --- I wonder if the decision to use UpdateReference was actually a good idea. There seems to be too many corner cases that we need to respect to make it fully useful. I have to think about all corner cases and list them and classify them depending on if they make sense with UpdateReference or not. Compared to normal formula cells the number of corner cases for conditional format updates is significantly higher. -- 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 59288] FORMATTING: Copying conditional formatting
https://bugs.freedesktop.org/show_bug.cgi?id=59288 --- Comment #1 from Lenge spam...@gmx.net --- Seems I better shouldn't have used strings like bug #1..3 as these are automatically converted into links to completey unrelated bug reports. Sorry! -- 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
