C1Olap Control not Export Data to Excel

C1Olap Control not Export Data to Excel

Posted by: porwal_kumudini on 21 June 2018, 9:57 am EST

• 

  porwal_kumudini

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 June 2018, 9:57 am EST

  Hello,

  I am using C1.Win.Olap Control Version 4.0.20173.282.
  
  I am loading view definition by code and calling SaveExcel()/SaveGrid() method which is not working when the form is not visible. I am using a background thread for performing all these tasks, working properly when displaying the form and call the same process.

  Kumudini Porwal

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 22 June 2018, 4:40 am EST

  Hello Kumudini,

  I tried calling the Save methods(using BackgroundWorker) of C1FlexGrid from a form different than the one containing C1.Win.Olap and it seems to be working fine at my end. Please check the attached test application and let me know, if I’ve missed anything.

  Regards,
  
  Ruchir
  
  C1Olap.zip

• 

  porwal_kumudini

  • Post Options:
  • Link
    Copy

  Posted 22 June 2018, 5:49 am EST

  I want to Export OlapGrid, not RawDataGrid

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 26 June 2018, 8:20 am EST

  Hi,

  I am able to observe the behavior you are mentioning. However, this is because the control has not loaded its fields. I am researching on how to resolve this.
  
  I will keep you updated on this.

  Regards,
  
  Ruchir

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 27 June 2018, 7:32 am EST

  HI again,

  I am discussing the issue with dev team {ID:329636}. We’ll update you once we receive some information from them.

  Thanks,
  
  Ruchir

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 29 June 2018, 12:48 am EST

  Hi,

  After investigating on this, it looks like OlapGrid just doesn’t fill itself with data in this case and there is no workaround to resolve this. However, if you have some visible form in your application, then you may try another approach:

  • add the same Olap controls to this form, but set Control.Visible property to false.
    
    In this case controls won’t be visible in UI, but save operation can be performed successfully

  Thanks,
  
  Ruchir

• 

  porwal_kumudini

  • Post Options:
  • Link
    Copy

  Posted 30 June 2018, 3:18 am EST

  The same code is working properly in previous versions of Olap Control. We are using Olap for win forms library version 4.0.20131.131 previously.

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 2 July 2018, 1:28 am EST

  Hi,

  I am too observing the desired behavior at my end using 20131 version. Hence, I have requested the developers to confirm the same.
  
  I would update you with the information I receive from them.

  Thanks,
  
  Ruchir

• 

  porwal_kumudini

  • Post Options:
  • Link
    Copy

  Posted 10 July 2018, 1:25 am EST

  Any update

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 11 July 2018, 3:04 am EST

  Hi,
  
  As of now, the development team is investigating and there is no update. So, I have asked them for an update to this. I’ll get to back to you once I receive some information.
  
  Thanks,
  
  Ruchir

• 

  porwal_kumudini

  • Post Options:
  • Link
    Copy

  Posted 25 July 2018, 5:03 am EST

  Please provide Update

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 26 July 2018, 2:58 am EST

  Hello,

  I am sorry to inform you that the development team is still researching over it and currently there are no updates from them. However, I am pursuing them on this and will get back to you soon with some information.

  Thank you for your patience.

  Regards,
  
  Ruchir

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 30 July 2018, 12:40 am EST

  Hi,

  Our development team investigated over it and found few issues with the sample, so it was not actually a bug but an implementation issue. The issues found have been corrected in the attached sample. Please use the same and verify that the save feature works for you even with the latest version.

  Thanks,
  
  Ruchir
  
  OlapDemo_fixed.zip

• 

  porwal_kumudini

  • Post Options:
  • Link
    Copy

  Posted 31 July 2018, 9:15 am EST

  The same code is working properly in previous versions of Olap Control (4.0.20131.131). do not able to do any changes in code. Please provide solution

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 1 August 2018, 3:24 am EST

  Hi,

  I am discussing this with the concerned developer and will update you with the information I receive from him.

  Thanks,
  
  Ruchir

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 3 August 2018, 12:15 am EST

  Hi,

  The devs have explained that the main reason behind you not being able to save the grid is that the C1OlapPage make the analysis asynchronously in the separate thread using the BackgroundWorker class internally.
  
  So, you should wait until the analysis completes and the data appears in the grid before saving it. For this you can use the C1OlapPage.Updated event. This is the only right place where you should save the analyzed grid.
  
  Now, the change in behavior was done few years back and it would not be correct to revert back the old behavior. So, I am sorry to say but you should change your code if you want to save analyzed grid with data.
  
  To help you modify your existing code according to current behavior, we have attached a sample application for your reference. That is you now need to implement only one event in your code - C1OlapPage.Updated.

  Thanks,
  
  RuchirOlapDemo_v20131_fixed.zip