[libreoffice-users] 3/4/1`3 in table

2013-03-05 Thread william drescher
I have a table in a writer document that has the first col formatted as date (MM/DD/YY), but when I enter 3/4/13 the 3/4 is converted in a smaller 3/4 = three fourths. Yes I can undo the auto correct, but shouldn't writer be smart enough to not do this in a date format cell ? Thoughts or

[libreoffice-users] Re: 3/4/1`3 in table - duplicate posting - sorry

2013-03-05 Thread william drescher
On 3/5/2013 6:31 AM, william drescher wrote: I have a table in a writer document that has the first col formatted as date (MM/DD/YY), but when I enter 3/4/13 the 3/4 is converted in a smaller 3/4 = three fourths. Yes I can undo the auto correct, but shouldn't writer be smart enough to not do

[libreoffice-users] Re: 3/4/13 in writer table

2013-03-05 Thread william drescher
On 3/4/2013 12:01 PM, upscope wrote: On Monday, March 04, 2013 10:09:52 AM bill wrote: I have a writer document with a table. The first col is formatted as date, but when I enter today ( 3/4/13 ) the 3/4 is formatted as a small 3/4th. I checked the col formatting and it really is date

Re: [libreoffice-users] Re: 3/4/13 in writer table

2013-03-05 Thread webmaster-Kracked_P_P
On 03/05/2013 06:32 AM, william drescher wrote: On 3/4/2013 12:01 PM, upscope wrote: On Monday, March 04, 2013 10:09:52 AM bill wrote: I have a writer document with a table. The first col is formatted as date, but when I enter today ( 3/4/13 ) the 3/4 is formatted as a small 3/4th. I checked

[libreoffice-users] Exported XLS doesn't opens in Calc

2013-03-05 Thread Nacho Rodríguez
Hi I use the PPM application from HP. This application can export data in XLS format. The exported XLS files opens right in MS-Office, but when try to open it with Calc it show the text import window and I get a sheet with XML and HTML tags Renaming the file with HTML extension and viewing in

Re: [libreoffice-users] Exported XLS doesn't opens in Calc

2013-03-05 Thread Jay Lozier
On 03/05/2013 12:31 PM, Nacho Rodríguez wrote: Hi I use the PPM application from HP. This application can export data in XLS format. The exported XLS files opens right in MS-Office, but when try to open it with Calc it show the text import window and I get a sheet with XML and HTML tags

[libreoffice-users] Xtable

2013-03-05 Thread Adriam Delgado Rivero
Using UNO API for java and charge a template that contains a table I try to copy that table on the next page (I need copy also property ) to create a new and I find as this is the code where I get the table and properties // first query the XTextTablesSupplier interface

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Wolfgang Keller
I don't know if it will be suitable, but you can try Kexi (part of Calligra suite, I believe; but you can install it separately). I heard it is much better than LO Base, but I don't know enough to verify that statement. Kexi will become usable as soon as it supports composite (natural) keys.

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Wolfgang Keller
I am still waiting for a database program that will allow me to create applications (not pieces of applications, like queries and forms) without having to learn C (this old dog is not going to learn that new trick!). If LO Base is not enough for you because you need more application logic,

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread J.A. de Vries
On 2013-03-05 20:12, Wolfgang Keller wrote: I am still waiting for a database program that will allow me to create applications (not pieces of applications, like queries and forms) without having to learn C (this old dog is not going to learn that new trick!). If LO Base is not enough for you

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Steve Edmonds
On 2013-03-06 08:13, Wolfgang Keller wrote: I don't know if it will be suitable, but you can try Kexi (part of Calligra suite, I believe; but you can install it separately). I heard it is much better than LO Base, but I don't know enough to verify that statement. Kexi will become usable as

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Dan Lewis
On 03/03/2013 10:09 AM, John R. Sowden wrote: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: *Flat databases* A flat database contains one or

RE: [libreoffice-users] Exported XLS doesn't opens in Calc

2013-03-05 Thread Dennis E. Hamilton
If renaming it from .xsl to .html had it open correctly, I suspect it is not OOXML. It *might* be the Excel XML Spreadsheet format. I checked here: http://hpsws.lithium.com/t5/Project-Portfolio-Management/HP-PPM-and-Excel-Integration/td-p/2250 Apparently exporting a report from PPM often

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Girvin R. Herr
Wolfgang Keller wrote: I don't know if it will be suitable, but you can try Kexi (part of Calligra suite, I believe; but you can install it separately). I heard it is much better than LO Base, but I don't know enough to verify that statement. Kexi will become usable as soon as it

Re: [libreoffice-users] 3/4/1`3 in table

2013-03-05 Thread upscope
On Tuesday, March 05, 2013 06:31:23 AM william drescher wrote: I have a table in a writer document that has the first col formatted as date (MM/DD/YY), but when I enter 3/4/13 the 3/4 is converted in a smaller 3/4 = three fourths. Yes I can undo the auto correct, but shouldn't writer be

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Mirosław Zalewski
On 05/03/2013 at 20:13, Wolfgang Keller felip...@gmx.net wrote: Kexi will become usable as soon as it supports composite (natural) keys. May I suggest you to contact Kexi main developer, Jarosław Staniek, with this proposal? You will find his e-mail address here:

Re: [libreoffice-users] definition of flat/relational database

2013-03-05 Thread Girvin R. Herr
Dan Lewis wrote: snip I'm still don't understand what the structure of dBase2 is. How can you use two or more tables in a query for example using this database engine? Some light reading required? https://en.wikipedia.org/wiki/DBase File formats: dbase II: