To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=71104
------- Additional comments from [EMAIL PROTECTED] Tue Jan 2 09:10:03 -0800
2007 -------
I can confirm the issue, and this also happens with absolute references (at
least with OO 2.1):
- Open a new spreadsheet
- Enter the following formula to cell A1:
=$C$1
and the following value to cell C1:
aa1
- Add a single condition for conditional formatting to cell A1 and A2:
Cell value is equal to $C$1; Cell style "Heading"
A1, respectively the string "aa1", is formatted with the Heading style.
- Right-click the header of column B
- Select Insert Column
A1, respectively the string "aa1", has lost its Heading format!!!
The condition is still
Cell value is equal to $C$1; Cell style "Heading"
which is obviously not correct.
This is also not consistent with cell editing. "aa1" moves from C1 to D1, and A1
is adapted correctly to "=$D$1". So, for formulas it works, but for conditional
formating, it does not.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
