FAQ

Usage

  1. How to use ReoGrid in VB.NET?
    See answer.
  2. What formats of Excel file are supported?
    ReoGrid supports Excel 2007 (and later) format, as well as other OpenXML-based spreadsheet format, such as OpenXML SDK-generated spreadsheet file and some open-source/free office applications-generated spreadsheet file. Excel 97-2003 format is not supported, and there is no plan to make it available in future versions.
  3. How to fix PInvoke exception?
    See answer.
  4. How to fill worksheet with a DataTable?
    See answer.
  5. How to make entire worksheet read-only?
    By setting the worksheet settings worksheet.SetSettings(WorksheetSettings.Edit_Readonly, true); to make entire worksheet read-only.
  6. How to know how many rows and columns of the data on given worksheet?
    To get number of rows and number of columns of the data on worksheet, use property MaxContentRow and MaxContentCol of worksheet.
  7. How to disable selection?
    Setting the SelectionMode property of worksheet instance to None will disable selection on worksheet.
  8. How to clear the selection?
    Setting the SelectionMode to None will make focus selection range disappear, select it back to Range will restore it, but notice that selection range will only be restore at first cell.
  9. How to iterate over all cells in range or worksheet?
    To iterate over range or worksheet, use method IterateCells of worksheet and pass a range position argument. Notice that this method skips empty cells on worksheet. If don’t want to skip empty cells, use for-each on Cells property of ReferenceRange instance. To get an instance of ReferenceRange, use code like worksheet.Ranges["B1:D5"]. Notice that Cells property will create cell instance if the cell is empty, this will cause many memory use if the range is large.
  10. How to find text over multiple cells?
    Use the IterateCells method to iterate over cells on worksheet or range, check the Data property of cell instance to find text.
  11. How to delete the specified cell’s content at one time, such as styles and borders?
    To remove cells content, use the method ClearRangeContent method. This method deletes the content that is specified by secondary argument CellElementFlag. To remove only styles, use RemoveRangeStyles method; To remove only borders, use RemoveRangeBorders method.
  12. Can I use ReoGrid in WPF?
    Yes, from the version 0.8.7 ReoGrid can run in both Windows Form and WPF platforms, for the details please check here.
  13. ReoGrid supports multiple worksheet, but I want to make it only one worksheet available, can I do that?
    Yes, by hiding the built-in sheet tab control to prevent that end user adds or removes worksheets. See built-in sheet tab control.
  14. Can I open Excel file, modify it, and save it back without creating a visible control on form?
    Yes, ReoGrid memory workbook provides almost all features to operate Excel file or RGF file without a visible control on form. Use ReoGridControl.CreateMemoryWorkbook to create the instance of memory workbook.
  15. How to read all images from Excel file?
    Handling images from Excel file is available in ReoGrid Pro-edition. See Read all images from Excel file.
  16. Can I print all worksheet at a time?
    Yes, print single worksheet available in free-edition, print all or specified worksheets available in ReoGrid Pro, see Paging and Print.

License

  1. What is the release license of ReoGrid?
    ReoGrid is open source software released under MIT License.
  2. Can I use ReoGrid in proprietary software or commercial software?
    Yes, you can.

