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
0
votes
1 answer

How do I Create a Horizontal Bar Chart in SpreadsheetGear with Names for the Y-Axis Labels?

Suppose I have a list of planet names and the distance of the planet from the sun in my spreadsheet (column 2 is in million of miles - closest distance per UniverseToday.com): Mars 10 Venus 66 Earth 91 Mars 127 Jupiter 460 How do I create a…
CoolBreeze
  • 381
  • 4
  • 14
0
votes
2 answers

SpreadsheetGear Excel using EPPLUS/NPOI not readable

Have anyone comes across this? I receive file from client which is generated through SpreadsheetGear. It looks fine if I open it in excel But it can't find data into cells if I try to read through EPPLUS or NPOI I believe SpresheetGear misses some…
user2739418
  • 1,623
  • 5
  • 29
  • 51
0
votes
1 answer

Using ProtectContents on IWorksheetin Spreadsheetgear

I've a workbook object in which I'm using excel formulas in certain cells. I'm programmtically setting the value for ProtectContents on IWorksheet object to turn the readonly mode on those cells on and off. 1.When the value of ProtectContents is set…
Vineet v
  • 175
  • 2
  • 13
0
votes
1 answer

Issue with using ProtectContent - Spreadsheet gear

I am trying to make a selected cells of my excel to be editable and rest to be readonly. Following is my code, I am trying to set the Locked property for the specified rows to be "False" and trying to protect the sheet excl.WorkSheet(0).Range[0,…
user1234
  • 97
  • 1
  • 9
0
votes
1 answer

SpreadsheetGear.shapes.IPictureFormat's getImage method is not available for Version7.4.1.104

I am migrating Spreadsheet Gear 6.0.3.190 to 7.4.1.104. I am getting "IPictureFormat doesnot contain the definition for GetImage" Can any one help me to solve this.
Rakesh Devarasetti
  • 1,409
  • 2
  • 24
  • 42
0
votes
1 answer

Spreadsheet Gear migration errors

I am migrating Spreadsheet gear of my application from 6.0.3.190 to 7.4.1.104.I am getting my issues with Color property.Can any one help me in this.Now I am using using Color = System.Drawing.Color; and also ToSGColor().This became very hectic to…
Rakesh Devarasetti
  • 1,409
  • 2
  • 24
  • 42
0
votes
1 answer

Data labels in spreadsheet gear 2012

I am trying to make the series name in a bar chart show up as a Data Label in spreadsheetgear 2012 but cannot find a way to make it visible in the chart explorer. Any help would be appreciated.
Kendall
  • 1
  • 1
0
votes
1 answer

I'm using SpreadSheetGear to create a 3D Pie chart. How do I change the Y-rotation value?

I'm using SpreadSheetGear to create a 3D Pie chart. How do I change the Y-rotation value? I keep getting the image on the left (in Excel the Y-rotation value is 15 degrees) when what I want is the one on the right (in Excel the Y-rotation value is…
Surfer Bling
  • 11
  • 3
0
votes
1 answer

Indexing with range names while using SpreadSheetGear's Advanced Cells API

I'm dealing with Excel file containing many sheets and even more formulas. I can reference all the 15K+ input cells with their range names, which is much nicer and readable than just using column-row indexes, like "AE2318". Since the file is huge, I…
Csaba Toth
  • 10,021
  • 5
  • 75
  • 121
0
votes
1 answer

How to change Excel format when thousand and decimal seperator is changed

I have an option allowing user to select thousand seperator and decimal seperator in my windows application.How can i change the worksheet-> Cell's Number format based on selected seperators.
Rakesh Devarasetti
  • 1,409
  • 2
  • 24
  • 42
0
votes
1 answer

Change to Use Spread Sheet Gear from Microsoft Office Interop OWC11

I wish to change my code to Spread Sheet Gear from Microsoft Office Interop OWC11. However, I face some problems in my code. The code show here is using the Microsoft.Office.Interop.Owc11, I do try with Spread Sheet Gear with some IWorkBook,…
mary
  • 1
0
votes
1 answer

Pastespecial Range from one workbook to another using SpreadsheetGear

daughter.Worksheets["DataLoad"].Range[1, 1, t.APIs.Count, 1].EntireRow.Copy(Master.Worksheets[DataLoad.Name].Range[rowIndex, 1, rowIndex + t.APIs.Count, 1].EntireRow); copies all formulas and formats and pastes into the range in the .Copy overload…
Tyler Cowan
  • 820
  • 4
  • 13
  • 35
0
votes
1 answer

Microsoft.Office.Interop.Excel.SpreadsheetGear does not contain a definition for Active cell and no extension method for active cell

I get this error when I want to change from AxMicrosoft.Office.Interop.Owc11 to Microsoft.Office.Interop.Excel , from AxSpreadsheet currentSpreadSheet = GetTestSheet to SpreadsheetGear IWorkbook =…
emma
  • 11
  • 3
0
votes
1 answer

Load an Excel cell value with a leading apostrophe

I want to be able to load the exact text within an Excel cell using Spreadsheet gear. This is because I want the leading apostrophe. For Example the cell has the text; 'Test' This is a test. Spreadsheet gear strips away the leading…
Dandaman
  • 15
  • 8
0
votes
1 answer

Spreadsheet Gear -- Generating large report via copy and paste seems to use a lot of memory and processor

I am attempting to generate a large workbook based report with 3 supporting worksheets of 100,12000 and 12000 rows and a final output sheet all formula based that ends up representing about 120 entities at 100 rows a piece. I generate a template…
Richard Davison
  • 141
  • 1
  • 7
1 2 3
…
16 17