dhtmlxSpreadsheet 2.0 Released with New Features and Improvements

| Comments (31)

We are happy to introduce a new version of our JavaScript/PHP spreadsheet widget, dhtmlxSpreadsheet 2.0. This update adds a lot of new features and improvements, including cell validation, the ability to lock cells, Undo/Redo operations, and more.

Data Validation

New version supports data validation in cells. It allows you to define the cell type and use its parameters to validate entered values. Supported cell types include: number, email, positive, or not empty. When a user types an incorrect value into a cell, a red triangle appears in the upper-right corner of the cell, indicating that the value should be corrected.

dhtmlxSpreadsheet 2.0 - Cell Validation

 
Lock/Unlock Cells

We have added the ability to lock cells to prevent them from being changed. You can easily lock/unlock individual cells using the context menu.

dhtmlxSpreadsheet 2.0 - Locking Cells

 
Improved Copy/Paste

dhtmlxSpreadsheet 2.0 provides better support for Ctrl+C/Ctrl+V operations, and also adds support for Ctrl+X. We have fixed a few bugs so cut/copy/paste clipboard operations now work more stable.

Another enhancement is support for relative and absolute references in formulas while copying and pasting cells with formulas (Excel-like behavior). dhtmlxSpreadsheet 2.0 also preserves cell style when you copy/paste cells within the spreadsheet.

 
Block Selection

With this update, you can select a block of cells to copy to clipboard or perform mass operations on selected cells: change text style, background, lock cells, or set up cell type (email, number, etc).

dhtmlxSpreadsheet 2.0 - Block Selection

 
Keyboard Support

Another feature introduced in this release is the ability to select, edit, and navigate through cells by using the keyboard. Supported hotkeys for navigation:

  • Arrow Keys – to navigate from one cell to another
  • Ctrl+Home/Ctrl+End – to navigate to the first or last cell of the spreadsheet
  • PageUp/PageDown – to navigate within a column
  • Home/End – to navigate to the first or last cell in the row

 
Selection:

  • Shift+Arrows – to select a block of cells
  • Ctrl+A – to select all cells

 
Font style:

  • Ctrl+B – bold text
  • Ctrl+I – italic text

 
In addition to Ctrl+C/Ctrl+V combinations, we’ve also added support for Ctrl+X, which can be used to cut a cell/block of cells.

 
Undo/Redo Operations

In version 2.0, users can use the buttons on the toolbar to undo/redo the last actions. The same operations can be done with Ctrl+Z/Ctrl+Y hotkeys. This makes editing the online spreadsheets easy and intuitive.

dhtmlxSreadsheet 2.0 - Redo Button

 
Absolute References In Formulas

There is another Excel-like feature available in this update – support for absolute references in formulas (e.g. $A$1). You can use it to perform a calculation in several places of a spreadsheet always referencing the same cell. The absolute references are also working when you copy and paste formulas in a spreadsheet.

 
Using Database Prefix

This new feature mostly concerns the WordPress and Joomla plugins. By using different table prefixes, you can create several spreadsheets from one database table and display different data for each installation.

 
Download version 2.0:

 
You can find a live demo and licensing details on the dhtmlxSpreadsheet page. If you have any ideas or suggestions for future updates, share them in comments.

Also, if you have successfully used dhtmlxSpreadsheet, share your experience with us!

