To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=71104
Issue #|71104
Summary|Conditional formatting lost if reference used in condi
|tion is not absolute
Component|Spreadsheet
Version|OOo 2.0.4
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|formatting
Assigned to|spreadsheet
Reported by|mchabrol
------- Additional comments from [EMAIL PROTECTED] Thu Nov 2 02:00:32 -0800
2006 -------
Hi,
This defect has been detected on Linux and reproduced on Windows, both in French
and English version.
When using conditional formatting on a cell, if the condition refers another
cell using a modifiable reference (like A$1), the formatting is lost if cell A1
becomes A2 by inserting a new row.
Steps to reproduce :
- Create a new Spreadsheet
- In cell A1 insert 1
- In cell A2 insert 1
- Select cell A2 and apply conditional formatting
via Format > Conditional Formatting ...
- In Condition1 select "Cell Value is" / "equal to" / $Sheet1.A$1 /
Cell Style : Heading
Note: Pointing to A1 will insert $Sheet1.$A$1, modify it to $Sheet1.A$1
(useful if you use copy/paste special/format)
- The style of cell A2 changes to Heading.
- Select Row 1
- Insert a new row via Insert > Rows (A1 becomes A2, A2 becomes A3)
- The style of cell A2 changes back to normal
- Check the conditional formatting, it still references $Sheet1.A$1
Expected Result :
- The conditional formatting should reference $Sheet1.A$2
This issue will not appear if the conditional formatting references A1 using
an non modifiable reference ($Sheet1.$A$1).
I can attach a spreadsheet if necessary but I think the steps to reproduce
are easy enough to see the issue.
Thanks.
---------------------------------------------------------------------
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]
