I'm familiar with various kinds of user interface, I've been learning to use the electronic equipment in '80s and using command line as well as complex GUIs like ProTools. It's really difficult to confuse me with an user interface.
I wanted to do a simple thing today: make a query in OpenOffice Base and move the resulting table to OpenOffice Calc for further processing. I created a query, executed it and saw a nice table. Great. Now I want to move it to Calc. How? I tried few usual ways of completing this kind of task.
- Select the table and copy it. I looked for the select all option in the Edit menu. It's not there. I try CTRL+A, no effect. I try to select one column by clicking on the column header. It works, the whole column is highlighted. Now I need only to select the remaning columns, but it's impossible.
- Investigate a context menu of the query. First item is "copy". Great, I clicked it, opened Calc and pressed CTRL+V. The message popped up and said that it was impossible to paste the clipboard contents. Next options are delete, rename, edit, open, create as view, form wizard, report wizard. No save as or export. I try to open, edit, I get to the point where I can't select the whole table.
- Use a report wizard. Maybe it's a problem of my OpenOffice installation, but it just opens OO Writer with some empty heading and there's no wizard.
- Use a form wizard. The wizard pops up this time. I select all the fields, choose the table view, open the form. I see a nice table and I want to copy it, but again, it's impossible to select the whole table. I look at the menu bar in search for select all or other kind of function that would allow me to use the query result.
I really wish that OpenOffice was a good tool, I use it and I recommend it to people. But this was all frustration and a waste of time.
UPDATE: There is something called a Data Pilot that should import a table or a query result to OO Calc. I tried to use but but had no luck. I just wanted to import the table exactly as it appears in the query, but Data Pilot showed a confusing user interface and I ended up with something that didn't even resemble the original table.
UPDATE: As an anonymous reader suggested, I created a query, saved it, right-clicked it, selected COPY, opened a new spreadsheet and choosed Paste… Voila! Thanks!