Issue 119641 - conditional formatting disapear if I add a column
Summary: conditional formatting disapear if I add a column
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.3
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2012-05-31 12:14 UTC by supportdoc
Modified: 2013-08-09 21:56 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

sample file (8.70 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-06-14 09:05 UTC, Li Feng Wang
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description supportdoc 2012-05-31 12:14:14 UTC
I have set conditional formating for the colums c --> h 

Then I insert a new column before the column b. the column c will become d ... h->i 

Then all conditional settings in the column d ... i are false (the condition is if($i3<>""1;0). It is also not possible to move the columns.
Comment 1 Terry 2012-05-31 23:24:32 UTC
This does not happen on my (Linux rpm) installation.
Comment 2 supportdoc 2012-06-01 19:53:32 UTC
i have a windows installation
Comment 3 Li Feng Wang 2012-06-14 09:03:04 UTC
may reproduce on AOo3.4 release version.
Comment 4 Li Feng Wang 2012-06-14 09:05:26 UTC
Created attachment 78323 [details]
sample file

I make a sample file for this defect in attachments. (after inserting new column before column b, there will be problem.)

maybe the same problem.
Comment 5 Regina Henschel 2012-06-14 15:50:13 UTC
Please look at issue 4155 and its duplicates too.
Comment 6 Terry 2012-06-14 22:43:45 UTC
I can confirm the problem now.
Comment 7 Chuck Spalding 2013-08-09 21:56:02 UTC
I have seen related behavior with AOO v4.0.0 on Mac OS X 10.6.8. If the cell referenced in the conditional formatting is on another sheet, and that referenced cell moves because of an insertion or deletion, the formula for the conditional formatting is not modified.

Also see related Bug 97254, and my comment to that bug.