To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105004 Issue #|105004 Summary|Make OOo Base UI and navigation looks similar to calcu |. Component|Database access Version|OOG680_m2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|bijugc
------- Additional comments from bij...@openoffice.org Sat Sep 12 04:32:36 +0000 2009 ------- This a more of an Excel problem than a OOo-Base issue. But I would like to see this feature first come OOo than a MS-Product. At work I do a lot of data processing. User generally sent me data in an MS-Excel or CSV format. They have MS-Access on their PC, but still they use MS-Excel format. As Excel never insist to define or use consistent data type on a column, there are a lot of crap data, which causes lot of problems while processing data. I wish Office App vendors make layout and navigation of their database module much similar to a spreadsheet layout. My Suggestion:- When user start database module we may present a in memory database with few tables having blank record as mentioned in Issue 104873 (see attachment below) Then the opening screen can have an Accordion/Tree control showing like * Tables - Table1 - Table2 - Table3 * Queries - Query1 - Query2 * Forms - Form1 - Form2 - Form3 * Reports - Report1 User can double click any object (Table1, Table2 ... or Query) it will open as a tab on right side. There should also be a "new Object" button if user want to create a new database object. New table object always comes with 10 case-insensitive text fields with 10 to 20 blank rows. Later user should have an option to rename the table by right clicking on tab and choosing rename in context menu. Table structure can be modified by selecting "Design" from the context menu. For fields, user should have an option to rename it by right clicking the fields column header and choosing rename in context menu. Other field properties can be modified by selecting "Design" from the context menu. This "Design" screen is same as Table "Design" screen with the chosen field as currently selected field. Also both "Design" screens should NOT be popups. Instead it will be shown in the same Tab of corresponding table/view/form/report. There should be also a button on design screen to switch back to data view. This functionality (switch back to data view) is same as current OOo Base Query view. Once user finished working with a table, query, form or report there showed be an "x" button to close the opened tab. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org