To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114053
------- Additional comments from [email protected] Sun Aug 22 21:48:15 +0000 2010 ------- Update: I found a couple triggers for the conversion to an absolute sheet reference in a Conditional Formatting Formula. If the save is done on a sheet without conditional formatting, the other sheets immediately update to an absolute sheet reference. If the save is done on a sheet with the conditional formatting, only the relative sheet reference is added. However, a second save, even on the conditional format sheet, then adds the absolute sheet reference. The result is eventually all conditional formatting with cell references have absolute sheet references added to them. These sheets cannot be copied to a new sheet without keeping the absolute reference to the original sheet name. --------------------------------------------------------------------- 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]
