[dba-dev] spreadsheet: auto fit columns?

2010-02-22 Thread John W
I'm writing out .ODS files via a program. I'd like to find a way to adjust all the column widths such that no cells "spill over" when the file is opened in Calc. That is: for each column, I want the column width to be that of the widest cell in that column. I'm not using UNO since that requires at

Re: [dba-dev] Confirming Oracle issue

2010-02-22 Thread Drew Jensen
What do you mean with a dataview window: grid control, date control, table? Yes I meant if you just opened a table directly. The latter: you can format the table column as -mm-dd hh:min:sec, the time then is always 00:00:00. and yes that would be the possible problem I was wondering ab

Re: [dba-dev] Confirming Oracle issue

2010-02-22 Thread Peter Eberlein
Am 22.02.2010 14:55, schrieb Drew Jensen: On 2/22/2010 8:38 AM, Drew Jensen wrote: On 2/22/2010 2:23 AM, Peter Eberlein wrote: Hi, anybody from the base team there who can confirm http://www.openoffice.org/issues/show_bug.cgi?id=109185 Also, could you tell me how you are connecting, ODBC, J

Re: [dba-dev] Confirming Oracle issue

2010-02-22 Thread Peter Eberlein
Hi Drew, Am 22.02.2010 14:38, schrieb Drew Jensen: On 2/22/2010 2:23 AM, Peter Eberlein wrote: Hi, anybody from the base team there who can confirm http://www.openoffice.org/issues/show_bug.cgi?id=109185 Hi Peter, Does that mean also that in a dataview window only the Date portion if a

Re: [dba-dev] Confirming Oracle issue

2010-02-22 Thread Drew Jensen
On 2/22/2010 8:38 AM, Drew Jensen wrote: On 2/22/2010 2:23 AM, Peter Eberlein wrote: Hi, anybody from the base team there who can confirm http://www.openoffice.org/issues/show_bug.cgi?id=109185 Also, could you tell me how you are connecting, ODBC, JDBC? Thanks -

Re: [dba-dev] Confirming Oracle issue

2010-02-22 Thread Drew Jensen
On 2/22/2010 2:23 AM, Peter Eberlein wrote: Hi, anybody from the base team there who can confirm http://www.openoffice.org/issues/show_bug.cgi?id=109185 Hi Peter, I don't have an Oracle server running at the moment, sorry. There will be one up here by the end of the week, but not any sooner

Re: [dba-dev] Confirming Oracle issue

2010-02-22 Thread Peter Eberlein
Am 22.02.2010 09:27, schrieb Fernand Vanrie: Peter, Its seem logical to me that a "time" field not can handle "date" information but maybe i miss understood your question ? yes The Oracle Date field is a Date/Time field as the Timestamp field is. The difference is the "fractional seconds".

Re: [dba-dev] Confirming Oracle issue

2010-02-22 Thread Fernand Vanrie
Peter, Its seem logical to me that a "time" field not can handle "date" information but maybe i miss understood your question ? In general database stored times/dates and the way OO handles this things is for me :-) a "blackbox". Therefore i alwayqs uqe cDate(databasefield) as a start for fut