Created attachment 70408 [details] Sample Document I found this problem during my investigations for "Bug 48970 - EDITING: Deleting a column in particular.xls corrupts following columns" with "LibreOffice 3.6.4.1 rc" German UI/ German Locale [Build-ID: a9a0717] on German WIN7 Home Premium (64bit) and a sample document what is a simplified Version of Attachment 60391 [details] Steps how to reproduce: 1. Open attached sample0.ods2. 2. Click cell D17, check Conditional formatting in 'Format -> Conditional Formatting -> Conditional Formatting'. Reference should be 'Sample.$D17=""' 3. Click cell D18 4. Menu 'Format -> Conditional Formatting -> Conditional Formatting' > Dialog opens 5. Modify formula from 'Sample.$D18=""' to 'Sample.$E18=""' <ok> Expected: only this cell gets new formatting (so it happens with 3.5) Actual: all similar conditions in B11:D22 change reference from column D to column E (check as per step 2)
This behavior might be a feature, in Conditional 'Formatting -> Manage' I see that the condition is defined for a range and not for separate cells. But: a) LibO 3.5 handled those conditions separately for each cell, so that the new behavior is worrying b) the result is even more worrying because there is no warning or question "change only this cell or ocmplete range? d) and the result is even more worrying because how for Version 3.6.4 we still have no Help contents matching with the new UI (see "Bug 55618 - LOCALHELP: obsolete for CALC Conditional Formatting") Because of the missing Help I have no idea how to break that range.
(In reply to comment #1) > This behavior might be a feature, in Conditional 'Formatting -> Manage' I > see that the condition is defined for a range and not for separate cells. It is a feature. Between 3.5 and 3.6 we switched from cell based conditional formats to range based conditional formats. There are several advantages with this approach like conditional formats that not only work with the current cell value but also take into the account the values in the range (color scales, data bars and in 4.0 several new conditional formats) > > But: > a) LibO 3.5 handled those conditions separately for each cell, so that the > new > behavior is worrying > b) the result is even more worrying because there is no warning or question > "change only this cell or ocmplete range? This will be improved in 4.0 with overlapping conditional formats. > d) and the result is even more worrying because how for Version 3.6.4 we > still > have no Help contents matching with the new UI (see > "Bug 55618 - LOCALHELP: obsolete for CALC Conditional Formatting") > > Because of the missing Help I have no idea how to break that range.