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 to show Find/Replace Dialog on SpreadsheetGear workbook?

How can I show from code SpreadsheetGear dialogs like Find/Replace? There is WorkbookDesigner form which has most of those dialogs in main menu, but how can I implement it myself?
Vladimir Sachek
  • 1,126
  • 1
  • 7
  • 20
0
votes
1 answer

how to make cell or column readonly using spreadsheetgear

I am using the Spreadsheet gear component and need to select particular cells or columns in a worksheet so I can apply a read only property . How do we do? Example : if there are 3 columns in excel sheet in that one column should be read only rest…
kumar
  • 1,117
  • 13
  • 34
  • 58
0
votes
1 answer

silverlight spreadsheetgear WorkbookView read only mode

Is there a way to switch WorkBookView in read only mode? So the user will not be allowed to edit cells, paste to cells, use AutoFill feature, change width/height of columns/row, but still be able to switch between sheets and copy text from cells.
mt_serg
  • 7,487
  • 4
  • 29
  • 45
0
votes
1 answer

CheckBox Operation in Spreadsheetgear

I have a Excel Tamplate in which i have Checkbox placed in it. I want to do Check uncheck/Checkbox depending on some condition in Spreadsheet Gear. Checkbox is already available in the Excel Sheet. I am using Spreadsheetgear 2008. I googled but cant…
Jankya
  • 966
  • 2
  • 12
  • 34
0
votes
2 answers

Setting number format for a column as percentage using SpreadsheetGear

I am using SpreadsheetGear and I want to set format for a column as %. currently I am using following code: worksheet.Cells[0, index].EntireColumn.NumberFormat = @"##0.00\%;[Red](##0.00\%)"; The above code apply formatting which converts: 6 = …
SharpCoder
  • 18,279
  • 43
  • 153
  • 249
0
votes
1 answer

SpreadsheetGear Custom functions descriptions

Could SpreadsheetGear set descriptions for custom functions? Like Excel has descriptions for every argument in standard functions. Like Xll add-in can do it. In the constructor of SpreadsheetGear.CustomFunctions.Function I see only Function name…
Alex
  • 1
0
votes
1 answer

SpreadsheetGear.ValidationType.List turn off

I have a spreadsheetgear validation type list on one of the columns in a spreadsheet. The issue I have is when I reload the spreadsheet with different sets of data, I get an error that validation already exists. I don't know how to turn off the…
Joe Jack
  • 3
  • 1
0
votes
1 answer

How does one select an entire worksheet with Spreadsheet gear (.NET)

I am using the Spreadsheet gear component and need to select all cells in a worksheet so I can apply a consistent font setting across. How do you create an IRange that represents an entire worksheet?
John Livermore
  • 30,235
  • 44
  • 126
  • 216
0
votes
1 answer

Applying number format on a column from a specific row number using SpreadsheetGear

I am using SpreadsheetGear to generate a excel sheet. I want to apply number formatting on a column starting from row number 10. But when I use below code, it apply formatting for the entire column. worksheet.Cells[10, 2].EntireColumn.NumberFormat =…
SharpCoder
  • 18,279
  • 43
  • 153
  • 249
0
votes
1 answer

Cell Edits to SpreadsheetGear WorkbookView aren't persisting

What's going wrong: When I edit a cell in a SpreadsheetGear WorkbookView, and initiate the CellEndEdit event by either hitting Enter, Tab, or any of the arrow keys, the value I just typed is wiped out. Context: It seems that when editing a cell in…
Jake Smith
  • 2,332
  • 1
  • 30
  • 68
0
votes
1 answer

is it possible to optimise spreadsheetgear performance?

I am using the spreadsheetgear library in a web application that manages some large spreadsheets, populating cell values and extracting the results. It runs extremely fast for small spreadsheets but we are noticing problems with more sophisticated…
Andrew
  • 547
  • 4
  • 13
0
votes
1 answer

WPF binding to obfuscated object can't find the property

I am trying to bind a ComboBox to the named cells of a SpreadsheetGear worksheet. SpreadsheetGear is an obfuscated assembly, so that i my first guess.
Nick Strupat
  • 4,928
  • 4
  • 44
  • 56
0
votes
1 answer

Spreadsheetgear .find method

Tools: asp.net VB, SpreadsheetGear 2010 I need to read in Excel files from external users and I do not control the format. There are 3 sections of data. I am able to read in the header. The challenge is that the body details can contain an…
user1821800
  • 21
  • 2
0
votes
2 answers

Reference another sheet in Formula string SpreadSheetGear

As the questions states, I'm trying to reference some cells from one sheet to another. In one sheet I have the Data to populate some other cells in my Principal sheet In short: DataSheet > Feeds > PrincipalSheet I'm trying something…
Dany
  • 131
  • 3
  • 17
0
votes
1 answer

VSTO Excel Add-In and SpreadsheetGear

We're working on a Excel Add-In in C# .Net 4. One of the requirements is to update a worksheet with results of some processing. The issue is, we need to do this both while the Excel file is open (with the Add-In), and also in batch (while the file…
midspace
  • 922
  • 9
  • 18
1 2 3
…
16
17