I have X11 and OpenOffice installed on my MacBook Pro now, and everything seems to be working OK. My first question about OpenOffice's spreadsheet concerns the sort function.
On Excel, you can simply highlight a column and sort, with every column to the left and the right adjusting accordingly. For example, you could highlight column 7, then choose "Sort by" column 76, then by column 2 and then by column 16. This is obviously very convenient when doing a lot of design and analysis. On OpenOffice's Calc spreadsheet, it appears that I have to highlight EVERYTHING that I want to sort. If I click on a single column, I can sort that column only. If I highlight three columns, those three columns are sorted in relation to each other, but all the other columns are left behind. This is inconvenient if I have to sort a large range of rows or columns, rather than the entire spreadsheet. For example, if I want to sort the first 500 rows of columns 3 through 27, then I have to highlight all the columns for the first 500 rows. Is there another way to sort columns with Calc, or is that it? If that's it, does anyone know of any other spreadsheets that have Excel's multi-sorting ability? Thanks. ____________________________________________________________________________________ Get your own web address. Have a HUGE year through Yahoo! Small Business. http://smallbusiness.yahoo.com/domains/?p=BESTDEAL
