Created attachment 119922 [details]
The virgin version
The fragmenting itself is notorious. I will focus on the "without need" here.
Reproducing my observations:
1. Create a new Calc document, 1 sheet.
2. Create values for A1:D10 and define a conditional format for this range.
You may use the attached CFfragmentingDemo001.ods instead.
3. Inspect the CF via >'Format'>'Conditional Formatting'>'Manage...'
4. Verify that there is exactly one range: A1:D10.
3. Save the document (001).
6. Select B3 and 'Copy' (Ctrl+C).
7. Go to C6 and 'Paste' (Ctrl+V, accept overwriting).
8. Verify that there are now 2 ranges one of which is composed of 4 parts: A1:D5;A7:D10;A6:B6;D6. The other one is C6 (single cell).
9. Save AS... file variant 002LibO. I did respectively and attach the file.
10. Close the 002LibO file and shut down LibreOffice.
11. Start AOO 4.1.1 and open the 001 file with it.
12. Repeat steps 6. and 7. from above.
13. Save AS... file variant 002AOO.
14. Close AOO and open 002AOO with LibreOffice Calc.
15. Inspect the CF and verify that there is still only one, the original, range.
16. Agree that the fragmentation by LibO Calc was "without need".
I would treat this as a bug. You may handle it as a feature request.
Created attachment 119923 [details]
After Copy/Past with LibO
Created attachment 119924 [details]
After Copy/Paste with AOO
As I mentioned AOO4.1.1 as the actually used version from the other branch, I should also post that the example was created with LibO 5.0.2.
(Additional versions tested beginning with 3.6.5)
Hi Waolfgan, thanks for reporting.
There is a request for enhancement for at least an option to reunify the ranges.
please post there your comment.
*** This bug has been marked as a duplicate of bug 87274 ***
I knew the bug 87274 and had added me to its CC list.
I do not regard this bug as a duplicate of it.
The other bug is much more complicated:
1. In its demanding a new feature never before implemented
2. In reporting crashes the condition of which I did not actually understand. (I also had CF crashes with earlier versions after copying sheets containing CF. I didn't report that because I couldn't always clearly reproduce it, and because my observations were too complicated.)
This bug IS a bug and also a REGRESSION. The wrong (though not destructive) behaviour was not present in V3.3. and is not in AOO. It was introduced seemingly together with the CF manager but not depending on it.
The bug is clearly described and can be fixed without introducing any new features. It is clearly distinguished from bug 87274 as fixing does not require any comparison of CF settings (for equivalence). On pasting a CF copied from another cell a check is necessary if both these cells belong to the same CF range.
(This is obsolete, of course, if someone is working on a complete redesign CF management.)
Set Status to NEW again
As you like, but please revert the status to UNCONFIRMED, it's not proper set up as new you own reports.
Set to UNCONFIRMED
I really don't understand how this isn't a duplicate of that other issue but to avoid an unnecessary flame war.
Minor - can slow down but won't prevent high quality work;
Low - default for minor bugs
Fixing the issue as described in bug #87274 would of course fix this issue as well.
(In reply to Joel Madero from comment #8)
> I really don't understand how this isn't a duplicate of that other issue but
> to avoid an unnecessary flame war.
Sorry! No flame war intended!
If someone wants to mark this bug as a duplicate again I will keep silent. But-
- I was not clear enough:
1. The first paragraph of the description of bug 87274 by "m.a.riosv" is actually concerning exactly the same issue.
2. The attachment created there to explain things in more detail is not working.
3. The subsequent two paragraphs make things ambiguous, and finally shift to an enhancement request - as also "raal" saw it in his first comment.
4. The short description (subject) of that bug emphasises this request exclusively. I was instructed that it is not best practise to mix up reporting about an actual bug which is also a regression (legacy versions and AOO don't show it) and requesting a new (and valuable!) feature.
5. Therefore I decided to create a report about the "naked bug".
"...in the manage CF dialog to reunify ranges with the same CF.." requires to decide what is "same CF" and what not. Difficult!
Fixing this bug only requires to recognise "same range" as already is done by older versions and AOO. Easy!
Waiting for the implementation of "the new feature" will lead to nothing because this is a really complicated task, possibly depending on a fundamental redesign not only of the manager but of the CF itself, which might then be heavily incompatible with other software within the interoperability range. My bet: It will not be done within the next 10 years.
If "same CF" in the other bug was intended to only mean "same range" this is misleading. The word "conditions" in the subject should exclude this interpretation, anyhow.
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice
(5.1.6 or 5.2.3 https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the version of LibreOffice and
your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave
a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
LO 22.214.171.124 x64 on Win7 Ultimate SP1 x64. This problem exists like before, no improvement, not even in 5.2 series I had with the current usage of Calc.
You don't even need to do the repro as outlined in OP, you get further (word 'worsening' ?) fragmentation until the condition has been duplicated across every cell in the sheet, if your machine can handle such task and you have the time to wait.
Nowadays I tend to use a local install of LO Calc to make very heavily mathematical spreadsheets where conditional formatting is used to highlight smallest and largest values (sometimes even the middle value) across a column, or even across a certain range of cells across possibly more than 1 column: this fragmentation occurs every single time those cells with formulas are modified by cell copying handle or copypasting data into.
Bumping cuz it's obvious this hasn't been looked into for one bit, especially the details. Wolfgang Jäger's email:
- In the few cases I still intend to use CF to a larger extent, I develop the conditions in a spare range commenting on the purpose and on the range(s) to which they should be applied finally.
- Having completed the functional design of the sheets and needing no further scaling or copy/paste operations (hopefully) I add the "highlighting" functionality in the very last step.
- Even if I decided to also manage CF from the beginning for specific reasons, I will clean it completely at one point of the development and reinstate it unfragmented from cell-formulae.
And like already said, this ain't a duplicate of #87274, this is a bug or possibly a leak (myself, I doubt it's a leak although that idea is mine) whereas #87274 is a request for a feature to merge applicable ranges broken by this problem.
A comment at #87274 references #97956, a problem similar to this, but doesn't sound the same.
Attached a new ODS from him.
Created attachment 132418 [details]
A new test file with a newer Calc
Once again this was mixed up with the (re-)unification enhancement bug #87274.
Unification should be expected to be much more difficult than avoiding fragmentation!
This is not about an enhancement, but about a REGRESSION!
To draw the fragmentation discussion back to this topic where it should continue, I include the recent post I made there also in this comment:
Quoting myself from bug #87274, comment #14:
Now I am talking only of the fragmentaion, not of the (re-) unification which would mostly not be needed if not first fragmentation took place.
The problem arose, as far as I can tell, at (about?) the same time as the CF manager was introduced. In advance it was not just "not visible". It was not existing at all - and it still does not exist in AOO up to V 4.3.1. (where the classical CF dialog allowing for 3 conditions is still used).
To be clear about steps to get evidence for my claim:
Create a spreadsheet document with freshly defined CF (more than one probably).
Open it in AOO.
Copy/Paste around in a way you know would cause unnecessary fragmentation in LibO.
Open in LibO.
Call the CF manager.
Verify: No unnecessary fragmentation.
Some developer should study the CF-"code before CF manager" and find in what way fragmentation was NEWLY introduced. Repair should be feasible then.
Unification of "equal" CFs (how to define exactly?) can wait then.
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":
tdf#95295: don't add duplicate conditional formats
It will be available in 6.1.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
I did a test with 'The virgin version'
and its working. Dragging with the mouse from D1:D10 to I1:I10 and there is only the range that is changed. No extended range.
Build ID: 6ca6d6ac912588a8f62d7e6b668ebec333752ebc
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4;
Locale: nl-BE (en_US.UTF-8); Calc: group threaded
(In reply to Xavier Van Wijmeersch from comment #16)
> I did a test with 'The virgin version'
> and its working. Dragging with the mouse from D1:D10 to I1:I10 and there is
> only the range that is changed. No extended range.
Thank you for testing.
Could you please clarify if your check confirms it fixed, or not: I'm confused with "and there is only the range that is changed" (I take it that you see the range of existing format extended, not a new format created, which is the desired result AFAICT), followed by "No extended range" - possibly you meant "no new format for extended range created"?
Sorry for the bad explanation
Yes i mean "no new format for extended range created" and "I see the range of existing format extended, not a new format created, which is the desired result"
(In reply to Xavier Van Wijmeersch from comment #18)
Thanks! So - closing FIXED.
Verified, really fixed
May I assume that the patch not aimed at minimizing the number of subranges used to represent the resulting SheetCellRanges for an edited CF?
An example to clarify what I mean:
I made a CF for D9:G22.
I copied E12:E18.
I pasted this to the range starting at F20.
I got the SheetCellRanges D9:G19;D20:E22;G20:G22;F20:F26 [A](4 ranges).
I might have expected: D9:G22;F23:F26 [B](2 ranges).
Is there a clear concept in what way to describe a connected selection requiring more than one range to describe it?
Selecting all the celle (in time as [B]describes gives:
D9:E22;F9:E26;G9:G22 [C] (3 ranges).
Changing the order of selection does not change the representation.
Coming from experiences with CurrentSelection and with queryContentCells / queryEmptyCells I assumed a scheme making the results unambiguous and thus easily comparable. Using different schemes in different cases may induce new issues if comparisons are once needed.
Isn't it feasible to analyze and represent a union created by CF editing in the same way as the query methods do (type [C]?
(In reply to Wolfgang Jäger from comment #21)
This might be a valid enhancement; but this is outside of the scope of this issue. Please file a new issue for this. (And unifying the code that joins ranges in different parts of Calc is The Good Thing(TM) :-) )