KOffice 1.1 Beta 3 Review: Part 6

<<

1 2 3 4 5 6 7 8

>>

KSpread 1.1

About 90% of the emails I received asked if KOffice can import Microsoft Office documents. In subsequent reviews, I will try to focus some time on importing Microsoft Office documents.

I booted my machine back to Windows and took a screenshot of an Excel spreadsheet that I created 4 months ago.
Click to enlarge:


I imported the excel file into KSpread. One good thing about Linux is that it can read my Windows partition. This way I don't have to put the file into a floppy.
Click to enlarge:


KSpread's Excel import filter is quite good. It imported all my data--that's pretty much what I needed.

KSpread has an auto-column expand feature that allows me to double click on a column, and automatically make the column expand to the size of the cell that has the longest string.
Click to enlarge:


I decided that I want to make my spreadsheet pretty. I stumbled across this "table style" feature. I selected the region of cells (C3:H9), click "format"->"table style"->"Standard 2".
Click to enlarge:


With a little rearranging and reapplying table styles, I came up with a good looking spreadsheet. To center "Debt" across the selection, I select A1:H1, click on "table"->"merge cell", and click on the "center" icon.
Click to enlarge:


I then did a print preview on the spreadsheet.
Click to enlarge:


All the basic functionality that I've come to expect from a spreadsheet is presented in KSpread. In addition, KSpread has a very good Excel 2000 importer. This should give soon-to-be KOffice users the assurance that the KOffice team is keen to making sure Microsoft Office compatibility is one of their highest priorities.

KSpread is already a good enough spreadsheet for probably 90% of users, with the basic functionalities I've described. In part 7, I will talk about the more advanced features in KSpread.

<<

1 2 3 4 5 6 7 8

>>