Re: [GENERAL] spreadsheet interface

On Monday 17 December 2007 3:10 pm, hjenkins wrote:
> Hello, all,
>
> >Dave Page writes:
> >pgAdmin will copy arbitrary blocks of cells to spreadsheets, and will
> >accept rows pasted into the edit grid. It should work out of the box
>
> with >Excel and OpenOffice - if not, check the copy delimiter/quoting
> options >under file->options.
> That sounds perfect, but I can't get it to work, even with OO. I can't
> find any copy delimiter/quoting options >under file->options.
>
> When you say "pgAdmin does work with a little effort", Mr. Hart, do you
> mean that I can set it up so that one can cut-and-paste multiple cells, as
> Mr. Page is describing, or that there is a work-around which requires more
> effort per-use than cut-and-paste?
>
> Using OpenOffice:
> OO driver: http://dba.openoffice.org/drivers/postgresql/index.html
> JDBC driver: http://jdbc.postgresql.org/
> ODBC driver: http://pgfoundry.org/projects/psqlodbc/ and others
>
> Since the JDBC driver is in Gentoo-portage, I tried that, but
> OpenOffice can't load org.postgresql.Driver as the JDBC Driver class... If
> I use this, I'll let you know how it goes.
You need to set up OpenOffice. Do following:

1) From Menu bar Tools --> Options
2) Click on OpenOffice.org --> Java
3) Make sure a Java Runtime Environment is set up
4) Click on the Class Path button
5) Click on Add Archive and browse for location of the Postgres JDBC jar file.
6) Back out of menus
7) Restart OpenOffice

-- 
Adrian Klaver
aklaver@comcast.net

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly