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

Copy SpreadsheetGear Range to html

I want to copy a selected range from SpreadsheetGear Worksheet to Clipboard and then to MS Word. Off course, I want to preserve all formating (colors, column widths . . .). I guess I have to put it in the Clipboard in HTML format, but how do I get…
gajo357
  • 958
  • 12
  • 22
0
votes
1 answer

Embedding Spredsheet (Using SpreadsheerGear) in Web Page

I want to Embed Spreadsheets in my Web Page. Using Windows its OK but how i will do same thing in Web page. I gone through ASP.NET Samples from here but sample tells that to download Excel sheet on client side. But there is possibility that…
Jankya
  • 966
  • 2
  • 12
  • 34
0
votes
1 answer

UsedRange.RowCount is not updated after an insert

I'm trying to write an Extension methods that adds a generic Item T to the workbook, I've got problem since the UsedRange.RowCount is not incremented after InsertMethod is called public static RowItem AddItem(this…
advapi
  • 3,661
  • 4
  • 38
  • 73
0
votes
1 answer

Spreadsheet gear cell with list validation selection changed event?

I have list validation on a few cells and would like to shade the cell if a value is selected/changed from dropdown(filter list). For regular cells, I use EndEdit event which apparently doesn't fire in this case. Could anyone please point me to…
stripathi
  • 766
  • 11
  • 23
0
votes
1 answer

Spreadsheetgear - edit comment

In Spreadsheetgear, I can right-click on a cell and select "edit comment". I'd like to do the same from code. But I see only an "IRange.AddComment" method, no "EditComment"... Is it possible?
jcmag
  • 35
  • 2
0
votes
1 answer

Does SpreadsheetGear have intellisense support for in-built or custom functions?

I am using SpreadsheetGear to integrate with my WPF project, and I have developed a few custom functions. Is there a way to display the function names and parameters as intellisense when the user starts typing the formula in the cell?
Vinod
  • 21
  • 3
0
votes
1 answer

Can I call a spreadsheet function from a custom function in SpreadsheetGear

I am using SpreadsheetGear and have been given a spreadsheet with a VBA macro that I need to convert to a custom function (as SSG can't handle VBA code). The macro calls Excel functions (Match, Index) and I can't see how to call these functions from…
Lee Willis
  • 1,552
  • 9
  • 14
0
votes
1 answer

spreadsheetgear - open/save file

I want to update an existing Excel file using SpreadsheetGear. I load the Excel file using: _activeWorkbook = Factory.GetWorkbook(@"./excel/test.xls"); workbookView1.ActiveWorkbook = _activeWorkbook; but when I want to save it: private void…
jcmag
  • 35
  • 2
0
votes
2 answers

Restrict Shape Re-sizing on spreadsheetgear

Is there any way by which I can remove anchors of a shape added in spreadsheetgear. So that the user cannot change the size of the shape. Please Suggest a solution or any work around.
Ammar
  • 152
  • 2
  • 12
0
votes
1 answer

Restrict User from changing the column width or row height in spreadsheetgear

Is there any way to restrict the users from changing width of column or height of row of the worksheet on my windows form?
Ammar
  • 152
  • 2
  • 12
0
votes
1 answer

"Open an existing file in Spreadsheetgear using VB.Net

I am trying to open an existing file in WorkBookView (named wkbMain in code given below) placed on my Windows Form. I am using the following code: Private Sub MenuItemOpen_Click(sender As Object, e As EventArgs) Dim lObjDialog As New…
Ammar
  • 152
  • 2
  • 12
0
votes
1 answer

SpreadSheetGear Right Click Menu Edit in Vb.Net

Can I: Edit the right click menu of selected cells of Sheet in SpreatSheetGear to add an option like Merge, and then handle the event of selection of that menu item click? Thanks in Advance for sharing some idea.
Ammar
  • 152
  • 2
  • 12
0
votes
1 answer

Localizing value for Excel cell using spreadsheetgear (.Net)

I am trying to localize the excel cell value using .Net spreadsheetgear dll, When i try to generate the excel i am suing the portugese number format as "[=0]0;###.###,00" which should display the value as 2.265,65 , but this is not happening and it…
sudha musham
  • 1
  • 1
0
votes
1 answer

How to display More than one Pie Chart in different Position in SpreadsheetGear

I add More than One Pie Chart in my Spreadsheet Gear. Pie Chart is dynamic Depending on Groups. Each Group has independent Pie Chart Depending on their dynamic Range. All this is Working fine for me Even Generating independent Pie Charts but in same…
Jankya
  • 966
  • 2
  • 12
  • 34
0
votes
1 answer

link in excel cause duplicate invocation

Problem Background In my ASP.net MVC4 web application, we allow user to download data in an Excel workbook, wherein one of the cell contains a hyperlink to a report page. We prepare the link such that when user click the link in Excel,…
SBirthare
  • 5,117
  • 4
  • 34
  • 59
1 2 3
…
16 17