Community | Tags

Browse By Tags

  • Grid lines are still visible on a dark background

    Hello there,

    when you deactivate the gridlines in the Excel workbook and set a dark background on the whole sheet, the gridlines are still visible in the Infragistics spreadsheet:

    It looks like you are not considering that the grid lines are deactivated…

  • Autocomplete feature on a spreadsheet cell

    Hi there!

    Is there a way to set an autocomplete in a spreadsheet cell when we're editing it?

    It´s not a data validation, it's only a feature that helps the user with the filling.

    Something like set the autocomplete directive on the cell…

  • Facing issue in GroupedRows functionality while Exporting grid to excel

    Hi

    I want a small clarification on one of the use case related to Excel Library. 

    I want to know how we can Add the GroupedRows functionality for Row, Which we can expand by clicking on + icon.

    So, for this I need to know how can we achieve that.

    Hoping for…

  • Spreadsheet - Set Filter and apply as table

    Hi ,

    Am going through some examples given here 

    https://www.infragistics.com/products/ignite-ui-angular/angular/components/excel-library-using-tables

     consider below line used for creating table 

    var table = worksheet.tables().add("A1:G10", t…

  • SpreadSheet sorting and customizations

    Hi,

    Am following this link for spreadsheet

    https://www.infragistics.com/products/ignite-ui-angular/angular/components/spreadsheet-configuring

    when we click  on particular row and apply filter it gives excel style filtering. now clicking on that filter…

  • IGX Spreadsheet Excel Utility

    Hi , am following this link  for implementing spreadsheet and trying to get the excel back from spradsheet

    https://www.infragistics.com/products/ignite-ui-angular/angular/components/excel-library  

    there is an excelutility which provides saving as excel…

  • igx-spreadsheet - Spreadsheet not rendered

    HI Team,

    I am new to the Excel igx-spreadsheet Library and I added the following dependencies: "file-saver", "igniteui-angular-core" and "igniteui-angular-excel" as well as the Excel utility class. As I followed this documentation…

  • Angular Spreadsheet load data from json

    I am looking at the documentation page and I don't see anything related to loading data from json.

    My use case is specifically tied to that functionality and I need to export to json as well

    Here is the link:

    www.infragistics.com/.../spreadsheet-…

  • Automating the Angular IgxSpreadsheetComponent with Selenium

    We run automated tests on our application, and part of our app uses the IgxSpreadsheetComponent (Angular 13.0) to display an Excel file that has been generated by our software. We also let the user manipulate the file that's displayed in the spreadsheet…

  • Azure build errors

    I am using AG/IG ~12.3,

    I get the following build errors in Azure (but not in local):

    Error: node_modules/igniteui-angular-spreadsheet/lib/CustomDOMEventProxy.d.ts:11:15 - error TS2416: Property 'cp' in type 'CustomDOMEventProxy' is not assignable to…

  • Uncaught TypeError: Cannot read properties of null (reading 'contentType')

    Hello,

    I'm trying to load files into this library via ExcelUtility.load(file), where `file` is an xlsx file.

    The application crashes and the following error occurs:

    CachedLoadPackagePart.ts:39 Uncaught TypeError: Cannot read properties of null (reading…

  • Download Charts?

    I'm on AG 12.3 and IG 12.3 with Excel and Charts.

    Users would like to be able to download the charts in addition to the Spreadsheet report being generated in the same page of our app. If at all possible, they would like both charts (Design & Process…

  • Unable to install npm packages from private npm feed, getting 401 unauthorized error.

    Hi Team,

    We have already purchased license for IngiteUI Angular, we have added user from manage subscription section. We have followed all steps provided in documentation. When we were trying to install npm packages from private npm feed, we are getting…

  • Spreadsheet cell text is not visible when formatting is applied to the cell.

    Issue: When formatting is applied to the cell, cell text is not visible in spreadsheet viewer. The text is present, if we click on cell, text is visible on formula bar. I have attached image for the reference. We have used same sample excel file shown…

  • Spreadsheet be able to group and ungroup

    I am occupying the Spreadsheet component, but I have an excel file that has groups as shown in the attached image.

    Is there a way to group or ungroup?

  • Spreadsheet with flattened data

    Just got onto Angular 12 w/ latest Ignite UI 12. I realize igniteui-excel and igniteui-spreadsheet are still in version 11.

    My need is not simple, but it is manageable.

    I have flattened data that includes mappings (header row info) to numeric data (some…

  • Base Error when using igr spreadsheet chart adapter and react modal

    I'm using igrspreadsheet along with its chart adapter to display some excel reports with charts. Also I 've created a expanding feature which use reactmodal to display a pop up window to display the same excel report.

    The problem is, Everytime…

  • Spreadsheet (Show DatePicker popup)

    Dear Team,

    Depending on date format string supplied to cell, it would be nice if user can open Date Picker dialog to choose date on cell double click.

    Same feature is available in Excel.

    Thanks

  • Formulas and inserting worksheets on UltraSpreadsheet

    Hi,

    We encountered an interesting behaviour regarding UltraSpreadsheet, formulas and inserting new worksheets. It seems that when a new worksheet is inserted in between existing ones, the formulas referring cells in the new worksheet are replaced to point…

  • Spreadsheet Add comment

    From customer:

    Dear Team ,

    As Microsoft Excel had add comment functionality & used frequently ,same feature need to be present in Infragistics Spreadsheet .

    i have raised the support case CAS-211279 where we got to know that add comment feature is…

  • Can I export to .xlsx rather than .xls using Infragistics version 11.1?

    Hi,

    I am using Infragistics version 11.1.
    I export my newly created Excel workbook via a C# MemoryStream to a file.

    This works fine but If I add an .xlsx file type to the file rather than an .xls type then the file will not open reporting that it is corrupted…

  • Make context menu more configurable

    Hello all,

    Currently, the context menu in the Angular Spreadsheet component always appears and it is fixed. That kind of limits the scenarios where this component can be used.

    Consider an app where this component is installed, but its use and editability…

  • Is there a way to turn on/off the context in Spreadsheet component?

    There is seemingly no way to configure the Spreadsheet component so it doesn't show the context menu on right mouse click. Not through the IgxSpreadsheetComponent class, nor through the Workbook or the Worksheet class.

    Does anyone know if there is…

  • Language in context menus

    I created a spreadsheet control.

    The language of the context menu is English.

    Is it customizable in any way?

    I found a similar question from 12 years ago. Hope some things changed since then ;)

  • Language in context menus

    I created a spreadsheet control.

    The language of the context menu is English.

    Is it customizable in any way?

    I found a similar question from 12 years ago. Hope some things changed since then ;)