To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=64550 Issue #:|64550 Summary:|function weeknum Component:|Spreadsheet Version:|OOo 2.0.2 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|viewing Assigned to:|spreadsheet Reported by:|pacomarquina
------- Additional comments from [EMAIL PROTECTED] Thu Apr 20 03:42:03 -0700 2006 ------- When I open an excel file that contains num.de.semana (this funtion is in spanish, the function in english is weeknum), first of all doesn't translate this function to english (directly is not recognized) but when I try to change for weeknum, it doesn't work correctly (I always have as result week 52) if I use a date in format dd/mm/yy (this date is not a value, is in a formula concatenate) column FV =CONCATENATE(K2;"/";J2;"/0";I2)) column SP =WEEKNUM(L2;2) FV SP 01/01/06 52 14/01/06 52 24/01/06 52 Many thanks. Paco Marquina. --------------------------------------------------------------------- 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]
