Stack Overflow
Stack Overflow

Questions tagged [spreadsheetgear]

SpreadsheetGear 2012 enables ASP.NET, Windows Forms, WPF and Silverlight developers to easily take advantage of scalable Excel Reporting, dynamic dashboards from Excel charts and ranges, powerful spreadsheet controls, comprehensive Excel compatible charting, the fastest and most complete Excel compatible calculations and more.

SpreadsheetGear 2012 enables ASP.NET, Windows Forms, WPF and Silverlight developers to easily take advantage of scalable Excel Reporting, dynamic dashboards from Excel charts and ranges, powerful spreadsheet controls, comprehensive Excel compatible charting, the fastest and most complete Excel compatible calculations and more.

SpreadsheetGear LLC is a privately held software publisher located in Lenexa, Kansas. The company was founded by Joe Erickson in 2003 to develop a new generation of Microsoft Excel compatible spreadsheet components for Microsoft .NET and Silverlight.

With a singular focus on spreadsheet technology and unparalleled experience, SpreadsheetGear is committed to being the leader in spreadsheet components.

Resources

254 questions
1
vote
1 answer

Spreadsheet Gear #value when result.Number contains the correct return value

I am working on a project porting VBA code to C# for Spreadsheet Gear. My team has successfully ported around 150 custom Excel Add-in functions. For one of the functions, our regression spreadsheet returns #value for 4 out of 148 function calls,…
user1769597
  • 55
  • 1
  • 1
  • 4
1
vote
1 answer

SpreadSheetGear IWorksheet cells reading from multiple cells throwing exception

I am trying to read the cells from SpreadSheetGear IworkBook it's getting exception . Is it expected ? for (int i = wr; j <= er; i++) { for (int j = sc; j <= ec; j++) { var rng =…
user1844634
  • 1,221
  • 2
  • 17
  • 35
1
vote
0 answers

inserting image into spreadsheetGear excel

I am using the below code to insert logo into my excel sheet but I am getting the excel without the image double width; double height; System.Drawing.Image image = System.Drawing.Image.FromFile(logo); using (image) { width = image.Width * 72.0…
Miroo
  • 795
  • 3
  • 13
  • 35
1
vote
1 answer

SpreadSheetGear 2012 copy range with conditional formatting

I have a range with Conditional Formatting in an existing Excel file. I'm trying to use SpreadSheetGear 2012 to copy that range to a new sheet, then I found the conditional formatting was missing: IRange someRange =…
kuhlin
  • 23
  • 1
  • 7
1
vote
1 answer

Select a shape programmatically

How to programmatically (C#) select a shape (or chart) in SpreadsheetGear? I have tried: 1. IShape.select(false); // failed 2. ShapeSelection = ...; // failed
GY_
  • 398
  • 3
  • 17
1
vote
2 answers

How to set default date format when load an xls file to SpreadSheetGear workbook?

When I load an xls file, which is created by the user, to SpreadSheetGear workbook it changes date format from dd/mm/yyyy to mm/dd/yyyy. How can I prevent this? I use the code below (VB.NET) to load xls file: WorkbookView1.ActiveWorkbook = …
BoraTahir
  • 11
  • 1
  • 3
1
vote
0 answers

SpreadsheetGear.Factory.GetWorkbook(filename) replacing empty value with 0 in excel file

I have DevEx gridControl with some data from DB. gridControl.ExportToXlsx(filename, new XlsxExportOptions(TextExportMode.Value)); this code block Works fine and export data to excel. after export, I am opening and closing excel file using…
Abhash786
  • 881
  • 2
  • 24
  • 53
1
vote
2 answers

Pivot Chart in SpreadsheetGear

I have Spreadsheetgear and I'm wondering if anyone knows if 2009 edition supports PivotCharts, does anyone know how to do this? Cheers, Doga
Doga
  • 281
  • 2
  • 11
1
vote
2 answers

Hiding column and row headings in SpreadsheetGear control

Is there a way to hide the A,B,C column headers and 1,2,3 row headers in the SpreadsheetGear 2010 control? We are using this as a display only control and showing these headings gives the impression that the data can be edited. Thanks.
Jose
  • 41
  • 6
1
vote
0 answers

Spreadsheet gear keeping the file open

Does the Spreadsheat gear dll or asp.net 5 provide any capabilities to keep the file open and ready constantly ? I am currently getting my workbook the following way: public WorkbookRepository(IApplicationEnvironment appEnvironment) { …
Dave Demirkhanyan
  • 570
  • 1
  • 5
  • 22
1
vote
1 answer

excel validation rule using vb.net using spreadsheetgear

I want to add validation rule to excel dynamically using VB.Net , I am able to add date validation to a cell as below using spreadsheetgear worksheet.Range(DateRange).Validation.Add(ValidationType.Date, ValidationAlertStyle.Stop,…
Ramesh
  • 13
  • 6
1
vote
2 answers

VB.NET - Combine rows in DataTable based on shared value

I'm trying to combine rows in a DataTable based on their shared ID. The table data looks something like this: Member | ID | Assistant | Content --------------------------------------------- 16 | 1234 | jkaufman | 1/1/2015 - stuff1 16 |…
TheIronCheek
  • 1,077
  • 2
  • 20
  • 50
1
vote
1 answer

Reading custom document property saved in an excel through SpreadsheetGear

I'm trying to open an .xlsx file and display the contents in my SpreadsheetGear. mySpreadSheetGearControl.ActiveWorkBook = SpreadsheetGear.Factory.GetWorkbook(filename); whereas filename is my excel file i'm trying to open. Contents gets diplayed…
user2134208
  • 53
  • 3
1
vote
1 answer

Globalize/Localize Excel Reports Using Spreadsheet

My company has new customers in Brazil and we realized that our excel reports are not working when our Brazilian customers tried to open the reports in their Brazilian versions of excel. For excel output we use spreadsheet gear in our vb.net web…
mga911
  • 1,536
  • 1
  • 16
  • 33
1
vote
1 answer

Is there any way to specify the encoding used in SpreadsheetGear to generate CSV files?

I am trying to export data containing Unicode characters from our system using Spreadsheet Gear to csv format. (Fine for excel). However because the CSV format is not UTF-8 encoded all the Unicode characters are exported as ??? I am aware that…
Ilessa
  • 602
  • 8
  • 27
1 2 3
…
16 17