To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=66441
User atdsm changed the following:
What |Old value |New value
================================================================================
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords|needmoreinfo, oooqa |ms_interoperability, oooqa
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Fri Jun 16 09:57:28 -0700
2006 -------
Confirmed with your spreadsheet.
Also, I managed to narrow down the problem. (There are actually two things which
happen, both of which must occur to cause a break in functionality.)
1) When importing from MS Excel, OOo Calc inteprets the sheet name for
conditional formatting as relative. (This, I think, is by design. Excel by
default does not put in a sheet name when referring to cells in the current
sheet, enabling conditionally formatted cells to copy and paste between sheets
correctly. Therefore, OOo keeps the sheet name relative, enabling the same sort
of copy paste operations to occur correctly.)
2) When a relative reference for sheet name is used, OOo Calc does not update
conditional formatting references when inserting cells/rows/columns. This
applies whether the conditional formatting is referring to its own or another
sheet.
By relative, I mean using a cell reference without a $, ie:
"Sheet1.C1" is a relative reference.
An absolute reference would be:
"$Sheet1.$C$1"
By default, OOo Calc inserts absolute references when using conditional
formatting (prefixing the sheet name with the dollar sign ($)). If absolute
references are used, the conditional formatting references update when
cells/rows/columns are inserted.
---------------------------------------------------------------------
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]
