Provides friendly Word processing, Spreadsheets & Presentation software.

|
Kingsoft Office > News > Differences between Kingsoft Office and MS Office - for Spreadsheets software

Differences between Kingsoft Office and MS Office - for Spreadsheets software

Release Date: 08-21-12

Kingsoft Spreadsheets 2012 is as good as Microsoft Excel both in use and operation. However, there are a little bit differences between them. This article introduces those different functions and comparing the key features.

Learn about Differences between Kingsoft Writer and Microsoft Word, or Differences between Kingsoft Presentation and Microsoft PowerPoint.

Fill cells

For Kingsoft Spreadsheets:
1. Directly click the left mouse button and drag the cell fill handle, which is ascending filling.
2. Press the Ctrl key and click the left mouse button and drag the cell fill handle, which is copy filling.

For Microsoft Excel:
1. Directly click the left mouse button and drag the cell fill handle, which is copy filling and also have fill options.
2. Press the Ctrl key and click the left mouse button and drag the cell fill handle, which is ascending filling.

F4 shortcut

For Kingsoft Spreadsheets: Only repeat the previous cell formatting, such as fill color for cell, font formatting

For Microsoft Excel: Repeat any previous action, such as inserting rows.

Reading Mode

For Kingsoft Spreadsheets: Highlight the rows and columns of the selected cell (View-read mode).


For Microsoft Excel: None

Full-screen

For Kingsoft Spreadsheets:

Classic interface: “View-Full Screen ", the edit bar is displayed above the file.
2012 interface: no full-screen option

For Microsoft Excel: When enter the View-full screen, the main menu bar is displayed above the file.

Page Setup

For Kingsoft Spreadsheets: You can directly custom paper size.


For Microsoft Excel: None

Internet and network paths converted to hyperlinks

For Kingsoft Spreadsheets: In the "Tools-Options-Edit and display", you can set whether convert Internet and network paths into hyperlink for the cells.


For Microsoft Excel: In the "Tools-Options-spell check-AutoCorrect Options-AutoFormat”, you can set based on your needs. When you enter the Internet and network paths, the "AutoCorrect Options" will pop-up, you can begin to set.

Do not open hyperlinks

For Kingsoft Spreadsheets: In the “Tools - Options – Edit and show", you should choose "Press the ALT key and click to follow hyperlink" option.

For Microsoft Excel: After entering the Internet and network paths, click the cell, Press the left mouse button, and then release that, thus you can select the cell without having to open the hyperlink

Picture toolbar

For Kingsoft Spreadsheets: Picture toolbar is a floating toolbar, when you selected the picture, the toolbar will display.

For Microsoft Excel: When you selected the picture, the toolbar will display. When the Picture toolbar is displayed, you can turn it off

Set the default workbook / worksheet name

For Kingsoft Spreadsheets: In the "Tools–Options-General and save –Advanced”, you can set default worksheet name.

For Microsoft Excel: None

Custom sequence

For Kingsoft Spreadsheets: You can direct input sequence list to add.

For Microsoft Excel: You can direct input sequence list to add or it can be imported by column region.

Print toolbar option button

For Kingsoft Spreadsheets: You can directly print or open the “Print” dialog box to print.

For Microsoft Excel: You can directly print.

Inverse output

For Kingsoft Spreadsheets: Open “Print” option, you can choose “Inverse output” way to print.

For Microsoft Excel: None

Annotations show

For Kingsoft Spreadsheets: Move the mouse to the cell with annotations, the comments show, otherwise, it does not show.

For Microsoft Excel: You can set hide or show the annotations. When it is hidden, move the mouse to the cell with annotations, comments display. When it is shown, regardless of the related cells are selected, it will be shown.

Balloons

For Kingsoft Spreadsheets: Fixed-size, non-format

For Microsoft Excel: You can set the annotations and balloons formatting.

Window

For Kingsoft Spreadsheets: Rearrangement window

For Microsoft Excel: Rearrangement and side-by-side windows

Consolidate

For Kingsoft Spreadsheets: Select a function, add a reference location and set the tab position.


For Microsoft Excel: Select a function, add a reference location and set the tab position, andalso provide a "link" to create links to source data, you can change any data in the source area are automatically updated when the merger table.

Highlight Changes

For Kingsoft Spreadsheets: In "Tools-Revision-Highlight Changes", you can click this option when workbook has been shared.

For Microsoft Excel: In "Tools-Revision-Highlight Changes", you can click this option anytime.

Share Workbook

For Kingsoft SpreadsheetsWhen the workbook is shared, the following functions cannot be changed: merged cells, conditional formatting, data validation, charts, pictures, objects (including graphics objects), hyperlinks, subtotals, data tables, PivotTable, workbook and worksheet protection, and macros. In addition, you cannot insert rows, columns, cells, annotations, and cannot be cleared annotation, cannot delete cells, rows, columns, and data cannot be sorted operation

For Microsoft ExcelWhen the workbook is shared, the following functions cannot be changed: merged cells, conditional formatting, data validation, charts, pictures, objects (including graphics objects), hyperlinks, subtotals, data tables, PivotTable, workbook and worksheet protection, and macros.

Create a PivotTable

For Kingsoft SpreadsheetsClick “Data-PivotTable" and the dialog box pop-up, first select the data you need to analyze: you can select a range of cells, and can also choose another PivotTable (in this case the area of the analysis is based on the PivotTable source data). And then select the location to place the PivotTable: You can create a new worksheet, and can also select area in this worksheet. 

For Microsoft ExcelClick "data-data pivot table and data a perspective view”, first select the type of data source analysis, the default first type is "Microsoft Office Excel data list or database", and choose “PivotTable” as created report type, and the click the "next, in step 2, you should select the cell range of data to be analyze, and then proceed to step 3, you should select the location to place the PivotTable.

The difference between Kingsoft Spreadsheets and Microsoft Excel is that Spreadsheets can select the existing PivotTable as a source of data, while for Excel, when you choose PivotTable source data area has been done will be prompted whether to create a new PivotTable or overwrite the original pivot table tips, otherwise that is all the new data PivotTable for default.

Chart

For Kingsoft SpreadsheetsClick “Insert-Chart”, the chart dialog box will appear, first you should select the chart type (such as a column chart) in the left of the dialog box, and then the corresponding color scheme will be displayed, you can visually preview the chart. Next choose the data area of the generate chart, and finally set chart options.

For Microsoft ExcelClick “Insert-Chart”, the chart dialog box will appear, first you can choose “standard type” or "custom type" in the dialog box, the "Custom type" which contains an embedded chart type and you can preview the chart. Next choose the data area of the generate chart. Next set the chart options. Finally, select the chart position

Table style

For Kingsoft Spreadsheets: Click on the "Table Styles" tab

For Microsoft Excel: None