Hello, I'm working with Office suits for approximately 10 years so would like to present few ideas that can be implemented in OpenOffice Calc to make it more productive. Please, look on them, discuss them and if you get familiar with them implement them in Calc.
== Filtering lists == When you try to filter lists in Calc you don't know how many rows you get. This is useful and valuable information. I suggest show this in status bar (like MS Excel) or in tooltip. Also aggregation functions (sum, average...) below sorted selection should show values only for visible part of list (maybe with comment on affected cell). http://img213.imageshack.us/img213/2786/filtering0of.gif == Moving selection == If you move selection in spreadsheet to cells containing data only you can do is replace data. Moving selection with some modifier (shift or ctrl) should move existing cells down or right like in MS Excel. http://img208.imageshack.us/img208/292/moveselection1gm.gif == Drag-and-drop with context menu == I also miss (against MS Excel) contextual menu when dragging filling mark (little box in bottom right corner of selected cells) with secondary mouse button (in Linux is usually used middle button for that purpose - try dragging file in Nautilus with middle button). Through this menu in MS Excel I am able to fill only formats/values, make geometrical sequence... It's easy and fast. In Openoffice it is not so straightforward. It's not about to be like Excel but be so productive. BTW my full article with other suggestion (for desktop not office suite) can be found at http://chabada.sk/better-desktop/. -- Peter Chabada --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