39 Responses to “FAQ”

  1. Syed Ali Naqi says:

    Hi.. I Have A Question?
    Is it possible for me to Somehow Not Allow The User To Edit Any Cells Although He can select them and copy the values too,,,

    Also Can i Export and import my table or data…

    Thanks!!

    • jing says:

      Hi! It’s possible to specify a range that is only available for editing by handling event. The version 0.8.8 supports that export the spreadsheet as Excel, CSV and HTML format. You will find more example code in Demo project.

      If you have more questions please post them in forum: https://reogrid.net/forum, thanks!

  2. AB Zaman says:

    How to use the workbook.DoDragDrop() function?

  3. Seal says:

    MAX and MIN formula is not available, like this “=MIN(A1:H1)”, get the min item from A1 to H1,
    MIN(A1,B1,C1) works well

    • jing says:

      Thanks for the information! We have also noticed this problem and planned to fix it in next version.

      • Seal says:

        It’s very much pleased that I can use ReoGrid for my application, Could you share me the next release date?
        And I found another issue, if I export a excel(*.xlsx) file from ReoGrid, then I open it by MS OFFICE 2010, it always popup a alert dialog, it says some unreadable content, and ask me “if recover the workbook or not, click ‘YES’ …… “, after I click YES, office excel prompt ‘have deleted part of style of /xl/styles.xml’.
        And it works well except the popup. Maybe it cause by the compatibility between OFFICE 2007 and 2010

        • Jing says:

          This problem has been resolved and tested, and will be released in 0.8.9.1-alpha version.

  4. tomas says:

    Hello! I very like this tools,but I found a problem, the dropdowncellbutton auto change height when I change the cell’s height, I saw your page about “Dropdown Cell”,buy I can’t found the “DropdownButtonAutoHeight” property ,can you help me? thany you very much!

  5. Chris says:

    Is there a renewal price for ReoGrid pro or is it the same amount every year?

  6. Jeffrey Kesselman says:

    What is the difference between your product and the LGPL’d open source REO grid?
    http://www.codeproject.com/Articles/691749/Free-NET-Spreadsheet-Control

    • Jing says:

      Hi! The LGPLv3 open source ReoGrid (linked in your comment) is an old version of this component (before 0.8.6.0). From 0.8.6.0 except the core library all code become BSD license, core library changed to closed-source free software license. After 0.8.6.0 there is many new features available for free, such as Excel format, WPF version, enhanced cells freeze, printing functionality and new formula engine.

  7. How do I iterate over all the defined border ranges in a worksheet?

  8. Gavin says:

    Hi. Can I open an existing xls or xml spreadsheet into the control, make some changes to data, and then save it back to the file?

    • Jing says:

      Hi. Excel .xls format is not supported. You can open Excel 2007 and later (.xlsx) format into the control, makes changes and save it back. Some settings to the Excel file may lose if they aren’t supported by ReoGrid. https://reogrid.net/document/excel-file-format/

      • Gavin says:

        Ah! Thanks.
        I had tried Excel 2007 too but it failed. I realise now that it probably failed because I loaded a spreadsheet with formatted text in it which displays on-screen but obviously causes it to fail when saving or printing because I’m using the free version which doesn’t support rich text.
        A shame because I can’t justify $760 for the full version just for the sake of rich text (thats more expensive than Crystal Reports)

  9. phantompeng says:

    Hi. Your ReoGrid is very great and useful. I can not print when the ReoGrid is applied to WPF. The case given in the website is ony applicable to WinForm.

    • Jing says:

      Hi! Thanks for your feedback! We’d like to solve the print problem of WPF edition in future versions.

      • phantompeng says:

        For the print problem, I can swtich to the WinForm. But another problem is occured. The event of DoubleMouseClick can not handled. Can you help me?

  10. naftaly weuinberger says:

    how can i get the info of a grid into data table or database

  11. phantompeng says:

    Hi,a weird problem is occured when I use the print function of reogrid. There is always blank area in the right side of page, no matter I change margin-left and margin-right.

  12. Ariadna says:

    Hi, if I buy one license, will this activate the ReoGrid Pro in just one computer? and if I want to use it in two different machines must I buy two licenses?

  13. RatHat says:

    Is there drag-n-drop in ReoGrid?

  14. Terry says:

    Hi, how can i use filter in WPF? I tried to use filter in WPF, and it’s not working, then i tried to use it in the windows form, it’s work perfectly.

  15. Koen says:

    Is it still closed source? I’m missing some customization regarding AutoFillSerial and went to the forums for help. Funny enough I saw the suggestion to the change the source code, as an answer to a similar question I was about to ask. So I googled for source code and found Reogrid on Github:
    https://github.com/unvell/ReoGrid/tree/0a286679199ebc0f9a090d9471d951cdca691d07

    The MIT license matches, the version number and the support for WinForms, WPF and Android. So I was wondering, is your reply to Jeffrey Kesselman in 2015 still up relevant? Or have you gone back to open source again in the meantime?

    • Jing says:

      It’s fully open source software since 2017, under MIT license. The source code on Github is the latest version. What is your question? You can post it at https://github.com/unvell/ReoGrid/issues

      • Koen says:

        Ok, cool! Might I suggest you change the text at the top of this FAQ page. At the heading ‘License’ it mentions Reogrid is closed source.

        I’ll post my issues and questions to github if I find any worth bothering you about. Right now I’m just toying around and don’t want to make an issue out of everything. Short version: I was looking for supplying custom incrementing behaviour when using AutoFillSerial for custom cellbody’s and/or custom datatypes. I looked at the source, and there appears to be no support for it. So my question is answered. 🙂

  16. Martin Mijalkovski says:

    I have two sheets not in the same workbook, the second sheet has formulas referencing to the first. When i add the second sheet in the workbook of the first sheet, the cells that have formula with reference do not update, but they still have the formula, if i copy/paste the formula in different cell it works. I tried .recalculate but that doesn’t help.

  17. Massimo says:

    Hi,
    is DDE (or RTD) as stock market data-feed supported ?