![]() ![]() I have read what docs I could find, and my questions were honest ones of, essentially, have I read correctly. In Excel's case, they pass a file to a colleague. What matters, to the user, is what did they experience and do to get their work done. (me) did their magic and provided a fully installed computer. What was and was not installed is irrelevant. Sadly, you did not see fit to answer them, merely to waste my time with another non-reply. #How to use openoffice excel install#Back to xls.Īt least you may have learned that you need to install MS Query from your Excel CD when the database import does not work. I can not modify the query used to, say, only link to a subset of columns?)Īll your assumptions are wrong. I CANNOT take anything less than the entire table, correct? (e.g. LINK to the ENTIRE DATABASE, inserting it at the current cell.īut. (Question: importing to cells is what they mean by 'import as text'?) IMPORT (the entire database or) columns, by dragging columns into the spreadsheet - but it imports as FORM FIELDS, not as cell data. IMPORT rows of the data by dragging in rows (instead of the entire table, above) IMPORT the entire database (datasource), via, for example, dragging the top / left corner of the data source into a cell Please sanity check my understanding: Having connected a calc sheet to itself, or another sheet, as a data source, I can: In ooo, if I understand correctly, you would have to pass at least two files: The spreadsheet itself, and a Base file containing the query. Have a spreadsheet with a data source, pass the one file to a colleague, and off you go. If I understand correctly, the Excel file, at least, is standalone. The user perceives it as truth, therefore it is truth. Truth or not, behind the scenes, is irrelevant. It might have changed with MS Office 2003/7. Don't take this as the full truth, either. ![]() In Calc you will define a database range (search this forum for database ranges) in order to integrate the data into a spreadsheet. OOo Base or Queries that can be defined in Base are the counterpart for that in OpenOffice. #How to use openoffice excel how to#But that's not the full truth: Excel makes use of an intermediate layer called MS Query (where you can specify how to connect and which columns and tables to retrieve). If you come from a MS Office background you might be tempted to think that you can link directly from Excel to a database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |