[CentOS] (OT) OpenOffice.org calc chart strangeness.

Sat Apr 3 20:10:28 UTC 2010
Pascal Robert <probert at macti.ca>

Le 2010-04-02 à 20:19, Bill Campbell a écrit :

> I am attempting to create a simple line chart graphing three columns from a
> soffice-calc spreadsheet.  I expect it to take the leftmost column as the
> X-Axis, plotting the others on the Y-Axis, but it always creates an X-Axis
> of the row number in the columns, and the first column amongst the data.
> I have tried this on OpenOffice.org 3.2.0, NeoOffice(R) 3.0.2 Patch 2,
> iWork Pages, and Excel 12.2.4 in Microsoft Office 2008 for Mac.
> It does what I expect in iWork Pages and M$-Excel, but not in the
> various incantations of OpenOffice.org.
> I OO-calc has gone to a fancy wizard thingy that doesn't seem to have any
> way to specify details for the X-Axis, and I can't find anything useful in
> the on-line documentation.
> Does anybody know how one gets this to work in OpenOffice.org?
> The Linux tie-in is that I'm getting data from a postgresql database that
> lives on a Linux box, and none of the fancy commercial products seem to be
> able to use it in their data sources.

You should be able to connect to it with a ODBC driver for pgsql, Excel on both Windows and OS X should be able to talk to it by ODBC.

> On the other hand, I have written a python script that extracts the data
> from the postgresql database and creates the pretty reports using groff and
> gplot totally on Linux which is faster in any case for my current problem.
> Bill
> -- 
> INTERNET:   bill at celestial.com  Bill Campbell; Celestial Software LLC
> URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
> Voice:          (206) 236-1676  Mercer Island, WA 98040-0820
> Fax:            (206) 232-9186  Skype: jwccsllc (206) 855-5792
> Blessed are the young, for they shall inherit the national debt.
>  -- Herbert Hoover
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos