To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=57095
User fst changed the following: What |Old value |New value ================================================================================ Status|NEW |RESOLVED -------------------------------------------------------------------------------- Resolution| |DUPLICATE -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Tue Nov 1 00:50:21 -0800 2005 ------- Hi, this *is* a double to Issue 24374 . And it's not unfriendly. Think about a sheet formatted as text one of these cells is referenced on an other sheet with an vlookup based on textdata. Now you format the referenced cell as number and the text changes to that. As a result the vlookup does not solve correctly and you get in trouble. This is the fact that makes this Issue a wontfix Issue. Also the conversion of such values to a real number is easy by using find&replace with regular expressions. Frank *** This issue has been marked as a duplicate of 24374 *** --------------------------------------------------------------------- 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]