https://bugs.freedesktop.org/show_bug.cgi?id=71940
--- Comment #11 from Aprax <[email protected]> --- Created attachment 90210 --> https://bugs.freedesktop.org/attachment.cgi?id=90210&action=edit 6 two ods files I made two copies of two ods files, one to test myself before submitting to you, the other to send to you so you can test. DVD Source test sample.ods DVD Index test sample.ods I suggest that you make your own multiple copies of "Index" now. They have 10 columns in common from Title to IMDB. The 'Source' has no conditional formatting. I record purchases in the Source, and have a column "Box" which is where the DVD is stored when I need to find it, and other columns related to purchasing. I copy the 10 columns to the "Index" and maintain other columns such as "my rate", "last seen", etc. Normally I can simply copy and paste but occasionally a single purchase represents multiple movie titles and I have to key the information (or copy parts of several fields to separate rows). ================================================================== Check your first copy of "Index". In the beginning the conditional formatting is correct with a single range from row 2 to row 1047662 for columns A, G, I, M & N. To demonstrate the error, where Libre Office redefines ranges when it should not, do the following: Go to row 1436 of Source. It contains two movie titles which will require two rows in Index. Copy part of the text = "Dirty Dancing 1987 1h45m" and paste it into row 1442 of Index Check the Conditional Formatting Rules. Copy part of the Title text = "Dirty Dancing: Havana Night 2004 1h26m" and paste it into the Title column, row 1443 of Index Check the Conditional Formatting Rules. Do the same for the "2nd title...", "Actors..." etc. i.e. any columns that do NOT have conditional formatting but NOT columns WITH conditional formatting rules = col A, G, I, M and N. Check the Conditional Formatting Rules, everything is still OK at this point. -------------------------------------------------------------------- Copy and paste the 10 columns for the two rows 1437 & 1438 in Source and Paste into rows 1444 & 1445 of Index. The columns with Conditional Formatting should change to the appropriate colors, they don't because the Conditional Formatting Rules for columns G and I have been altered by Libre Office (without my permission) The rules now have 2 ranges: G1446:G1047662,G2:G1443 I1446:I1047662,I2:I1443 (and appear in descending sequence, which seems weird to me, I'd use G2:G1443,G1446:G1047662 to make it easier to see what's missing which is G1444:G1445) Now key the Time in row 1443, and the Time changes to salmon "1:26" because it's "in the range". ------------------------------------------------------------------ Fix the Rules so that all have a single range from row 2 to row 1047666 and the correct colors appear. ================================================================== Check your second copy of "Index". In the beginning the conditional formatting is correct with a single range from row 2 to row 1047666 for columns A, G, I, M & N. Now repeat except that before copying from Source 1437 & 1438, key the Time in Index row 1443 and check conditional formatting. ================================================================== Delete the 4 rows from Index and the Rules are automatically 'fixed' except the top end of the ranges has been decreased by four (4). I don't like that either, I want a rule range that essentially covers from row 2 to the highest/last row possible. I grant that row 1047662 is more than adequate, I'll never have that many DVDs, but, I don't like a program to second guess me when specifying a range. I can see that it would be appropriate in a case where I had a 'small' range, e.g. from 37 to 54 and I wanted to insert a new row between row 42 and 43, then the range should be expanded from 37 to 55. But not when the range is virtualy all encompassing. and so it goes, but it shouldn't. I've specified a set of rules and I don't want them changed the way that they're being changed. I don't understand if changing the rules this way is considered a 'feature'. I hope this is adequate for your needs, J -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
