To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69909
------- Additional comments from [EMAIL PROTECTED] Mon Oct 30 01:37:29 -0800 2006 ------- I was wrong - the list of regexps does say that \n, \t and & should work in replace (despite what the other (incorrect) entry in Help says). There is a bug here. As the OP says, if you replace the 2 in 123 with \t, the result is a text entry (=TEXT() gives true) looking like 13, but with LEN() equal to 3. Using & works as expected - eg replacing 2 in 123 with 7&8 gives 17283. I believe Issue 15666 is relevant here; it discusses changes to regexp behaviour, originally to do with Writer, but now I believe application-wide. I don't know what the relevant action should be having spotted this - advice someone? --------------------------------------------------------------------- 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]
