Few questions related to FlexPivot

Few questions related to FlexPivot

Posted by: rabin.shakya on 12 December 2017, 6:57 pm EST

• 

  rabin.shakya

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 December 2017, 6:57 pm EST

  Is it possible to implement drag-and-drop feature to drag a field from field list to the grid directly (not dragging to filter/columns/rows/values area)?

  Also, is it possible to add a caption to the row/column values in the FlexPivotGrid? In the screenshot you can’t tell what exactly is “Feb2015”, “Mar2015”, etc without looking up the fields added in the columns/rows/values.

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 14 December 2017, 5:44 am EST

  Hi Rabin,

  Thanks for attaching the screen-shot.
  
  C1FlexPivot does not by default allow dragging & dropping fields directly from Fields area to grid. However, could you please share what exact operation do you wish to perform once you drag & drag i.e., would you like to add the dropped field to RowFields/ ColumnFields / ValuesField collection.
  
  Regarding the caption, every Field has a Caption property that can be used as follows, to show any text in UI.

  field.Caption = "This is the calculated price";
  

  Do let me know, if you need anything else.

  Thanks,
  
  Ruchir Agarwal

• 

  rabin.shakya

  • Post Options:
  • Link
    Copy

  Posted 17 December 2017, 10:42 pm EST

  Thanks for replying.

  We were thinking it would be user-friendly if the users could drag the field to the grid where they like to place it.

  You have only added rows in your screenshot but i have added columns as well. If you add column as well the Caption for column is not shown. You can see in my screenshot, the caption is set as the column value itself.

  So I am wondering if we can add caption for the first 3 rows in my screenshot as Country, Order date and Customer.

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 19 December 2017, 12:55 am EST

  Hi,

  Thank you for explaining more into the requirement.
  
  For showing the caption for the ColumnFields in Grid, you may Cast the grid in C1Flexgrid and then access its OwnerDrawCell event and set e.Text as shown in attached image.
  
  I have also attached a sample application implementing the same.

  Do let me know if you face any troubles implementing the same.

  Thanks,
  
  Ruchir Agarwal

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 19 December 2017, 12:57 am EST

  Here is attached sample application.

  ~RuchirC1FlexPivot_ColumnCaption.zip