Re: OO: 1.1.x: problems with the edit tables
Uwe Brauer <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
>>>>> "Frank" == Frank Schönheit <- Sun Microsystems Germany >>>>> <[email protected]>> writes: Frank> Hi Uwe, Hi Frank [snip] >> >> - when choosing autoformat no field is added Frank> What do you mean by "autoformat"? I am using the spanish version so I have to check for the english one. >> - the display is not refreshed I have to leave the table >> display another one and return in order to see the new >> fields, this is very annoying. Frank> I assume you mean the table data view (opened by Frank> double-clicking the table) whose columns are in fact not Frank> updated when you change the design. Frank> Instead of closing and re-opening, you might also choose Frank> "rebuild" from the "refresh" drop down icon in the toolbar. Frank> You might also submit an RFE requesting automatic Frank> updates. I'd consider this a valid, though not-too-high Frank> priority, RFE. Since I have to convince people used to MS Access I think everything which enhance the convenience (and not necessarily the features) should be of high priority (IMHO). >> - once the field is generated its name can not be changed nor >> its format: Bug or feature? Frank> What type do you see in "Edit|Database|Connection Type"? Frank> "MySQL" or "ODBC"? Should definately be MySQL, *not* ODBC, Frank> then editing columns is possible. I see ODBC, I thought this should be the setting, I thought MySQL was sort of buggy, seems to be the other way around. That definitely should be mentioned in the Doc somewhere >> - when choosing decimal / or numeric and specifying the >> standard format, a column full of zeros is generated. I >> have to change the standard format to format 1234,45 in >> order to prevent this strange outcome. Frank> Hmm, cannot reproduce. IssueZilla might be happy about your more Frank> detailed description :) I have the feeling this might be due to the spanish version, but I have to check >> - the copy and paste of non text columns into scalc documents >> suffer from the following all numerical formats (decimal >> numeric) end up with the symbol of the euro added. When >> data or time stamps are chosen they end up in the calc >> document as ###. These problems can be repaired by setting >> the format of the columns in the calc document, but this is >> inconvenient. Since for the next fresh up the same >> behaviour happens. Frank> again: Hmm, cannot reproduce. Sample database (result of a Frank> "mysqldump" for the table in question, plus .odb file Frank> accessing this database) might be useful in IZ .... Same here. I will check and then may be IZ. Uwe