To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114053 Issue #|114053 Summary|Relative Conditional Format Formula converts to Absolu |te after save & reopen Component|Spreadsheet Version|OOO320m12 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|dcreid
------- Additional comments from dcr...@openoffice.org Sun Aug 22 21:11:50 +0000 2010 ------- A conditional format entered as: Formula is $C$1<6 will convert to: Formula is $Mysheet.$C$1<6 after save, exit and re-open. This isn't consistent though. I repeated the experiment with different starting conditions: C1<6 became Mysheet.C1<6 C$1<6 became Mysheet.C$1<6 $C$1<6 became Mysheet.$C$1<6 I could not replicate the result of $Mysheet.$C$1<6 with the absolute sheet reference in setting up the individual cell formatting. The addition of the sheet reference to the formula is not desirable. It could be acceptable if it did not do the conversion to absolute sheet reference. When that happens, copied sheets keep the reference to the original sheet, which is to be expected. In the follow-up tests above, the relative sheet reference does work when copying the sheet. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org