Apache OpenOffice (AOO) Bugzilla – Issue 22611
DATASOURCE DATE ROUTINES
Last modified: 2006-05-31 14:29:06 UTC
Bugs in version 1.1rc4 for Windows (with Win XP pro): In a "Datasource" dbf table with 1000 records with this structure: DATAESAME,D (date) COGNOME,C,30 (char) NOME,C,30 DATANASCIT,D INDIRIZZO,C,50 CITTA,C,30 TELEFONO,C,30 PRESTAZION,C,50 PROVENIENZ,C,30 MEDICO,C,50 REFERTO,M (memo) If you click the Data to text.. icon --> Insert Database Columns as Text (*): if you insert text and dates this way,as an example <cognome> <nome> <datanascit> <dataesame> in english <surname> <firstname> <birthdate> <examdate> dates (in Italy format is DD/MM/YYYY or DD-MM-YYYY) are transfered in the text with a minus two days error for example this patient data: ROMANO Rosalba 15-08-1957 02-10-2003 are transfered in the text as: ROMANO Rosalba 13/08/57 30/09/03 (note that the date format is not maintained, although I used the option Format(DATAESAME) --> (*) From Database is it another bug?) This error was produced on the same data both with a .dbf file and an MySQL/odbc table. The bug is present both in the Windows (I use WinXP pro) and in RedHat 9.0 Linux. I found another bug in updating OpenOffice from version 1.0.3 to 1.1rc4 with the Windows version: All dates in the dbf table (obtained with previos versions of OO) are shifted of 2 days (HUGE BUG!). Your date routines need to be reviewed to be more reliable. This does not appear to happen with the same version on OpenOffice in Linus (RedHat 9.0) Check also the date format. I am trying to use OpenOffice as a small RIS (radiology information system) for the patients RX reports and for storing records. So far we have a dbf table with 1000 records. When you want to print a document that contains data from a database fields the program asks: "Your document contains addres database fields. Do you want to print a form letter [Yes][No][Help]" This did not happen with version 1.0.3. I find it very intrusive and it adds extra-step to print a document. This "feature" should be available elsewhere, not when you have to quickly print a report, for example. File-->Autopilot-->Form does not work, it outputs a message saying "The files required could not be found - please start the OpenOffice. org Setup and choose Repair" Repairing the application does not fix it. best regards Daniel Liscia <danyliscia@libero.it>
Daniel, thanks for supporting OOo. One thing: *Please* submit separate issues for separate problems. There is a number of reasons for this, amonst them the fact that different problems are to be handled/fixed by different people, which *requires* different issues in IZ. So please split this issue here up into separate issues, where each one describes exactly *one* problem you have. Thanks!
Hi, separated issue arrieved. I close this "many isssues task". Bye Marc
close
change subcomponent to 'none'