Table support in RadSpreadsheet

4 posts, 0 answers
  1. Ke
    Ke avatar
    11 posts
    Member since:
    Mar 2013

    Posted 07 Jan 2014 Link to this post

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

    Thanks,
    Ke
  2. Anna
    Admin
    Anna avatar
    99 posts

    Posted 08 Jan 2014 Link to this post

    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
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  3. UI for WPF is Visual Studio 2017 Ready
  4. Joel Palmer
    Joel Palmer avatar
    164 posts
    Member since:
    May 2009

    Posted 10 Jan 2015 in reply to Anna Link to this post

    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;
  5. Anna
    Admin
    Anna avatar
    99 posts

    Posted 12 Jan 2015 Link to this post

    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
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top