Table support in RadSpreadsheet

[Ke]

Hi There,
Is there any estimates on when tables and Pictures and shapes will be supported in RadSpreadsheet?

Thanks,
Ke

[Anna]

Hello,

Thank you for your question. We are currently working on an implementation of pictures for RadSpreadsheet and it is planned to be ready for Q1 2014. Unfortunately, we still don't have an estimate for tables and shapes. We do take into account what our customers are interested in when deciding on new features, so I'd like to thank you for your input.

Regards,
Anna
Telerik

[Joel Palmer]

Are pictures now supported Q3 2014?  If so, can you provide some examples and guidelines?  I have an .xlsx file that I'm trying to open that includes a logo picture in the top left corner.  I get this error when I try to open it (code provided at the bottom):

Exception from HRESULT: 0x88982F50
No imaging component suitable to complete this operation was found.

   at System.Windows.Media.Imaging.BitmapDecoder.SetupDecoderFromUriOrStream(Uri uri, Stream stream, BitmapCacheOption cacheOption, Guid& clsId, Boolean& isOriginalWritable, Stream& uriStream, UnmanagedMemoryStream& unmanagedMemoryStream, SafeFileHandle& safeFilehandle)
   at System.Windows.Media.Imaging.BitmapDecoder.CreateFromUriOrStream(Uri baseUri, Uri uri, Stream stream, BitmapCreateOptions createOptions, BitmapCacheOption cacheOption, RequestCachePolicy uriCachePolicy, Boolean insertInDecoderCache)
   at System.Windows.Media.Imaging.BitmapImage.FinalizeCreation()
   at Telerik.Windows.Documents.Spreadsheet.Layout.Layers.ShapesLayer.UpdateRenderOverride(WorksheetRenderUpdateContext worksheetUpdateContext)
   at Telerik.Windows.Documents.Spreadsheet.Layout.Layers.WorksheetLayerBase.UpdateRenderOverride(RenderUpdateContext updateContext)
   at Telerik.Windows.Documents.Spreadsheet.Layout.Layers.LayerBase.UpdateRender(RenderUpdateContext updateContext)
   at Telerik.Windows.Controls.Spreadsheet.Worksheets.Layers.ShapesUILayer.UpdateUIOverride(WorksheetUIUpdateContextBase updateContext)
   at Telerik.Windows.Controls.Spreadsheet.Worksheets.Layers.ShapesUILayer.UpdateUIOverride(WorksheetUIUpdateContext updateContext)
   at Telerik.Windows.Controls.Spreadsheet.Worksheets.Layers.WorksheetUILayerBase.UpdateUIOverride(UIUpdateContext updateContext)
   at Telerik.Windows.Controls.Spreadsheet.Layers.UILayer.UpdateUI(UIUpdateContext updateContext)
   at Telerik.Windows.Controls.Spreadsheet.Layers.UILayerStack`1.UpdateUI(UIUpdateContext updateContext)
   at Telerik.Windows.Controls.Spreadsheet.Worksheets.NormalWorksheetEditorPresenter.UpdateUI(Boolean hasViewportChanged)
   at Telerik.Windows.Controls.Spreadsheet.Worksheets.NormalWorksheetEditorPresenter.MeasureOverride(Size availableSize)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at MS.Internal.Helper.MeasureElementWithSingleChild(UIElement element, Size constraint)
   at System.Windows.Controls.ContentPresenter.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.ContextLayoutManager.UpdateLayout()
   at System.Windows.ContextLayoutManager.UpdateLayoutCallback(Object arg)
   at System.Windows.Media.MediaContext.FireInvokeOnRenderCallbacks()
   at System.Windows.Media.MediaContext.RenderMessageHandlerCore(Object resizedCompositionTarget)
   at System.Windows.Media.MediaContext.RenderMessageHandler(Object resizedCompositionTarget)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)
   at System.Windows.Threading.DispatcherOperation.InvokeImpl()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Threading.DispatcherOperation.Invoke()
   at System.Windows.Threading.Dispatcher.ProcessQueue()
   at System.Windows.Threading.Dispatcher.WndProcHook(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)
   at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs)
   at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
   at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
   at System.Windows.Application.RunInternal(Window window)
   at System.Windows.Application.Run()
   at PrairieGrove.Product.ExcelXml.UI.App.Main() in c:\PrairieGrove\Product.ExcelXml\PrairieGrove.Product.ExcelXml.UI\obj\Debug\App.g.cs:line 0
   at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
   at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

​

Workbook workbook;
IWorkbookFormatProvider formatProvider = new XlsxFormatProvider();

using (FileStream input = new FileStream(txtPath.Text, FileMode.Open))
{
    workbook = formatProvider.Import(input);
}

spreadsheetControl.Workbook = workbook;

[Anna]

Hello,

Pictures are supported as of Q1 2014 and you can find some information on how to use them in the Shapes and Images article in our documentation. However, judging by the exception, it seems like the issue here is in the file which is imported and not in the usage. As mentioned in the other thread, if you could send us the file, we should be able to find what is causing the problem.

Regards,
Anna
Telerik