Hi :) Errr, it's a feature, not a bug! It preserves the "audit trail" of the data being put into the database.
To view the data i think you are supposed to use a Query and have that sort or filter your data any which way you like. Calc would then read from the Query (hopefully). Regards from Tom :) >________________________________ > From: Girvin R. Herr <[email protected]> >To: Alexander Thurgood <[email protected]> >Cc: [email protected] >Sent: Friday, 31 May 2013, 18:34 >Subject: Re: [libreoffice-users] Re: How to insert a row between current >fields? > > > > >Alexander Thurgood wrote: >> Le 31/05/13 02:42, minhsien0330 a écrit : >> >> Hi, >> >> >>> Dear all: >>> When editing field names in Design View in Libreoffice Base, I cannot >>> insert a new row between current fields. >>> If I click the "Insert Rows", Base will add a new row at the end of >>> this table, but not the current site. >>> Does Base not support insert a new field that just like Calc does? >>> Thanks. >>> >> >> No. Base is, well, a database program. Calc is...a spreadsheet, not a >> database program. The two are constructed differently, behave >> differently and have different code, which is as it should be. >> >> However, I would agree with you that if the user is provided a user >> interface which leads the user to believe that he/she can do such a >> things as graphically insert a new field definition, then that >> functionality should actually work. As you have noticed from your >> attempts, it does not. This is one of the older limitations of Base, >> that has been around for a very long time. >> >> The solution to your problem is to use a SQL command via the Tools > SQL >> menu : >> >> http://www.oooforum.org/forum/viewtopic.phtml?t=70021 >> >> >> If this doesn't work in the version of LibreOffice you are using, then >> this is a bug, because with the post above, it worked in OpenOffice.org >> back in 2008. >> >> >> Alex >> >> >The "Insert Rows" function threw me at first also. Maybe it should be renamed >"Add row(s)" rather than "Insert Rows". That should be an easy menu change >and much less confusing for the users. > >Another option may be to display the Base data in a spreadsheet and move the >columns around? >I use a question mark, since I have never actually tried to do that. >Girvin Herr > > > >-- >To unsubscribe e-mail to: [email protected] >Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >List archive: http://listarchives.libreoffice.org/global/users/ >All messages sent to this list will be publicly archived and cannot be deleted > > > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
