Hi Joost, Thank you very much.
Seems I come to understand with your help. But I have an another question. How to import database? I know MS-Excel has a menu item called "import external data" which can import data from a spreadsheet, text file, database, etc... But I can't found such a entry in calc. Thank you! Best regards, zhulihua 2008-02-20 发件人： Joost Andrae 发送时间： 2008-02-19 18:10:33 收件人： [email protected] 抄送： 主题： Re: [qa-dev] About "range" in Calc Hi, "database ranges" defined (named) cell areas which you can use eg. within Calc's database formulas like DBSUM. If you import database content into Calc then the application automatically creates a database range (eg. import1). Within the options of such a named object you can define if the imported database content is saved or if the query is saved within the document only. You can define if formating is kept and if you're allowed to insert cells into that area. If you imported data from a database then you can redo the database query and update your Calc document by using the "refresh range" menu entry. If you want to see what data belongs to that database range then you can use "select range" to select it. Kind regards, Joost zhulihua wrote: > Hi everyone, > > Under the data menu of Calc, there are 3 items named "define range...", > "select range...", and "refresh range". > > In what scenario can we use them? After click More button in "Define database > range" dialog, there are 4 checkboxes, I don't know the function of the last > 3 ones. > > Is there any detailed specifaction about this feature? > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
