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 <girvin.herr@sbcglobal.net> To: Alexander Thurgood <alex.thurgood@gmail.com> Cc: users@global.libreoffice.org 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. AlexThe "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: users+unsubscribe@global.libreoffice.org 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: users+unsubscribe@global.libreoffice.org 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