https://bugs.documentfoundation.org/show_bug.cgi?id=153506
--- Comment #12 from bwilder...@yahoo.com --- (In reply to ady from comment #11) > (In reply to bwilderhoo from comment #9) > > Attached PDF containing screenshots and other information about the problem, > > and provides answer to the last question asked by support personnel. > > Hmm? Who is "support personnel"? > > > > > Hope this info makes clear the problem as I see it--- and have tried to > > report it previously. > > Since you admit that there is no way to trigger a real problem in the result > (i.e. in the cells themselves), you seem to be requesting not to modify the > copy in comparison to the original (worksheet) in any way (at least > regarding the conditional formats), even when the resulting actual behavior > in the cell's format is the same. I admit users might have their valid > reasons (and relevant workflow) for this request. > > The alternative to that interpretation (IMHO) is that you are not yet > understanding that LO Calc deals with the syntax for CF in a different way > than other programs do. The result is the same, but the syntax is slightly > different. > > There is a PDF, "Conditional formatting guide" for Calc. Search for it. > Whether it would help in this case, IDK (I haven't read it myself). > > You can also try at ask.libreoffice.org > > At this time I’ll leave the status of this report without further > modification. Someone else might have a different interpretation, and/or > reaction. Thanks for your additional insights and the recommendation that I search for the CF guide for Calc. I downloaded and read this brief 25 page document and it confirms my understanding of how CF are intended to work. In fact, the following info from the document, if correct, confirms my hunch about how CF are defined for for a given sheet: Use “Manage Conditional Formatting” dialog. Select Format > Conditional > Manage menu A dialog box opens. This dialog has a list of all cell ranges with conditional formatting on current sheet. The problem I reported in this bug is that after copying an existing sheet, yyyy, to a new sheet 2023, the resulting "list of all cell ranges with conditional formatting on current sheet" was not even close to being logically equivalent to "list of all cell ranges with conditional formatting on the source sheet". The sample data I provided was a very small set to clearly show the differences and loss of vital info (i.e. - cell references dropped and distinct and mutually exclusive cell ranges merged). The original source spreadsheet from which this sample data was obtained, the Manage Conditional Formatting dialog for the source sheet yyyy listed 30 distinct mutually exclusive cell ranges with conditional formatting, and the 2023 sheet that was copied from this source sheet, only had 14 mutually exclusive cell ranges with conditional formatting. The reduction that occurred during the sheet copy seemed to simply combine cell ranges using first range defined CF, and ignored the CFs for subsequent ranges being combined. In the provided sample data you see that there is no references to $Budget.$B24 in the single combined cell range CF. This info has been lost in the Manage Conditional Formatting dialog. Anyway, thanks for your "support" in trying to understand and help the issue I have reported. I will take a look at ask.libreoffice.org as you suggested. -- You are receiving this mail because: You are the assignee for the bug.
