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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.