[Libreoffice-bugs] [Bug 153506] Conditional format not preserved in copied sheet. See comment 19
https://bugs.documentfoundation.org/show_bug.cgi?id=153506 --- Comment #28 from m.a.riosv --- (In reply to BDF from comment #27) > I observed the same issue in a slightly different way: > > =$S$3:$T$23;$S$25:$T$109;$S$111:$T$127;$S$129:$T$140;$S$142:$T$215;$S$218: > $T$230;$S$232:$T$247;$S$249:$T$254;$S$256:$T$291;$S$293:$T$316;$S$349:$T$356; > $S$358:$T$372;$S$374:$T$398;$S$479:$T$598;$S$400:$T$477;$S$318:$T$347;$S$600: > $T$606;$S$608:$T$616;$S$618:$T$677;$S$681:$T$696;$S$699:$T$700;$S$721:$T$725; > $S$702:$T$719;$S$727:$T$816;$S$818:$T$873;$S$878:$T$934;$S$938:$T$964;$S$966: > $T$974;$S$976:$T$978;$S$980:$T$1503 > > ... It is not the same, what you have is for the same conditions a lot of different ranges. You know your sheet, but maybe with S3:T1503 does the same. I have just tested, adding at data with the CF at the end of the range, expand that range, doesn't add a new one. Maybe https://bugs.documentfoundation.org/show_bug.cgi?id=133027 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153506] Conditional format not preserved in copied sheet. See comment 19
https://bugs.documentfoundation.org/show_bug.cgi?id=153506 --- Comment #27 from BDF --- I observed the same issue in a slightly different way: In my company we use a large table where you enter your finished work. Because the way the file is saved is not very meant for the way we do it, the progress within the file is often not saved. The result is that some workers saved the file to their own PC, edit it over there and just copy the effected lines. This messes with the range/area of the conditional formatting in the original file. The original range is this: =$C$3:$D$1503 The current range of this year (2023-02) is this: =$C$3:$D$55;$C$58:$D$94;$C$96:$D$1503 The end result of last year was this: =$S$3:$T$23;$S$25:$T$109;$S$111:$T$127;$S$129:$T$140;$S$142:$T$215;$S$218:$T$230;$S$232:$T$247;$S$249:$T$254;$S$256:$T$291;$S$293:$T$316;$S$349:$T$356;$S$358:$T$372;$S$374:$T$398;$S$479:$T$598;$S$400:$T$477;$S$318:$T$347;$S$600:$T$606;$S$608:$T$616;$S$618:$T$677;$S$681:$T$696;$S$699:$T$700;$S$721:$T$725;$S$702:$T$719;$S$727:$T$816;$S$818:$T$873;$S$878:$T$934;$S$938:$T$964;$S$966:$T$974;$S$976:$T$978;$S$980:$T$1503 The end goal would be that you could somehow protect the conditional formatting against unwanted changes. I'm not sure if this bug report/feature request has the same core issue, but it sounds familiar enough to me. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153506] Conditional format not preserved in copied sheet. See comment 19
https://bugs.documentfoundation.org/show_bug.cgi?id=153506 Stéphane Guillou (stragu) changed: What|Removed |Added Blocks||87351 See Also|https://bugs.documentfounda | |tion.org/show_bug.cgi?id=87 | |351,| |https://bugs.documentfounda | |tion.org/show_bug.cgi?id=11 | |6221, | |https://bugs.documentfounda | |tion.org/show_bug.cgi?id=11 | |6222| --- Comment #26 from Stéphane Guillou (stragu) --- (Meta bugs should be in Blocks rather than See Also.) Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=87351 [Bug 87351] [META] Conditional formatting bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153506] Conditional format not preserved in copied sheet. See comment 19
https://bugs.documentfoundation.org/show_bug.cgi?id=153506 Mike Kaganski changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=95 ||295 --- Comment #25 from Mike Kaganski --- (In reply to ady from comment #24) > I don't recall seeing anything about such thing in any Release Notes – maybe I > just missed it. Any links to any kind of info about this, anywhere? Indeed, there is the info - right following the commit link, there is a reference to tdf#95295. And since that was a bug fix, just one of hundreds bugfixes, it's not something that goes to the release notes. (And I didn't think about this behavior change back then; it wasn't intentional; if I did, it wouldn't change things, I'd only mention that in the commit message and in the bug.) Again: if someone finds a way to improve the logic of that fix, that would be great. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153506] Conditional format not preserved in copied sheet. See comment 19
https://bugs.documentfoundation.org/show_bug.cgi?id=153506 --- Comment #24 from ady --- (In reply to Mike Kaganski from comment #23) > I disagree that this is a bug. Yes, this is a behavior change. However, both > behaviors have their benefits and logic, and merging the multiple CFs was > done to avoid much worse problems. > > OTOH, if there is a way to only merge ranges on copy of cells, not on sheet > copy, that would be a possible improvement. IDK about pros and cons, because I have no idea which issues prompted such behavior's change. BTW and FWIW, I don't recall seeing anything about such thing in any Release Notes – maybe I just missed it. Any links to any kind of info about this, anywhere? What I do know is that, as a simple common user, I would expect that a copy of a worksheet would behave the "same" as the original. If a formula is using an absolute reference for a worksheet, I would expect to be kept in the newly-pasted copy with the same absolute reference. The same goes for a CF that depends on an absolute reference. I have to admit that, even if I would had known about such behavior's change, I'm not sure I would had realized I was about to make a mistake in some common "duplicate sheet" action. Of course this is speculation ATM. IOW, I could understand the frustration of users finding out that what was supposed to be a copy, it is not really an exact copy. That is, if they happen to find out about it. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153506] Conditional format not preserved in copied sheet. See comment 19
https://bugs.documentfoundation.org/show_bug.cgi?id=153506 --- Comment #23 from Mike Kaganski --- To comment 14, comment 19: I disagree that this is a bug. Yes, this is a behavior change. However, both behaviors have their benefits and logic, and merging the multiple CFs was done to avoid much worse problems. OTOH, if there is a way to only merge ranges on copy of cells, not on sheet copy, that would be a possible improvement. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153506] Conditional format not preserved in copied sheet. See comment 19
https://bugs.documentfoundation.org/show_bug.cgi?id=153506 zcrhonek changed: What|Removed |Added CC||mikekagan...@hotmail.com --- Comment #22 from zcrhonek --- Sorry, it's Mike Kaganski's patch. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153506] Conditional format not preserved in copied sheet. See comment 19
https://bugs.documentfoundation.org/show_bug.cgi?id=153506 zcrhonek changed: What|Removed |Added OS|Linux (All) |All Keywords||bibisected, bisected CC||er...@redhat.com, ||zcrho...@gmail.com --- Comment #21 from zcrhonek --- (In reply to ady from comment #19) > Finally! > > Steps to reproduce: > 1. Open attachment 185308 [details] > 2. On the _3rd_ worksheet, named "", cell C19, enter the number: 119 > [ENTER] > 3. Duplicate Worksheet "". > 4. Worksheet "Budget", select entire row 24, [CTRL]+[+] > 5. Compare conditional format of $_2.C19 vs $.C19 > > Note that the CF for cell $.C19 refers to "$Budget" (as an _absolute_ > reference to the worksheet). Hence, both worksheets, the original "" and > the copy "_2", contain CF that depend on the same "Budget" worksheet. > bisected to e8e8d5c930bd2f68a4d874d01d4734b9a0beaa8b is the first bad commit commit e8e8d5c930bd2f68a4d874d01d4734b9a0beaa8b Author: Norbert Thiebaud Date: Thu Dec 14 01:50:12 2017 -0800 source sha:3f614f431475e1bf3bb3bbeac59b0681309628b7 https://gerrit.libreoffice.org/c/core/+/45656 Adding CC to Eike Rathke -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153506] Conditional format not preserved in copied sheet. See comment 19
https://bugs.documentfoundation.org/show_bug.cgi?id=153506 ady changed: What|Removed |Added Keywords||regression See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=87 ||351, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=11 ||6221, ||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=11 ||6222 --- Comment #20 from ady --- Also repro (as steps in comment 19) in: Version: 7.0.0.3 (x86) Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e and in: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: c3bd52f81bf733a0b9b0560794a54b2ac1e0f444 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded whereas with: _ LibreOffice 3.3.0 _ Version: 5.4.7.2 _ Version: 6.0.0.3 Build ID: 64a0f66915f38c6217de274f0aa8e15618924765 I repeated the steps in comment 19 and worksheet _2 behaves the same as , thus it's a regression that started somewhere between version 6 and 6.1.5.2. See also META bug 87351 bug 116221 bug 116222. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153506] Conditional format not preserved in copied sheet. See comment 19
https://bugs.documentfoundation.org/show_bug.cgi?id=153506 ady changed: What|Removed |Added Summary|LibreCalc - When copying an |Conditional format not |existing sheet to a new |preserved in copied sheet. |sheet LibreCalc does not|See comment 19 |preserve conditional| |formatting on new sheet.| |Example provided in | |description.| -- You are receiving this mail because: You are the assignee for the bug.
