Home Ask Login Register

Developers Planet

Your answer is one click away!

rakesh February 2016

Spreadsheet Gear migration errors

I am migrating Spreadsheet gear of my application from to 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 do in all places where ever we use color.I expect we should have some shortcut to do this.Can any one suggest me How can i get all functionalities with few changes only.I am also getting exceptions to c onvert IColorFormat.LineColor to system.drawing.Color.


Tim Andersen February 2016

Note the "Breaking Changes" page in the SpreadsheetGear 2012 documentation, which lists this particular change:

  • In order to support WPF and Silverlight, the core API has been separated from the GDI+ and Windows Forms APIs and therefore uses the new SpreadsheetGear.Color type rather than SpreadsheetGear.Drawing.Color. SpreadsheetGear.Drawing.Color has been moved to SpreadsheetGear2012.Drawing.dll. See SpreadsheetGear.Drawing.Color for an example which uses the implicit and static converters to convert between SpreadsheetGear.Color, SpreadsheetGear.Drawing.Color and System.Drawing.Color. SpreadsheetGear.Colors and SpreadsheetGear.SystemColors provide helpful predefined colors to replace the use of predefined colors in System.Drawing.Color.

So you'll need to ensure than any place where you were previously using System.Drawing colors now use SpreadsheetGear.Drawing colors, including API like IColorFormat.LineColor.

There aren't really any "migration" tools to automatically convert such instances to the new API. So you'll need to resolve these errors for each code file. Doing a Find/Replace keyword search for "System.Drawing" and "SpreadsheetGear.Drawing" could possibly speed up th

Post Status

Asked in February 2016
Viewed 1,575 times
Voted 9
Answered 1 times


Leave an answer

Quote of the day: live life