Sophisticated and flexible, OpenOffice also works transparently with a variety of file formats, including those of Microsoft Office.Īvailable in over 45 supported languages with more being constantly added by the community, OpenOffice runs stably and natively on Solaris, Linux (including PPC Linux), Windows, Mac OS X (X11), and numerous other platforms.

It includes the key desktop applications, such as a word processor, spreadsheet, presentation manager, and drawing program, with a user interface and feature set similar to other office suites. I will not help with that in this topic.OpenOffice Portable is a multi-platform office productivity suite. To explore sorting by last name, open a new topic.

In Sheet2, assign the proper styles to A4 through E999īecause you have only one name field, names will sort by first name.Data → Define Range → Name → Customers → Add → OK.In Sheet2, type A3:E999 in the Name Box and press Enter.In Sheet2, delete row 4 so the names are adjacent to the headings so Calc understands the relationship between them.In Sheet1, assign the proper styles to A4 through E4 cell D4 should have a date style and all the others should have a text style.I will assume you're putting the new customer on Sheet1 line 4. For your attachment, start by making some settings so the spreadsheet will act more like the database you should have.

It is harder to use a button on your sheet like you show in Sheet1.A6 use a toolbar button. You cannot trigger a macro by pressing the Enter key. Since you cannot move information between cells with formulas, you must use a macro.You can record a macro to move the data, and then assign a button to it. And enter it (alphabetically) into the list on sheet 2 when I hit 'enter.'

Openoffice draw portable