Comments

  1. Brian October 27, 2012 at 5:18 pm

    This stuff is great. Nice work.

  2. Alex November 8, 2012 at 11:53 pm

    the file config.php is missing!

    • Ivan November 9, 2012 at 6:00 pm

      The config.php file is created automatically when you install the spreadsheet. Manual installation is no longer available since v.2.0.

  3. John Smith December 6, 2012 at 6:39 pm

    One more thing and this product would be perfect. Functions like: conditional sum (SUM.IF), condition (IF) and comparison operators (, =) are really desirable.

  4. k April 26, 2013 at 2:34 pm

    is there an import function ?
    there is an export i can see that.
    is it hard to have an insert line function?

    Thanks

    • Inga April 30, 2013 at 2:46 pm

      There is no specific import for spreadsheet, but it has PHP API which may be used to import any data you like.
      Unfortunately, there is no way to insert a line.

  5. Al McBride August 19, 2013 at 4:17 am

    I am using concrete5’s web development tool. Can someone tell me how to get this spreadsheet onto a page?

    Thanks in advance
    Al McBride
    SMART Light Systems

  6. Jorge Millan October 22, 2013 at 4:38 pm

    For viewing only function (Edit disabled), when I export to PDF or Excel, all cells are empty. Am I missing anything?

    Thanks
    Jorge

  7. Daniel Hobbs January 28, 2014 at 11:18 pm

    This is an awesome plugin for wordpress. the spreadsheet export to PDF button works well – but i couldn’t get the export to excel to work (not a big deal). I have some suggested improvements:

    1. the formula bar (when you hit the edit button) should have it’s own line, always visible, perhaps just above the table? like in Excel. I like that we can use bold/italics, as well as change cell background colors.
    2. would love to be able to set a fixed quantity of columns or rows beforehand in the shortcode, in addition to the ability to set table width/height.
    3. would love to be able to edit tables within wordpress admin area as well (not just on the site.
    4. would love to be able to have a template auto load for tables or the ability to clone existing tables into new tables (preferably from the WordPress admin)

    I’d get the Commercial License if some of these could be implemented. Please reach out to me if you get this. Great work!

    • Ivan January 29, 2014 at 3:57 pm

      Daniel, thank you for your kind words about dhtmlxSpreadsheet. As for your suggestions:

      1. Theoretically it can be done but it will require a lot of work as there will be many details that have to be fixed to correctly display a row with a formula.
      2. Unfortunately, it’s not possible for technical reasons.
      3. It can be done but again it will require a lots of efforts and time.
      4. There is no easy solution for this.

      > it would be nice if double-clicking between the column headers
      > would auto-adjust the width of the cel
      Unfortunately, it can’t be done.

      If you need export to Excel and it doesn’t work for you, please create a topic on the forum:
      http://forum.dhtmlx.com/viewforum.php?f=9

  8. Daniel Hobbs January 29, 2014 at 12:14 am

    also, it would be nice if double-clicking between the column headers would auto-adjust the width of the cell to match the length of the longest string/number in that column. similar to Excel as well.

    • Ivan (DHTMLX team) August 13, 2014 at 11:55 am

      Sorry for the delay with a reply. Unfortunately, there is no way to implement this functionality for now.

  9. eric May 22, 2014 at 10:06 am

    I wander is this must be used by database ?
    Can it be used just like grid(import some js) .

    • Ivan (DHTMLX team) May 23, 2014 at 12:33 pm

      dhtmlxSpreadSheet was designed to use only with database. There is no way to load data from any other resources.

  10. Juddene B. Villarin August 13, 2014 at 4:27 am

    I can’t work with the file I downloaded from your site. I wish to develop spreadsheet online, but I don’t know whats the first thing to do. I need your help.

  11. Juddene B. Villarin August 13, 2014 at 4:51 am

    I really need your help DHTMLX team.

  12. Juddene B. Villarin August 15, 2014 at 4:21 am

    Mr. Ivan how can I run the database configuration? What are the steps that I need to take? I tried it so hard but I failed. Please help .Thank you.

  13. Chris Estrada September 1, 2014 at 1:42 pm

    Can I use this on ASP.NET MVC4 framework?

    • Ivan (DHTMLX team) September 1, 2014 at 7:42 pm

      Chris, unfortunately, no.

      • Chris Estrada September 5, 2014 at 1:38 pm

        Oh, anyway. I’m using it on php now. but I had encountered a problem, I can’t install it. It just keeps on loading after I clicked install button (all the fields are filled out) and I don’t know why.

        • Chris Estrada September 5, 2014 at 1:40 pm

          I actually just realized that my wampserver hangs everytime I run the installation.

  14. Juddene Villarin September 22, 2014 at 4:26 am

    Good day Mr. Ivan.

    I already tried the installation at it is once effective. But I encounter some problem in installing it again right now. It says:

    (DHTMLX Spreadsheet Updating)
    You have already had Spreadsheet installed. If you want to update the existing installation, click button “Update”.

    (Database Configuration)
    If you want to re-install it, use the following form.

    What will I do with this? Please help. Thank you.

    • Ivan (DHTMLX team) September 25, 2014 at 5:43 pm

      Hi, if you want to create update dhtmlxSpreadsheet from version 1.0 to 2.0 then click “Update”.
      If you want to removing existing data and create new database table then follow the form. Actully you may use another database prefix or another database configuration and you’ll have two instances of spreadsheet installed.
      When you installing dhtmlxSpreadsheet the second time it detects that it was already installed. Installer proposes you to update spreadsheet to the last version

  15. Teko March 19, 2015 at 12:00 am

    is there any plan this plug in available in future for .NET

    • Ivan (DHTMLX team) March 24, 2015 at 5:59 pm

      We don’t have some concrete plans about .NET version. Maybe in future, but we can’t say exactly for now.

  16. John Velling June 2, 2015 at 2:22 am

    I’d like to deny the user the ability to edit a cell. In particular, I am trying to randomly generate data for students in a statistics class and have them perform standard operations based on the data. I want them to edit certain cells (i.e. enter commands like “=MEAN(A1:A10)” or some such) while being unable to change the data that is presented. Is this possible?

Leave a Reply