To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=102022
                 Issue #|102022
                 Summary|Data validity using cells area don't work after saving
               Component|Spreadsheet
                 Version|OOo 3.1
                Platform|PC
                     URL|
              OS/Version|Windows XP
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|code
             Assigned to|spreadsheet
             Reported by|ziotibia81





------- Additional comments from ziotibi...@openoffice.org Mon May 18 10:34:38 
+0000 2009 -------
I use openoffice in Italian so I don't know if my tanslation for menu items is
correct.

Step to reporoduce error are:

- Create a new spreadsheed contains 2 folders: workarea and lookuparea.
- In lookuparea from A1 to A10 fill with some test
- In workarea click on a column and go to menu data -> validity
- On criteria select "cells area"
- Click on "selection list"
- In sources insert: "lookuparea.$A$1:$A$10"

So all work and we have a dropdown menu showing data on lookuparea.

Now save file in xls format and close calc.
Reopen xls file using calc, click on a cell who have dropdown menu and dropdown
is empty and show "Err:520".
Now on data -> validity sources space is empty.

---------------------------------------------------------------------
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

Reply via email to