To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52034 Issue #:|52034 Summary:|Buscar() (Find() in english??) are buggy??? Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|TASK Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|stargeizer
------- Additional comments from [EMAIL PROTECTED] Fri Jul 15 05:54:21 -0700 2005 ------- Using the spanish version of OOO 1.9.113, open the attached file... IN OOO 1.9.113 (probably earlier also... can't tell for sure).. i have problems with the "Buscar()" formula... - Make a list on the page 3, and define an area with the list. (i call it "Area2") - Make another list on the page 3 (every cell in "area2" must have an value in the right cell) and call it "area1" - go to Page 1 - choose any cell. - go to Datos-> Validez... - in the "criterios" label, choose "Intervalo de Celdas" - Unmark "permitir celdas en blanco" - Mark "Mostrar lista de Selección" - put in "origen": area2 Click "aceptar" Now you will have a cell with a list inside... choose the next right cell and put this: =BUSCAR(B5;area2;area1) An you are ready... choose anything in the list and a correct value should appear... except in you choose "L-100x100x8, L-100x100x10 or L-100x100x12"... you will have a cell with a "#N/A"... Bug, feature or i'm doing something wrong??? J. (PS. I'have put the "Buscar()" in the search issues and got an error... (is possible that the search engine don't like the () symbol) so i can't tell you if this is a duplicate or not... sorry!) --------------------------------------------------------------------- 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]