Kingsoft Office 2010 Professional contains 3 applications: Kingsoft Writer, Kingsoft Presentation, and Kingsoft Spreadsheets. Kingsoft Spreadsheets 2010 contains the following changes:

    • Added support for opening files in .VML, .MHT, and .HTML format.
    • Added Range.CopyFromRecordset, which is used for importing contents from SQL.
    • Added a control option to Replace Internet and network paths with hyperlinks as you type in “Tools -> Options -> Edit”.
    • Enhanced the protect worksheet function.
    • Added workbook sharing.
    • Added support for displaying multiple summarizing in the status bar.
    • Added a function to convert text to a hyperlink.
    • Added support to allow users to edit ranges.
    • Added support inserting pictures in the header and footer.
    • Added support for pasting a name list in a worksheet.
    • Added support for saving as a .PRN text file in a fixed width.
    • Added 27 worksheet functions (e.g. database function, and more).
    • Added Reset the page break in the page break preview.
    • Added support for updating and importing external data.
    • Fixed a problem that prevented filling a sequence based on the date at the end of a month.
    • Fixed a problem of incorrect reference among workbooks.
    • Fixed a problem that the properties of page setup were lost when moving or copying a worksheet.
    • Fixed a problem that the calculation results of some nested functions were not matching with Microsoft Excel.
    • Fixed a problem that users did not know when a worksheet is protected.
    • Fixed the missing control option of Hidden in “Format -> Cells -> Protection”.
    • Improved the function of automatically identifying the header row during data sorting.
    • Improved the function of Auto Filter Again during data filtering.
    • Fixed a problem that the Hyperlink function can not link to a cell.
    • Fixed a problem that the data label of a pie chart does not display guide lines.
    • Fixed a problem that a user cannot exit when editing the protected cells in a protected worksheet.
    • Fixed a problem that the result is displayed as #Value! when users assign null value to a RANGE through an array in VBA.
    • Fixed a problem that users can not view the statistical result in the status bar after activating an OLE object.
    • Fixed a problem that adds an external reference name when copying cells, while it prompts to update the external data source after reopening the document.
    • Fixed a problem that saving in *.DBF format causes decimal loss when reopening the document.

      Related Articles

      1. Kingsoft Office 2010 (6.6.0.2462) has been released
      2. New features and bug fixes included in Kingsoft Writer 2010
      3. Password protect workbook, sheets and cell ranges with Kingsoft Spreadsheets 201...
      4. Kingsoft Office 2009 Released
      5. List of new additions and changes in Kingsoft Presentation 2010

      Tags:

      kingsoft imported graph appears (3), spreadsheets2010 (3), spreadsheet office 2010 (2), professional spreadsheets (2), how to make a chart in kingsoft word 2010 (2)