Browse By Tags

Hi,

We have a solution utilizing UltraSpreadsheet that allows the user to edit values of the model in our application. So in other words, when the user updates a value in a cell, we handle the appropriate event, check which property of an object the cell…

Hi,

We encountered a bit strange behaviour in Format cells dialog when setting the format for numeric fields, while having a comma set as decimal separator in the regional settings of Windows. It seems that  the dialog uses period as the separator, regardless…

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…

Trying to see if I use the UltraSpreadsheet to load a formatted Excel sheet to allow a user to add data.  Then so I can use the values to insert into a SQL database.  I don't care much for saving the data after, this would be used as a data import using…

Hi,

I was wondering if there is a way to get all cells referenced by a formula in UltraSpreadSheet? So for instance, if I have a formula "SUM(C1:C9)" in a cell, is there a built in way to get the cells in the range defined for the sum formula…

Hi.

Is there any way to specify formulas in UltraSpreadseet the same way as it is done in MS Excel, when you can select regions, which contribute to the formula?

Thanks!

Hello.
I have met one very strange case, during working with UltraSpreadsheet. There is an Excel file, which, when loaded in the control, cause freezes on copy or paste. (At the moment, I have only single example of such an Excel, and I can't reproduce…

Hello.

I have a very simple Excel file, which cannot be correctly displayed in UltraSpreadsheet. It looks like cells get wrong formatting with white font color. You can see the example on the screenshot.

On the left hand side is a screenshot from the…

There are bunch of static methods inside CellFill class, that let you create create gradient fill for cells. At the same time, ShapeFill methods are capable to create only solid fill.And I didn't find any other subclasses for ShapeFill, except ShapeFillSolid…

Is there a way to change the cursor for the cell area of the UltraSpreadsheet control?

I have tried to set ultraSpreadsheet1.UseWaitCursor = true, but it has no effect on cursor displayed above the cells, it remains as standard Excel cross.

What I'd like…

Does anybody knows if there is a spreadsheet control for ASP?

I use  UltraSpreadsheet for winform and know there is a similar control for WPF but I need to add a excel like control for a ASP app.

Thanks in advance

Alejandro Castrejon

Hi,

     I am using winforms Ultraspreadsheet control; i need to group rows by setting OutlineLevel. But the code does not work. I dont see the spreadsheet with rows grouped

The following is an sample code:

public Form1()
{
InitializeComponent();
for(int…

We recently upgraded to the July 2018  Service Release 20181.177, and we are now having some issues with applying cell formatting in Ultraspreadsheets.

We load information from a database, and based on the SQL data type we apply a column format string…

Hi,

I use the control UltraSpreadsheet to watch a preview of my excel files on a panel form vb.net.

The control open and show the documents excel but without the charts.

I even downloaded the samples solution package Infragistics_WinForms_20181_Samples.…

We are beginning to add support for Comments in the UltraSpreadsheet.   As you would expect, we would ultimately need to selectively hide/show/edit the comment when a cell is hovered over.   But to start, we are programmaticly creating a comment on all of…

This should be fundamental, but I guess it is not.

We are designing Filters for the UltraSpreadsheet for Windows Forms  ---NOT THE WINGRID--  and since the filtering is based on type (Date, Number, Text, ext), how do we set the data type for each column…

We are using your UltraSpreadsheet for one of our forms.

We have added an 'Excel Like" Ribbon.   One of the controls on the Ribbon is for Sorting.   We have developed a dialog the allows the user to define multiple levels of sorting (e.g. Name Column…

When I load certain spreadsheets from a hard drive, the spreadsheet control crashes when the code attempts to set the workbook.

If I hover over the workbook variable after this line ...

Infragistics.Documents.Excel.Workbook workbook = Infragistics.Documents…

I am using UltraWinSpreadsheet, and the thing we really need it to do is cell filtering. I can have a very simple test app with a grid and a button pressing the button loads an excel spreadsheet that contains a filtered area. The filter headers are not…

When selecting a range of cells using the mouse and you get to the last visible column on your right it only scrolls one column to the right.

You have to mouse your mouse left then right again to scroll the next column on the right into view. 

It does…

I need to combine sheets from different Excel sources into a single workbook:  open a saved Excel workbook, grab a worksheet and put it into the spreadsheet control, do some manipulation.  Then open a different Excel workbook, grab another worksheet and…

Our application has the need to open workbooks that have been saved in the StrictOpenXml format.  Calling the workbook's load method generates "Input string was not in a correct format." with the following stack dump.  Any help would be appreciated…