https://bugs.freedesktop.org/show_bug.cgi?id=48970
Rainer Bielefeld <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW CC| |[email protected], | |[email protected], | |markus.mohrhard@googlemail. | |com See Also| |https://issues.apache.org/o | |oo/show_bug.cgi?id=4155 Summary|EDITING: Deleting a column |EDITING Conditional |in particular.xls corrupts |Formatting: Absolute |following columns |references not fitted Version|3.4.5 release |3.3.0 Beta2 Ever confirmed|0 |1 --- Comment #15 from Rainer Bielefeld <[email protected]> --- I created a more simple document reduced to the relevant. My results with parallel installation of "LOdev 4.0.0.0.alpha1 - ENGLISH UI / German Locale [Build ID: dec8fe)]" {tinderbox: @6, pull time 2012-11-13 06:07:28} on German WIN7 Home Premium (64bit) with separate /4 User Profile for Master Branch: Absolute references for conditions in formulas will not be fitted correctly after insert or delete column or row. A) Tests with "sample.ods" -------------------------- You can recapitulate the "normal behavior for absolute references in sheet "Sample1" in line 32. All Formulas in E32 ... I32 refer to the number "100" in cell J32. When you insert a column with cursor in column A the reference in E32 changes from "=$J$32" to "=$K$32/1", so that the target of the reference remains the "100" with blue borders. Undo before next test! B) Now check the behavior with references. -------------------------------------------- D2:I4 contains Conditional Formatting referring to column K with an absolute column reference, if cell in column K is empty the background of cells with CF will be yellow, if K is not empty background disappears. Due to results of 'A' references like '$K2=""' should change to '$L2=""' after you have inserted a Column with cursor in Column A. But When you check Cell E2 after column insertion you see that reference still is '$K2=""', and so the background disappeared, because letters "j" now are in column K The effect is the same in cell D11, where the CF only is applied for a single cell. The effect also appears for column deletion, as you see in D5:E7 and D112 No problem with relative references as you see in D15 and D16 The effect also is visible for insertion or deletion of rows, as you see in Sheet2 with insertion or deletion of row 1 Has already been reported as "Bug 55941 - EDITING: Conditional Formatting, Insert/Delete Column/Row only update cell references in CF when there are not absolute references.", I do not know why reporter marked that one "invalid". It seems that Excel does this job correctly. Same effect with LibO 3.3.3 an OOo 3.1.1, so this one seems to be inherited from OOo, and indeed, there is a very old OOo issue. @Spreadsheet Team Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug or forward the Bug if it's not your turf (and remove others in team from CC). -- 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
